public static void UpdatePaymentStatus(string TranID, string ErrorDesc, String status, String payuMoneyID, string mode, string ID) { try { string sqlconn = ConfigurationManager.ConnectionStrings["DBCONN"].ConnectionString; string query = "update tbl_Payment_info set TranId = '" + TranID + "', payUMoneyId = '" + payuMoneyID + "', Status = '" + status + "', Mode = '" + mode + "', ErrorMsg = '" + ErrorDesc + "' where ID = '" + ID + "'"; SqlHelper.ExecuteNonQuery(sqlconn, CommandType.Text, query); } catch (Exception ex) { ExceptionHandling.WriteException(ex); throw; } }
public static void SendEmail(string mailBodyHtml, string mailSubject, string toMail) { try { var mail = new MailMessage(ConfigurationManager.AppSettings["FromMail"], ConfigurationManager.AppSettings["ToMail"], mailSubject, mailBodyHtml); mail.To.Add(toMail); mail.IsBodyHtml = true; var smtpClient = new SmtpClient("smtp.gmail.com", 587); //if your from email address is "*****@*****.**" then host should be "smtp.hotmail.com"** smtpClient.UseDefaultCredentials = true; smtpClient.Credentials = new NetworkCredential("*****@*****.**", "Terex@2018"); mail.DeliveryNotificationOptions = DeliveryNotificationOptions.OnSuccess | DeliveryNotificationOptions.OnFailure; mail.Priority = MailPriority.Normal; smtpClient.EnableSsl = true; smtpClient.Send(mail); } catch (Exception ex) { ExceptionHandling.WriteException(ex); } }
public static int SavePaymentOut(string amount, string firstname, string email, string phone, string productinfo) { try { string sqlconn = ConfigurationManager.ConnectionStrings["DBCONN"].ConnectionString; SqlParameter[] sqlParameter = new SqlParameter[5]; sqlParameter[0] = new SqlParameter("@Amount", amount); sqlParameter[1] = new SqlParameter("@Name", firstname); sqlParameter[2] = new SqlParameter("@Email", email); sqlParameter[3] = new SqlParameter("@Phone", phone); sqlParameter[4] = new SqlParameter("@ID", SqlDbType.Int); sqlParameter[4].Direction = ParameterDirection.Output; SqlHelper.ExecuteNonQuery(sqlconn, CommandType.StoredProcedure, "sp_Insert_Payment_Info", sqlParameter); int identity = Convert.ToInt32(sqlParameter[4].Value); return(identity); } catch (Exception ex) { ExceptionHandling.WriteException(ex); return(-1); } }