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 = "PersonLastName, PersonEmail, PersonPhone, LoginTime")] LoginClass lc) { //connecting database BakeryEntities db = new BakeryEntities(); Person p = new Person(); var email = (from pl in db.People where pl.PersonLastName.Equals(lc.PersonLastName) select pl.PersonEmail).FirstOrDefault(); var phone = (from pl in db.People where pl.PersonLastName.Equals(lc.PersonLastName) select pl.PersonPhone).FirstOrDefault(); if (lc.PersonEmail == email || lc.PersonPhone == phone) { //lookup user key int uID = (from pl in db.People where pl.PersonLastName.Equals(lc.PersonLastName) && (pl.PersonEmail.Equals(lc.PersonEmail) || pl.PersonPhone.Equals(lc.PersonPhone)) select pl.PersonKey).FirstOrDefault(); var FName = (from pl in db.People where pl.PersonLastName.Equals(lc.PersonLastName) && (pl.PersonEmail.Equals(lc.PersonEmail) || pl.PersonPhone.Equals(lc.PersonPhone)) select pl.PersonFirstName).FirstOrDefault(); Session["LoginTime"] = DateTime.Now; Session["CustomerID"] = uID; //create a message class and pass the string to the result view Message msg = new Message("Welcome " + FName + ", You can now shop!"); return(RedirectToAction("Result", msg)); } //if it fails pass this message to the result view Message message = new Message("Invalid Login"); return(View("Result", message)); }
public ActionResult Index([Bind(Include = " PersonKey, PersonLastName, PersonFirstName,PersonEmail, PersonPhone,PersonDateAdded")] CustomerRegister cr) { //connecting database of bakery BakeryEntities db = new BakeryEntities(); Person p = new Person(); p.PersonLastName = cr.PersonLastName; p.PersonFirstName = cr.PersonFirstName; var email = (from pl in db.People where pl.PersonLastName.Equals(cr.PersonLastName) || pl.PersonFirstName.Equals(cr.PersonFirstName) || pl.PersonEmail.Equals(cr.PersonEmail) select pl.PersonEmail).FirstOrDefault(); var phone = (from pl in db.People where pl.PersonLastName.Equals(cr.PersonLastName) || pl.PersonFirstName.Equals(cr.PersonFirstName) || pl.PersonPhone.Equals(cr.PersonPhone) select pl.PersonPhone).FirstOrDefault(); //checking if the personkey existed by comparing the input email and phone if (email == cr.PersonEmail || phone == cr.PersonPhone) { Message msg = new Message("Account Existed"); return(RedirectToAction("Result", msg)); } p.PersonEmail = cr.PersonEmail; p.PersonPhone = cr.PersonPhone; p.PersonDateAdded = DateTime.Now; db.People.Add(p); db.SaveChanges(); Message m = new Message(); m.MessageText = "Thank you, the book has been added"; return(View("Result", m)); }
public ActionResult Index([Bind(Include = "ProductName, ProductPrice")] Product p) { BakeryEntities db = new BakeryEntities(); db.Products.Add(p); db.SaveChanges(); return(View()); }
public ActionResult Index() { //initialize entities classes BakeryEntities db = new BakeryEntities(); //pass the collection categories to the index as a list return(View(db.Products.ToList())); }
public ActionResult Index([Bind(Include = "ProductName, ProductPrice")]Product formProduct) { BakeryEntities db = new BakeryEntities(); Product dbProduct = new Product(); dbProduct.ProductName = formProduct.ProductName; dbProduct.ProductPrice = formProduct.ProductPrice; db.Products.Add(dbProduct); db.SaveChanges(); return View("Verification"); }
public ActionResult Index([Bind(Include = "PersonEmail")] Person lp) { BakeryEntities be = new BakeryEntities(); var loginKey = (from p in be.People where p.PersonEmail.Equals(lp.PersonEmail) select p.PersonKey).FirstOrDefault(); if (loginKey == 0) { Message bad = new Message(); bad.MessageTitle = "Login"; bad.MessageText = "Sorry, you need to register before you can login."; return(RedirectToAction("Result", bad)); } // store user personKey in Session int pKey = (int)loginKey; Session["personKey"] = pKey; //store username String first = (from p in be.People where p.PersonKey.Equals(pKey) select p.PersonFirstName).FirstOrDefault(); Session["personName"] = first; //store user phone String phone = (from p in be.People where p.PersonKey.Equals(pKey) select p.PersonPhone).FirstOrDefault(); Session["personPhone"] = phone; //store user email String email = (from p in be.People where p.PersonKey.Equals(pKey) select p.PersonEmail).FirstOrDefault(); Session["personEmail"] = email; Message m = new Message(); m.MessageTitle = "Login"; m.MessageText = "Thank you, " + first + " your login was successful."; return(RedirectToAction("Result", m)); }
public ActionResult Index([Bind(Include = "LastName, FirstName, Email, Phone, Password")] NewPerson p) { BakeryEntities db = new BakeryEntities(); Message msg = new Message(); int result = db.usp_newPerson(p.LastName, p.FirstName, p.Email, p.Phone, p.Password); if (result != -1) { msg.MessageText = "Thank you for registering"; } else { msg.MessageText = "Something went wrong with the registration"; } return(View("Result", msg)); }
public ActionResult Index([Bind(Include = "PersonLastName, PersonFirstName," + "PersonEmail, PersonPhone")] Person formPerson) { BakeryEntities db = new BakeryEntities(); Person dbPerson = new Person(); dbPerson.PersonLastName = formPerson.PersonLastName; dbPerson.PersonFirstName = formPerson.PersonFirstName; dbPerson.PersonEmail = formPerson.PersonEmail; dbPerson.PersonPhone = formPerson.PersonPhone; dbPerson.PersonDateAdded = DateTime.Now; db.People.Add(dbPerson); db.SaveChanges(); return(View("Validation")); }
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 = "PersonLastName, PersonEmail, PersonPhone")] LoginClass lc) { //connecting database BakeryEntities db = new BakeryEntities(); Person p = new Person(); var email = (from pl in db.People where pl.PersonLastName.Equals(lc.PersonLastName) select pl.PersonEmail).FirstOrDefault(); var phone = (from pl in db.People where pl.PersonLastName.Equals(lc.PersonLastName) select pl.PersonPhone).FirstOrDefault(); if (lc.PersonEmail == email || lc.PersonPhone == phone) { //lookup user key int uID = (from pl in db.People where pl.PersonLastName.Equals(lc.PersonLastName) && (pl.PersonEmail.Equals(lc.PersonEmail) || pl.PersonPhone.Equals(lc.PersonPhone)) select pl.PersonKey).FirstOrDefault(); var FName = (from pl in db.People where pl.PersonLastName.Equals(lc.PersonLastName) && (pl.PersonEmail.Equals(lc.PersonEmail) || pl.PersonPhone.Equals(lc.PersonPhone)) select pl.PersonFirstName).FirstOrDefault(); int eID = 0; eID = (from e in db.Employees where e.PersonKey == (uID) select e.EmployeeKey).FirstOrDefault(); Session["EmployeeID"] = eID; if (Session["EmployeeID"] != null) { //create a message class and pass the string to the result view Message msg = new Message("Welcome " + FName + ", you can Operate the system now."); return(RedirectToAction("Result", msg)); } Message message1 = new Message("Invalid Employee Login"); return(View("Result", message1)); } //if it fails pass this message to the result view Message message = new Message("Invalid Login"); 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)); }
public ActionResult Index() { BakeryEntities db = new BakeryEntities(); return(View()); }
public ActionResult Index() { BakeryEntities db = new BakeryEntities(); return(View(db.Products.ToList())); }