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