protected void Login_ServerClick(object sender, EventArgs e) { var email = username.Value; var Password = Secrecy.computeHash(password.Value); var db = new AlchemyLinkDataContext(); var user = from User u in db.Users where u.Email.Equals(email) select u; }
protected void Change_Click(object sender, EventArgs e) { var db = new AlchemyLinkDataContext(); //this line prevents conflict exception when updating multiple fields db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues); int currentUserID = (int)Session["UserID"]; var currentUser = (from User u in db.Users where u.Id.Equals(currentUserID) select u).FirstOrDefault(); if (email.Value != "") { currentUser.Email = email.Value; } if (password.Value != "" && password.Value == cPassword.Value) { currentUser.Password = Secrecy.computeHash(password.Value); } if (fName.Value != "") { currentUser.FirstName = fName.Value; } if (sName.Value != "") { currentUser.Surname = sName.Value; } if (pNumber.Value != "") { currentUser.Phone = pNumber.Value; } if (uName.Value != "") { currentUser.Username = uName.Value; } db.SubmitChanges(); Response.Redirect("UserManagement.aspx"); }
protected void Login_ServerClick(object sender, EventArgs e) { var Email = email.Value; var Password = Secrecy.computeHash(password.Value); var db = new AlchemyLinkDataContext(); var user = (from User u in db.Users where u.Email.Equals(Email) && u.Password.Equals(Password) select u).FirstOrDefault(); if (user != null) { Session["UserID"] = user.Id; Session["Admin"] = user.Admin; Response.Redirect("HomePage.aspx"); } else { userMsg.InnerHtml = "<h1 style=\"color: red\">User details not found. Please try again.</h1>"; } }
protected void Register_ServerClick(object sender, EventArgs e) { Usermsg.InnerHtml = "<h1 style=\"color: red\"> testing </h1>"; var email = userEmail.Value; var UserName = username.Value; var Name = firstname.Value; var SurName = surname.Value; var Cell = phonenumber.Value; var PassWord = Secrecy.computeHash(password.Value); var ConfPass = Secrecy.computeHash(confpassword.Value); Boolean exists = false; var database = new AlchemyLinkDataContext(); dynamic users = from u in database.Users select u; if (PassWord.Equals(ConfPass)) { foreach (User u in database.Users) { if (u.Username.Equals(username) || u.Email.Equals(email)) { exists = true; } } if (!exists) { var NewUser = new User { FirstName = Name, Email = email, Username = UserName, Surname = SurName, Phone = Cell, Password = PassWord, Admin = false, DateRegistered = DateTime.Now.Date }; try { database.Users.InsertOnSubmit(NewUser); database.SubmitChanges(); Response.Redirect("Login.aspx"); } catch (Exception ex) { ex.GetBaseException(); Usermsg.InnerHtml = "<h1 style=\"color: red\"> Registration Failed </h1>"; } } else if (exists) { Usermsg.InnerHtml = "<h1 style=\"color: red\"> User Account Already In Use </h1>"; } } else { Usermsg.InnerHtml = "<h1 style=\"color: red\"> Passwords Do Not Match </h1>"; } }