public ActionResult AccountRecovery(AccountRecoveryModel model)
{
ErrorController ErrorFinder = new ErrorController();
List <CreateUser> user;
using (IDbConnection db = new SqlConnection(SqlAccess.GetConnectionString()))
{
user = db.Query <CreateUser>("Select * from dbo.UserTable where Username = @Username AND Email = @Email;",
new { Username = model.Username, Email = model.Email }).ToList();
}
if (user.Count() == 0)
{
ViewBag.Message = ErrorFinder.GetErrorMessage(35);
}
else if (user[0].AccountLocked == false)
{
ViewBag.Message = ErrorFinder.GetErrorMessage(36);
}
else
{
//store in session variables the username and email
System.Web.HttpContext.Current.Session["Username"] = user[0].Username;
System.Web.HttpContext.Current.Session["Email"] = user[0].Email;
// //go to security questions page for answerings and unlocking
return(Redirect("~/Account/AnswerQuestions"));
}
//Database1Entities5 db = new Database1Entities5();
//var userDetails = db.CreateUsers.Where(validUser => validUser.Username == model.Username && validUser.Email == model.Email).FirstOrDefault();
//if (userDetails == null)
//{
// ViewBag.Message = ErrorFinder.GetErrorMessage(35);
//}
//else if (userDetails.Account_Locked == false)
//{
// ViewBag.Message = ErrorFinder.GetErrorMessage(36);
//}
//else
//{
// //store in session variables the username and email
// System.Web.HttpContext.Current.Session["Username"] = userDetails.Username;
// System.Web.HttpContext.Current.Session["Email"] = userDetails.Email;
// //go to security questions page for answerings and unlocking
// return Redirect("~/Account/AnswerQuestions");
//}
return(View());
}
public ActionResult AccountRecovery()
{
var v = new AccountRecoveryModel();
return(View(v));
}
