public async Task <ActionResult> LoginPostBack(AccountViewModel vm)
{
using (var ctx = new UBTTestContext())
{
var user = ctx.Users.Where(x => x.UserName == vm.User.UserName && x.Password == vm.User.Password).FirstOrDefault();
if (user != null)
{
Session["User"] = user; return(await Task.Run(() => RedirectToAction("Index", "Home")));
}
} return(await Task.Run(() => RedirectToAction("Login", "Account")));
}
public async Task <ActionResult> CreateAccountPostBack(AccountViewModel vm)
{
using (var ctx = new UBTTestContext())
{
ctx.Users.Add(vm.User);
await ctx.SaveChangesAsync();
Session["User"] = vm.User;
}
return(await Task.Run(() => RedirectToAction("Index", "Home")));
}
public async Task <ActionResult> ChangePasswordPostback(AccountViewModel vm)
{
using (var ctx = new UBTTestContext())
{
var user = ctx.Users.Where(x => x.UserName == vm.User.UserName && x.Password == vm.User.Password).FirstOrDefault();
if (user != null)
{
user.Password = vm.NewPassword;
var sql = string.Format("UPDATE Users SET Password = '******' WHERE UserId = {1}", vm.NewPassword, user.UserId);
ctx.Database.ExecuteSqlCommand(sql);
return(await Task.Run(() => RedirectToAction("Index", "Home")));
}
}
return(await Task.Run(() => RedirectToAction("ChangePassword", "Account")));
}
