public ActionResult Index([Bind(Include = "UserName, Password")] LoginClass lc) { //make a connection to the Entities BookReviewDbEntities db = new BookReviewDbEntities(); //use the stored procedure prebuilt in the database int result = db.usp_ReviewerLogin(lc.UserName, lc.Password); //if the result is valid if (result != -1) { //look up the users key var uID = (from r in db.Reviewers where r.ReviewerUserName.Equals(lc.UserName) select r.ReviewerKey).FirstOrDefault(); //cast it to an int int key = (int)uID; //strore it in a session key Session["userKey"] = key; //create a message class and pass the string to the result view Message msg = new Message("Welcome, " + lc.UserName + ". You can now add and review books."); 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 int BookReviewLogin(string user, string password) { int key = 0; int result = bre.usp_ReviewerLogin(user, password); if (result != -1) { var ky = (from r in bre.Reviewers where r.ReviewerUserName.Equals(user) select r.ReviewerKey).FirstOrDefault(); key = (int)ky; } return(key); }
public int Login(string user, string password) { //just like the login we did in the last assignment int key = 0; int result = db.usp_ReviewerLogin(user, password); if (result != -1) { var userKey = (from k in db.Reviewers where k.ReviewerUserName.Equals(user) select k.ReviewerKey).FirstOrDefault(); key = (int)userKey; } return(result); }
public int ReviewerLogin(string password, string username) { int result = db.usp_ReviewerLogin(username, password); if (result != -1) { var key = from k in db.Reviewers where k.ReviewerUserName.Equals(username) select new { k.ReviewerKey }; foreach (var k in key) { result = (int)k.ReviewerKey; } } return(result); }
protected void LoginButton_Click(object sender, EventArgs e) { int key = 0; BookReviewDbEntities db = new BookReviewDbEntities(); int success = db.usp_ReviewerLogin(UserTextBox.Text, PasswordTextBox.Text); if (success != -1) { var uKey = (from k in db.Reviewers where k.ReviewerUserName.Equals(UserTextBox.Text) select k.ReviewerKey).FirstOrDefault(); key = (int)uKey; Session["userKey"] = key; Response.Redirect("Author.aspx"); } else { ResultLabel.Text = "Invalid Login"; } }
public ActionResult Index([Bind(Include = "UserName, Password")] LoginClass lc) { BookReviewDbEntities db = new BookReviewDbEntities(); int loginResult = db.usp_ReviewerLogin(lc.UserName, lc.Password); if (loginResult != -1) { var uid = (from r in db.Reviewers where r.ReviewerUserName.Equals(lc.UserName) select r.ReviewerKey).FirstOrDefault(); int rKey = (int)uid; Session["reviewerKey"] = rKey; MessageClass msg = new MessageClass(); msg.MessageText = "Thank You, " + lc.UserName + " for logging in. You can now donate or apply for assistance."; return(RedirectToAction("Result", msg)); } MessageClass message = new MessageClass(); message.MessageText = "Invalid Login"; return(View("Result", message)); }
//overloaded Index method public ActionResult Index([Bind(Include = "UserName, Password, ReviewerKey")] LoginClass loginClass) { //make connection to Ado Entity model classes BookReviewDbEntities br = new BookReviewDbEntities(); //Assign review key a value of 0 loginClass.ReviewerKey = 0; //pass the values to the stored procedure and get result (-1 = failure) int result = br.usp_ReviewerLogin(loginClass.UserName, loginClass.Password); //test the results if (result != -1) { //run a query to get the ReviewerKey var ukey = (from r in br.Reviewers where r.ReviewerUserName.Equals(loginClass.UserName) select r.ReviewerKey).FirstOrDefault(); loginClass.ReviewerKey = (int)ukey; } //return the class to the Result view return(View("Result", loginClass)); }
protected void loginbutton_Click(object sender, EventArgs e) { int key = 0; BookReviewDbEntities db = new BookReviewDbEntities(); int success = db.usp_ReviewerLogin(usertextbox.Text, passwordtextbox.Text); if (success != -1) { var uKey = (from K in db.Reviewers where K.ReviewerUserName.Equals(usertextbox.Text) select K.ReviewerKey).FirstOrDefault(); key = (int)uKey; Session["userkey"] = key; ResultLabel.Text = " Helloooo" + key.ToString(); } else { ResultLabel.Text = " Errrrr"; } }