1. Solution Explorer > right click on Solution Name > add a new project > choose a class library > give a name as "BusinessLayerRody"
2. Make a class(Change the class name as "Employee.cs") in BusinesslayerRody project refer coloumns of database
using System.Data;
using System.Configuration; <-- Check System.configuration in Reference
using System.Data.SqlClient;
public int Id { get; set; }
public string Name { get; set; }
public string Gender { get; set; }
public string CIty { get; set; }
public DateTime DateOfBirth { get; set; }
3. Add a class to put all business layer even database connection
public IEnumerable<Employee> Employees
{
get
{
string connection = ConfigurationManager.ConnectionStrings["employee"].ConnectionString;
List<Employee> employees = new List<Employee>();
using (SqlConnection con =new SqlConnection(connection))
{
SqlCommand cmd = new SqlCommand("spGetAllEmployees", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while(rdr.Read())
{
Employee employee = new Employee();
employee.Id = Convert.ToInt32(rdr["Id"]);
employee.Name = rdr["Name"].ToString();
employee.Gender = rdr["Gender"].ToString();
employee.DateOfBirth = Convert.ToDateTime(rdr["DateOfBirth"]);
employees.Add(employee);
}
}
return employees;
}
}
Check this project using "Build"
4. Original project > add "BusinessLayerRody" reference to using business layer in original project
5. Add a controller as "EmployeeController.cs"
using BusinessLayerRody;
in Index()
EmployeeBusinessLayer employeeBusinessLayer = new EmployeeBusinessLayer();
List<Employee> employees = employeeBusinessLayer.Employees.ToList();
return View(employees);
6. Add a view using right click on index controller > choose Add View > Create a strongly-typed view as Employee(BusinessLayerRody) and Scaffold template: List