Skip to main content

N-Tier Architecture

Form User Interface:
















***************

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace WinFormAppN_TierArchitecture.BLL
{
   public class EmployeeHelper
   {
      public static void SaveErrorLog(Exception ex)
      {
         string fileName = Environment.CurrentDirectory + "\\ERROR_" + Guid.NewGuid() + ".txt";
         File.WriteAllText(fileName, ex.ToString());
      }
   }
}


***************

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace WinFormAppN_TierArchitecture.BLL
{
   public static class EmployeeConverter
   {
      #region [ ToDecimal ]

      public static Decimal ToDecimal(object value)
      {
         return ToDecimal(value, 0);
      }

      private static Decimal ToDecimal(object value, decimal defaultValue)
      {
         decimal retVal = defaultValue;
         if (value.Assigned())
         {
            Decimal.TryParse(Convert.ToString(value), out retVal);
         }
         return retVal;
      }

      #endregion

      #region [ ToInt32 ]

      public static Int32 ToInt32(object value, Int32 defaultValue)
      {
         Int32 retVal = defaultValue;
         if (value.Assigned())
         {
            Int32.TryParse(Convert.ToString(value), out retVal);
         }
         return retVal;
      }

      public static Int32 ToInt32(object value)
      {
         return ToInt32(value, 0);
      }

      #endregion

      public static bool Assigned(this object o)
      {
         if (o is string)
            return !string.IsNullOrEmpty((string)o);

         if (o is DateTime)
            return (DateTime)o > DateTime.MinValue;

         return (o != null);
      }
   }
}

***************

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WinFormAppN_TierArchitecture.DAL;

namespace WinFormAppN_TierArchitecture.BLL
{
   public class EmployeeBLL
   {
      public DataTable GetEmployees()
      {
         try
         {
            EmployeeDAL empDAL = new EmployeeDAL();
            return empDAL.GetEmployees();
         }
         catch (Exception ex)
         {
            EmployeeHelper.SaveErrorLog(ex);
            throw;
         }
      }
      public DataTable GetEmployee(int EmployeeId)
      {
         try
         {
            EmployeeDAL empDAL = new EmployeeDAL();
            return empDAL.GetEmployee(EmployeeId);
         }
         catch (Exception ex)
         {
            EmployeeHelper.SaveErrorLog(ex);
            throw;
         }
      }
   }
}

***************
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WinFormAppN_TierArchitecture.BLL;

namespace WinFormAppN_TierArchitecture.DAL
{
   public class EmployeeDAL
   {
      public string connectionString = "Data Source=NURHAK-KAYA;Initial Catalog=northwind;Integrated Security=True";

      SqlConnection con = new SqlConnection();
      DataTable dt = new DataTable();
      public DataTable GetEmployees()
      {
         try
         {
            con.ConnectionString = connectionString;
            if (con.State == ConnectionState.Closed)
               con.Open();
            SqlCommand cmd = new SqlCommand("select * from Employees", con);
            SqlDataReader rd = cmd.ExecuteReader();
            dt.Load(rd);
            return dt;
         }
         catch (Exception ex)
         {
            EmployeeHelper.SaveErrorLog(ex);
            throw;
         }
      }
      public DataTable GetEmployee(int EmployeeId)
      {
         try
         {
            con.ConnectionString = connectionString;
            if (con.State == ConnectionState.Closed)
               con.Open();
            SqlCommand cmd = new SqlCommand("select * from Employees where EmployeeID=" + EmployeeId, con);
            SqlDataReader rd = cmd.ExecuteReader();
            dt.Load(rd);
            return dt;
         }
         catch (Exception ex)
         {
            EmployeeHelper.SaveErrorLog(ex);
            throw;
         }
     }
   }
}

***************
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using WinFormAppN_TierArchitecture.BLL;

namespace WinFormAppN_TierArchitecture
{
   public partial class Form1 : Form
   {
      public Form1()
      {
         InitializeComponent();
      }

      private void Form1_Load(object sender, EventArgs e)
      {
         try
         {
            EmployeeBLL empBLL = new EmployeeBLL();
            this.dataGridView1.DataSource = empBLL.GetEmployees();
         }
         catch (Exception ex)
         {
            EmployeeHelper.SaveErrorLog(ex);
            throw;
         }
      }

      private void button1_Click(object sender, EventArgs e)
      {
         try
         {
            EmployeeBLL empBLL = new EmployeeBLL();
            int employeeId = EmployeeConverter.ToInt32(this.textBox1.Text);
            this.dataGridView1.DataSource = empBLL.GetEmployee(employeeId);
         }
         catch (Exception ex)
         {
            EmployeeHelper.SaveErrorLog(ex);
            throw;
         }
      }
   }
}

***************

Architecture:




















Get All Employees List:

















Get One Employee By EmployeeId:






Comments

Popular posts from this blog

How to fix Umbraco v9 "Boot Failed : Umbraco failed to boot, if you are the owner of the website please see the log file for more details." error

If you have started working with Umbraco v9 and done your first Azure deployment to one of your testing environments, there is a possibility that you might see the following "Boot Failed" error. Error: Checking the logs In order to understand the problem, you should check the Umbarco log file.  The default location for this file is umbraco/Logs and this file contains the Machine name, along with the date information. You can reach this file via Azure's Kudu Service  or alternatively, you can get download your Azure App Service's publish profile and connect your App Service via an FTP application, i.e. FileZilla. See the FileZilla screen below; Once you get your log file, you can download it to your local machine and open it with a text editor, i.e. Notepad++. When you open it, you will see all logs, including the error message. Please be aware, as most things with Umbraco, logging is also customizable, so you can either use the default Umbraco logging which is Micros

How to use JQuery Ajax Methods for Async ASP.NET MVC Action Methods

Making repeatedly calls to async methods can be a nightmare. In this case, it makes sense to use 2 ajax methods, instead of one. Here is a simple solution to overcome this problem. See that  ajaxcalls   is emptied after the success response for the first ajax call and then the second ajax method is used to make one single call to the async action method. Hope it helps. View: @section Scripts{     < script type ="text/javascript">         var smartDebitObject = new Object();         smartDebitObject.MembershipNumber = $( "#MembershipNumber" ).val();         smartDebitObject.ProfileId = $( "#ProfileId" ).val();         smartDebitObject.FirstName = $( "#FirstName" ).val();         smartDebitObject.LastName = $( "#LastName" ).val();         smartDebitObject.AddressLine1 = $( "#AddressLine1" ).val();         smartDebitObject.Postcode = $( "#Postcode" ).val();         smartDebitObject

Umbraco lifehack: How to setup anchor/jump links in Umbraco without making code changes

Today one of my clients created a ticket asking whether it is possible to set up anchor/jump links for an Umbraco content page so that they could link different sections of the page together. This is a common scenario for most Content editors and it should be super easy with any CMS platform, right? Houston, we got a problem! Now an anchor or page jump link is a special URL that takes you to a specific place on a page and it normally requires a unique HTML element ID to link different parts of a page.  When I investigated my issue, I realised that the page sections of the Umbraco page didn't have unique IDs.  View Source Code comes to the rescue In order to resolve the issue without any code changes, I decided to update the content using the built-in View Source Code feature of Umbraco CMS. This feature is available on built-in property editors, like Rich Text Editor and is super handy for checking the code that Umbraco generates for your Front-end website and making minor adju