Skip to main content

Three Tier Architecture : A simple Example/Illustration

Three Tier Architecture: Very Easy to understand, the three tier are:

1. Presentation layer
2. Business Layer
3. Database Layer


Simple Example:
Lets take example of a Songs and Artist.



1. DataAccess Layer

Below is a class of Data Access Layer, that has some dummy/fudge data, we only write DataBase calling method in DataAccessLayer.



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

namespace DataBaseLayer
{
    public class DataAccessLayer
    {
        string[] ArtistName = { "Akon", "Shakira", "Michael_Jackson" };
        string[] Shakira = { "Waka Waka", "Addicted to you", "Beautiful Liar" };
        string[] Akon = { "Chammak Challo", "Lonely", "Dont Matter" };
        string[] Michael_Jackson = { "Beat It", "Dangerous", "Smooth Criminal" };

        public string[] Songs(string ArtistName)
        {
            string[] ArtistSong = new string[3];
            int i = 0;
            if (ArtistName == "Shakira" )
            {
                foreach (string s in Shakira)
                {
                    ArtistSong[i] = s; ;
                    i++;
                }

            }
            if (ArtistName == "Akon")
            {
                foreach (string s in Akon)
                {
                    ArtistSong[i] = s; ;
                    i++;
                }

            }
            if (ArtistName == "Michael_Jackson")
            {
                foreach (string s in Michael_Jackson)
                {
                    ArtistSong[i] = s; ;
                    i++;
                }

            }
            return ArtistSong;

        }
    }
}



2. Business Access Layer




using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using DataBaseLayer;


namespace BusinessLayer
{
    public class BusinessAccessLayer
    {
        public string[] DataCalling(string ArtistName)
        {
            DataAccessLayer dataAccessLayer = new DataAccessLayer();
            string [] ArtistSongs = dataAccessLayer.Songs(ArtistName);
            return ArtistSongs;
        }

    }
}


It only has object i.e. parameters and Stored Procedure Name that are used to call DB, its a wire between DB and View, it only believes in business.



3. Presentation Layer

It is no where related to database and no link, its only work is to display.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using BusinessLayer;

namespace Three_Tier_Architecture
{
    class PresentationLayer
    {
        static int flag = 0;
       static string choice = null;
        static void Main(string[] args)
       {
           while (flag == 0)
           {     
            Console.WriteLine("Please Enter the Artist Name, Enter Number");
            Console.WriteLine("Choose From: \n 1. Shakira \n 2. Akon \n 3. Michael Jackson");
            choice = Console.ReadLine();           
            flag = CallingBusinessLayer(choice);
            Console.WriteLine("Wanna Continue (Y/N)");
            string Reply = Console.ReadLine().ToLower();
            if (Reply == "n")
                flag = 1;
            else
                flag = 0;
            }
        }

        public static int CallingBusinessLayer(string SelectedChoice)
        {
            BusinessAccessLayer _businessAccessLayer = new BusinessAccessLayer();
            string[] Songs = null;
            if (flag == 0)
            {
                switch (choice)
                {
                    case "1":
                        Songs = _businessAccessLayer.DataCalling("Shakira");
                        foreach (string s in Songs)
                        {
                            Console.WriteLine("\n " + s + "\n");
                        }
                        break;
                    case "2":
                        Songs = _businessAccessLayer.DataCalling("Akon");
                        foreach (string s in Songs)
                        {
                            Console.WriteLine("\n " + s + "\n");
                        }
                        break;
                    case "3":
                        Songs = _businessAccessLayer.DataCalling("Michael_Jackson");
                        foreach (string s in Songs)
                        {
                            Console.WriteLine("\n " + s +"\n");
                        }
                        break;

                }
            }
          
            return 0;
          
        }
    }
}



A very simple and effective example. no Jargon's used.

 things should be pretty clear here.


Download Source Code


Labels:

Comments

Post a Comment

Important - Make sure to click the Notify Me check-box below the comment to be notified of follow up comments and replies.

Popular posts from this blog

Send a Fax in windows using faxcomexlib and TAPI in VB code .Net

An application that provides sending fax from faxmodem, connected to the computer, will be explained in the following post.  We can use Telephony Application Programming Interface (TAPI) and the Fax Service Extended Component Object Model (COM) API to send fax. The fax service is a Telephony Application Programming Interface (TAPI)-compliant system service that allows users on a network to send and receive faxes from their desktop applications. The service is available on computers that are running Windows 2000 and later. The fax service provides the following features: Transmitting faxes Receiving faxes Flexible routing of inbound faxes Outbound routing Outgoing fax priorities Archiving sent and received faxes Server and device configuration management Client use of server devices for sending and receiving faxes Event logging Activity logging Delivery receipts Security permissions The following Microsoft Visual Basic code example sends a fax. Note that...
Post a Comment
Read more

Convert your datatable into generic poco object in c# using linq, ado and reflections.

Follow @harshit_parshii The most common problem that we face these days is to create a common class and method that can be used across all the projects and codes. So today I will be sharing my code where you can see how to make and create a generic function without using entity framework for ado. net. The scenario is like you have an old software that uses stored procedure to return set of entities as a data-table, you do not want to re-write the back-end code as you are creating a web API in c# which needs to be delivered asap. You need to map these data tables to models as you might be using MV* pattern. So here we will be doing one to one mapping of model to data- table, and in similar fashion insert or update can also be done. So basically we are converting a data-table to list of strongly typed object model to do CRUD operations. So we have following things before hand. A helper class is referenced as the database(dbFactory) which executes ado. ne...
Post a Comment
Read more

Decoding underscore js SortBy - Sorting in javascript

Sorting can be the developers worst nightmare especially if it is done in more then one field. So what can help, recently doing research on it I came across underscore js sortBy (underscorejs.org/#sortBy) function which will help you to sort the array very effectively. So I was going through the documentation and found it very useful, but there are one drawback of it. Will let you know that: How to order in Ascending Order _.sortBy([6, 2, 4, 5, 3, 1], function(num){ return num }); [ 1 , 2 , 3 , 4 , 5 , 6 ] How to order in Descending Order _.sortBy([6, 2, 4, 5, 3, 1], function(num){ return -num }); [ 6 , 5 , 4 , 3 , 2 , 1 ] The underscore sort by will also work with string literals Ascending _.sortBy(['6','2', '4', '5', '3', '1'], function(num){ return num }); [ " 1 " , " 2 " , " 3 " , " 4 " , " 5 " , " 6 " ] Descending _.sortBy(['6','2'...
Post a Comment
Read more