public string GetEmail(ChangePasswordBO objGetEmailBO) { string Email = string.Empty; SqlConnection sqlConnection = getConnection(); SqlCommand cmd = new SqlCommand(); try { sqlConnection.Open(); DataTable dt = new DataTable(); cmd.Connection = sqlConnection; cmd.CommandText = "Sp_GetEmail"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserId", objGetEmailBO.Id); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); foreach (DataRow Row in dt.Rows) { Email = (Convert.ToString(Row["Email"])); } } catch (Exception ex) { } return(Email); }
public string ChangeUserPassword(string OldPassword, string NewPassword) { string strResult = string.Empty; string Email = string.Empty; try { ChangePasswordBL objChangePasswordBL = new ChangePasswordBL(); ChangePasswordBO objChangePasswordBO = new ChangePasswordBO(); Guid Uid = new Guid(); if (HttpContext.Current.Session != null) { Uid = (Guid)HttpContext.Current.Session["UserId"]; } objChangePasswordBO.Id = Uid; objChangePasswordBO.OldPassword = new MD5Secure().Encrypt(OldPassword); //OldPassword; objChangePasswordBO.NewPassword = new MD5Secure().Encrypt(NewPassword); //NewPassword; strResult = objChangePasswordBL.ChangePassword(objChangePasswordBO); Email = objChangePasswordBL.GetEmail(objChangePasswordBO); if (strResult == "1") { if (Email != "") { SendMail(Email); } } } catch (Exception ex) { strResult = "0"; // Exception } return(strResult); }
public string ChangePassword(ChangePasswordBO objChangePasswordBO) { string strResult = string.Empty; SqlConnection sqlConnection = getConnection(); SqlCommand cmd = new SqlCommand(); try { sqlConnection.Open(); DataTable dt = new DataTable(); cmd.Connection = sqlConnection; cmd.CommandText = "Sp_AdminChangePassword"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserId", objChangePasswordBO.Id); cmd.Parameters.AddWithValue("@OldPassword", objChangePasswordBO.OldPassword); cmd.Parameters.AddWithValue("@NewPassword", objChangePasswordBO.NewPassword); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); foreach (DataRow Row in dt.Rows) { strResult = (Convert.ToString(Row["Result"])); } } catch (Exception ex) { throw ex; } return(strResult); }
public string GetEmail(ChangePasswordBO objGetEmailBO) { ChangePasswordDA objGetEmailDA = new ChangePasswordDA(); return(objGetEmailDA.GetEmail(objGetEmailBO)); }
public string ChangePassword(ChangePasswordBO objChangePasswordBO) { ChangePasswordDA objForgetPasswordDA = new ChangePasswordDA(); return(objForgetPasswordDA.ChangePassword(objChangePasswordBO)); }