// Send Email on Credit purchase public PaymentReceipt GetCreditPtTransactionDetails(object[] objValue) { BillingResource objBillingResource = new BillingResource(); PaymentReceipt objTransactionDetails = new PaymentReceipt(); objTransactionDetails = objBillingResource.GetCreditPtTransactionDetails(objValue); SendCreditPurchaseTransactionEmail(objTransactionDetails); //string subject = ""; //string body = ""; //SendEmail(objTransactionDetails.TributeId, "subject", "body", "Your Tribute <" + WebConfig.NoreplyEmail + ">"); return objTransactionDetails; }
/// Method to get the Transaction details for the payment of Video tribute upgrade public PaymentReceipt GetVideoTrUpgradeTransactionDetails(object[] objValue) { PaymentReceipt objPaymentReceipt = new PaymentReceipt(); //PaymentReceipt objpay = null; try { DataSet ds = GetDataSet("usp_GetTransactionDetails", objValue); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { objPaymentReceipt = (new PaymentReceipt(int.Parse(ds.Tables[0].Rows[i]["TransactionId"].ToString()), ds.Tables[0].Rows[i]["Tributename"].ToString(), ds.Tables[0].Rows[i]["TypeDescription"].ToString(), ds.Tables[0].Rows[i]["Packagename"].ToString(), (ds.Tables[0].Rows[i]["Enddate"].ToString().Length != 0 ? Convert.ToDateTime(ds.Tables[0].Rows[i]["Enddate"]).ToString("MMMM dd, yyyy") : "Never"), ds.Tables[0].Rows[i]["CardholdersName"].ToString(), ds.Tables[0].Rows[i]["Address"].ToString(), ds.Tables[0].Rows[i]["City"].ToString(), ds.Tables[0].Rows[i]["State"].ToString(), ds.Tables[0].Rows[i]["Country"].ToString(), ds.Tables[0].Rows[i]["Zip"].ToString(), ds.Tables[0].Rows[i]["Telephone"].ToString(), DateTime.Parse(ds.Tables[0].Rows[i]["StartDate"].ToString()), ds.Tables[0].Rows[i]["CreditCardType"].ToString(), ds.Tables[0].Rows[i]["CreditCardNo"].ToString(), Convert.ToDouble(ds.Tables[0].Rows[i]["AmountPaid"].ToString()), ds.Tables[0].Rows[i]["SponsorEmailAddress"].ToString(), Convert.ToBoolean(ds.Tables[0].Rows[i]["IsAutomaticRenew"].ToString()))); } } return objPaymentReceipt; } catch (Exception ex) { throw ex; } }
public PaymentReceipt GetCreditPtTransactionDetails(object[] objValue) { PaymentReceipt objPaymentReceipt = new PaymentReceipt(); //PaymentReceipt objpay = null; try { DataSet ds = GetDataSet("usp_GetCreditPtPurchaseDetails", objValue); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { objPaymentReceipt = (new PaymentReceipt(int.Parse(ds.Tables[0].Rows[i]["TransactionId"].ToString()), ds.Tables[0].Rows[i]["CardholdersName"].ToString(), ds.Tables[0].Rows[i]["Address"].ToString(), ds.Tables[0].Rows[i]["City"].ToString(), ds.Tables[0].Rows[i]["State"].ToString(), ds.Tables[0].Rows[i]["Country"].ToString(), ds.Tables[0].Rows[i]["Zip"].ToString(), ds.Tables[0].Rows[i]["Telephone"].ToString(), DateTime.Parse(ds.Tables[0].Rows[i]["CreatedDate"].ToString()), ds.Tables[0].Rows[i]["CreditCardType"].ToString(), ds.Tables[0].Rows[i]["CreditCardNo"].ToString(), int.Parse(ds.Tables[0].Rows[i]["AmountPaid"].ToString()), ds.Tables[0].Rows[i]["SponsorEmailAddress"].ToString())); } } return objPaymentReceipt; } catch (Exception ex) { throw ex; } }
private void SendTransactionEmail(PaymentReceipt transactionDetails) { string subject = "Order Receipt #" + transactionDetails.TransactionId.ToString(); StringBuilder sbEmailBody = new StringBuilder(); sbEmailBody.Append("<font style='font-size: 12px; font-family:Lucida Sans;'>"); sbEmailBody.Append("<p>Your Tribute thanks you for your order. Please retain this receipt for your records.</p>"); sbEmailBody.Append("<br/>"); sbEmailBody.Append("<b>Order Information:</b><br/>"); sbEmailBody.Append("<table border='0' width='100%' style=\"font-family:Lucida Sans; font-size:12px\"><tr><td width=\"200\">Tribute Name:</td><td>" + transactionDetails.Tributename.Trim() + "</td></tr>"); sbEmailBody.Append("<tr><td width=\"200\">Tribute Type:</td><td>" + transactionDetails.TypeDescription.Trim() + "</td></tr>"); sbEmailBody.Append("<tr><td width=\"200\">Package Type:</td><td>" + transactionDetails.Packagename.Trim() + "</td></tr>"); sbEmailBody.Append("<tr><td width=\"200\">Expiry Date:</td><td>" + transactionDetails.Enddate.Trim() + "</td></tr></table>"); sbEmailBody.Append("<br/>"); sbEmailBody.Append("<b>Payment Information:</b><br/>"); sbEmailBody.Append("<table border='0' width='100%' style=\"font-family:Lucida Sans; font-size:12px\"><tr><td width=\"200\">Billing Date:</td><td>" + transactionDetails.StartDate.ToString("MMMM dd, yyyy").Trim() + "</td></tr>"); sbEmailBody.Append("<tr><td width=\"200\">Payment Type:</td><td>" + transactionDetails.CreditCardType.Trim() + "</td></tr>"); sbEmailBody.Append("<tr><td width=\"200\">Amount Billed:</td><td>" + transactionDetails.AmountPaid.ToString().Trim() + "</td></tr>"); string strCredit = string.Empty; string ccnumber = TributePortalSecurity.Security.DecryptSymmetric(transactionDetails.CreditCardNo.Trim()); //comment for server //string ccnumber = transactionDetails.CreditCardNo.Trim(); for (int indexCredit = 0; indexCredit < ccnumber.Length - 4; indexCredit++) strCredit += "X"; sbEmailBody.Append("<tr><td width=\"200\">Credit Card:</td><td>" + strCredit + ccnumber.Substring(ccnumber.Length - 4) + "</td></tr>"); sbEmailBody.Append("<tr><td width=\"200\">TransactionId:</td><td>" + transactionDetails.TransactionId.ToString().Trim() + "</td></tr></table>"); sbEmailBody.Append("<br/>"); sbEmailBody.Append("<b>Billing Information:</b><br/>"); sbEmailBody.Append("<table border='0' width='100%' style=\"font-family:Lucida Sans; font-size:12px\"><tr><td width=\"200\">Name:</td><td>" + transactionDetails.CardholdersName.Trim() + "</td></tr>"); sbEmailBody.Append("<tr><td width=\"200\">Address:</td><td>" + transactionDetails.Address.Trim() + "</td></tr>"); sbEmailBody.Append("<tr><td width=\"200\">City:</td><td>" + transactionDetails.City.Trim() + "</td></tr>"); sbEmailBody.Append("<tr><td width=\"200\">State/Province:</td><td>" + transactionDetails.State.Trim() + "</td></tr>"); sbEmailBody.Append("<tr><td width=\"200\">Country:</td><td>" + transactionDetails.Country.Trim() + "</td></tr>"); sbEmailBody.Append("<tr><td width=\"200\">Zip/Postal Code:</td><td>" + transactionDetails.Zip.Trim() + "</td></tr>"); sbEmailBody.Append("<tr><td width=\"200\">Telephone:</td><td>" + transactionDetails.Telephone.Trim() + "</td></tr></table>"); sbEmailBody.Append("<br/>"); sbEmailBody.Append("<strong>If you have any questions about your order, please email Your Tribute at <a href='#'>" + ConfigurationSettings.AppSettings["BillingEmail"] + "</a>, with the transaction details listed above.</strong>"); sbEmailBody.Append("</font>"); EmailMessages objEmail = EmailMessages.Instance; objEmail.SendSponsorEmail("Your Tribute<*****@*****.**>", transactionDetails.SponsorEmailAddress, subject, sbEmailBody.ToString(), EmailMessages.TextFormat.Html.ToString()); }
/// <summary> /// Method to get the transaction details based on the package id /// </summary> /// <param name="objValue">Package id</param> /// <returns>Transaction details.</returns> public PaymentReceipt GetTransactionDetails(object[] objValue) { BillingResource objBillingResource = new BillingResource(); PaymentReceipt objTransactionDetails = new PaymentReceipt(); objTransactionDetails = objBillingResource.GetTransactionDetails(objValue); SendTransactionEmail(objTransactionDetails); return objTransactionDetails; }
private void SendVideoTributeCreationTransactionEmail(PaymentReceipt transactionDetails) { string subject = "Order Receipt #" + transactionDetails.TransactionId.ToString(); StringBuilder sbEmailBody = new StringBuilder(); sbEmailBody.Append("<font style='font-size: 12px; font-family:Lucida Sans;'>"); sbEmailBody.Append("<p>Your " + WebConfig.ApplicationWord + " thanks you for your order. Please retain this receipt for your records.</p>"); sbEmailBody.Append("<br/>"); sbEmailBody.Append("<b>Order Information:</b><br/>"); sbEmailBody.Append("<table border='0' width='100%' style=\"font-family:Lucida Sans; font-size:12px\"><tr><td width=\"200\">" + WebConfig.ApplicationWordForInternalUse + " Name:</td><td>" + transactionDetails.Tributename.Trim() + "</td></tr>"); sbEmailBody.Append("<tr><td width=\"200\">" + WebConfig.ApplicationWordForInternalUse + " Type:</td><td>" + transactionDetails.TypeDescription.Trim() + " " + WebConfig.ApplicationWordForInternalUse + "</td></tr>"); sbEmailBody.Append("<tr><td width=\"200\">Package Type:</td><td>" + transactionDetails.Packagename.Trim() + "</td></tr>"); sbEmailBody.Append("<tr><td width=\"200\">Expiry Date:</td><td>" + transactionDetails.Enddate.Trim() + "</td></tr></table>"); sbEmailBody.Append("<br/>"); sbEmailBody.Append("<b>Payment Information:</b><br/>"); sbEmailBody.Append("<table border='0' width='100%' style=\"font-family:Lucida Sans; font-size:12px\"><tr><td width=\"200\">Billing Date:</td><td>" + transactionDetails.StartDate.ToString("MMMM dd, yyyy").Trim() + "</td></tr>"); if (HttpContext.Current.Session["ViaCreditCard"].Equals(true)) { sbEmailBody.Append("<tr><td width=\"200\">Payment Type:</td><td>" + transactionDetails.CreditCardType.Trim() + "</td></tr>"); } else { sbEmailBody.Append("<tr><td width=\"200\">Payment Type:</td><td>Credits</td></tr>"); } if (HttpContext.Current.Session["ViaCreditCard"].Equals(true)) { sbEmailBody.Append("<tr><td width=\"200\">Amount Billed:</td><td>" + transactionDetails.AmountPaid.ToString().Trim() + "</td></tr>"); } else { if (transactionDetails.Packagename.Trim().ToString().Equals("1 Year")) { sbEmailBody.Append("<tr><td width=\"200\">Amount Billed:</td><td>1 Credit</td></tr>"); } else { sbEmailBody.Append("<tr><td width=\"200\">Amount Billed:</td><td>2 Credits</td></tr>"); } } if (HttpContext.Current.Session["ViaCreditCard"].Equals(false)) { sbEmailBody.Append("<tr><td width=\"200\">Account Name:</td><td>" + transactionDetails.CardholdersName.Trim() + "</td></tr></table>"); } if (HttpContext.Current.Session["ViaCreditCard"].Equals(true)) { if (!(transactionDetails.CreditCardNo.Trim() == null || transactionDetails.CreditCardNo.Trim() == "")) { string strCredit = string.Empty; string ccnumber = TributePortalSecurity.Security.DecryptSymmetric(transactionDetails.CreditCardNo.Trim()); for (int indexCredit = 0; indexCredit < ccnumber.Length - 4; indexCredit++) strCredit += "X"; sbEmailBody.Append("<tr><td width=\"200\">Credit Card:</td><td>" + strCredit + ccnumber.Substring(ccnumber.Length - 4) + "</td></tr>"); sbEmailBody.Append("<tr><td width=\"200\">TransactionId:</td><td>" + transactionDetails.TransactionId.ToString().Trim() + "</td></tr></table>"); sbEmailBody.Append("<br/>"); } sbEmailBody.Append("<b>Billing Information:</b><br/>"); if (!(transactionDetails.Address.Trim() == null || transactionDetails.Address.Trim() == "")) { sbEmailBody.Append("<table border='0' width='100%' style=\"font-family:Lucida Sans; font-size:12px\"><tr><td width=\"200\">Name:</td><td>" + transactionDetails.CardholdersName.Trim() + "</td></tr>"); sbEmailBody.Append("<tr><td width=\"200\">Address:</td><td>" + transactionDetails.Address.Trim().Replace(WebConfig.AddressSeparator, WebConfig.AddressSeparatorDisplay) + "</td></tr>"); } if (!(transactionDetails.City.Trim() == null || transactionDetails.City.Trim() == "")) { sbEmailBody.Append("<tr><td width=\"200\">City:</td><td>" + transactionDetails.City.Trim() + "</td></tr>"); } if (!(transactionDetails.State.Trim() == null || transactionDetails.State.Trim() == "")) { sbEmailBody.Append("<tr><td width=\"200\">State/Province:</td><td>" + transactionDetails.State.Trim() + "</td></tr>"); } if (!(transactionDetails.Country.Trim() == null || transactionDetails.Country.Trim() == "")) { sbEmailBody.Append("<tr><td width=\"200\">Country:</td><td>" + transactionDetails.Country.Trim() + "</td></tr>"); } if (!(transactionDetails.Zip.Trim() == null || transactionDetails.Zip.Trim() == "")) { sbEmailBody.Append("<tr><td width=\"200\">Zip/Postal Code:</td><td>" + transactionDetails.Zip.Trim() + "</td></tr>"); } if (!(transactionDetails.Telephone.Trim() == null || transactionDetails.Telephone.Trim() == "")) { sbEmailBody.Append("<tr><td width=\"200\">Telephone:</td><td>" + transactionDetails.Telephone.Trim() + "</td></tr></table>"); } sbEmailBody.Append("<br/>"); } sbEmailBody.Append("<br/>"); sbEmailBody.Append("<strong>If you have any questions about your order, please email Your " + WebConfig.ApplicationWord + " at <a href= mailto:" + WebConfig.BillingEmail + ">" + WebConfig.BillingEmail + "</a>. with the transaction details listed above.</strong>"); sbEmailBody.Append("</font>"); EmailMessages objEmail = EmailMessages.Instance; bool val = objEmail.SendSponsorEmail("Your " + WebConfig.ApplicationWord + " <" + WebConfig.NoreplyEmail + ">", transactionDetails.SponsorEmailAddress, subject, sbEmailBody.ToString(), EmailMessages.TextFormat.Html.ToString()); }
private void SendTransactionEmail(PaymentReceipt transactionDetails) { StateManager stateManager = StateManager.Instance; string SentFrom = (string)stateManager.Get("SentFrom", StateManager.State.Session); string subject = "Order Receipt #" + transactionDetails.TransactionId.ToString(); StringBuilder sbEmailBody = new StringBuilder(); sbEmailBody.Append("<font style='font-size: 12px; font-family:Lucida Sans;'>"); sbEmailBody.Append("<p>Your " + WebConfig.ApplicationWord + " thanks you for your order. Please retain this receipt for your records.</p>"); sbEmailBody.Append("<br/>"); sbEmailBody.Append("<b>Order Information:</b><br/>"); sbEmailBody.Append("<table border='0' width='100%' style=\"font-family:Lucida Sans; font-size:12px\"><tr><td width=\"200\">" + WebConfig.ApplicationWordForInternalUse + " Name:</td><td>" + transactionDetails.Tributename.Trim() + "</td></tr>"); sbEmailBody.Append("<tr><td width=\"200\">" + WebConfig.ApplicationWordForInternalUse + " Type:</td><td>" + transactionDetails.TypeDescription.Trim() + "</td></tr>"); sbEmailBody.Append("<tr><td width=\"200\">Package Type:</td><td>" + transactionDetails.Packagename.Trim() + "</td></tr>"); sbEmailBody.Append("<tr><td width=\"200\">Expiry Date:</td><td>" + transactionDetails.Enddate.Trim() + "</td></tr></table>"); sbEmailBody.Append("<br/>"); if (!(transactionDetails.CreditCardType.Trim() == null || transactionDetails.CreditCardType.Trim() == "")) { sbEmailBody.Append("<b>Payment Information:</b><br/>"); sbEmailBody.Append("<table border='0' width='100%' style=\"font-family:Lucida Sans; font-size:12px\"><tr><td width=\"200\">Billing Date:</td><td>" + transactionDetails.StartDate.ToString("MMMM dd, yyyy").Trim() + "</td></tr>"); sbEmailBody.Append("<tr><td width=\"200\">Payment Type:</td><td>" + transactionDetails.CreditCardType.Trim() + "</td></tr>"); } // If the Video tribute Upgrade has to be executed for Normal tribute the Amount Paid would be integer //if (HttpContext.Current.Session["SentFrom"] == "VideoTributeSpons") if (transactionDetails.AmountPaidDouble != 0 || transactionDetails.AmountPaid != 0) { if (SentFrom == "VideoTributeSpons") { sbEmailBody.Append("<tr><td width=\"200\">Amount Billed:</td><td>" + transactionDetails.AmountPaidDouble.ToString().Trim() + "</td></tr>"); } // To Differentiate between normal Tribute Upgrade and Memorial video(Of Video)Tribute Upgradation else if (Math.Truncate(transactionDetails.AmountPaidDouble) == transactionDetails.AmountPaidDouble) { sbEmailBody.Append("<tr><td width=\"200\">Amount Billed:</td><td>" + Math.Floor(transactionDetails.AmountPaidDouble).ToString().Trim() + "</td></tr>"); } else { sbEmailBody.Append("<tr><td width=\"200\">Amount Billed:</td><td>" + transactionDetails.AmountPaidDouble.ToString().Trim() + "</td></tr>"); } } if (!(transactionDetails.CreditCardNo.Trim() == null || transactionDetails.CreditCardNo.Trim() == "")) { string strCredit = string.Empty; string ccnumber = TributePortalSecurity.Security.DecryptSymmetric(transactionDetails.CreditCardNo.Trim()); for (int indexCredit = 0; indexCredit < ccnumber.Length - 4; indexCredit++) strCredit += "X"; sbEmailBody.Append("<tr><td width=\"200\">Credit Card:</td><td>" + strCredit + ccnumber.Substring(ccnumber.Length - 4) + "</td></tr>"); sbEmailBody.Append("<tr><td width=\"200\">TransactionId:</td><td>" + transactionDetails.TransactionId.ToString().Trim() + "</td></tr></table>"); sbEmailBody.Append("<br/>"); } if (!(transactionDetails.Address.Trim() == null || transactionDetails.Address.Trim() == "")) { sbEmailBody.Append("<b>Billing Information:</b><br/>"); sbEmailBody.Append("<table border='0' width='100%' style=\"font-family:Lucida Sans; font-size:12px\"><tr><td width=\"200\">Name:</td><td>" + transactionDetails.CardholdersName.Trim() + "</td></tr>"); sbEmailBody.Append("<tr><td width=\"200\">Address:</td><td>" + transactionDetails.Address.Trim().Replace(WebConfig.AddressSeparator, WebConfig.AddressSeparatorDisplay) + "</td></tr>"); } if (!(transactionDetails.City.Trim() == null || transactionDetails.City.Trim() == "")) { sbEmailBody.Append("<tr><td width=\"200\">City:</td><td>" + transactionDetails.City.Trim() + "</td></tr>"); } if (!(transactionDetails.State.Trim() == null || transactionDetails.State.Trim() == "")) { sbEmailBody.Append("<tr><td width=\"200\">State/Province:</td><td>" + transactionDetails.State.Trim() + "</td></tr>"); } if (!(transactionDetails.Country.Trim() == null || transactionDetails.Country.Trim() == "")) { sbEmailBody.Append("<tr><td width=\"200\">Country:</td><td>" + transactionDetails.Country.Trim() + "</td></tr>"); } if (!(transactionDetails.Zip.Trim() == null || transactionDetails.Zip.Trim() == "")) { sbEmailBody.Append("<tr><td width=\"200\">Zip/Postal Code:</td><td>" + transactionDetails.Zip.Trim() + "</td></tr>"); } if (!(transactionDetails.Telephone.Trim() == null || transactionDetails.Telephone.Trim() == "")) { sbEmailBody.Append("<tr><td width=\"200\">Telephone:</td><td>" + transactionDetails.Telephone.Trim() + "</td></tr></table>"); } sbEmailBody.Append("<br/>"); sbEmailBody.Append("<strong>If you have any questions about your order, please email Your " + WebConfig.ApplicationWord + " at <a href= mailto:" + WebConfig.BillingEmail + ">" + WebConfig.BillingEmail + "</a>. with the transaction details listed above.</strong>"); sbEmailBody.Append("</font>"); EmailMessages objEmail = EmailMessages.Instance; bool val = objEmail.SendSponsorEmail("Your " + WebConfig.ApplicationWord + " <" + WebConfig.NoreplyEmail + ">", transactionDetails.SponsorEmailAddress, subject, sbEmailBody.ToString(), EmailMessages.TextFormat.Html.ToString()); }
private void SendTransactionEmail(int p, PaymentReceipt paymentReceipt) { throw new NotImplementedException(); }
public PaymentReceipt GetVideoTributeTransactionDetails(object[] objValue) { BillingResource objBillingResource = new BillingResource(); PaymentReceipt objTransactionDetails = new PaymentReceipt(); //if (HttpContext.Current.Session["ViaCreditCard"].Equals(false)) //{ objTransactionDetails = objBillingResource.GetVideoTributeTransactionDetails(objValue); //} //else //{ //objTransactionDetails = objBillingResource.GetTransactionDetails(objValue); SendVideoTributeCreationTransactionEmail(objTransactionDetails); //string subject = ""; //string body = ""; //SendEmail(objTransactionDetails.TributeId, "subject", "body", "Your Tribute <" + WebConfig.NoreplyEmail + ">"); return objTransactionDetails; }
public PaymentReceipt GetTransactionDetailsForEmail(int packId, string transactionId, object[] objValue) { BillingResource objBillingResource = new BillingResource(); PaymentReceipt objTransactionDetails = new PaymentReceipt(); objTransactionDetails = objBillingResource.GetTransactionDetails(objValue); SendCreationTransactionEmail(packId, transactionId, objTransactionDetails); return objTransactionDetails; }