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);
}
}
