public ActionResult Save()
{
var Code = Request.Form["Code"].ToUpper();
var Description = Request.Form["Description"].ToUpper();
var Point = Convert.ToInt32(Request.Form["Point"]);
var Type = Request.Form["Type"];
using (lear_DailiesCertificationRequirementEntities ldcr = new lear_DailiesCertificationRequirementEntities())
{
var exist = ldcr.Certifications.Where(cert => cert.Code == Code).FirstOrDefault();
if (exist == null)
{
Certification certification = new Certification
{
Code = Code,
Description = Description,
Points = Point,
Type = Type
};
ldcr.Certifications.Add(certification);
ldcr.SaveChanges();
}
}
return(RedirectToAction("Certificates", "Certificate"));
}
public AccountController(ApplicationUserManager userManager, ApplicationSignInManager signInManager,
lear_DailiesCertificationRequirementEntities accountManager,
commonEmployeesEntities employeesManager)
{
UserManager = userManager;
SignInManager = signInManager;
_AccountManager = accountManager;
_EmployeesManager = employeesManager;
}
public ActionResult Edit(String id)
{
using (lear_DailiesCertificationRequirementEntities db = new lear_DailiesCertificationRequirementEntities())
{
int ID = Convert.ToInt32(id);
var certification = db.Certifications.Where(crt => crt.Id == ID).FirstOrDefault();
ViewBag.OldCode = certification.Code;
return(View(certification));
}
}
// GET: Certificate
public ActionResult Certificates()
{
CertificateViewModel model = new CertificateViewModel();
using (lear_DailiesCertificationRequirementEntities db = new lear_DailiesCertificationRequirementEntities())
{
model.Certifications = db.Certifications.ToList <Certification>();
}
return(View(model));
}
public ActionResult PostEdit([Bind(Include = "Id,Code,Description,Points")] Certification certification)
{
var oldCode = Request.Form["OldCode"].ToString();
var Type = Request.Form["Type"];
using (lear_DailiesCertificationRequirementEntities db = new lear_DailiesCertificationRequirementEntities())
{
if (ModelState.IsValid)
{
if (oldCode.Equals(certification.Code.ToUpper()))
{
certification.Code = certification.Code.ToUpper();
certification.Description = certification.Description.ToUpper();
certification.Type = Type;
db.Entry(certification).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Certificates"));
}
else
{
if (db.Certifications.Where(crt => crt.Code == certification.Code.ToUpper()).FirstOrDefault() == null)
{
certification.Code = certification.Code.ToUpper();
certification.Description = certification.Description.ToUpper();
certification.Type = Type;
db.Entry(certification).State = EntityState.Modified;
db.SaveChanges();
db.UpdateLDCRTablesWhenUpdateCertification(oldCode, certification.Code);
return(RedirectToAction("Certificates"));
}
else
{
return(RedirectToAction("ModalFailed", new { id = certification.Id, errorMessage = "Code is already used! It must be unique. " }));
}
}
}
}
return(RedirectToAction("Edit", new { id = certification.Id.ToString() }));
}
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));
}
}
public async Task <ActionResult> Register(Account model)
{
_EmployeesManager = new commonEmployeesEntities();
_AccountManager = new lear_DailiesCertificationRequirementEntities();
// Check if model is Valid
if (ModelState.IsValid)
{
// Check if password is Match
System.Diagnostics.Debug.WriteLine(Request["Confirm"].ToString() + "___" + model.Password);
if (model.Password == Request["Confirm"].ToString())
{
// Check if BadgeNo is exist!;
var user = _EmployeesManager.Employees_Details.Where(u => u.Employee_ID == model.BagdeNo).SingleOrDefault();
if (user != null)
{
// Check if account is already exist
var account = _AccountManager.Users.Where(a => a.BadgeNo == model.BagdeNo).SingleOrDefault();
if (account != null)
{
ModelState.AddModelError("", "Account already exist");
}
else //if not save to User table
{
var users = _EmployeesManager.Database.SqlQuery <Approver>("Select * from approvers").ToList <Approver>();
model.Roles = "Default";
foreach (Approver app in users)
{
System.Diagnostics.Debug.WriteLine(app.approver);
if (model.BagdeNo.Equals(app.approver.ToString()))
{
model.Roles = "Approver";
break;
}
}
// Implement here Password:Encryption
PasswordSecurity ps = new PasswordSecurity();
var pass = ps.Encryptdata(model.Password);
//System.Diagnostics.Debug.WriteLine(pass);
//System.Diagnostics.Debug.WriteLine(ps.Decryptdata(pass)+"DECRYPTED");
User useraccount = new User()
{
BadgeNo = model.BagdeNo, Roles = model.Roles, Password = pass
};
_AccountManager.Users.Add(useraccount);
_AccountManager.SaveChanges();
return(RedirectToAction("Home", "Home"));
}
}
else
{
ModelState.AddModelError("", "BadgeNo is not exist");
}
}
else
{
ModelState.AddModelError("", "Password is not Match!");
}
//return RedirectToAction("Index", "Home");
}
return(View(model));
}
