protected void BindGiftCardsList() { BPGiftCards bpcat = new BPGiftCards(); DSGiftCards = bpcat.SelectAll(); // DSGiftCards.tbl_GiftCards.DefaultView.Sort = "GiftCardSenderName"; dgGiftCards.DataBind(); }
private void EmailOrder() { BPGiftCards bp = new BPGiftCards(); DSGiftcards = bp.SelectGiftCardsByID(Convert.ToInt32(GiftCardID)); BEGiftCards.tbl_GiftCardsRow giftcard; giftcard = DSGiftcards.tbl_GiftCards.FindByGiftCardID(GiftCardID); BESetup setupInfo = new BESetup(); BPSetup bpSetup = new BPSetup(); setupInfo = bpSetup.SelectAll(); string email = ""; if (!giftcard.IsGiftCardSenderEmailNull()) { //email = "*****@*****.**"; email = giftcard.GiftCardSenderEmail; } if (email == null || email == "") { email = setupInfo.tbl_Setup[0].SetupEmailAddress1 + "; " + setupInfo.tbl_Setup[0].SetupEmailAddress2; } else { if (!setupInfo.tbl_Setup[0].IsSetupEmailAddress1Null()) { email += "; " + setupInfo.tbl_Setup[0].SetupEmailAddress1; } if (!setupInfo.tbl_Setup[0].IsSetupEmailAddress2Null()) { email += "; " + setupInfo.tbl_Setup[0].SetupEmailAddress2; } } StringBuilder body = GetShippingInfo(giftcard); StringBuilder body2 = DisplayCart (giftcard); StringBuilder body3 = CalculateTotals (giftcard); MailMessage mm = new MailMessage(); mm.To = email; mm.From = setupInfo.tbl_Setup[0].SetupEmailAddress1; mm.Subject = string.Format ("Carriel Receipt. Gift Card Receipt #{0}", GiftCardID); mm.Body = string.Format ("Gift Card Receipt #{0} <br>", GiftCardID) + body.ToString() + body2.ToString() + body3.ToString(); mm.BodyFormat = MailFormat.Html; SmtpMail.SmtpServer = setupInfo.tbl_Setup[0].SetupEmailServer; SmtpMail.Send (mm); }
private void Page_Load(object sender, EventArgs e) { // Put user code to initialize the page here if (GiftCardID > 0) { BPGiftCards bp = new BPGiftCards(); DSGiftcards = bp.SelectGiftCardsByID(Convert.ToInt32(GiftCardID)); BEGiftCards.tbl_GiftCardsRow giftcard; giftcard = DSGiftcards.tbl_GiftCards.FindByGiftCardID(GiftCardID); giftcard.GiftCardApproved = true; bp.Update(DSGiftcards); EmailOrder(); } }
private void btnSubmit_Click(object sender, System.EventArgs e) { //make new gift card row BPGiftCards bp = new BPGiftCards(); BEGiftCards.tbl_GiftCardsRow giftCard; BEGiftCards DSGiftCards = new BEGiftCards(); giftCard = DSGiftCards.tbl_GiftCards.Newtbl_GiftCardsRow(); //fill row giftCard.GiftCardRecipientName = txtRecipientName.Value; giftCard.GiftCardRecipientEmail = txtRecipientEmail.Value; giftCard.GiftCardSenderName = txtSenderName.Value; giftCard.GiftCardSenderEmail = txtSenderEmail.Value; giftCard.GiftCardSenderPhone = txtSenderPhone.Value; giftCard.GiftCardMessage = txtMessage.Value; giftCard.GiftCardSubTotal = Convert.ToDouble(txtEnteredAmount.Value); // if (rbPickup.Checked) // { // giftCard.GiftCardDeliveryMethod = Convert.ToInt32(rbPickup.Value); // giftCard.GiftCardShipping = 0; // }else if (rbCourier.Checked) { giftCard.GiftCardDeliveryMethod = Convert.ToInt32(rbCourier.Value); giftCard.GiftCardShipping = 5; }else if (rbRegularMail.Checked) { giftCard.GiftCardDeliveryMethod = Convert.ToInt32(rbRegularMail.Value); giftCard.GiftCardShipping = 0; } giftCard.GiftCardDeliveryName = txtDeliveryName.Value; giftCard.GiftCardDeliveryAddress = txtDeliveryAddress.Value; giftCard.GiftCardDeliveryCity = txtDeliveryCity.Value; giftCard.GiftCardDeliveryPostalCode = txtDeliveryPostalCode.Value; giftCard.GiftCardComments = txtComments.Value; giftCard.GiftCardGST = 0; giftCard.GiftCardTotal = giftCard.GiftCardSubTotal + giftCard.GiftCardShipping + giftCard.GiftCardGST; giftCard.GiftCardDateCreated = DateTime.Now; giftCard.GiftCardApproved = false; DSGiftCards.tbl_GiftCards.Addtbl_GiftCardsRow(giftCard); bp.Update(DSGiftCards); RegisterClientScriptBlock("redirect","<script>this.parent.location.assign('SendToMiraPay.aspx?gc=" + DSGiftCards.tbl_GiftCards[0].GiftCardID + "')</script>"); // this.Parent.Page.Response.Redirect("SendToMiraPay.aspx?gc="+DSGiftCards.tbl_GiftCards[0].GiftCardID); }
private StringBuilder CalculateTotals (BEGiftCards.tbl_GiftCardsRow giftcard) { StringBuilder body = new StringBuilder(); body.Append("<br /><br /><b><u>Purchase Totals</u></b><br />"); body.Append("Sub Total: " + giftcard.GiftCardSubTotal.ToString ("$0.00") + "<br />"); body.Append("Shipping Total: " + giftcard.GiftCardShipping.ToString ("$0.00") + "<br />"); body.Append("Grand Total: " + giftcard.GiftCardTotal.ToString ("$0.00") + "<br />"); return body; }
private StringBuilder DisplayCart (BEGiftCards.tbl_GiftCardsRow giftcard) { StringBuilder body = new StringBuilder(); body.Append("<br /><br /><b><u>Purchase Information</u></b><br />"); body.Append(giftcard.GiftCardSubTotal.ToString("$#,##0.00") + " Gift Card <br />"); return body; }
private StringBuilder GetShippingInfo(BEGiftCards.tbl_GiftCardsRow giftcard) { StringBuilder body = new StringBuilder(); body.Append("<br /><br /><b><u>Billing Information</u></b><br />"); body.Append(giftcard.GiftCardSenderName + "<br />"); body.Append(giftcard.GiftCardSenderPhone.ToString() + "<br />"); body.Append(giftcard.GiftCardSenderEmail.ToString() + "<br />"); body.Append("<br /><br /><b><u>Shipping Information</u></b><br />"); body.Append(giftcard.GiftCardDeliveryName + "<br />"); body.Append(giftcard.GiftCardDeliveryAddress + "<br />"); if (!giftcard.IsGiftCardRecipientEmailNull()) { body.Append(giftcard.GiftCardRecipientEmail.ToString() + "<br />"); } body.Append(giftcard.GiftCardDeliveryCity.ToString() + "<br />"); body.Append(giftcard.GiftCardDeliveryPostalCode.ToString() + "<br />"); return body; }
protected void BindSalesList() { BPGiftCards bp = new BPGiftCards(); DSGiftCards = bp.SelectAll(); string searchString = string.Empty; if (dtStart.SelectedDate != DateTime.MinValue) { //searchString += String.Format("GiftCardDateCreated >= '{0}'", dtStart.SelectedDate.ToString("MM/dd/yyyy")); searchString += String.Format("GiftCardDateCreated >= '{0}'", Convert.ToDateTime(dtStart.SelectedDate.ToString("MM/dd/yyyy"))); //searchString += String.Format("GiftCardDateCreated >= '" + dtStart.SelectedDate.ToString("MM/dd/yyyy") + "'"); //searchString += "GiftCardDateCreated >= " + Convert.ToDateTime(dtStart.SelectedDate.ToString("MM/dd/yyyy")); } if (dtEnd.SelectedDate != DateTime.MinValue) { if (searchString != string.Empty) { searchString += " and "; } //searchString += String.Format("GiftCardDateCreated <= '{0}'", dtEnd.SelectedDate.ToString("MM/dd/yyyy")); searchString += String.Format("GiftCardDateCreated < '{0}'", Convert.ToDateTime((dtEnd.SelectedDate.AddDays(1).ToString("MM/dd/yyyy")))); //searchString += String.Format("GiftCardDateCreated <= '" + dtEnd.SelectedDate.ToString("dd/MM/yyyy") + "'"); //searchString += "GiftCardDateCreated <= " + Convert.ToDateTime(dtEnd.SelectedDate.ToString("MM/dd/yyyy")); } string Filter = searchString; if (Filter != null && Filter != "" && Filter != " ") { Filter = "(" + Filter + ") and "; } Filter += " GiftCardApproved = 1"; //DataRow [] somearray; //somearray = DSGiftCards.tbl_GiftCards.Select(Filter); DSGiftCards.tbl_GiftCards.DefaultView.RowFilter = Filter; }