protected void Page_Load(object sender, EventArgs e) { int certificateId = GetIdFromQueryString(); if (certificateId > 0) { CertificateTableAdapter certificateAdapter = new CertificateTableAdapter(); DollarSaverDB.CertificateDataTable certificateTable = certificateAdapter.GetCertificate(certificateId); if (certificateTable.Rows.Count == 1) { DollarSaverDB.CertificateRow certificate = certificateTable[0]; if (certificate.Advertiser.StationId != StationId) { RedirectToHomePage(); } certificateDetail.DisplayCertificate = certificate; } else { RedirectToHomePage(); } } else { RedirectToHomePage(); } }
protected void Page_Load(object sender, EventArgs e) { certificateId = GetIdFromQueryString(); CertificateTableAdapter certificateAdapter = new CertificateTableAdapter(); DollarSaverDB.CertificateDataTable certificateTable = certificateAdapter.GetCertificate(certificateId); if (certificateTable.Count != 1) { Response.Redirect("~/admin/AdvertiserList.aspx"); } certificate = certificateTable[0]; if (certificate.Advertiser.StationId != StationId) { Response.Redirect("~/admin/AdvertiserList.aspx"); } if (certificate.Advertiser.IsDeleted) { InfoMessage = "Sorry, this advertiser has been deleted"; Response.Redirect("~/admin/AdvertiserList.aspx"); } if (!Page.IsPostBack) { returnToCertificateLink.NavigateUrl = "~/admin/CertificateEdit.aspx?id=" + certificate.CertificateId; advertiserNameLabel.Text = certificate.Advertiser.Name; certificateNameLabel.Text = certificate.ShortName; DollarSaverDB.CertificateNumberDataTable usedNumbers = certificate.UsedNumbers; usedCountLabel.Text = usedNumbers.Count.ToString(); usedNumbers.DefaultView.Sort = "CreateDate"; var sortedNumbers = from DollarSaverDB.CertificateNumberRow cn in usedNumbers orderby cn.CreateDate.ToString("yyyyMMdd") descending, cn.OrderId ascending select cn; usedNumberGrid.DataSource = sortedNumbers; usedNumberGrid.DataBind(); } }
void sendSoldoutNoticeButton_Click(object sender, EventArgs e) { int certificateId = Convert.ToInt32(certificateIdBox.Text); CertificateTableAdapter certificateAdapter = new CertificateTableAdapter(); DollarSaverDB.CertificateDataTable certificateLookup = certificateAdapter.GetCertificate(certificateId); if (certificateLookup.Count == 1) { NotifySoldOut(certificateLookup[0]); InfoMessage = "Sent Sold Out Notice for Certificate " + certificateLookup[0].ShortName; } else { ErrorMessage = "Certificate Not Found"; } }
void saveButton_Click(object sender, EventArgs e) { if (Page.IsValid) { int advertiserId = Int32.Parse(advertiserIdHidden.Value); String shortName = nameBox.Text.Trim(); String description = descriptionBox.Text.Trim(); if (shortName == String.Empty) { ErrorMessage = "Name is required"; return; } if (shortName.Length > 100) { shortName = shortName.Substring(0, 100); } if (description == String.Empty) { ErrorMessage = "Description is required"; return; } if (description.Length > 500) { description = description.Substring(0, 500); } int minPurchaseQty = 0; try { minPurchaseQty = Int32.Parse(minPurchaseQtyBox.Text); } catch { ErrorMessage = "Min Purchase Qty must be an integer"; return; } if (minPurchaseQty <= 0) { ErrorMessage = "Min Purchase Qty must be a postive number"; return; } int maxPurchaseQty = 0; try { maxPurchaseQty = Int32.Parse(maxPurchaseQtyBox.Text); } catch { ErrorMessage = "Max Purchase Qty must be an integer"; return; } if (maxPurchaseQty < 0) { ErrorMessage = "Min Purchase Qty must be greater than or equal to 0"; return; } decimal faceValue = 0; try { faceValue = Decimal.Parse(faceValueBox.Text); } catch { ErrorMessage = "Face Value must be a decimal"; return; } if (faceValue <= 0) { ErrorMessage = "Face Value be a postive"; return; } decimal discount = 0; try { discount = Decimal.Parse(discountBox.Text); } catch { ErrorMessage = "Discount must be a decimal"; return; } if (discount <= 0) { ErrorMessage = "Discount be a postive"; return; } int discountTypeId = Int32.Parse(discountList.SelectedValue); String onSaleDateStr = String.Empty; if (Station.StationSiteType == SiteType.DealOfTheWeek) { onSaleDateStr = onSaleDateList.SelectedValue; } else { onSaleDateStr = onSaleDateBox.Text.Trim(); } if (onSaleDateStr == String.Empty) { ErrorMessage = "On Sale Date is required"; return; } if (Station.StationSiteType == SiteType.Standard) { onSaleDateStr += " " + onSaleHourList.SelectedValue + ":" + onSaleMinuteList.SelectedValue + ":00 "; } DateTime onSaleDate; try { onSaleDate = Convert.ToDateTime(onSaleDateStr); } catch { ErrorMessage = "On Sale Date must by in the format MM/DD/YYYY"; return; } onSaleDate = TimeZoneInfo.ConvertTime(onSaleDate, Station.StationTimeZoneInfo, TimeZoneInfo.Local); int lowStockAmount = 0; try { lowStockAmount = Int32.Parse(lowStockAmountBox.Text); } catch { ErrorMessage = "Low Stock Amount must be an integer"; return; } if (lowStockAmount < 0) { ErrorMessage = "Low Stock Amount must be greater than or equal to 0"; return; } int numberLength = Convert.ToInt32(numberLengthList.SelectedValue); int deliveryTypeId = Convert.ToInt32(deliveryList.SelectedValue); string deliveryNote = deliveryNoteBox.Text.Trim(); if (deliveryNote.Length > 500) { deliveryNote = deliveryNote.Substring(0, 500); } bool isActive = isActiveBox.Checked; CertificateTableAdapter certificateAdapter = new CertificateTableAdapter(); if (idHidden.Value != String.Empty) { certificateId = Int32.Parse(idHidden.Value); certificate = certificateAdapter.GetCertificate(certificateId)[0]; certificate.ShortName = shortName; certificate.Description = description; certificate.MinPurchaseQty = minPurchaseQty; certificate.MaxPurchaseQty = maxPurchaseQty; certificate.FaceValue = faceValue; certificate.Discount = discount; certificate.DiscountTypeId = discountTypeId; certificate.OnSaleDate = onSaleDate; certificate.LowStockAmount = lowStockAmount; certificate.NumberLength = numberLength; certificate.DeliveryTypeId = deliveryTypeId; certificate.DeliveryNote = deliveryNote; certificate.IsActive = isActive; certificateAdapter.Update(certificate); CertificateNumberTableAdapter certificateNumberAdapter = new CertificateNumberTableAdapter(); InfoMessage = "Certificate updated"; } else { int quantity = 0; try { quantity = Int32.Parse(qtyBox.Text.Trim()); } catch { ErrorMessage = "Quantity must be an integer"; return; } if (quantity <= 0) { ErrorMessage = "Quantity must be a postive"; return; } certificateId = Convert.ToInt32(certificateAdapter.InsertPK(advertiserId, shortName, description, minPurchaseQty, maxPurchaseQty, faceValue, discount, discountTypeId, deliveryTypeId, deliveryNote, isActive, onSaleDate, lowStockAmount, numberLength)); CertificateNumberTableAdapter certificateNumberAdapter = new CertificateNumberTableAdapter(); certificateNumberAdapter.Generate(certificateId, quantity); InfoMessage = "Certificate created"; } Response.Redirect("~/admin/AdvertiserEdit.aspx?id=" + advertiserId); } }
protected void Page_Load(object sender, EventArgs e) { saveButton.Click += new EventHandler(saveButton_Click); cancelButton.Click += new EventHandler(cancelButton_Click); deleteButton.Click += new EventHandler(deleteButton_Click); deleteButton.Attributes["onclick"] = "javascript: return confirm('Are you sure want to delete this item?');"; emailButton.Click += new EventHandler(emailButton_Click); addNumbersButton.Click += new EventHandler(addNumbersButton_Click); removeNumbersButton.Click += new EventHandler(removeNumbersButton_Click); createHistoryRepeater.ItemDataBound += new RepeaterItemEventHandler(createHistoryRepeater_ItemDataBound); availableNumberGrid.RowDataBound += new GridViewRowEventHandler(availableNumberGrid_RowDataBound); certificateId = GetIdFromQueryString(); int advertiserId = 0; CertificateTableAdapter certificateAdapter = new CertificateTableAdapter(); if (certificateId > 0) { DollarSaverDB.CertificateDataTable certificateTable = certificateAdapter.GetCertificate(certificateId); if (certificateTable.Count != 1) { Response.Redirect("~/admin/AdvertiserList.aspx"); } certificate = certificateTable[0]; advertiserId = certificate.AdvertiserId; } else { advertiserId = GetValueFromQueryString("advertiserId"); } if (!Page.IsPostBack) { if (Station.StationSiteType == SiteType.DealOfTheWeek) { standardDateHolder.Visible = false; onSaleDateBoxRFV.Enabled = false; onSaleDateList.Visible = true; ArrayList onSaleDates = new ArrayList(); onSaleDates = certificateAdapter.GetDealDates(StationId); onSaleDateList.DataSource = onSaleDates; onSaleDateList.DataTextFormatString = "{0:MM/dd/yyyy hh:mm:ss tt}"; onSaleDateList.DataBind(); DateTime onSaleNow = TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.Local, Station.StationTimeZoneInfo); onSaleNow = onSaleNow.AddDays(-14); onSaleDateList.Items.Add(new ListItem("-- On Sale Now --", onSaleNow.ToString("MM/dd/yyyy hh:mm:ss tt"))); } else { standardDateHolder.Visible = true; onSaleDateBoxRFV.Enabled = true; onSaleDateList.Visible = false; for (int i = 0; i <= 23; i++) { String hour; if (i % 12 == 0) { hour = "12"; } else { hour = (i % 12).ToString("00"); } onSaleHourList.Items.Add(new ListItem(hour + " " + (i < 12 ? "AM" : "PM"), i.ToString("00"))); } for (int i = 0; i <= 59; i++) { onSaleMinuteList.Items.Add(new ListItem(i.ToString("00"), i.ToString("00"))); } } AdvertiserTableAdapter advertiserAdapter = new AdvertiserTableAdapter(); DollarSaverDB.AdvertiserDataTable advertiserTable = advertiserAdapter.GetAdvertiser(advertiserId); if (advertiserTable.Count != 1) { Response.Redirect("~/admin/AdvertiserList.aspx"); } DollarSaverDB.AdvertiserRow advertiser = advertiserTable[0]; if (advertiser.StationId != StationId) { Response.Redirect("~/admin/AdvertiserList.aspx"); } if (advertiser.IsDeleted) { InfoMessage = "Sorry, this advertiser has been deleted"; Response.Redirect("~/admin/AdvertiserList.aspx"); } discountList.Items.Add(new ListItem("Percentage", "1")); discountList.Items.Add(new ListItem("Flat Amount", "2")); advertiserNameLabel.Text = advertiser.Name; advertiserIdHidden.Value = advertiserId.ToString(); if (certificateId > 0) { createEditLabel.Text = "Edit"; newCertHolder.Visible = false; idHidden.Value = certificateId.ToString(); nameBox.Text = certificate.ShortName; descriptionLengthLabel.Text = certificate.Description.Length.ToString(); descriptionBox.Text = certificate.Description; minPurchaseQtyBox.Text = certificate.MinPurchaseQty.ToString(); maxPurchaseQtyBox.Text = certificate.MaxPurchaseQty.ToString(); faceValueBox.Text = certificate.FaceValue.ToString("0.00"); discountBox.Text = certificate.Discount.ToString("0.00"); discountList.SelectedValue = certificate.DiscountTypeId.ToString(); if (CurrentUser.Role == AdminRole.Manager || CurrentUser.Role == AdminRole.SalesRep) { faceValueBox.Enabled = false; discountBox.Enabled = false; discountList.Enabled = false; } deliveryList.SelectedValue = certificate.DeliveryTypeId.ToString(); deliveryNoteBox.Text = certificate.DeliveryNote; isActiveBox.Checked = certificate.IsActive; lowStockAmountBox.Text = certificate.LowStockAmount.ToString(); if (numberLengthList.Items.FindByValue(certificate.NumberLength.ToString()) != null) { numberLengthList.SelectedValue = certificate.NumberLength.ToString(); } if (Station.StationSiteType == SiteType.DealOfTheWeek) { ListItem dateItem = onSaleDateList.Items.FindByText(certificate.AdjustedOnSaleDate.ToString("MM/dd/yyyy hh:mm:ss tt}")); if (dateItem != null) { onSaleDateList.SelectedIndex = onSaleDateList.Items.IndexOf(dateItem); } else { onSaleDateList.Items.Insert(0, new ListItem(certificate.AdjustedOnSaleDate.ToString("MM/dd/yyyy hh:mm:ss tt"), certificate.AdjustedOnSaleDate.ToString("M/d/yyyy h:mm:ss tt"))); } } else { onSaleDateBox.Text = certificate.AdjustedOnSaleDate.ToString("MM/dd/yyyy"); onSaleHourList.SelectedValue = certificate.AdjustedOnSaleDate.Hour.ToString("00"); onSaleMinuteList.SelectedValue = certificate.AdjustedOnSaleDate.Minute.ToString("00"); } CertificateNumberTableAdapter certificateNumberAdapter = new CertificateNumberTableAdapter(); ArrayList createDates = certificateNumberAdapter.GetDates(certificateId); createDateList.DataSource = createDates; createDateList.DataTextFormatString = "{0:MM/dd/yyyy}"; createDateList.DataBind(); createDateList.Items.Insert(0, new ListItem("-- All Dates --", "")); certificateNumberHolder.Visible = true; createHistoryRepeater.DataSource = createDates; createHistoryRepeater.DataBind(); if (certificate.DeliveryType == DeliveryType.Print) { printableHolder.Visible = true; notPrintableHolder.Visible = false; String queryString = "sample_id=" + certificate.CertificateId; String encryptedString = Server.UrlEncode(Cipher.Encrypt(queryString)); viewSampleLink.NavigateUrl = "~/ViewCertificate.aspx?x=" + encryptedString; BindNumbers(); } else { printableHolder.Visible = false; notPrintableHolder.Visible = true; availableCountLabel.Text = certificate.AvailableNumbers.Count.ToString(); usedCountLabel.Text = certificate.UsedNumbers.Count.ToString(); } } else { deleteButton.Visible = false; saveButton.Text = "Create"; createEditLabel.Text = "Create"; certificateNumberHolder.Visible = false; newCertHolder.Visible = true; onSaleDateBox.Text = DateTime.Now.ToString("MM/dd/yyyy"); } } }
private void LoadCertificateNumber() { CertificateNumberTableAdapter certificateNumberAdapter = new CertificateNumberTableAdapter(); int id = 0; int orderId = 0; int sampleId = 0; String cipherText = Request.QueryString["x"]; if (cipherText != null && cipherText != String.Empty) { try { String plainText = Server.UrlDecode(Cipher.Decrypt(cipherText)); String[] keysAndValues = plainText.Split('&'); foreach (String keyAndValueStr in keysAndValues) { String[] keyAndValue = keyAndValueStr.Split('='); if (keyAndValue.Length == 2) { if (keyAndValue[0] == "id") { try { id = Convert.ToInt32(keyAndValue[1]); } catch { } } else if (keyAndValue[0] == "order_id") { try { orderId = Convert.ToInt32(keyAndValue[1]); } catch { } } else if (keyAndValue[0] == "sample_id") { try { sampleId = Convert.ToInt32(keyAndValue[1]); } catch { } } } } } catch { } } if (sampleId == 0) { if (id == 0 || orderId == 0) { // check for old parameters for backward compatibility // viewcertificate?orderNum=13651&certNum=755426&backBtn=no orderId = GetValueFromQueryString("orderNum"); id = 0; // cut off backward compatibility after certain order id if (orderId < 17000) { String number = Convert.ToString(Request.QueryString["certNum"]); if (orderId == 0 || number == String.Empty) { return; } DollarSaverDB.CertificateNumberDataTable numberSearch = certificateNumberAdapter.GetBackward(orderId, number); if (numberSearch.Count == 1) { id = numberSearch[0].CertificateNumberId; } else { return; } } } DollarSaverDB.CertificateNumberDataTable certNumberTable = certificateNumberAdapter.GetCertificateNumber(id); if (certNumberTable.Count != 1) { return; } DollarSaverDB.CertificateNumberRow checkCertNumber = certNumberTable[0]; OrderTableAdapter orderAdapter = new OrderTableAdapter(); DollarSaverDB.OrderDataTable orderTable = orderAdapter.GetOrder(orderId); if (orderTable.Count != 1) { return; } DollarSaverDB.OrderRow order = orderTable[0]; if (order.OrderStatusId != (int)OrderStatus.Complete) { return; } if (checkCertNumber.IsOrderLineItemIdNull() || !order.LineItems.Contains(checkCertNumber.OrderLineItemId)) { return; } certNumber = checkCertNumber; certificate = certNumber.Certificate; } else { CertificateTableAdapter certAdapter = new CertificateTableAdapter(); DollarSaverDB.CertificateDataTable certificateTable = certAdapter.GetCertificate(sampleId); if (certificateTable.Count != 1) { return; } certificate = certificateTable[0]; } }
protected void Page_Load(object sender, EventArgs e) { lineItemRepeater.ItemDataBound += new RepeaterItemEventHandler(lineItemRepeater_ItemDataBound); lineItemRepeater.ItemCommand += new RepeaterCommandEventHandler(lineItemRepeater_ItemCommand); updateButton.Click += new EventHandler(updateButton_Click); continueButton.Click += new EventHandler(continueButton_Click); /* * if (Order != null && * (Order.OrderStatusId != 1 || Order.StationId != StationId)) { * Order = null; * Response.Redirect("~/Cart.aspx"); * }*/ if (displayCookieMessage) { itemHolder.Visible = false; emptyCartHolder.Visible = false; cookieMessageHolder.Visible = true; homeLink.NavigateUrl += "?station_id=" + StationId; return; } else { cookieMessageHolder.Visible = false; } if (!Page.IsPostBack) { OrderTableAdapter orderAdapter = new OrderTableAdapter(); int certificateId = GetCertificateIdFromQueryString(); if ((Order == null && certificateId > 0) || (Order != null && Order.OrderStatusId != 1) || (Order != null && Order.StationId != StationId)) { Order = GenerateOrder(); } if (certificateId > 0) { CertificateTableAdapter certificateAdapter = new CertificateTableAdapter(); DollarSaverDB.CertificateDataTable certificateTable = certificateAdapter.GetCertificate(certificateId); if (certificateTable.Count != 1) { Response.Redirect("~/Cart.aspx"); } DollarSaverDB.CertificateRow certificate = certificateTable[0]; if (certificate.Advertiser.StationId != StationId) { Response.Redirect("~/Cart.aspx"); } if (!certificate.IsActive || !certificate.Advertiser.IsActive) { InfoMessage = "Sorry, this certificate is no longer available"; Response.Redirect("~/Cart.aspx"); } if (certificate.OnSaleDate > DateTime.Now) { InfoMessage = "Sorry, this certificate is not yet available"; Response.Redirect("~/Cart.aspx"); } int quantity = GetValueFromQueryString("qty"); if (quantity == 0) { quantity = 1; } OrderLineItemTableAdapter orderLineItemAdapter = new OrderLineItemTableAdapter(); DollarSaverDB.OrderLineItemRow lineItem = Order.LineItems.GetLineItem(certificateId); if (lineItem == null) { quantity = CheckQuantity(quantity, certificate); if (quantity > 0) { Order.LineItems.AddOrderLineItemRow(Order.OrderId, -1, quantity, certificate.CertificateId, certificate.ShortName, certificate.Description, certificate.FaceValue, certificate.Discount, certificate.DiscountTypeId, false, certificate.DeliveryTypeId, certificate.DeliveryNote); orderLineItemAdapter.Update(Order.LineItems); } } else { quantity += lineItem.Quantity; quantity = CheckQuantity(quantity, certificate); if (quantity == 0) { orderLineItemAdapter.Delete(lineItem.OrderLineItemId); } else { lineItem.Quantity = quantity; orderLineItemAdapter.Update(lineItem); } } UpdateLineItemModifiedDate(); if (InfoMessage == String.Empty) { InfoMessage = "Certificate(s) added to your cart"; } // reload the cart Response.Redirect("~/Cart.aspx"); } if (Order != null && Order.LineItems.Count > 0) { itemHolder.Visible = true; emptyCartHolder.Visible = false; lineItemRepeater.DataSource = Order.LineItems.Rows; lineItemRepeater.DataBind(); subTotalLabel.Text = Order.LineItems.SubTotal.ToString("$#,0.00"); continueShoppingLink.NavigateUrl = "~/Default.aspx?station_id=" + StationId; } else { itemHolder.Visible = false; emptyCartHolder.Visible = true; } } else { // if page is postback, make sure the order is still in the session if (Order == null) { InfoMessage = "Sorry, your session has timed out"; Response.Redirect("~/Cart.aspx"); } } }