public ActionResult Login(login_tab usermodel)
{
using (DB05TMS155_1718Entities1 db = new DB05TMS155_1718Entities1())
{
if (ModelState.IsValid)
{
var userdetails = db.login_tab.Where(x => x.userid == usermodel.userid && x.passwrd == usermodel.passwrd).FirstOrDefault();
if (userdetails == null)
{
Response.Write("<script>alert('Please enter valid credentials')</script>");
return(View("Login"));
}
else
{
ObjectParameter o = new ObjectParameter("userrole", 0);
db.checkrole(usermodel.userid, usermodel.passwrd, o);
if (o.Value.ToString() == "CAE")
{
db.login(usermodel.userid, usermodel.passwrd);
Session["userID"] = userdetails.userid;
return(RedirectToAction("startpage", "Executive"));
}
else
{
db.login(usermodel.userid, usermodel.passwrd);
Session["userID"] = userdetails.userid;
return(RedirectToAction("startpage", "Account"));
}
}
}
}
return(View());
}
public static void addLogin(string login, string pass, string role, bool status, short u_id)
{
login_tab new_log = new login_tab();
new_log.login = login;
new_log.password = hashing.GetMd5Hash(MD5.Create(), pass);
new_log.role = role;
new_log.status = status;
new_log.u_id = u_id;
DataClassesDataContext context = new DataClassesDataContext();
new_log.Id = (short)((context.login_tab.OrderByDescending(u => u.Id).FirstOrDefault()).Id + 1);
context.login_tab.InsertOnSubmit(new_log);
context.SubmitChanges();
}
