/// <summary> /// Casts DataModel entity to MVC Model entity /// </summary> /// <param name="employee"></param> private EmployeeManagementModel CastToCommonEmployeeModel(DataModel.Entities.Common.Employee employee) { return(new EmployeeManagementModel() { Id = employee.Id, Name = employee.Name, Surname = employee.LastName }); }
public List <DataModel.Entities.Common.Employee> GetEmployees() { List <DataModel.Entities.Common.Employee> deserialized = new List <DataModel.Entities.Common.Employee>(); string baseUrl = ConfigurationManager.ConnectionStrings["ManagementServerName"].ConnectionString; string url = baseUrl + DestinationNames.GetTaskEmployees; deserialized = Communicator.GetEntities <DataModel.Entities.Common.Employee>(url); List <DataModel.Entities.Common.Employee> employees = new List <DataModel.Entities.Common.Employee>(); foreach (var item in deserialized) { DataModel.Entities.Common.Employee employee = new DataModel.Entities.Common.Employee(); employee.Id = item.Id; employee.Name = item.Name; employees.Add(employee); } return(employees); }
public List <DataModel.Entities.Common.Employee> GetEmployees() { List <DataModel.Entities.Common.Employee> employees = new List <DataModel.Entities.Common.Employee>(); using (SqlConnection con = new SqlConnection (ConfigurationManager.ConnectionStrings["SQLProviderConnectionString"].ConnectionString)) { SqlCommand cmd = new SqlCommand("dbo.GetEmployees", con); cmd.CommandType = CommandType.StoredProcedure; con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { DataModel.Entities.Common.Employee employee = new DataModel.Entities.Common.Employee(); employee.Id = Int32.Parse(reader[0].ToString()); employee.Name = reader[1].ToString(); employee.LastName = reader[1].ToString(); employees.Add(employee); } return(employees); } }