public EmployeeViewModel GetEmployee(int EmployeeId) { using (DomainLayer.Model.CrudDemoDBEntities db = new DomainLayer.Model.CrudDemoDBEntities()) { // CrudDemoDBEntities db = new CrudDemoDBEntities(); List <SelectListItem> listOfDeparts = new List <SelectListItem>(); foreach (DomainLayer.Model.Department dept in db.Departments) { SelectListItem selectList = new SelectListItem() { Text = dept.DepartmentName, Value = dept.DepartmentId.ToString(), Selected = dept.IsActive }; listOfDeparts.Add(selectList); } EmployeeViewModel customerModel = new EmployeeViewModel(); customerModel.Departs = listOfDeparts; List <DomainLayer.Model.City> citylist = db.Cities.ToList(); customerModel.CitiesList = new SelectList(citylist, "CityId", "CityName"); if (EmployeeId > 0) { //Employee emp = from x in db.Employees // join y in db.Ci on x.EmpId equals y.Countryid into ps // from p in ps // select new { x.is, x.name, x.countryid, p.countryname } DomainLayer.Model.Employee emp = db.Employees.SingleOrDefault(x => x.EmpId == EmployeeId && x.IsActive == true); customerModel.EmpId = emp.EmpId; customerModel.DepartmentId = emp.DepartmentId; customerModel.Name = emp.Name; customerModel.Address = emp.Address; customerModel.Gender = emp.Gender; customerModel.DOB = emp.DOB; customerModel.CityId = emp.CityId; customerModel.IsActive = emp.IsActive; } return(customerModel); } }
//public List<EmployeeViewModel> GetAllEmployee() //{ // throw new NotImplementedException(); //} public EmployeeViewModel GetAllEmployees(int currentPage) { int maxRows = 10; List <EmployeeViewModel> List = new List <EmployeeViewModel>(); using (DomainLayer.Model.CrudDemoDBEntities entities = new DomainLayer.Model.CrudDemoDBEntities()) { EmployeeViewModel customerModel = new EmployeeViewModel(); // CustomerModel customerModel = new CustomerModel(); customerModel.EMployees = (from customer in entities.Employees where customer.IsActive != false select customer) .OrderBy(customer => customer.EmpId) .Skip((currentPage - 1) * maxRows) .Take(maxRows).ToList(); double pageCount = (double)((decimal)entities.Employees.Count() / Convert.ToDecimal(maxRows)); customerModel.PageCount = (int)Math.Ceiling(pageCount); customerModel.CurrentPageIndex = currentPage; //List = db.Employees //List = db.Employees // .OrderBy(customer => customer.EmpId) // .Skip((currentPage - 1) * maxRows) // .Take(maxRows) // .Select(x => new EmployeeViewModel // { // Name = x.Name, // EmpId = x.EmpId, // DepartmentId = x.DepartmentId, // DepartmentName = x.Department.DepartmentName, // Address = x.Address, // IsActive = x.IsActive // }).ToList(); //double pageCount = (double)((decimal)db.Employees.Count() / Convert.ToDecimal(maxRows)); //customerModel.PageCount = (int)Math.Ceiling(pageCount); //customerModel.CurrentPageIndex = currentPage; return(customerModel); } }