public ActionResult Index([Bind(Include = "UserName, Password")] Login login) { int results = db.usp_Login(login.UserName, login.Password); int perKey = 0; Message msg = new Message(); if (results != -1) { var pkey = (from p in db.People where p.PersonEmail.Equals(login.UserName) select p.PersonKey).FirstOrDefault(); perKey = (int)pkey; Session["Personkey"] = perKey; msg.MessageText = "Welcome, " + login.UserName; } else { msg.MessageText = "Invalid Login"; } return(View("Results", msg)); }
public ActionResult Index([Bind(Include = "UserName, Password")] LoginClass l) { BakeryEntities db = new BakeryEntities(); //use the stored procedure to validate the user int result = db.usp_Login(l.UserName, l.Password); //Initialize the Message object Message m = new Message(); //if the login is valid get the personkey for the user if (result != -1) { var userkey = (from p in db.People where p.PersonEmail.Equals(l.UserName) select p.PersonKey).FirstOrDefault(); int pkey = (int)userkey; //write the personkey to a session Session["PersonKey"] = pkey; //Create the welcome message m.MessageText = "Welcome, " + l.UserName; } else { //if not valid send the the invalid login message m.MessageText = "Invalid Login"; } return(View("Result", m)); }
public ActionResult Index([Bind(Include = "Email, Password")] LoginClass lc) { int results = db.usp_Login(lc.Email, lc.Password); int vk = 0; Message msg = new Message(); if (results != -1) { var pk = (from r in db.People where r.PersonEmail.Equals(lc.Email) select r.PersonKey).FirstOrDefault(); vk = (int)pk; Session["PersonKey"] = vk; msg.MessageText = "Welcome, " + lc.Email; } else { msg.MessageText = "Invalid Login"; } return(View("result", msg)); }
public ActionResult Index([Bind(Include = "Email, Password")] Login l) { int results = db.usp_Login(l.Email, l.Password); int PKey = 0; Message msg = new Message(); if (results != -1) { var pkey = (from np in db.People where np.PersonEmail.Equals(l.Email) select np.PersonKey).FirstOrDefault(); PKey = (int)pkey; Session["PersonKey"] = PKey; msg.MessageText = "Welcome, " + l.Email; } else { msg.MessageText = "Invalid Login. Please try again. If it's your first time visiting our website, please register first."; } return(View("Result", msg)); }
public ActionResult Index([Bind(Include = "Email, Password")] LoginClass lc) { BakeryEntities db = new BakeryEntities(); int loginResult = db.usp_Login(lc.PersonEmail, lc.PersonPhone); if (loginResult != -1) { var uid = (from r in db.People where r.PersonEmail.Equals(lc.PersonEmail) select r.PersonKey).FirstOrDefault(); int rKey = (int)uid; Session["personKey"] = rKey; MessageClass msg = new MessageClass(); msg.MessageText = "Thank You! You are now logged in as '" + lc.PersonEmail + "'."; return(RedirectToAction("Result", msg)); } MessageClass message = new MessageClass(); message.MessageText = "Invalid Login"; return(View("Result", message)); }
public ActionResult Index([Bind(Include = "email, password")] PersonLogin pl) { int res = db.usp_Login(pl.email, pl.password); int personKey = 0; Message message = new Message(); bool isEmployee = false; if (res == -1) { message.text = "Sorry, your email/password is incorrect. Please try it one more time."; Response.AddHeader("Refresh", "3;url=login"); } else { var personItem = (from r in db.People where r.PersonEmail.Equals(pl.email) select r).FirstOrDefault(); personKey = (int)personItem.PersonKey; var firstName = personItem.PersonFirstName; var emKey = (from e in db.Employees where e.PersonKey == personKey select e.EmployeeKey).FirstOrDefault(); isEmployee = ((int)emKey) == personKey; //TODO: Not try with an employee account. if (isEmployee) { message.text = String.Format("Welcome employee {0}, you can go to check the menu.", firstName); //Response.AddHeader("Refresh", "3;url=product"); } else { message.text = String.Format("Welcome customer {0}, get some delicous bakery with good price.", firstName); Response.AddHeader("Refresh", "3;url=sales"); } Session["PersonKey"] = personKey; Session["isEmployee"] = isEmployee; } return(View("Result", message)); }
public ActionResult Index([Bind(Include = "UserName, Password, PersonKey")] LoginClass loginClass) { BakeryEntities db = new BakeryEntities(); loginClass.PersonKey = 0; int result = db.usp_Login(loginClass.UserName, loginClass.Password); Message msg = new Message(); if (result != -1) { var ukey = (from r in db.People where r.PersonEmail.Equals(loginClass.UserName) select r.PersonKey).FirstOrDefault(); loginClass.PersonKey = (int)ukey; Session["NewPersonKey"] = loginClass.PersonKey; msg.MessageText = "Welcome " + loginClass.UserName; } else { msg.MessageText = "Invalid Login"; } return(View("Result", loginClass)); }