示例#1
0
		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();
			}
		}
示例#4
0
		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;
		}