/// <summary>
/// Create, Update, Delete Employees
/// </summary>
/// <returns></returns>
public JsonResult EmployeesD
(
string EmployeeID
)
{
EmployeesController employees = new EmployeesController();
employees.Delete(int.Parse(EmployeeID));
return(Json("Employee deleted successfully", 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));
}
/// <summary>
/// Check PayRoll Tickets
/// </summary>
/// <param name="generate">Flag to generate</param>
/// <param name="year">Year</param>
/// <param name="month">Month</param>
/// <returns></returns>
public ActionResult CheckPayRollTickets(int employeeID = 0)
{
EmployeesController employees = new EmployeesController();
List <MPayRoll> listPayRolls = null;
ViewBag.EmployeeSelected = employeeID;
listPayRolls = new PayRollController().Get().Where(item => ((bool)item.Employee.Active) == true).OrderByDescending(item => item.PayRollDate).ToList();
if (employeeID != 0)
{
listPayRolls = new PayRollController().Get().Where(item => item.Employee.EmployeeID == employeeID).OrderByDescending(item => item.PayRollDate).ToList();
}
return(View(listPayRolls));
}
/// <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>
/// Login a User within system
/// </summary>
/// <returns></returns>
public ActionResult UserLogin(string user = "", string pws = "", int SignOut = 0)
{
if (SignOut != 0)
{
Session["UserLogged"] = null;
Session["RoleLogged"] = null;
Session["UserIDLogged"] = null;
return(View());
}
if (!string.IsNullOrWhiteSpace(user) && !string.IsNullOrWhiteSpace(pws))
{
MEmployees employee = new EmployeesController().Get().Where(u => u.Email == user && u.Password == pws).FirstOrDefault();
if (employee == null)
{
return(Json("Failed", JsonRequestBehavior.AllowGet));
}
if (employee.Active == false)
{
return(Json("Inactive", JsonRequestBehavior.AllowGet));
}
string roleName = new RolesController().Get(int.Parse(employee.RoleID.ToString())).Name;
string userName = string.Format("{0} {1}", employee.Name, employee.LastNames);
Session["UserLogged"] = userName;
Session["RoleLogged"] = roleName;
Session["UserIDLogged"] = employee.EmployeeID;
return(Json(Url.Content("~/Home/" + (roleName == "Admin" ? "DashboardAdmin" : "DashboardAdmin")), JsonRequestBehavior.AllowGet));
}
else
{
return(View());
}
}
