public void ForgotPassword(ForgotPasswordModel ForgotPass, string Email)
{
string Em = Email;
EventLogHandler Logger = new EventLogHandler();
List <CreateUser> validateEmail;
using (IDbConnection db = new SqlConnection(SqlAccess.GetConnectionString()))
{
validateEmail = db.Query <CreateUser>("Select * from dbo.Usertable Where Email = @Email", new { Email = Em }).ToList();
}
if (validateEmail.Count > 0)
{
//send email
string resetCode = Guid.NewGuid().ToString();
SendEmail(Em, resetCode);
validateEmail[0].ResetPasswordCode = resetCode;
using (IDbConnection db = new SqlConnection(SqlAccess.GetConnectionString()))
{
string sql = "Update dbo.UserTable set ResetPasswordCode = @resetCode where Username = @Username";
db.Execute(sql, new { resetCode = resetCode, Username = validateEmail[0].Username });
}
Logger.LogForgotPassword(Em);
System.Diagnostics.Debug.WriteLine("Email was sent");
}
else
{
System.Diagnostics.Debug.WriteLine("Fail, no email sent");
}
//using (Database1Entities5 dc = new Database1Entities5())
//{
// var account = dc.CreateUsers.Where(a => a.Email == Em).FirstOrDefault();
// if (account != null)
// {
// //send email
// string resetCode = Guid.NewGuid().ToString();
// SendEmail(Em, resetCode);
// account.ResetPasswordCode = resetCode;
// dc.SaveChanges();
// Logger.LogForgotPassword(Em);
// Database1Entities6 db2 = new Database1Entities6();
// var events = db2.EventLogs.ToList();
// System.Diagnostics.Debug.WriteLine("Email was sent");
// }
// else {
// System.Diagnostics.Debug.WriteLine("Fail, no email sent");
// }
//}
}
