protected void Page_Load(object sender, EventArgs e)
{
saveButton.Click += new EventHandler(saveButton_Click);
cancelButton.Click += new EventHandler(cancelButton_Click);
if (Station.SiteTypeId != (int)SiteType.Standard)
{
Response.Redirect("~/admin/Default.aspx");
}
specialTable = specialAdapter.GetStationSpecial(StationId, 1);
if (specialTable.Count == 1)
{
specialOne = specialTable[0];
}
specialTable = specialAdapter.GetStationSpecial(StationId, 2);
if (specialTable.Count == 1)
{
specialTwo = specialTable[0];
}
specialTable = specialAdapter.GetStationSpecial(StationId, 3);
if (specialTable.Count == 1)
{
specialThree = specialTable[0];
}
specialTable = specialAdapter.GetStationSpecial(StationId, 4);
if (specialTable.Count == 1)
{
specialFour = specialTable[0];
}
if (!Page.IsPostBack)
{
CategoryTableAdapter categoryAdapter = new CategoryTableAdapter();
DollarSaverDB.CategoryDataTable categories = categoryAdapter.GetPrimaryCategoriesByStation(StationId);
CertificateTableAdapter certificateAdapter = new CertificateTableAdapter();
DollarSaverDB.CertificateDataTable certificates = certificateAdapter.GetActive(StationId);
//certificates.DefaultView.Sort
SpecialSettingsTableAdapter specialSettingsAdapter = new SpecialSettingsTableAdapter();
DollarSaverDB.SpecialSettingsDataTable specialSettingsTable = specialSettingsAdapter.GetSpecialSettings(StationId);
if (specialSettingsTable.Count == 1)
{
if (specialSettingsTable[0].DailyHeader)
{
dailyWeeklyList.SelectedValue = "1";
}
else
{
dailyWeeklyList.SelectedValue = "2";
}
}
// Daily/Weekly Special 1
/*
* specialOneCategoryList.DataSource = categories;
* specialOneCategoryList.DataTextField = "Name";
* specialOneCategoryList.DataValueField = "CategoryId";
* specialOneCategoryList.DataBind();
*/
specialOneCertificateList.DataSource = certificates.Rows;
specialOneCertificateList.DataTextField = "AdvertiserAndCertificate";
specialOneCertificateList.DataValueField = "CertificateId";
specialOneCertificateList.DataBind();
if (specialOne != null)
{
if (!specialOne.IsCertificateIdNull())
{
//specialOneCertificateBox.Checked = true;
if (certificates.FindByCertificateId(specialOne.CertificateId) != null)
{
specialOneCertificateList.SelectedValue = specialOne.CertificateId.ToString();
}
}
/*
* else if (!specialOne.IsCategoryIdNull()) {
* specialOneCategoryBox.Checked = true;
*
* specialOneCategoryList.SelectedValue = specialOne.CategoryId.ToString();
* } else {
* specialOneRandomBox.Checked = true;
* }
*/
}
// Special 2
specialTwoCategoryList.DataSource = categories;
specialTwoCategoryList.DataTextField = "Name";
specialTwoCategoryList.DataValueField = "CategoryId";
specialTwoCategoryList.DataBind();
specialTwoCertificateList.DataSource = certificates.Rows;
specialTwoCertificateList.DataTextField = "AdvertiserAndCertificate";
specialTwoCertificateList.DataValueField = "CertificateId";
specialTwoCertificateList.DataBind();
if (specialTwo != null)
{
if (!specialTwo.IsCertificateIdNull())
{
specialTwoCertificateBox.Checked = true;
if (certificates.FindByCertificateId(specialTwo.CertificateId) != null)
{
specialTwoCertificateList.SelectedValue = specialTwo.CertificateId.ToString();
}
}
else if (!specialTwo.IsCategoryIdNull())
{
specialTwoCategoryBox.Checked = true;
specialTwoCategoryList.SelectedValue = specialTwo.CategoryId.ToString();
}
else
{
specialTwoRandomBox.Checked = true;
}
}
// Special 3
specialThreeCategoryList.DataSource = categories;
specialThreeCategoryList.DataTextField = "Name";
specialThreeCategoryList.DataValueField = "CategoryId";
specialThreeCategoryList.DataBind();
specialThreeCertificateList.DataSource = certificates.Rows;
specialThreeCertificateList.DataTextField = "AdvertiserAndCertificate";
specialThreeCertificateList.DataValueField = "CertificateId";
specialThreeCertificateList.DataBind();
if (specialThree != null)
{
if (!specialThree.IsCertificateIdNull())
{
specialThreeCertificateBox.Checked = true;
if (certificates.FindByCertificateId(specialThree.CertificateId) != null)
{
specialThreeCertificateList.SelectedValue = specialThree.CertificateId.ToString();
}
}
else if (!specialThree.IsCategoryIdNull())
{
specialThreeCategoryBox.Checked = true;
specialThreeCategoryList.SelectedValue = specialThree.CategoryId.ToString();
}
else
{
specialThreeRandomBox.Checked = true;
}
}
// Special 4
specialFourCategoryList.DataSource = categories;
specialFourCategoryList.DataTextField = "Name";
specialFourCategoryList.DataValueField = "CategoryId";
specialFourCategoryList.DataBind();
specialFourCertificateList.DataSource = certificates.Rows;
specialFourCertificateList.DataTextField = "AdvertiserAndCertificate";
specialFourCertificateList.DataValueField = "CertificateId";
specialFourCertificateList.DataBind();
if (specialFour != null)
{
if (!specialFour.IsCertificateIdNull())
{
specialFourCertificateBox.Checked = true;
if (certificates.FindByCertificateId(specialFour.CertificateId) != null)
{
specialFourCertificateList.SelectedValue = specialFour.CertificateId.ToString();
}
}
else if (!specialFour.IsCategoryIdNull())
{
specialFourCategoryBox.Checked = true;
specialFourCategoryList.SelectedValue = specialFour.CategoryId.ToString();
}
else
{
specialFourRandomBox.Checked = true;
}
}
}
}
void saveButton_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
specialTable = new DollarSaverDB.StationSpecialDataTable();
bool specialOneNew = false;
if (specialOne == null)
{
specialOneNew = true;
specialOne = specialTable.NewStationSpecialRow();
specialOne.StationId = StationId;
specialOne.SeqNo = 1;
}
bool specialTwoNew = false;
if (specialTwo == null)
{
specialTwoNew = true;
specialTwo = specialTable.NewStationSpecialRow();
specialTwo.StationId = StationId;
specialTwo.SeqNo = 2;
}
bool specialThreeNew = false;
if (specialThree == null)
{
specialThreeNew = true;
specialThree = specialTable.NewStationSpecialRow();
specialThree.StationId = StationId;
specialThree.SeqNo = 3;
}
bool specialFourNew = false;
if (specialFour == null)
{
specialFourNew = true;
specialFour = specialTable.NewStationSpecialRow();
specialFour.StationId = StationId;
specialFour.SeqNo = 4;
}
// Special One
//if (specialOneCertificateBox.Checked) {
bool dailyHeader = false;
if (dailyWeeklyList.SelectedValue == "1")
{
dailyHeader = true;
}
SpecialSettingsTableAdapter specialSettingsAdapter = new SpecialSettingsTableAdapter();
DollarSaverDB.SpecialSettingsDataTable specialSettingsTable = specialSettingsAdapter.GetSpecialSettings(StationId);
if (specialSettingsTable.Count == 1)
{
specialSettingsTable[0].DailyHeader = dailyHeader;
specialSettingsAdapter.Update(specialSettingsTable[0]);
}
else
{
specialSettingsAdapter.Insert(StationId, dailyHeader);
}
specialOne.CertificateId = Convert.ToInt32(specialOneCertificateList.SelectedValue);
specialOne.SetCategoryIdNull();
/*
* } else if (specialOneCategoryBox.Checked) {
* specialOne.CategoryId = Convert.ToInt32(specialOneCategoryList.SelectedValue);
* specialOne.SetCertificateIdNull();
* } else {
* specialOne.SetCertificateIdNull();
* specialOne.SetCategoryIdNull();
* }
* */
if (specialOneNew)
{
specialTable.AddStationSpecialRow(specialOne);
}
else
{
specialTable.ImportRow(specialOne);
}
// Special Two
if (specialTwoCertificateBox.Checked)
{
specialTwo.CertificateId = Convert.ToInt32(specialTwoCertificateList.SelectedValue);
specialTwo.SetCategoryIdNull();
}
else if (specialTwoCategoryBox.Checked)
{
specialTwo.CategoryId = Convert.ToInt32(specialTwoCategoryList.SelectedValue);
specialTwo.SetCertificateIdNull();
}
else
{
specialTwo.SetCertificateIdNull();
specialTwo.SetCategoryIdNull();
}
if (specialTwoNew)
{
specialTable.AddStationSpecialRow(specialTwo);
}
else
{
specialTable.ImportRow(specialTwo);
}
// Special Three
if (specialThreeCertificateBox.Checked)
{
specialThree.CertificateId = Convert.ToInt32(specialThreeCertificateList.SelectedValue);
specialThree.SetCategoryIdNull();
}
else if (specialThreeCategoryBox.Checked)
{
specialThree.CategoryId = Convert.ToInt32(specialThreeCategoryList.SelectedValue);
specialThree.SetCertificateIdNull();
}
else
{
specialThree.SetCertificateIdNull();
specialThree.SetCategoryIdNull();
}
if (specialThreeNew)
{
specialTable.AddStationSpecialRow(specialThree);
}
else
{
specialTable.ImportRow(specialThree);
}
// Special Four
if (specialFourCertificateBox.Checked)
{
specialFour.CertificateId = Convert.ToInt32(specialFourCertificateList.SelectedValue);
specialFour.SetCategoryIdNull();
}
else if (specialFourCategoryBox.Checked)
{
specialFour.CategoryId = Convert.ToInt32(specialFourCategoryList.SelectedValue);
specialFour.SetCertificateIdNull();
}
else
{
specialFour.SetCertificateIdNull();
specialFour.SetCategoryIdNull();
}
if (specialFourNew)
{
specialTable.AddStationSpecialRow(specialFour);
}
else
{
specialTable.ImportRow(specialFour);
}
specialAdapter.Update(specialTable);
InfoMessage = "Specials updated";
Response.Redirect("~/admin/Default.aspx");
}
}
