public IActionResult Gets()
{
var draw = HttpContext.Request.Form["draw"].FirstOrDefault();
// Skiping number of Rows count
var start = Request.Form["start"].FirstOrDefault();
// Paging Length 10,20
var length = Request.Form["length"].FirstOrDefault();
// Sort Column Name
var sortColumn = Request.Form["columns[" + Request.Form["order[0][column]"].FirstOrDefault() + "][name]"].FirstOrDefault();
// Sort Column Direction ( asc ,desc)
var sortColumnDirection = Request.Form["order[0][dir]"].FirstOrDefault();
// Search Value from (Search box)
var searchValue = Request.Form["search[value]"].FirstOrDefault();
//Paging Size (10,20,50,100)
int pageSize = length != null?Convert.ToInt32(length) : 0;
int skip = start != null?Convert.ToInt32(start) : 0;
int recordsTotal = 0;
var model = new GetEmployeeList()
{
ManagerId = 1
};
var responseData = _managerRepository.GetEmployeeList(model);
//Sorting
if (!(string.IsNullOrEmpty(sortColumn) && string.IsNullOrEmpty(sortColumnDirection)))
{
var prop = GetProperty(sortColumn);
if (sortColumnDirection == "asc")
{
responseData = responseData.OrderBy(prop.GetValue).ToList();
}
else
{
responseData = responseData.OrderByDescending(prop.GetValue).ToList();
}
}
//Search
if (!string.IsNullOrEmpty(searchValue))
{
responseData = (from e in responseData
where e.FullName.Contains(searchValue) ||
e.PhoneNumber.Contains(searchValue) ||
e.Email.Contains(searchValue)
select e).ToList();
}
//total number of rows count
recordsTotal = responseData.Count();
//Paging
var data = responseData.Skip(skip).Take(pageSize).ToList();
//Returning Json Data
return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data }));
}
//public bool UpdateLeaveApplication(UpdateLeaveApplication model)
//{
// var list = new List<TimeSheetList>();
// try
// {
// int DepartmentId = _dbContext.Employee.FirstOrDefault(e => e.Id == model.ManagerId && e.IsActive == true && e.IsDelete == false).DepartmentId;
// list = (from e in _dbContext.Employee
// join t in _dbContext.TimeSheet on e.Id equals t.EmployeeId
// where e.Id == model.EmployeeId && e.DepartmentId == DepartmentId && e.IsDelete == false
// orderby t.Date descending
// select new TimeSheetList
// {
// EmployeeId = e.Id,
// ManagerId = t.ManagerId,
// FullName = e.FullName,
// Status = t.Status == 1 ? "Có mặt" :
// (t.Status == 2 ? "Trễ" :
// (t.Status == 3 ? "Vắng không phép" :
// (t.Status == 4 ? "Vắng có phép" :
// (t.Status == 5 ? "Vắng không lương" : ""
// )))),
// Date = t.Date.ToString()
// }).ToList();
// }
// catch (Exception ex)
// {
// throw ex;
// }
// return list;
//}
#endregion
#region Information
public IList <EmployeeList> GetEmployeeList(GetEmployeeList model)
{
var list = new List <EmployeeList>();
try
{
int DepartmentId = _dbContext.Employee.FirstOrDefault(e => e.Id == model.ManagerId && e.IsActive == true && e.IsDelete == false).DepartmentId;
list = (from e in _dbContext.Employee
join p in _dbContext.Position on e.PositionId equals p.Id
where e.DepartmentId == DepartmentId && e.IsDelete == false
select new EmployeeList
{
EmployeeId = e.Id,
FullName = e.FullName,
Sex = e.Sex,
Dob = e.Dob.ToString(),
PhoneNumber = e.PhoneNumber,
Email = e.Email,
Image = e.Image,
PositionName = p.Name
}).ToList();
}
catch (Exception ex)
{
throw ex;
}
return(list);
}
public ActionResult _EmployeeFilter(GetEmployeeList getEmployeeList)
{
FilterModel filterModel = new FilterModel()
{
Id = "FilterEmployeeId", SelectAllCaption = "All Providers", SelectListItemList = new SelectList(getEmployeeList.ExecuteList(), "Id", "FullName").ToList()
};
return(View("_Filter", filterModel));
}
public ActionResult Appointment(GetEmployeeList getEmployeeList)
{
this.ViewData["employeeList"] = getEmployeeList.ExecuteList();
return(View(new List <SchedulerInfo>()));
}
// GET: Settings/Employee
public ActionResult Index(GetEmployeeList getEmployeeList)
{
return(View(getEmployeeList.ExecuteList()));
}
