public ActionResult Index( [Bind(Include = "UserName, Password, PersonKey") ] Login lg) { lg.PersonKey = 0; int result = db.usp_Login(lg.UserName, lg.Password); Message m = new Message(); if (result == -1) { m.MessageText = "Validation failed, please try again or register."; } else { Session["ukey"] = (from p in db.People where p.PersonEmail.Equals(lg.UserName) select p.PersonKey).FirstOrDefault(); lg.PersonKey = (int)Session["ukey"]; m.MessageText = "Thank you for logging in. You are now free to donate or apply for assistance"; } return(View("LoginResult", m)); }
public ActionResult Index([Bind(Include = "UserName, " + "Password, " + "PersonKey" )] Login li) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); li.PersonKey = 0; int result = db.usp_Login(li.UserName, li.Password); Message msg = new Message(); msg.Succeeded = result != -1; if (msg.Succeeded) { Session["PersonKey"] = (int)(from p in db.People where p.PersonEmail.Equals(li.UserName) select p.PersonKey).FirstOrDefault(); msg.UserName = (string)(from p in db.People where p.PersonEmail.Equals(li.UserName) select p.PersonFirstName).FirstOrDefault(); return(RedirectToAction("Result", msg)); } else { return(View("Result", msg)); } }
public ActionResult Index([Bind(Include = "UserName, Password")] LoginClass lc) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); int loginResult = db.usp_Login(lc.UserName, lc.Password); if (loginResult != -1) { var uid = (from r in db.People where r.PersonEmail.Equals(lc.UserName) select r.PersonKey).FirstOrDefault(); int rKey = (int)uid; Session["reviewKey"] = rKey; Message msg = new Message(); msg.MessageText = "Thank you, " + lc.UserName + " for logging in. You can now donate or apply for assistance."; return(RedirectToAction("Result", msg)); } Message message = new Message(); message.MessageText = "Invalid Login"; return(View("Result", message)); }
public ActionResult Index([Bind(Include = "Username, Password")] LoginClass lc) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); int loginresult = db.usp_Login(lc.Username, lc.Password); if (loginresult != -1) { var uid = (from p in db.People where p.PersonEmail.Equals(lc.Username) select p.PersonKey).FirstOrDefault(); int pKey = (int)uid; Session["personKey"] = pKey; //create message Message m = new Message(); m.MessageTitle = "Login Results"; m.MessageText = "Thank You, " + lc.Username + " for logging in. You can now donate or apply for grants"; return(RedirectToAction("Result", m)); } Message bad = new Message(); bad.MessageTitle = "Login Results"; bad.MessageText = "Invalid Login"; return(View("Result", bad)); }
public ActionResult Index([Bind(Include = "UserName, Password, PersonKey")] LoginClass loginClass) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); 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 the class to the Result view return(View("Result", loginClass)); }
public ActionResult Index([Bind(Include = "UserName, Password")] LoginClass lc) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); int loginResult = db.usp_Login(lc.UserName, lc.Password); if (loginResult != -1) { var uid = (from np in db.People where np.PersonEmail.Equals(lc.UserName) select np.PersonKey).FirstOrDefault(); int npKey = (int)uid; Session["personkey"] = npKey; Message msg = new Message(); msg.MessageText = "Thank you," + lc.UserName + "for logging in. You can now" + "donate or apply for assistance"; return(RedirectToAction("Result", msg)); } Message message = new Message(); message.MessageText = "Validation failed, please try again or register if you have not done so yet"; return(View("Result", message)); }
public ActionResult Index([Bind(Include = "Email, PlainPassword")] LoginClass lc) { int results = db.usp_Login(lc.Email, lc.PlainPassword); int revKey = 0; Message msg = new Message(); if (results != -1) { var pkey = (from r in db.People where r.PersonEmail.Equals(lc.Email) select r.PersonKey).FirstOrDefault(); revKey = (int)pkey; Session["PersonKey"] = revKey; msg.MessageText = "Welcome, " + lc.Email; } else { msg.MessageText = "Invalid Login. Please try again or register first."; } return(View("Result", msg)); }
public ActionResult Index([Bind(Include = "Email, Password")] LoginClass lgc) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); lgc.PersonKey = 0; int result = db.usp_Login(lgc.Email, lgc.Password); if (result != -1) { var ukey = (from p in db.People where p.PersonEmail.Equals(lgc.Email) select p.PersonKey).FirstOrDefault(); lgc.PersonKey = ukey; System.Web.HttpContext.Current.Session["ukey"] = ukey; } var resultMessage = new Message(); if (result != -1) { resultMessage.MessageText = "Thank you for loggin in. You may now Donate or apply for assistance."; } else { resultMessage.MessageText = "Login failed. Please check your credentials, or Register if you have not yet done so."; } return(View("Result", resultMessage)); }
public ActionResult Index([Bind(Include = "UserName, Password")] LogInClass lc) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); int loginResult = db.usp_Login(lc.UserName, lc.Password); if (loginResult != -1) { var uid = (from r in db.People where r.PersonFirstName.Equals(lc.UserName) select r.PersonKey).FirstOrDefault(); int rKey = (int)uid; Session ["ReviewerKey"] = rKey; Class1Messages msg = new Class1Messages(); msg.MessageText = "Thank You, " + lc.UserName + " for login you can donate"; return(RedirectToAction("Result", msg)); } Class1Messages message = new Class1Messages(); message.MessageText = "invalid Login"; return(View("Result", message)); }
public ActionResult Index([Bind(Include = "Email, Password")] Login lc) { //make connection with database CommunityAssist2017Entities db = new CommunityAssist2017Entities(); //use stored procedure in database int result = db.usp_Login(lc.Email, lc.Password); if (result != -1) { var uID = (from p in db.People where p.PersonEmail.Equals(lc.Email) select p.PersonKey).FirstOrDefault(); //cast ID into a int int key = (int)uID; //store it in a session key Session["PersonKey"] = key; var pName = (from p in db.People where p.PersonEmail.Equals(lc.Email) select p.PersonFirstName).FirstOrDefault(); //create a message class and pass the string to the result view Message msg = new Message("Welcome, " + pName + ". You can now make donation or request for grant."); 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 = "UserName , Password")] LoginClass lc) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); int loginresult = db.usp_Login(lc.UserName, lc.Password); if (loginresult != -1) { var uid = (from r in db.People where r.PersonEmail.Equals(lc.UserName) select r.PersonKey).FirstOrDefault(); int Key = (int)uid; Session["userKey"] = Key; Message msg = new Message("Welcome, " + lc.UserName + ". You can now Donate or apply for a assistance."); return(RedirectToAction("Result", msg)); } Message message = new Message("Invalid Login"); return(View("Result", message)); }
// get the fields from the forms and bind them to the class public ActionResult Index([Bind(Include = "UserName,Password")] LoginClass lc) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); int logingResult = db.usp_Login(lc.Username, lc.Password); if (logingResult != -1) { var uid = (from p in db.People where p.PersonEmail.Equals(lc.Username) select p.PersonKey).FirstOrDefault(); int rKey = (int)uid; Session["userKey"] = rKey; Session["Username"] = lc.Username; Message msg = new Message("Thank you " + lc.Username + " for logging in. You can now donate or apply for assitance"); return(RedirectToAction("Result", msg)); } Message msge = new Message("Invalid Login! Please try again."); return(View("Result", msge)); }
public ActionResult Index([Bind(Include = "UserName, Password")] LoginClass lc) { int results = db.usp_Login(lc.UserName, lc.Password); int perKey = 0; Message msg = new Message(); if (results != -1) { var pkey = (from p in db.People where p.PersonEmail.Equals(lc.UserName) select p.PersonKey).FirstOrDefault(); perKey = (int)pkey; Session["PersonKey"] = perKey; msg.MessageText = "Welcome, " + lc.UserName; } else { msg.MessageText = "Invalid Login"; } return(View("Result", msg)); }
public ActionResult Index([Bind(Include = "Email, Password")] LoginClass lc) { int results = db.usp_Login(lc.Email, lc.Password); int revKey = 0; Message msg = null; if (results != -1) { var pkey = (from e in db.People where e.PersonEmail.Equals(lc.Email) select e.PersonKey).FirstOrDefault(); revKey = (int)pkey; Session["PersonKey"] = revKey; //msg.MessageText = "Welcome" + lc.Email; } else { msg.MessageText = "Invalid Login"; } return(View("result", msg)); }
public ActionResult Index([Bind(Include = "Email, Password")] LoginClass lc) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); int loginResult = db.usp_Login(lc.Email, lc.Password); if (loginResult != -1) { var uid = (from r in db.People where r.PersonEmail.Equals(lc.Email) select r.PersonKey).FirstOrDefault(); int rKey = (int)uid; Session["reviewerKey"] = rKey; MessageClass msg = new MessageClass(); msg.MessageText = "Thank You! You are now logged in as '" + lc.Email + "'."; return(RedirectToAction("Result", msg)); } MessageClass message = new MessageClass(); message.MessageText = "Invalid Login"; return(View("Result", message)); }
public ActionResult Index([Bind(Include = "userName, password")] PersonLogin pl) { int res = db.usp_Login(pl.userName, pl.password); int personKey = 0; Message message = new Message(); if (res == -1) { message.messageText = "Invalid login."; Response.AddHeader("Refresh", "3;url=login"); } else { var pkey = (from r in db.People where r.PersonEmail.Equals(pl.userName) select r.PersonKey).FirstOrDefault(); var firstName = (from r in db.People where r.PersonEmail.Equals(pl.userName) select r.PersonFirstName).FirstOrDefault(); personKey = (int)pkey; Session["PersonKey"] = personKey; message.messageText = "Welcome " + (string)firstName; } return(View("Result", message)); }
public ActionResult Index([Bind(Include = "UserName,Password")] LoginClass loginclass) { CommunityAssist2017Entities br = new CommunityAssist2017Entities(); int result = br.usp_Login(loginclass.UserName, loginclass.Password); int pk = 0; Message n = new Message(); if (result != -1) { var pkey = (from r in br.People where r.PersonEmail.Equals(loginclass.UserName) select r.PersonKey).FirstOrDefault(); pk = (int)pkey; Session["PersonKey"] = pk; n.Messagetext = "Welcome"; } else { n.Messagetext = "invalid login"; } return(View("Result", n)); }
public ActionResult Index([Bind(Include = "Email, Password, UserKey")] LoginClass loginClass) { //make connection to Ado Entity model classes CommunityAssist2017Entities user = new CommunityAssist2017Entities(); //Assign user key a value of 0 loginClass.UserKey = 0; //pass the values to the stored procedure and get result (-1 = failure) int result = user.usp_Login(loginClass.Email, loginClass.Password); //test the results if (result != -1) { //run a query to get the UserKey var ukey = (from r in user.People where r.PersonEmail.Equals(loginClass.Email) select r.PersonKey).FirstOrDefault(); loginClass.UserKey = (int)ukey; Session["personKey"] = loginClass.UserKey; } //return the class to the Result view return(View("Result", loginClass)); }
public ActionResult Index( //bind form values to the class preceeding square brackets [Bind(Include = "ClientEmail, ClientPassword")] AuthenticateClient authClient) { Message argMessage = new Message(); CommunityAssist2017Entities db = new CommunityAssist2017Entities(); /*Logging In *For the login validation we will use the built in stored procedure *usp_login which takes a username (email) and a password.*/ int verifyAuthentication = db.usp_Login( authClient.ClientEmail, authClient.ClientPassword ); /*If the validation fails (the stored procedure returns a -1 if it *fails), the Result page should say something like Validation *failed, please try again or register if you have not done so yet.*/ if ( verifyAuthentication != -1 ) { var personKey = ( from r in db.People where r.PersonEmail.Equals ( authClient.ClientEmail ) select r.PersonKey ).FirstOrDefault(); int clientKey = (int)personKey; Session["sessClientKey"] = clientKey; argMessage.MessageText = "Thank you for verifying creditials " + "of e-mail account: " + authClient.ClientEmail + "."; return RedirectToAction("Result", argMessage); } argMessage.MessageText = "Invaild authentication credentials " + "please try again or register if you have not done so yet."; return View("Result", argMessage); }
public ActionResult Index([Bind(Include = "UserName, Password")] LoginClass lc) { int loginResult = db.usp_Login(lc.UserName, lc.Password); if (loginResult != -1) { var uid = (from u in db.People where u.PersonEmail.Equals(lc.UserName) select u.PersonKey).FirstOrDefault(); int uKey = (int)uid; Session["personKey"] = uKey; Message msg = new Message(); msg.MessageText = "Thank You, " + lc.UserName + " for logging in. You can now donate or apply for assistance"; return(RedirectToAction("Result", msg)); } Message loginFailed = new Message(); loginFailed.MessageText = "Login Failed"; return(View("Result", loginFailed)); }
public ActionResult Index([Bind(Include = "UserName, Password")] LoginClass login) { CommunityAssist2017Entities db = new CommunityAssist2017Entities(); int loginResult = db.usp_Login(login.UserName, login.Password); if (loginResult != -1) { var uid = (from r in db.People where r.PersonEmail.Equals(login.UserName) select r.PersonKey).FirstOrDefault(); int personKey = (int)uid; Session["personKey"] = personKey; Message loginOkay = new Message(); loginOkay.MessageText = "Thank you, " + login.UserName + " login successful!"; return(RedirectToAction("Result", loginOkay)); } Message loginFail = new Message(); loginFail.MessageText = "Invalid credentials! Try again or register."; return(View("Result", loginFail)); }