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