/// <summary> /// Employees management /// </summary> /// <returns></returns> public ActionResult EmployeesManagement(int active = -1) { EmployeesController employees = new EmployeesController(); ViewBag.ActiveFlag = (active == 1 ? true : false); return(View((active == -1 ? employees.Get() : employees.Get().Where(item => item.Active == (active == 1 ? true : false))))); }
/// <summary> /// Get Employees /// </summary> /// <returns></returns> public JsonResult Employees(string id = "") { EmployeesController employees = new EmployeesController(); MEmployeesEnt employee = employees.Get(int.Parse(id)).MapTo <MEmployees, MEmployeesEnt>(); return(Json(employee, JsonRequestBehavior.AllowGet)); }
/// <summary> /// Get employees /// </summary> /// <returns></returns> public JsonResult GetEmployeeNames(int id, int active) { EmployeesController employees = new EmployeesController(); List <MEmployees> listEmployees = (active == -1 ? employees.Get() : employees.Get().Where(item => item.Active == (active == 1 ? true : false)).ToList()); if (id != 0) { listEmployees = listEmployees.Where(item => item.EmployeeID == id).ToList(); } List <MCatalogs> catalog = new List <MCatalogs>(); listEmployees.ForEach(item => catalog.Add(new MCatalogs() { ID = item.EmployeeID, Name = string.Format("{0} {1}", item.Name, item.LastNames) })); return(Json(catalog, JsonRequestBehavior.AllowGet)); }
/// <summary> /// Generate Monthly PayRoll /// </summary> /// <param name="generate">Flag to generate</param> /// <param name="year">Year</param> /// <param name="month">Month</param> /// <returns></returns> public ActionResult GenerateMonthlyPayRoll(bool generate = false, int year = 0, int month = 0, int action = -1) { EmployeesController employees = new EmployeesController(); List <MEmployees> listEmployees = null; List <MPayRoll> listPayRolls = null; ViewBag.Year = year; ViewBag.Month = month; if (generate) { //Get days by month DateTime dateFirst = new DateTime(year, month, 1); DateTime dateLast = new DateTime(year, month + 1, 1).AddDays(-1); //Get employee employees = new EmployeesController(); listEmployees = employees.Get().Where(item => item.Active == true).ToList(); //Generates Payroll string msgResult = string.Empty; PayRollController payRollController = new PayRollController(); foreach (MEmployees employee in listEmployees) { if ( payRollController.Get().Where ( item => item.PayRollInfoID == employee.PayRollInfo_.PayRollInfoID && ((DateTime)item.PayRollDate).Year == year && ((DateTime)item.PayRollDate).Month == month ).Count() == 0) { //Payroll payRollController.Post(dateFirst, dateLast, dateLast, employee.PayRollInfo_.PayRollInfoID); msgResult += string.Format("- <span style='color: rgba(0, 0, 0, 0.55); font-weight: 600;'>Employee [ {0} {1} ] - PayRoll generated successfully</span> <br>", employee.Name, employee.LastNames); } else { msgResult += string.Format("- <span style='color: rgba(0, 0, 0, 0.55); font-weight: 600;'>Employee [ {0} {1} ] - PayRoll was already generated</span> <br>", employee.Name, employee.LastNames); } } return(Json(msgResult, JsonRequestBehavior.AllowGet)); } else { listPayRolls = new PayRollController().Get().Where(item => ((DateTime)item.PayRollDate).Year == year && ((DateTime)item.PayRollDate).Month == month && ((bool)item.Employee.Active) == true).ToList(); return(View(listPayRolls)); } }
/// <summary> /// Check if email exists /// </summary> /// <returns></returns> public JsonResult EmailExists(string email = "") { EmployeesController employees = new EmployeesController(); int emailCount = 0; if (email == "") { return(Json((emailCount), JsonRequestBehavior.AllowGet)); } emailCount = employees.Get().Where(item => item.Email.Trim() == email.Trim()).ToList().Count(); return(Json((emailCount), JsonRequestBehavior.AllowGet)); }