/// <summary> /// This method used to update status of tribute /// </summary> /// <param name="intNumberOfDays"></param> /// <param name="DeleteTribute"></param> public void SetTributeStatus() { ResourceAccess objResouce = new ResourceAccess(); objResouce.GetDataSet("usp_ChangeTributeStatus", null); objResouce = null; }
/// <summary> /// This method used for AutoRenewal for One Year /// </summary> public void AutoRenewalForOneYearPackage() { DataSet dsMailerList = new DataSet(); DataSet dsMailerList1 = new DataSet();//vchange line added bool _transaction = true; PaymentGateWay objPay = new PaymentGateWay(); ResourceAccess objResouce = new ResourceAccess(); EmailMessages objEmail = EmailMessages.Instance; string _EmailBody=string.Empty; string confirmationId = string.Empty;//vchange line added string amount = string.Empty;//vchange line added object[] objParam = new object[3]; object[] objParam2 = { null }; try { dsMailerList = objResouce.GetDataSet("usp_AutoRenewalCustomerList", null); if (dsMailerList.Tables[0].Rows.Count > 0) { for (int i = 0; i <= dsMailerList.Tables[0].Rows.Count - 1; i++) { //This code will execute on server /*_transaction = objPay.PayYourBill(dsMailerList.Tables[0].Rows[i]["CreditCardNo"].ToString(), dsMailerList.Tables[0].Rows[i]["CVC"].ToString(), int.Parse(DateTime.Now.Month.ToString()), int.Parse(DateTime.Now.Year.ToString()), "20.00", SelectCreditCardType(dsMailerList.Tables[0].Rows[i]["CreditCardType"].ToString()), dsMailerList.Tables[0].Rows[i]["FirstName"].ToString(), dsMailerList.Tables[0].Rows[i]["Lastname"].ToString(), "TimelessTribute BackOffice", dsMailerList.Tables[0].Rows[i]["City"].ToString(), StateV1.CA, CountryV1.US, dsMailerList.Tables[0].Rows[i]["Zip"].ToString(), dsMailerList.Tables[0].Rows[i]["Telephone"].ToString(), dsMailerList.Tables[0].Rows[i]["Email"].ToString(), Environment.MachineName.ToString());*/ //This code will execute on local /* _transaction = true;*/ //vchange added satarted try { int Couponamount = 0; amount = ConfigurationSettings.AppSettings["OneyearAmount"]; Couponamount = Convert.ToInt32(amount.Substring(1, amount.Length - 1)); _transaction = objPay.PayYourBill(TributePortalSecurity.Security.DecryptSymmetric(dsMailerList.Tables[0].Rows[i]["CreditCardNo"].ToString()), TributePortalSecurity.Security.DecryptSymmetric(dsMailerList.Tables[0].Rows[i]["CVC"].ToString()), Convert.ToInt32(dsMailerList.Tables[0].Rows[i]["ExpiryMonth"]), Convert.ToInt32(dsMailerList.Tables[0].Rows[i]["ExpiryYear"]), Couponamount.ToString(), SelectCreditCardType(dsMailerList.Tables[0].Rows[i]["CreditCardType"].ToString()), dsMailerList.Tables[0].Rows[i]["FirstName"].ToString(), dsMailerList.Tables[0].Rows[i]["Lastname"].ToString(), dsMailerList.Tables[0].Rows[i]["Address"].ToString().Replace(ConfigurationSettings.AppSettings["AddressSeparator"],ConfigurationSettings.AppSettings["AddressSeparatorDisplay"]), dsMailerList.Tables[0].Rows[i]["City"].ToString(), StateV1.CA, CountryV1.US, dsMailerList.Tables[0].Rows[i]["Zip"].ToString(), dsMailerList.Tables[0].Rows[i]["Telephone"].ToString(), dsMailerList.Tables[0].Rows[i]["Email"].ToString(), Environment.MachineName.ToString(), out confirmationId); // _transaction = objPay.PayYourBill(dsMailerList.Tables[0].Rows[i]["CreditCardNo"].ToString(), dsMailerList.Tables[0].Rows[i]["CVC"].ToString(), // int.Parse(DateTime.Now.Month.ToString()), int.Parse(DateTime.Now.Year.ToString()), // Couponamount.ToString(), SelectCreditCardType(dsMailerList.Tables[0].Rows[i]["CreditCardType"].ToString()), // dsMailerList.Tables[0].Rows[i]["FirstName"].ToString(), dsMailerList.Tables[0].Rows[i]["Lastname"].ToString(), "TimelessTribute BackOffice", //dsMailerList.Tables[0].Rows[i]["City"].ToString(), StateV1.CA, CountryV1.US, dsMailerList.Tables[0].Rows[i]["Zip"].ToString(), //dsMailerList.Tables[0].Rows[i]["Telephone"].ToString(), dsMailerList.Tables[0].Rows[i]["Email"].ToString(), //Environment.MachineName.ToString(), out confirmationId); //vchange added end if (_transaction) { EventLog.WriteEntry("Payment Recived"); objParam[0] = dsMailerList.Tables[0].Rows[i]["TributePackageId"].ToString(); objParam[1] = Couponamount.ToString();// vchnage "20"; objParam[2] = confirmationId.Length == 0 ? 0 : int.Parse(confirmationId); //objResouce.GetDataSet("usp_RenewTributePackage", objParam); //vchnage code added satrt dsMailerList1 = objResouce.GetDataSet("usp_RenewTributePackage", objParam); if (dsMailerList1.Tables[0].Rows.Count > 0) { //vchnage code added end objEmail = EmailMessages.Instance; _EmailBody = ConfigurationSettings.AppSettings["MailAfterRenewal"]; _EmailBody = _EmailBody.Replace("#FirstName", dsMailerList.Tables[0].Rows[i]["FirstName"].ToString()); _EmailBody = _EmailBody.Replace("#LastName", dsMailerList.Tables[0].Rows[i]["LastName"].ToString()); _EmailBody = _EmailBody.Replace("#TributeName", dsMailerList.Tables[0].Rows[i]["TributeName"].ToString()); _EmailBody = _EmailBody.Replace("#TributeUrl", dsMailerList.Tables[0].Rows[i]["TributeUrl"].ToString()); _EmailBody = _EmailBody.Replace("#RenewalDate", DateTime.Parse(dsMailerList.Tables[0].Rows[i]["EndDate"].ToString()).ToString("MMMM dd, yyyy")); _EmailBody = _EmailBody.Replace("#TributeType", dsMailerList.Tables[0].Rows[i]["TributeTypeName"].ToString().ToLower()); objEmail.SendMessages("Your Tribute<*****@*****.**>", dsMailerList.Tables[0].Rows[i]["Email"].ToString(), "The " + dsMailerList.Tables[0].Rows[i]["TributeName"].ToString() + " Tribute renewed.", _EmailBody, EmailMessages.TextFormat.Html.ToString()); ///vchnage code added start object[] param ={ dsMailerList1.Tables[0].Rows[0][0].ToString() }; GetTransactionDetails(param); } } else { //NotifyRenwealFailed() EventLog.WriteEntry("Payment not recevied"); objEmail = EmailMessages.Instance; _EmailBody = ConfigurationSettings.AppSettings["MailRenewalFailed"]; _EmailBody = _EmailBody.Replace("#FirstName", dsMailerList.Tables[0].Rows[i]["FirstName"].ToString()); _EmailBody = _EmailBody.Replace("#LastName", dsMailerList.Tables[0].Rows[i]["LastName"].ToString()); _EmailBody = _EmailBody.Replace("#TributeName", dsMailerList.Tables[0].Rows[i]["TributeName"].ToString()); _EmailBody = _EmailBody.Replace("#TributeUrl", dsMailerList.Tables[0].Rows[i]["TributeUrl"].ToString()); _EmailBody = _EmailBody.Replace("#TributeType", dsMailerList.Tables[0].Rows[i]["TributeTypeName"].ToString().ToLower()); objEmail.SendMessages("Your Tribute<*****@*****.**>", dsMailerList.Tables[0].Rows[i]["Email"].ToString(), "Auto-Renewal of the " + dsMailerList.Tables[0].Rows[i]["TributeName"].ToString() + " Tribute has failed...", _EmailBody, EmailMessages.TextFormat.Html.ToString()); } } catch { // NotifyRenwealFailed() EventLog.WriteEntry("Exception occured,Payment not recevied"); objEmail = EmailMessages.Instance; _EmailBody = ConfigurationSettings.AppSettings["MailRenewalFailed"]; _EmailBody = _EmailBody.Replace("#FirstName", dsMailerList.Tables[0].Rows[i]["FirstName"].ToString()); _EmailBody = _EmailBody.Replace("#LastName", dsMailerList.Tables[0].Rows[i]["LastName"].ToString()); _EmailBody = _EmailBody.Replace("#TributeName", dsMailerList.Tables[0].Rows[i]["TributeName"].ToString()); _EmailBody = _EmailBody.Replace("#TributeUrl", dsMailerList.Tables[0].Rows[i]["TributeUrl"].ToString()); _EmailBody = _EmailBody.Replace("#TributeType", dsMailerList.Tables[0].Rows[i]["TributeTypeName"].ToString().ToLower()); objEmail.SendMessages("Your Tribute<*****@*****.**>", dsMailerList.Tables[0].Rows[i]["Email"].ToString(), "Auto-Renewal of the " + dsMailerList.Tables[0].Rows[i]["TributeName"].ToString() + " Tribute has failed...", _EmailBody, EmailMessages.TextFormat.Html.ToString()); ///vchnage code added end } objEmail = null; } } } catch (Exception ex) { EventLog.WriteEntry(ex.Message.ToString()); } }
//vchnage code added end /// <summary> /// This Method used to send email to users for credit card exipration /// </summary> public void NotifyCreditCardExpirationDate(int intNumberOfDays) { DataSet dsMailerList = new DataSet(); ResourceAccess objResouce = new ResourceAccess(); object[] objParam = { intNumberOfDays }; dsMailerList = objResouce.GetDataSet("usp_CreditCardExpiredCustomerList", objParam); if (dsMailerList.Tables[0].Rows.Count > 0) { //EventLog.WriteEntry(dsMailerList.Tables[0].Rows[0][0].ToString() + "-Record Found"); EmailMessages objEmail = EmailMessages.Instance; string _EmailBody = string.Empty; for (int i = 0; i <= dsMailerList.Tables[0].Rows.Count - 1; i++) { _EmailBody = _EmailBody = ConfigurationSettings.AppSettings["CreditCardExpiryReminder"]; _EmailBody = _EmailBody.Replace("#FirstName", dsMailerList.Tables[0].Rows[i]["FirstName"].ToString()); _EmailBody = _EmailBody.Replace("#LastName", dsMailerList.Tables[0].Rows[i]["LastName"].ToString()); _EmailBody = _EmailBody.Replace("#TributeName", dsMailerList.Tables[0].Rows[i]["TributeName"].ToString()); _EmailBody = _EmailBody.Replace("#TributeUrl", dsMailerList.Tables[0].Rows[i]["TributeUrl"].ToString()); _EmailBody = _EmailBody.Replace("#ExpireDate",DateTime.Parse(dsMailerList.Tables[0].Rows[i]["EndDate"].ToString()).ToString("MMMM dd, yyyy")); _EmailBody = _EmailBody.Replace("#TributeType", dsMailerList.Tables[0].Rows[i]["TributeTypeName"].ToString().ToLower()); _EmailBody = _EmailBody.Replace("#CCExpireReminder", Convert.ToString(intNumberOfDays)); objEmail.SendMessages("Your Tribute<*****@*****.**>", dsMailerList.Tables[0].Rows[i]["Email"].ToString(), "The " + dsMailerList.Tables[0].Rows[i]["TributeName"].ToString() + " Your Tribute CC Expiry Notice", _EmailBody, EmailMessages.TextFormat.Html.ToString()); } objEmail = null; } EventLog.WriteEntry("My simple service Ended."); }
/// <summary> /// This Method used for Tribute expiry /// </summary> /// <param name="intNumberOfDays"></param> public void NotifyTributeExpiryToUsersOneYear(int intNumberOfDays) { DataSet dsMailerList = new DataSet(); ResourceAccess objResouce = new ResourceAccess(); object[] objParam = { intNumberOfDays, 2 }; dsMailerList = objResouce.GetDataSet("usp_GetTributeOwnerMailerList", objParam); if (dsMailerList.Tables[0].Rows.Count > 0) { //EventLog.WriteEntry(dsMailerList.Tables[0].Rows[0][0].ToString() + "-Record Found"); EmailMessages objEmail = EmailMessages.Instance; string _EmailBody = string.Empty; int packageid = 0;//vchange line added for (int i = 0; i <= dsMailerList.Tables[0].Rows.Count - 1; i++) { _EmailBody = ConfigurationSettings.AppSettings["ExpiryReminder"]; // vchange block added srart packageid = Convert.ToInt32(dsMailerList.Tables[0].Rows[i]["packageid"]); if (packageid == 3) { _EmailBody = _EmailBody.Replace("#FreeTrialPackage", "The free trial for"); } else { _EmailBody = _EmailBody.Replace("#FreeTrialPackage", "The"); } // vchange block added end _EmailBody = _EmailBody.Replace("#FirstName", dsMailerList.Tables[0].Rows[i]["FirstName"].ToString()); _EmailBody = _EmailBody.Replace("#LastName", dsMailerList.Tables[0].Rows[i]["LastName"].ToString()); _EmailBody = _EmailBody.Replace("#TributeName", dsMailerList.Tables[0].Rows[i]["TributeName"].ToString()); _EmailBody = _EmailBody.Replace("#TributeUrl", dsMailerList.Tables[0].Rows[i]["TributeUrl"].ToString()); _EmailBody = _EmailBody.Replace("#ExpireDate", DateTime.Parse(dsMailerList.Tables[0].Rows[i]["EndDate"].ToString()).ToString("MMMM dd, yyyy")); _EmailBody = _EmailBody.Replace("#TributeType", dsMailerList.Tables[0].Rows[i]["TributeTypeName"].ToString().ToLower().Replace("new baby", "newbaby")); objEmail.SendMessages("Your Tribute<*****@*****.**>", dsMailerList.Tables[0].Rows[i]["Email"].ToString(), "The " + dsMailerList.Tables[0].Rows[i]["TributeName"].ToString().ToLower() + " Tribute expires soon...", _EmailBody, EmailMessages.TextFormat.Html.ToString()); } objEmail = null; } EventLog.WriteEntry("My simple service Ended."); }
/// <summary> /// Method to get the Transaction details for the payment /// </summary> /// <param name="objValue">Package Id</param> /// <returns>Get the details of transaction.</returns> public PaymentReceipt GetTransactionDetail(object[] objValue) { ResourceAccess objResouce = new ResourceAccess(); PaymentReceipt objPaymentReceipt = new PaymentReceipt(); //PaymentReceipt objpay = null; try { DataSet ds = objResouce.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(), int.Parse(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; } }