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);
        }
Esempio n. 3
0
        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"));
            }
        }
Esempio n. 4
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));
                }
            }
        }
Esempio n. 8
0
        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&amp;v=2&amp;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();
                }
            }
        }