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