public ActionResult AddRecertification()
{
System.Diagnostics.Debug.WriteLine(Request.Form["EmployeeID"]);
System.Diagnostics.Debug.WriteLine(Request.Form["Code"]);
System.Diagnostics.Debug.WriteLine(Request.Form["DatePlanned"]);
if (Request.Form["EmployeeID"] != null && Request.Form["Code"] != "X" && !String.IsNullOrEmpty(Request.Form["DatePlanned"]))
{
var EmpId = Request.Form["EmployeeID"].ToString();
var Code = Request.Form["Code"].ToString();
if ((ldcr.ReCertificationPlans.Where(rcp => rcp.Badge_No == EmpId).ToList().FirstOrDefault()) == null)
{
Employees_Details employee = cEE.Employees_Details.Where(emp => emp.Employee_ID == EmpId).FirstOrDefault();
ReCertificationPlan reCertificationPlan = new ReCertificationPlan();
reCertificationPlan.Badge_No = Request.Form["EmployeeID"];
reCertificationPlan.CertificationCode = Request.Form["Code"];
reCertificationPlan.PlanDate = Convert.ToDateTime(Request.Form["DatePlanned"]);
reCertificationPlan.Lastname = employee.Last_Name;
reCertificationPlan.Firstname = employee.First_Name;
ldcr.ReCertificationPlans.Add(reCertificationPlan);
ldcr.SaveChanges();
Session["NumberOfRecertificationPlans"] = Convert.ToInt32(Session["NumberOfRecertificationPlans"]) + 1;
}
else
{
ReCertificationPlan reCertificationPlan = ldcr.ReCertificationPlans.Where(rcp => rcp.Badge_No == EmpId).ToList().FirstOrDefault();
reCertificationPlan.CertificationCode = Code;
reCertificationPlan.PlanDate = Convert.ToDateTime(Request.Form["DatePlanned"]);
ldcr.Entry(reCertificationPlan).State = EntityState.Modified;
ldcr.SaveChanges();
}
}
return(RedirectToAction("ReCertificationPlan"));
}
public ActionResult AddModalRecertification()
{
var EmpId = Request.Form["EmployeeID"].ToString();
Employees_Details employee = cEE.Employees_Details.Where(emp => emp.Employee_ID == EmpId).FirstOrDefault();
ViewBag.Name = employee.Last_Name + ", " + employee.First_Name;
ModalAddRecertificactionModel modal = new ModalAddRecertificactionModel();
modal.BadgeNo = EmpId;
modal.CertificationTrackers = ldcr.CertificationTrackers.Where(ctr => ctr.EmpBadgeNo == EmpId && ctr.DateRecertified == null).ToList();
return(View(modal));
}
public async Task <ActionResult> Login(Account model, string returnUrl)
{
_EmployeesManager = new commonEmployeesEntities();
learUser = new gatepassEntities();
_AccountManager = new lear_DailiesCertificationRequirementEntities();
PasswordSecurity ps = new PasswordSecurity();
System.Diagnostics.Debug.WriteLine(ps.EncryptPassword(model.Password) + " : pass");
var adminPass = ps.EncryptPassword(model.Password);
var adminAccount = _AccountManager.Users.Where(us => us.BadgeNo.ToString().Equals(model.BagdeNo) && us.Password.Equals(adminPass)).FirstOrDefault();
//System.Diagnostics.Debug.WriteLine(adminAccount.Password+" : password");
if (!ModelState.IsValid)
{
return(View(model));
}
Account user = new Account()
{
BagdeNo = model.BagdeNo, Roles = "", Password = model.Password
};
user = Repository.GetAccountDetails(user); // Calling getAccountDetailsFunction from Repository Class
// check if User is exist..
if (user != null)
{
// if true..
// Get Employee Details
Employees_Details userrr = _EmployeesManager.Employees_Details.Where(em => em.Employee_ID == user.BagdeNo).FirstOrDefault();
var intBadge = System.Int32.Parse(model.BagdeNo).ToString();
// Get User info from user_vw using BadgeNo
users_vw usertemp = learUser.users_vw.Where(use => use.Employee_ID == user.BagdeNo).FirstOrDefault();
// Get total Number of Employees
var countEmployees = _EmployeesManager.Employees_Details.ToList();
// Get total Number of Active Employees
var countActiveEmployees = _EmployeesManager.Employees_Details.Where(emp => emp.Job_Status.ToUpper().Contains("CURRENT")).ToList().Count();
// Get total Number of Newly Employed Employees
var countNewlyEmployees = _EmployeesManager.newlyEmployees.Where(emp => emp.Payroll_Type.ToString().ToUpper().Equals("DAILY")).OrderBy(nwEmp => nwEmp.Last_Name).ToList();
// Set Authentication Cookie to User's EMAIL ADDRESS
FormsAuthentication.SetAuthCookie(usertemp.Email, false);
// [ BEGIN -- Authentication Configuration
var authTicket = new FormsAuthenticationTicket(1, usertemp.Email, DateTime.Now, DateTime.Now.AddMinutes(720), false, user.Roles);
string encryptedTicket = FormsAuthentication.Encrypt(authTicket);
var authCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encryptedTicket);
HttpContext.Response.Cookies.Add(authCookie);
// -- END Authentication Configuration ]
// [ BEGIN -- Session Configuration
Session["User"] = usertemp.Email;
Session["RoleUser"] = user.Roles;
Session["UserId"] = user.BagdeNo;
Session["NumberOfEmployees"] = countEmployees.Count();
Session["NumberOfUnderEmployees"] = _EmployeesManager.Emp_Route.Where(emp => emp.Checker_1_ID == user.BagdeNo).ToList().Count();
Session["NumberOfNewlyEmployees"] = countNewlyEmployees.Count();
Session["NumberOfActiveEmployees"] = countActiveEmployees;
Session["NumberOfInactiveEmployees"] = countEmployees.Count() - countActiveEmployees;
if (userrr != null)
{
Session["UserPosition"] = userrr.Position;
}
// -- END Session Configuration ]
return(RedirectToAction("Home", "Home"));
}
else if (/*model.BagdeNo.ToString() == "1234" && model.Password.ToString() =="IT"*/ adminAccount != null) // Hardcoded User For IT admin
{
// Get total Number of Dailies Employees
var countEmployees = _EmployeesManager.Employees_Details.Where(emp => emp.Payroll_Type.ToUpper().Equals("DAILY")).ToList();
// Get total Number of Active Employees
var countActiveEmployees = _EmployeesManager.Employees_Details.Where(emp => emp.Job_Status.ToUpper().Contains("CURRENT") && emp.Payroll_Type.ToUpper().Equals("DAILY")).ToList().Count();
// Get total Number of Newly Employed Employees
var countNewlyEmployees = _EmployeesManager.newlyEmployees.Where(emp => emp.Payroll_Type.ToString().ToUpper().Equals("DAILY")).OrderBy(nwEmp => nwEmp.Last_Name).ToList();
// Get total Number of Probationary Employees
var countProbationaryEmployees = _AccountManager.EmployeeDCR_Vw.Where(emp => emp.EmploymentStatus.ToUpper().Equals("PROBATIONARY") && emp.Job_Status.ToUpper().Contains("CURRENT") && emp.PayrollType.ToUpper().Equals("DAILY")).ToList().Count();
// Set Authentication Cookie to User's EMAIL ADDRESS -- ( Hardcoded )
FormsAuthentication.SetAuthCookie("*****@*****.**", false);
// [ BEGIN -- Authentication Configuration
var authTicket = new FormsAuthenticationTicket(1, "*****@*****.**", DateTime.Now, DateTime.Now.AddMinutes(720), true, "IT");
string encryptedTicket = FormsAuthentication.Encrypt(authTicket);
var authCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encryptedTicket);
HttpContext.Response.Cookies.Add(authCookie);
// -- END Authentication Configuration ]
// [ BEGIN -- Session Configuration
Session["User"] = "******";
Session["RoleUser"] = "******";
Session["UserId"] = "IT";
Session["UserPosition"] = "ITAdmin";
Session["NumberOfEmployees"] = countEmployees.Count();
Session["NumberOfNewlyEmployees"] = countNewlyEmployees.Count();
Session["NumberOfActiveEmployees"] = countActiveEmployees;
Session["NumberOfInactiveEmployees"] = countEmployees.Count() - countActiveEmployees;
Session["NumberOfRecertificationPlans"] = _AccountManager.ReCertificationPlans.ToList().Count();
Session["NumberOfCertificates"] = _AccountManager.Certifications.ToList().Count();
Session["NumberOfProbationaryEmployees"] = countProbationaryEmployees;
// [ BEGIN -- Session Configuration
return(RedirectToAction("Home", "Home"));
}
else // else return View with error mesage.
{
ModelState.AddModelError("", "Invalid login attempt.");
return(View(model));
}
}
