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