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 void Page_Load(object sender, System.EventArgs e) { BEGiftCards.tbl_GiftCardsRow giftcard; BPGiftCards bp = new BPGiftCards(); giftcard = bp.SelectGiftCardsByID(Convert.ToInt32(Request.QueryString["gc"])).tbl_GiftCards[0]; string Password = "******"; string tempMKEY = giftcard.GiftCardID.ToString() + giftcard.GiftCardTotal.ToString("0.00") + Password; //string tempMKEY = "110100development"; string strMKEY = MDString(tempMKEY); MTID.Value = giftcard.GiftCardID.ToString(); MKEY.Value = strMKEY; EMail.Value = giftcard.GiftCardSenderEmail; Amount1.Value = giftcard.GiftCardTotal.ToString("0.00"); RegisterStartupScript("submit","<script>document.purchase.submit();</script>"); }
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; }
private void GetGiftCardInfo() { BPGiftCards bpCat = new BPGiftCards(); BEGiftCards ds = bpCat.SelectGiftCardsByID(GiftCardID); BEGiftCards.tbl_GiftCardsRow GiftCard = ds.tbl_GiftCards.FindByGiftCardID(GiftCardID); lblTitle.Text = "View GiftCard - " + GiftCard.GiftCardID; lblGiftCardID.Text = GiftCard.GiftCardID.ToString(); lblGiftCardDateCreated.Text = GiftCard.GiftCardDateCreated.ToString(); if (GiftCard.GiftCardApproved == true) { imgApproved.Visible = true; imgNotApproved.Visible = false; } else { imgApproved.Visible = false; imgNotApproved.Visible = true; } lblGiftCardRecipientName.Text = GiftCard.GiftCardRecipientName; if (!GiftCard.IsGiftCardRecipientEmailNull()) { lblGiftCardRecipientEmail.Text = GiftCard.GiftCardRecipientEmail; } lblGiftCardSenderName.Text = GiftCard.GiftCardSenderName; if (!GiftCard.IsGiftCardSenderEmailNull()) { lblGiftCardSenderEmail.Text = GiftCard.GiftCardSenderEmail; } if (!GiftCard.IsGiftCardSenderPhoneNull()) { lblGiftCardSenderPhone.Text = GiftCard.GiftCardSenderPhone; } if (!GiftCard.IsGiftCardMessageNull()) { lblGiftCardMessage.Text = GiftCard.GiftCardMessage; } lblGiftCardTotal.Text = GiftCard.GiftCardTotal.ToString(MONEY_FORMAT); string GiftCardDeliveryMethod = ""; if (GiftCard.GiftCardDeliveryMethod == 0) { GiftCardDeliveryMethod = "Pick Up"; } else if (GiftCard.GiftCardDeliveryMethod == 1) { GiftCardDeliveryMethod = "Courier ($5)"; } else if (GiftCard.GiftCardDeliveryMethod == 2) { GiftCardDeliveryMethod = "Regular Mail ($0)"; } lblGiftCardDeliveryMethod.Text = GiftCardDeliveryMethod; lblGiftCardDeliveryName.Text = GiftCard.GiftCardDeliveryName; lblGiftCardDeliveryAddress.Text = GiftCard.GiftCardDeliveryAddress; lblGiftCardDeliveryCity.Text = GiftCard.GiftCardDeliveryCity; lblGiftCardDeliveryPostalCode.Text = GiftCard.GiftCardDeliveryPostalCode; lblGiftCardComments.Text = GiftCard.GiftCardComments; }