void deleteButton_Click(object sender, EventArgs e) { /* * try { * AdvertiserTableAdapter advertiserAdapter = new AdvertiserTableAdapter(); * * advertiserAdapter.Delete(advertiserId); * * } catch (SqlException ex) { * if (ex.Number == 547) { * ErrorMessage = "Advertiser cannot be deleted due to database constraints. De-activate it instead."; * return; * } else { * throw ex; * } * } * */ if (advertiserId > 0) { AdvertiserTableAdapter advertiserAdapter = new AdvertiserTableAdapter(); advertiser.IsDeleted = true; advertiserAdapter.Update(advertiser); InfoMessage = "Advertiser deleted"; Response.Redirect("~/admin/AdvertiserList.aspx"); } }
protected override void OnPreInit(EventArgs e) { int advertiserId = GetValueFromQueryString("advertiser_id"); if (advertiserId > 0) { AdvertiserTableAdapter adapter = new AdvertiserTableAdapter(); DollarSaverDB.AdvertiserDataTable advertisers = adapter.GetAdvertiser(advertiserId); if (advertisers.Count == 1) { Advertiser = advertisers[0]; } } base.OnPreInit(e); }
protected override void OnLoad(EventArgs e) { base.OnLoad(e); submitButton.Click += new EventHandler(submitButton_Click); if (!Page.IsPostBack) { AdvertiserTableAdapter advertiserAdapter = new AdvertiserTableAdapter(); DollarSaverDB.AdvertiserDataTable advertisers = advertiserAdapter.GetActiveByStation(StationId); advertiserList.DataSource = advertisers.Rows; advertiserList.DataTextField = "Name"; advertiserList.DataValueField = "AdvertiserId"; advertiserList.DataBind(); advertiserList.Items.Insert(0, new ListItem("", "0")); } }
void submitButton_Click(object sender, EventArgs e) { if (Page.IsValid) { String firstName = firstNameBox.Text.Trim(); String lastName = lastNameBox.Text.Trim(); String emailAddress = emailBox.Text.Trim(); String confirmEmailAddress = confirmEmailBox.Text.Trim(); int advertiserId = Convert.ToInt32(advertiserList.SelectedValue); String orderIdStr = orderIdBox.Text.Trim(); String message = messageBox.Text.Trim(); if (firstName == String.Empty) { ErrorMessage = "First Name is required"; return; } else if (firstName.Length > 50) { firstName = firstName.Substring(0, 50); } if (lastName == String.Empty) { ErrorMessage = "Last Name is required"; return; } else if (lastName.Length > 50) { lastName = lastName.Substring(0, 50); } if (emailAddress == String.Empty) { ErrorMessage = "E-mail is required"; return; } if (emailAddress != confirmEmailAddress) { ErrorMessage = "E-mail address do not match"; return; } if (!Regex.IsMatch(emailAddress, @"^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$")) { ErrorMessage = "E-mail address is not valid"; return; } int orderId = 0; if (orderIdStr != String.Empty) { try { orderId = Convert.ToInt32(orderIdStr); if (orderId <= 0) { throw new Exception(); } } catch { ErrorMessage = "Order ID is not valid"; return; } } if (message == String.Empty) { ErrorMessage = "Please enter a message"; return; } else if (message.Length > 5000) { message = message.Substring(0, 5000); } IssueTableAdapter issueAdapter = new IssueTableAdapter(); int issueId = Convert.ToInt32(issueAdapter.InsertPK(StationId, true, DateTime.Now, Globals.ConvertToNull(advertiserId), Globals.ConvertToNull(orderId), message, emailAddress, firstName, lastName, null, null, null, null, null, null, null)); MailMessage emailMessage = new MailMessage("\"" + firstName + " " + lastName + "\" <" + emailAddress + ">", "\"DollarSaver Help\" <*****@*****.**>"); emailMessage.IsBodyHtml = false; emailMessage.Subject = Station.SiteNamePlainText + " DollarSaver Issue #" + issueId; String body = Station.SiteNamePlainText + " DollarSaver Issue #" + issueId + Environment.NewLine + Environment.NewLine; body += "From: " + firstName + " " + lastName + " - " + emailAddress + Environment.NewLine; if (advertiserId > 0) { AdvertiserTableAdapter advertiserAdapter = new AdvertiserTableAdapter(); DollarSaverDB.AdvertiserRow advertiser = advertiserAdapter.GetAdvertiser(advertiserId)[0]; body += "Advertiser: " + advertiser.Name + Environment.NewLine; } if (orderId > 0) { body += "Order #: " + orderId + Environment.NewLine; } body += Environment.NewLine + "Message:" + Environment.NewLine; body += message; emailMessage.Body = body; try { Mailer mailer = new Mailer(); mailer.Send(emailMessage); } catch { } InfoMessage = "Thank you for your message. You should receive a response within 48 hours."; DollarSaverRedirect("~/Default.aspx"); } }
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"); } } }
void saveButton_Click(object sender, EventArgs e) { if (Page.IsValid) { //String imageDir = Request.PhysicalApplicationPath + "/station/" + StationId + "/images/"; Globals.CheckDirectory(ImageDir); int categoryId = Int32.Parse(categoryList.SelectedValue); String name = nameBox.Text.Trim(); String address1 = address1Box.Text.Trim(); String address2 = address2Box.Text.Trim(); String city = cityBox.Text.Trim(); String stateCode = stateList.SelectedValue; String zipCode = zipCodeBox.Text.Trim(); bool isAddressMappable = isAddressMappableBox.Checked; String contactPerson = contactPersonBox.Text.Trim(); String phoneNumber = phoneNumberBox.Text.Trim(); String websiteUrl = websiteBox.Text.Trim(); String description = descriptionBox.Text.Trim(); int salesPersonId = Int32.Parse(salesPersonList.SelectedValue); bool isActive = isActiveBox.Checked; if (name == String.Empty) { ErrorMessage = "Name cannot be blank"; return; } if (websiteUrl != String.Empty) { websiteUrl = websiteUrlStart.SelectedValue + websiteUrl; // come up with a better validation... if (!Uri.IsWellFormedUriString(websiteUrl, UriKind.Absolute)) { ErrorMessage = "Please enter a valid Advertiser Website"; return; } } else { websiteUrl = null; } if (address1 == String.Empty) { address1 = null; } if (address2 == String.Empty) { address2 = null; } if (city == String.Empty) { city = null; } if (stateCode == String.Empty) { stateCode = null; } if (zipCode == String.Empty) { zipCode = null; } if (contactPerson == String.Empty) { contactPerson = null; } if (phoneNumber == String.Empty) { phoneNumber = null; } if (description == String.Empty) { description = null; } if (description != null && description.Length > 3000) { description = description.Substring(0, 3000); } int subCat1Id = 0; int subCat2Id = 0; int subCat3Id = 0; if (subCategory1Holder.Visible && subCategoryList1.SelectedValue != "0") { subCat1Id = Int32.Parse(subCategoryList1.SelectedValue); } if (subCategory2Holder.Visible && subCategoryList2.SelectedValue != "0") { subCat2Id = Int32.Parse(subCategoryList2.SelectedValue); if (subCat2Id == subCat1Id) { subCat2Id = 0; } } if (subCategory3Holder.Visible && subCategoryList3.SelectedValue != "0") { subCat3Id = Int32.Parse(subCategoryList3.SelectedValue); if (subCat3Id == subCat1Id || subCat3Id == subCat2Id) { subCat3Id = 0; } } AdvertiserTableAdapter advertiserAdapter = new AdvertiserTableAdapter(); if (advertiserId > 0) { advertiser.CategoryId = categoryId; advertiser.Name = name; if (address1 == null) { advertiser.SetAddress1Null(); } else { advertiser.Address1 = address1; } if (address2 == null) { advertiser.SetAddress2Null(); } else { advertiser.Address2 = address2; } if (city == null) { advertiser.SetCityNull(); } else { advertiser.City = city; } if (zipCode == null) { advertiser.SetZipCodeNull(); } else { advertiser.ZipCode = zipCode; } advertiser.StateCode = stateCode; advertiser.IsAddressMappable = isAddressMappable; if (contactPerson == null) { advertiser.SetContactPersonNull(); } else { advertiser.ContactPerson = contactPerson; } if (phoneNumber == null) { advertiser.SetPhoneNumberNull(); } else { advertiser.PhoneNumber = phoneNumber; } if (websiteUrl == null) { advertiser.SetWebsiteUrlNull(); } else { advertiser.WebsiteUrl = websiteUrl; } String logoImage = String.Empty; String fileType = String.Empty; if (logoUpload.HasFile) { logoImage = logoUpload.FileName.ToUpper();; if (logoImage.EndsWith(".GIF")) { fileType = ".gif"; } else if (logoImage.EndsWith(".JPG")) { fileType = ".jpg"; } else if (logoImage.EndsWith(".JPEG")) { fileType = ".jpeg"; } else { ErrorMessage = "Image must be of type .gif or .jpg"; return; } System.Drawing.Image logoImageFile = System.Drawing.Image.FromStream(logoUpload.FileContent); if (!(logoImageFile.Width == 125 && logoImageFile.Height == 75) && !(logoImageFile.Width == 75 && logoImageFile.Height == 125)) { ErrorMessage = "Image must be 125px X 75px OR 75px X 125px"; return; } Boolean isLogoImageVertical = false; if (logoImageFile.Width == 75) { isLogoImageVertical = true; } logoImage = "advertiser_" + advertiserId + fileType; advertiser.LogoImage = logoImage; advertiser.IsLogoImageVertical = isLogoImageVertical; logoUpload.SaveAs(ImageDir + logoImage); } if (description == null) { advertiser.SetDescriptionNull(); } else { advertiser.Description = description; } if (salesPersonId == 0) { advertiser.SetSalesPersonIdNull(); } else { advertiser.SalesPersonId = salesPersonId; } advertiser.IsActive = isActive; advertiserAdapter.Update(advertiser); CategoryTableAdapter categoryAdapter = new CategoryTableAdapter(); categoryAdapter.ClearSubCategoriesByAdvertiser(advertiserId); if (subCat1Id > 0) { categoryAdapter.AddSubCategoryToAdvertiser(advertiserId, subCat1Id); } if (subCat2Id > 0) { categoryAdapter.AddSubCategoryToAdvertiser(advertiserId, subCat2Id); } if (subCat3Id > 0) { categoryAdapter.AddSubCategoryToAdvertiser(advertiserId, subCat3Id); } InfoMessage = "Advertiser updated"; Response.Redirect("~/admin/AdvertiserList.aspx"); } else { advertiserId = Convert.ToInt32(advertiserAdapter.InsertPK(StationId, name, categoryId, Globals.ConvertToNull(salesPersonId), address1, address2, city, stateCode, zipCode, contactPerson, phoneNumber, websiteUrl, null, description, isActive, false, isAddressMappable, false)); String logoImage = String.Empty; String fileType = String.Empty; if (logoUpload.HasFile) { logoImage = logoUpload.FileName.ToUpper();; if (logoImage.EndsWith(".GIF")) { fileType = ".gif"; } else if (logoImage.EndsWith(".JPG")) { fileType = ".jpg"; } else if (logoImage.EndsWith(".JPEG")) { fileType = ".jpeg"; } else { ErrorMessage = "Image must be of type .gif or .jpg"; return; } System.Drawing.Image logoImageFile = System.Drawing.Image.FromStream(logoUpload.FileContent); if (!(logoImageFile.Width == 125 && logoImageFile.Height == 75) && !(logoImageFile.Width == 75 && logoImageFile.Height == 125)) { ErrorMessage = "Image must be 125px X 75px OR 75px X 125px"; return; } Boolean isLogoImageVertical = false; if (logoImageFile.Width == 75) { isLogoImageVertical = true; } logoImage = "advertiser_" + advertiserId + fileType; advertiser = advertiserAdapter.GetAdvertiser(advertiserId)[0]; advertiser.LogoImage = logoImage; advertiser.IsLogoImageVertical = isLogoImageVertical; logoUpload.SaveAs(ImageDir + logoImage); advertiserAdapter.Update(advertiser); } CategoryTableAdapter categoryAdapter = new CategoryTableAdapter(); categoryAdapter.ClearSubCategoriesByAdvertiser(advertiserId); if (subCat1Id > 0) { categoryAdapter.AddSubCategoryToAdvertiser(advertiserId, subCat1Id); } if (subCat2Id > 0) { categoryAdapter.AddSubCategoryToAdvertiser(advertiserId, subCat2Id); } if (subCat3Id > 0) { categoryAdapter.AddSubCategoryToAdvertiser(advertiserId, subCat3Id); } InfoMessage = "Advertiser created, please create a certificate for the advertiser"; Response.Redirect("~/admin/CertificateEdit.aspx?advertiserId=" + 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?');"; categoryList.SelectedIndexChanged += new EventHandler(categoryList_SelectedIndexChanged); advertiserId = GetIdFromQueryString(); if (advertiserId > 0) { AdvertiserTableAdapter advertiserAdapter = new AdvertiserTableAdapter(); DollarSaverDB.AdvertiserDataTable advetisers = advertiserAdapter.GetAdvertiser(advertiserId); if (advetisers.Count != 1) { Response.Redirect("~/admin/AdvertiserList.aspx"); } advertiser = advetisers[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"); } } if (!Page.IsPostBack) { categoryList.DataSource = Station.PrimaryCategories; categoryList.DataTextField = "Name"; categoryList.DataValueField = "CategoryId"; categoryList.DataBind(); salesPersonList.DataSource = Station.ActiveSalesPeople.Rows; salesPersonList.DataValueField = "SalesPersonId"; salesPersonList.DataTextField = "FullName"; salesPersonList.DataBind(); salesPersonList.Items.Insert(0, new ListItem("", "0")); StateTableAdapter stateAdapter = new StateTableAdapter(); DollarSaverDB.StateDataTable states = stateAdapter.GetStates(); stateList.DataSource = states.Rows; stateList.DataTextField = "Summary"; stateList.DataValueField = "StateCode"; stateList.DataBind(); stateList.Items.Insert(0, new ListItem(String.Empty, String.Empty)); if (advertiserId > 0) { createEditLabel.Text = "Edit"; categoryList.SelectedValue = advertiser.CategoryId.ToString(); BindSubCategories(advertiser.CategoryId); nameBox.Text = advertiser.Name; address1Box.Text = advertiser.DisplayAddress1; address2Box.Text = advertiser.DisplayAddress2; cityBox.Text = advertiser.DisplayCity; if (!advertiser.IsStateCodeNull()) { stateList.SelectedValue = advertiser.StateCode; } zipCodeBox.Text = advertiser.DisplayZipCode; isAddressMappableBox.Checked = advertiser.IsAddressMappable; phoneNumberBox.Text = advertiser.DisplayPhoneNumber; if (!advertiser.IsContactPersonNull()) { contactPersonBox.Text = advertiser.ContactPerson; } string urlDomain = String.Empty; if (!advertiser.IsWebsiteUrlNull() && advertiser.WebsiteUrl != String.Empty) { if (advertiser.WebsiteUrl.StartsWith("https://")) { urlDomain = advertiser.WebsiteUrl.Substring(8); websiteUrlStart.SelectedValue = "https://"; } else { urlDomain = advertiser.WebsiteUrl.Substring(7); } } websiteBox.Text = urlDomain; descriptionLengthLabel.Text = advertiser.DisplayDescription.Length.ToString(); descriptionBox.Text = advertiser.DisplayDescription; isActiveBox.Checked = advertiser.IsActive; if (advertiser.DisplayLogoImage != String.Empty) { logoUrlImage.ImageUrl = advertiser.LogoUrl + "?" + DateTime.Now.ToString("yyyyMMddhhmmss"); if (advertiser.IsLogoImageVertical) { logoUrlImage.Width = 75; logoUrlImage.Height = 125; } else { logoUrlImage.Width = 125; logoUrlImage.Height = 75; } logoUrlImage.Visible = true; } if (!advertiser.IsSalesPersonIdNull() && salesPersonList.Items.FindByValue(advertiser.SalesPersonId.ToString()) == null) { if (advertiser.SalesPerson != null) { salesPersonList.Items.Add(new ListItem(advertiser.SalesPerson.FullName, advertiser.SalesPerson.SalesPersonId.ToString())); } } if (!advertiser.IsSalesPersonIdNull()) { salesPersonList.SelectedValue = advertiser.SalesPersonId.ToString(); } if (advertiser.ActiveCertificates.Count > 0) { noActiveFoundHolder.Visible = false; activeCertHolder.Visible = true; certificateGrid.DataSource = advertiser.ActiveCertificates.Rows; certificateGrid.DataBind(); } else { noActiveFoundHolder.Visible = true; activeCertHolder.Visible = false; } if (advertiser.InactiveCertificates.Count > 0) { inactiveCertHolder.Visible = true; inactiveCertificateGrid.DataSource = advertiser.InactiveCertificates.Rows; inactiveCertificateGrid.DataBind(); } else { inactiveCertHolder.Visible = false; } newCertificateLink.NavigateUrl = "~/admin/CertificateEdit.aspx?advertiserId=" + advertiserId; certificateHolder.Visible = true; } else { deleteButton.Visible = false; saveButton.Text = "Create"; createEditLabel.Text = "Create"; certificateHolder.Visible = false; stateList.SelectedValue = Station.StateCode; BindSubCategories(Convert.ToInt32(categoryList.SelectedValue)); } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { int advertiserId = GetValueFromQueryString("advertiser_id"); if (advertiserId > 0) { AdvertiserTableAdapter adapter = new AdvertiserTableAdapter(); DollarSaverDB.AdvertiserDataTable data = adapter.GetAdvertiser(advertiserId); if (data.Rows.Count == 1) { advertiserHolder.Visible = true; Advertiser = data[0]; if (Advertiser.StationId != StationId || !Advertiser.IsActive) { RedirectToHomePage(); } returnLink.NavigateUrl = "~/Advertiser.aspx?advertiser_id=" + Advertiser.AdvertiserId; String displayText = "<b>" + Server.HtmlEncode(Advertiser.Name) + "</b><br>" + Advertiser.FullAddress; displayText = displayText.Replace("'", @"\'"); Page.Header.Controls.Add(new LiteralControl("<script src=\"http://maps.google.com/maps?file=api&v=2&key=ABQIAAAA0FhpaLYxjG1W_O_krcsz7xQyXc6TLbTx09-5RFMXJMMBRxWMXRR5ekopx2FaawD8vTFlpkvByI7eQA\" type=\"text/javascript\"></script>")); Page.ClientScript.RegisterStartupScript(this.GetType(), "1", "<script type=\"text/javascript\">showAddress('" + Advertiser.InlineAddress.Replace("'", "\'") + "', '" + displayText + "');</script>"); if (Advertiser.LogoUrl != String.Empty) { advertiserImage.ImageUrl = Advertiser.LogoUrl; if (Advertiser.IsLogoImageVertical) { advertiserImage.Width = 75; advertiserImage.Height = 125; } else { advertiserImage.Width = 125; advertiserImage.Height = 75; } advertiserImage.AlternateText = Advertiser.Name; advertiserImage.ToolTip = Advertiser.Name; } else { advertiserImage.Visible = false; } advertiserNameLabel.Text = Advertiser.Name; if (!Advertiser.IsWebsiteUrlNull()) { viewWebsiteLink.NavigateUrl = Advertiser.WebsiteUrl; } else { viewWebsiteLink.Visible = false; } if (Advertiser.InlineAddress.Trim() != String.Empty) { addressLabel.Text = "<strong>Address:</strong> " + Advertiser.InlineAddress; } if (Advertiser.DisplayPhoneNumber.Trim() != String.Empty) { phoneLabel.Text = "<strong>Phone:</strong> " + Advertiser.DisplayPhoneNumber; } } else { RedirectToHomePage(); } } else { RedirectToHomePage(); } } }