- \n
- Data Layer<\/li>\n
- Business Layer<\/li>\n
- Presentation Layer<\/li>\n<\/ul>\n
Now let’s go on to explain these things.<\/p>\n
Data Layer<\/h2>\n
This layer is also known by its name and we will deal with the database part. Database connections are made in this layer and classes are created for the tables in the database. Of course, we need to have our database for this. A sample database is available for this. I will use the Northwind<\/strong> database.<\/p>\n
![\"\"](\"http:\/\/sezeromer.com\/wp-content\/uploads\/2018\/06\/northwind.png\")
<\/p>\nAfter adding the database, we will go to the code. For this we need to make a database connection first. After we write our link address, we open the link. Then we need to create a query to retrieve the data. We can extract data from different tables. That’s why we create such a function.<\/p>\n
\n\/\/ Ba\u011flant\u0131 adresimizi yaz\u0131p, ba\u011flant\u0131y\u0131 a\u00e7\u0131yoruz\r\n public SqlConnection OpenConnection()\r\n {\r\n SqlConnection baglanti = new SqlConnection(\"Server=.;database=Northwind;trusted_connection=true\");\r\n baglanti.Open();\r\n return baglanti;\r\n }\r\n \/\/ Her sorgu olu\u015fturdu\u011fumuzda buradan yararlanaca\u011f\u0131z.\r\n public SqlCommand CreateConnection(string sorgu)\r\n {\r\n SqlCommand sqlCommand = new SqlCommand(sorgu, OpenConnection());\r\n return sqlCommand;\r\n }<\/pre>\n<\/div>\nWe performed the database bind operations. We also made preparations to write queries when needed. Now we are going to work on which table in the database. If you are going to deal with all the tables, you have to add all the tables. I am adding this only because I will deal with the customer chart. I am adding this column to the database in the same way as it would be here. You can easily create it by typing “prop<\/strong>“. I later add a constructor by creating a Constructor<\/strong>.<\/p>\n
\npublic class Musteriler\r\n {\r\n public string MusteriID { get; set; }\r\n public string SirketAdi { get; set; }\r\n public string MusteriAdi { get; set; }\r\n public string MusteriUnvani { get; set; }\r\n public string Adres { get; set; }\r\n public string Sehir { get; set; }\r\n public string Bolge { get; set; }\r\n public string PostaKodu { get; set; }\r\n public string Ulke { get; set; }\r\n public string Telefon { get; set; }\r\n public string Faks { get; set; }\r\n\r\n public Musteriler(string musteriID,string sirketAdi, string musteriAdi , string musteriunvani,\r\n string adres, string sehir, string bolge, string postakodu,\r\n string ulke,string telefon,string faks)\r\n {\r\n this.MusteriID = musteriID;\r\n this.SirketAdi = sirketAdi;\r\n this.MusteriAdi = musteriAdi;\r\n this.MusteriUnvani = musteriunvani;\r\n this.Adres = adres;\r\n this.Sehir = sehir;\r\n this.Bolge = bolge;\r\n this.PostaKodu = postakodu;\r\n this.Ulke = ulke;\r\n this.Telefon = telefon;\r\n this.Faks = faks;\r\n }<\/pre>\n<\/div>\nBusiness Layer<\/h2>\n
In this layer, the main events begin. How we read the data from the database, what questions we will read, how we read the data, what we will do after reading the data. In fact, it provides a bridge between our database and our project.<\/p>\n
In this example I will just do data extraction. If you want to do other things later, we can go together. After creating a function called data check, I create a list so that I can keep the data in a list. Then I get the linking and query writing functions in the data layer to open the connection and query that we created in the data layer. Then I read the data. After I read the data, I am assigning a class called Customer. I add a customer list afterwards. That’s all my business here. You can perform basic CRUD<\/strong>\u00a0(Create – Read – Update – Delete ) operations on this layer.<\/p>\n
\npublic List<Musteriler> TakeData()\r\n {\r\n \/\/ B\u00fct\u00fcn m\u00fc\u015fterileri bir liste i\u00e7inde tutaca\u011f\u0131m\r\n List<Musteriler> musteriler = new List<Musteriler>();\r\n Veri veritabani = new Veri();\r\n SqlConnection connection = veritabani.OpenConnection();\r\n SqlCommand sqlCommand = veritabani.CreateConnection(\"SELECT MusteriID,SirketAdi,MusteriAdi,\" +\r\n \"MusteriUnvani,Adres,Sehir,Bolge,PostaKodu,Ulke,Telefon,Faks from Musteriler\");\r\n SqlDataReader dataReader = sqlCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection);\r\n while(dataReader.Read())\r\n {\r\n Musteriler musteri = new Musteriler(\r\n dataReader[\"MusteriID\"].ToString(),\r\n dataReader[\"SirketAdi\"].ToString(),\r\n dataReader[\"MusteriAdi\"].ToString(),\r\n dataReader[\"MusteriUnvani\"].ToString(),\r\n dataReader[\"Adres\"].ToString(),\r\n dataReader[\"Sehir\"].ToString(),\r\n dataReader[\"Bolge\"].ToString(),\r\n dataReader[\"PostaKodu\"].ToString(),\r\n dataReader[\"Ulke\"].ToString(),\r\n dataReader[\"Telefon\"].ToString(),\r\n dataReader[\"Faks\"].ToString());\r\n musteriler.Add(musteri);\r\n }\r\n\r\n connection.Close();\r\n return musteriler;\r\n \r\n }<\/pre>\n<\/div>\nPresentation Layer<\/h2>\n
In this layer, we present data to the user in our database. Dilerseniz mobile application, you do not want to do a console application in the windows form application. This is up to you. This is the layer where you will have more pages. We will reach the user in this layer. The user will start the data extraction process from here and will do basic operations here. I did a simple bit console application in this application, but as I said, you can do whatever you want.<\/p>\n
Here I first get help from my class at the Job Layer to take the data. We already did everything we needed to attract data at the business layer. I’m making a list. This listenin type will be in Customer style. To retrieve the Customer list from the business layer. Then we get the customers coming from the business layer to this list. We need to go through this list after we get it. We navigate with Foreach and print it on the screen. That’s our process.<\/p>\n
\nList<Musteriler> musteriListe = new List<Musteriler>();\r\n Helper helper = new Helper();\r\n musteriListe = helper.TakeData();\r\n foreach (Musteriler item in musteriListe)\r\n {\r\n Console.WriteLine(item.MusteriID + \" \" + item.SirketAdi + \" \" + item.MusteriAdi + \" \" + item.MusteriUnvani + \" \" +\r\n item.Adres + \" \" + item.Sehir + \" \" + item.Bolge + \" \" + item.PostaKodu + \" \" + item.Ulke + \" \" +\r\n item.Telefon + \" \" + item.Faks);\r\n }\r\n Console.ReadKey();<\/pre>\n<\/div>\nOur display is as below.<\/p>\n
![\"\"](\"http:\/\/sezeromer.com\/wp-content\/uploads\/2018\/06\/katmanli-mimari.png\")
<\/p>\nThe reason for the layered architecture is that each process is performed in different layers. I went through this project in one project and stored them in different folders. You can create different projects for each layer you are baking.<\/p>\n
![\"\"](\"http:\/\/sezeromer.com\/wp-content\/uploads\/2018\/06\/katmanli-mimari-2.png\")
<\/p>\n