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));
}