public ActionResult ResetPassword(ResetPasswordModel model)
{
EventLogHandler Logger = new EventLogHandler();
var message = "";
if (ModelState.IsValid)
{
List <CreateUser> validatePasswordCode;
using (IDbConnection db = new SqlConnection(SqlAccess.GetConnectionString()))
{
validatePasswordCode = db.Query <CreateUser>($"Select * from dbo.Usertable Where ResetPasswordCode = @ResetCode", new { ResetCode = model.ResetCode }).ToList();
}
if (validatePasswordCode.Count > 0)
{
OldPasswordHandler PassHand = new OldPasswordHandler();
PassHand.AdjustOldPasswords(validatePasswordCode[0].Password, validatePasswordCode[0].ID);
using (IDbConnection db = new SqlConnection(SqlAccess.GetConnectionString()))
{
string sql = $"Update dbo.UserTable set Password = @Password, ResetPasswordCode = NULL where Username = @Username";
db.Execute(sql, new { Password = model.Password, Username = validatePasswordCode[0].Username });
message = "Password updated successfully.";
Logger.LogPasswordReset(validatePasswordCode[0].ID, validatePasswordCode[0].Username);
ViewBag.Message = message;
}
}
}
return(View(model));
//if (ModelState.IsValid)
//{
// using (Database1Entities5 dc = new Database1Entities5())
// {
// var user = dc.CreateUsers.Where(a => a.ResetPasswordCode == model.ResetCode).FirstOrDefault();
// if (user != null)
// {
// OldPasswordHandler PassHand = new OldPasswordHandler();
// PassHand.AdjustOldPasswords(user.Password, user.ID);
// user.Password = model.Password;
// user.ResetPasswordCode = "";
// dc.SaveChanges();
// Logger.LogPasswordReset(user.ID, user.Username);
// Database1Entities6 db2 = new Database1Entities6();
// var events = db2.EventLogs.ToList();
// var message = "Password updated successfully.";
// ViewBag.Message = message;
// }
// }
//}
//return View(model);
}
