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);
}
