public ActionResult Index(Account account) { if (ModelState.IsValid) { var t = (from o in db.Accounts where o.UserName == account.UserName && o.Password == account.Password select o.UserName).ToList(); if (t.Count()!= 0) { Session["admin"] = t[0]; return Redirect("/DbWeb/index"); } } return View(account); }
public ActionResult AddAdmin(Admin admin) { if (ModelState.IsValid) { db.Admins.Add(admin); db.SaveChanges(); var tempName = (from i in db.Admins where i.UserName==admin.UserName select i.UserName).ToList(); var tempPassword = (from i in db.Admins where i.UserName==admin.UserName select i.ConfirmNewPassword).ToList(); Account account = new Account(); account.UserName=tempName[0]; account.Password = tempPassword[0]; db.Accounts.Add(account); db.SaveChanges(); db.Admins.Remove(admin); db.SaveChanges(); return Redirect("/DbWeb/index"); } return View(admin); }
public ActionResult ModifyPassword(Password password) { if (ModelState.IsValid) { var tempPassword = (from i in db.Passwords where i.Name == password.Name select i).ToList(); tempPassword[0].Name = password.Name; tempPassword[0].NewPassword = password.NewPassword; tempPassword[0].ConfirmNewPassword = password.ConfirmNewPassword; Account account = new Account(); var tempAccount = (from i in db.Accounts where i.UserName == password.Name select i).ToList(); tempAccount[0].Password = tempPassword[0].ConfirmNewPassword; var keyId = (from i in db.Accounts where i.UserName == password.Name select i.AccountId).ToList(); db.Accounts.Find(keyId[0]).Password = tempAccount[0].Password; db.SaveChanges(); return Redirect("/DbWeb/index"); } return View(password); }