public ChangePasswordResponse ChangePassword(ChangePassword ul) { ChangePasswordResponse res = new ChangePasswordResponse(); try { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[Convert.ToString(ul.AppId)].ConnectionString); string Password = string.Empty; string PasswordKey = string.Empty; string ChangePassword = string.Empty; string changePasswordKey = string.Empty; ChangePassword = DBsecurity.Encrypt(ul.Password, ref changePasswordKey); con.Open(); string query = "Sp_WebSevice"; SqlCommand cmd = new SqlCommand(query, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@QueryType", "ChangePassword"); cmd.Parameters.AddWithValue("@UserId", ul.UserId); cmd.Parameters.AddWithValue("@Password", ChangePassword); cmd.Parameters.AddWithValue("@PasswordKey", changePasswordKey); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable ds = new DataTable(); da.Fill(ds); if (ds != null && ds.Rows.Count > 0) { res.status = "Success"; res.message = "Password changed successfully"; res.userId = ul.UserId; } else { res.status = "failure"; res.message = "Password not changed"; res.userId = ""; } con.Close(); } catch (Exception ex) { res.status = "failure"; res.message = "Invalid data"; } return(res); }
public SendEmailResponse ForgetPassword(SendEmail Data) { SendEmailResponse pf = new SendEmailResponse(); try { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[Convert.ToString(Data.AppId)].ConnectionString); con.Open(); string query = "Sp_WebSevice"; SqlCommand cmd = new SqlCommand(query, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@QueryType", "ChkEmail"); cmd.Parameters.AddWithValue("@EmailId", Data.emailId); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); if (ds != null && ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0] != null && Convert.ToInt32(ds.Tables[0].Rows[0]["value"]) == 1) { if (ds.Tables[1].Rows.Count > 0 && ds.Tables[1] != null) { using (StringWriter sw = new StringWriter()) { using (HtmlTextWriter hw = new HtmlTextWriter(sw)) { StringBuilder sb = new StringBuilder(); string WebAppUrl = ConfigurationManager.AppSettings["WebAppUrl" + Data.AppId].ToString(); //string SMTPHost = ConfigurationManager.AppSettings["SMTPHost"].ToString(); //string UserId = ConfigurationManager.AppSettings["UserId"].ToString(); //string MailPassword = ConfigurationManager.AppSettings["MailPassword"].ToString(); //string SMTPPort = ConfigurationManager.AppSettings["SMTPPort"].ToString(); //string SMTPEnableSsl = ConfigurationManager.AppSettings["SMTPEnableSsl"].ToString(); string SMTPHost = ConfigurationManager.AppSettings["Amazon_SMTPHost"].ToString(); string UserId = ConfigurationManager.AppSettings["Amazon_UserId"].ToString(); string MailPassword = ConfigurationManager.AppSettings["Amazon_MailPassword"].ToString(); string SMTPPort = ConfigurationManager.AppSettings["Amazon_SMTPPort"].ToString(); string SMTPEnableSsl = ConfigurationManager.AppSettings["Amazon_SMTPEnableSsl"].ToString(); string FromMailId = ConfigurationManager.AppSettings["Amazon_FromMailId" + Data.AppId].ToString(); sb.Append("Dear " + ds.Tables[1].Rows[0]["UserName"].ToString() + ",<br> <br>"); sb.Append("Please click on the below button to set a new Password . <br> <br>"); string User = DBsecurity.Encrypt(ds.Tables[1].Rows[0]["UserId"].ToString()); sb.Append("<a href='" + WebAppUrl + "ChangePassword.aspx?Id=" + User + "' target='_blank'>"); sb.Append("<input style='background-color: #3965a9;color: #fff;padding: 3px 10px 3px 10px;' type='button' value='Change Password' /></a> </div>"); SmtpClient smtpClient = new SmtpClient(); MailMessage mailmsg = new MailMessage(); MailAddress mailaddress = new MailAddress(FromMailId); mailmsg.To.Add(ds.Tables[1].Rows[0]["EmailId"].ToString()); mailmsg.From = mailaddress; mailmsg.Subject = "Recover Password"; mailmsg.IsBodyHtml = true; mailmsg.Body = sb.ToString(); smtpClient.Host = SMTPHost; smtpClient.Port = Convert.ToInt32(SMTPPort); smtpClient.EnableSsl = Convert.ToBoolean(SMTPEnableSsl); smtpClient.UseDefaultCredentials = true; smtpClient.Credentials = new System.Net.NetworkCredential(UserId, MailPassword); smtpClient.Send(mailmsg); } } } pf.message = "Successfully Send"; pf.status = "Success"; } else if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0] != null && Convert.ToInt32(ds.Tables[0].Rows[0]["value"]) == 2) { if (ds.Tables[1].Rows.Count > 0 && ds.Tables[1] != null) { using (StringWriter sw = new StringWriter()) { using (HtmlTextWriter hw = new HtmlTextWriter(sw)) { string WebAppUrl = ConfigurationManager.AppSettings["WebAppUrl"].ToString(); string SMTPHost = ConfigurationManager.AppSettings["SMTPHost"].ToString(); string UserId = ConfigurationManager.AppSettings["UserId"].ToString(); string MailPassword = ConfigurationManager.AppSettings["MailPassword"].ToString(); string SMTPPort = ConfigurationManager.AppSettings["SMTPPort"].ToString(); string SMTPEnableSsl = ConfigurationManager.AppSettings["SMTPEnableSsl"].ToString(); StringBuilder sb = new StringBuilder(); sb.Append("Dear Sir/Mam ,<br> <br>"); sb.Append(" " + ds.Tables[1].Rows[0]["Name"].ToString() + " has requested to set a new password. Please click on the below button to set a new Password. <br> <br>"); string User = DBsecurity.Encrypt(ds.Tables[1].Rows[0]["UserId"].ToString()); sb.Append("<a href='" + WebAppUrl + "ChangePassword.aspx?Id=" + User + "' target='_blank'>"); sb.Append("<input style='background-color: #3965a9;color: #fff;padding: 3px 10px 3px 10px;' type='button' value='Change Password' /></a> </div>"); SmtpClient smtpClient = new SmtpClient(); MailMessage mailmsg = new MailMessage(); MailAddress mailaddress = new MailAddress(UserId); mailmsg.To.Add(ds.Tables[2].Rows[0]["EmailId"].ToString()); mailmsg.From = mailaddress; mailmsg.Subject = "Recover Password"; mailmsg.IsBodyHtml = true; mailmsg.Body = sb.ToString(); smtpClient.Host = SMTPHost; smtpClient.Port = Convert.ToInt32(SMTPPort); smtpClient.EnableSsl = Convert.ToBoolean(SMTPEnableSsl); smtpClient.UseDefaultCredentials = true; smtpClient.Credentials = new System.Net.NetworkCredential(UserId, MailPassword); smtpClient.Send(mailmsg); } } } pf.message = "Successfully Send"; pf.status = "Success"; } else if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0] != null && Convert.ToInt32(ds.Tables[0].Rows[0]["value"]) == -1) { pf.status = "failure"; pf.message = "Not exist"; } } else { pf.status = "failure"; pf.message = "Not exist"; } } catch (Exception ex) { pf.message = "Invalid data"; pf.status = "failure"; } return(pf); }
public UserLogin ChangePassword(UserLoginRequest ul) { try { if (ul.UserPin.Trim() == "") { res.Message = "User cannot be blank"; res.Status = "Failure"; res.UserLoginResponse = ListView; Ulr.UserId = ""; Ulr.UserPin = ""; ListView.Add(Ulr); return(res); } else { if (ul.Password.Trim() != "") { string pass = string.Empty; string passkey = string.Empty; pass = DBsecurity.Encrypt(ul.Password.Trim(), ref passkey); query = "SP_Login"; dbcommand = new SqlCommand(query, conn); dbcommand.Connection.Open(); dbcommand.CommandType = CommandType.StoredProcedure; dbcommand.Parameters.AddWithValue("@QueryType", "APIUpdatePassword"); dbcommand.Parameters.AddWithValue("@UserPin", ul.UserPin); dbcommand.Parameters.AddWithValue("@Password", pass); dbcommand.Parameters.AddWithValue("@PasswordKey", passkey); SqlDataAdapter da = new SqlDataAdapter(dbcommand); DataTable dt = new DataTable(); da.Fill(dt); conn.Close(); if (dt.Rows.Count > 0) { res.Message = "Password has been changed"; res.Status = "success"; res.UserLoginResponse = ListView; Ulr.UserId = ""; Ulr.UserPin = ""; ListView.Add(Ulr); } } else { res.Message = "Password cannot be blank"; res.Status = "Failure"; res.UserLoginResponse = ListView; Ulr.UserId = ""; Ulr.UserPin = ""; ListView.Add(Ulr); } } } catch (Exception ex) { res.Status = "Failure"; res.Message = ex.Message; } finally { dbcommand.Connection.Close(); } return(res); }