protected void Page_Load(object sender, EventArgs e)
{
stationRepeater.ItemDataBound += new RepeaterItemEventHandler(stationRepeater_ItemDataBound);
if (!Page.IsPostBack)
{
StationTableAdapter stationAdapter = new StationTableAdapter();
DollarSaverDB.StationDataTable stations = stationAdapter.GetActive();
DollarSaverDB.StationDataTable activeSiteStations = new DollarSaverDB.StationDataTable();
foreach (DollarSaverDB.StationRow station in stations)
{
if (station.StationId != 1 && station.IsSiteActive)
{
activeSiteStations.ImportRow(station);
}
}
stationRepeater.DataSource = activeSiteStations.Rows;
stationRepeater.DataBind();
endYearLabel.Text = DateTime.Now.ToString("yyyy");
}
}
private void BindData()
{
timerBottomLabel.Text = now.ToString("MM/dd/yyyy hh:mm:ss tt");
bool inactive = Globals.ConvertToBool(Request.QueryString["inactive"]);
DollarSaverDB.StationDataTable stations;
if (inactive)
{
mainTimer.Enabled = false;
activeLinkHolder.Visible = true;
inactiveLinkHolder.Visible = false;
headerCell.Attributes["class"] = "inactive_header";
headerCell.InnerText = "Inactive Stations";
recentOrderHolder.Visible = false;
StationTableAdapter stationAdapter = new StationTableAdapter();
stations = stationAdapter.GetInactive();
}
else
{
activeLinkHolder.Visible = false;
inactiveLinkHolder.Visible = true;
StationTableAdapter stationAdapter = new StationTableAdapter();
stations = stationAdapter.GetActive();
recentOrderHolder.Visible = true;
OrderTableAdapter orderAdapter = new OrderTableAdapter();
DollarSaverDB.OrderDataTable recentOrders = orderAdapter.GetSuperRecent(15);
recentOrderGrid.DataSource = recentOrders.Rows;
recentOrderGrid.DataBind();
}
if (stations.Count > 0)
{
stationHolder.Visible = true;
noStationsHolder.Visible = false;
stationGrid.DataSource = stations.Rows;
stationGrid.DataBind();
}
else
{
stationHolder.Visible = false;
noStationsHolder.Visible = true;
}
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
orderGrid.RowCommand += new GridViewCommandEventHandler(orderGrid_RowCommand);
//orderGrid.PageIndexChanging += new GridViewPageEventHandler(orderGrid_PageIndexChanging);
searchButton.Click += new EventHandler(searchButton_Click);
if (!Page.IsPostBack)
{
StationTableAdapter stationAdapter = new StationTableAdapter();
DollarSaverDB.StationDataTable stations = stationAdapter.GetActive();
stationList.DataSource = stations.Rows;
stationList.DataTextField = "ShortName";
stationList.DataValueField = "Stationid";
stationList.DataBind();
stationList.Items.Insert(0, new ListItem("-- All Stations --", "0"));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Request.RawUrl.StartsWith("/dollarsaver/index"))
{
//Response.Redirect("~/Default.aspx?station_id=" + StationId);
DollarSaverRedirect("~/Default.aspx");
}
DateTime currentDate = DateTime.Now;
currentDate = new DateTime(currentDate.Year, currentDate.Month, currentDate.Day);
StationTableAdapter stationAdapter = new StationTableAdapter();
DollarSaverDB.StationRow station = stationAdapter.GetStation(StationId)[0];
siteType = (SiteType)station.SiteTypeId;
CertificateTableAdapter certificateAdapter = new CertificateTableAdapter();
//stationNameLabel.Text = station.Name;
if (!station.IsContent1Null())
{
content1Label.Text = station.Content1;
}
if (!station.IsContent2Null())
{
content2Label.Text = station.Content2;
}
String ImageDir = Request.PhysicalApplicationPath + station.ImageDirUrl;
if (station.StationSiteType == SiteType.Standard)
{
standardHolder.Visible = true;
dealHolder.Visible = false;
signUpTopLink.NavigateUrl = GetUrl(signUpTopLink.NavigateUrl);
SpecialSettingsTableAdapter specialSettingsAdapter = new SpecialSettingsTableAdapter();
DollarSaverDB.SpecialSettingsDataTable specialSettingsTable = specialSettingsAdapter.GetSpecialSettings(StationId);
bool dailyHeader = false;
if (specialSettingsTable.Count == 1)
{
dailyHeader = specialSettingsTable[0].DailyHeader;
}
Image dailyWeeklyImage = new Image();
if (dailyHeader)
{
//dailyWeeklyImage.SkinID = "dailyImage";
if (!station.Content.IsDailyDealImageNull() && File.Exists(ImageDir + station.Content.DailyDealImage))
{
dailyWeeklyImage.ImageUrl = station.ImageDirUrl + station.Content.DailyDealImage;
}
else
{
dailyWeeklyImage.ImageUrl = "~/images/boxtop_daily.gif";
}
}
else
{
//dailyWeeklyImage.SkinID = "weeklyImage";
if (!station.Content.IsWeeklyDealImageNull() && File.Exists(ImageDir + station.Content.WeeklyDealImage))
{
dailyWeeklyImage.ImageUrl = station.ImageDirUrl + station.Content.WeeklyDealImage;
}
else
{
dailyWeeklyImage.ImageUrl = "~/images/boxtop_weekly.gif";
}
}
dailyWeeklyImageHolder.Controls.Add(dailyWeeklyImage);
DollarSaverDB.CertificateDataTable daily = certificateAdapter.GetSpecial(StationId, 1);
if (daily.Count == 1)
{
SpecialCert1.DisplayCertificate = daily[0];
if (HitCounterEnabled)
{
LogHit(currentDate, daily[0].CertificateId, PageHitType.HomePage);
}
}
DollarSaverDB.CertificateDataTable cert2 = certificateAdapter.GetSpecial(StationId, 2);
if (cert2.Count == 1)
{
SpecialCert2.DisplayCertificate = cert2[0];
if (HitCounterEnabled)
{
LogHit(currentDate, cert2[0].CertificateId, PageHitType.HomePage);
}
}
DollarSaverDB.CertificateDataTable cert3 = certificateAdapter.GetSpecial(StationId, 3);
if (cert3.Count == 1)
{
SpecialCert3.DisplayCertificate = cert3[0];
if (HitCounterEnabled)
{
LogHit(currentDate, cert3[0].CertificateId, PageHitType.HomePage);
}
}
DollarSaverDB.CertificateDataTable cert4 = certificateAdapter.GetSpecial(StationId, 4);
if (cert4.Count == 1)
{
SpecialCert4.DisplayCertificate = cert4[0];
if (HitCounterEnabled)
{
LogHit(currentDate, cert4[0].CertificateId, PageHitType.HomePage);
}
}
if (!station.Content.IsOtherDealsImageNull() && File.Exists(ImageDir + station.Content.OtherDealsImage))
{
otherDealsImage.ImageUrl = station.ImageDirUrl + station.Content.OtherDealsImage;
}
if (!station.Content.IsLogoImageNull() && File.Exists(ImageDir + station.Content.LogoImage))
{
logoImage.ImageUrl = station.ImageDirUrl + station.Content.LogoImage;
}
}
else // Deal of the Week
{
standardHolder.Visible = false;
dealHolder.Visible = true;
if (!Station.IsSiteNameNull() && Station.SiteName != String.Empty)
{
dotwStationNameLabel.Text = Regex.Replace(Station.SiteName, "<[^>]+>", "");
}
else
{
dotwStationNameLabel.Text = "DollarSaver Deal of the Week";
}
if (!Station.Content.IsDotwSubheaderImageNull() && File.Exists(ImageDir + station.Content.DotwSubheaderImage))
{
subheaderCell.Style["background-image"] = "url(" + station.ImageDirUrl + station.Content.DotwSubheaderImage + ")";
}
else
{
subheaderCell.Style["background-image"] = "url(" + ResolveUrl("~/images/dotw_background.gif") + ")";
}
DollarSaverDB.CertificateDataTable certificateTable = certificateAdapter.GetCurrentDeal(StationId);
if (certificateTable.Count == 1)
{
dealOfTheWeek.Deal = certificateTable[0];
if (HitCounterEnabled)
{
LogHit(currentDate, certificateTable[0].CertificateId, PageHitType.HomePage);
}
}
}
}
}
void loginButton_Click(object sender, EventArgs e)
{
String username = usernameBox.Text.Trim();
String password = passwordBox.Text;
//int stationId = Int32.Parse(stationList.SelectedValue);
StationTableAdapter stationAdapter = new StationTableAdapter();
String stationCode = stationCodeBox.Text.Trim().ToUpper();
int stationId = 0;
if (stationCode != String.Empty)
{
DollarSaverDB.StationDataTable stationLookup = stationAdapter.GetByCode(stationCode);
if (stationLookup.Count != 1 || !stationLookup[0].IsActive)
{
errorMessage = "Incorrect username, password or station";
return;
}
stationId = stationLookup[0].StationId;
}
AdminTableAdapter adminAdapter = new AdminTableAdapter();
if ((int)adminAdapter.Authenticate(stationId, username, password) == 1)
{
DollarSaverDB.AdminRow user = adminAdapter.GetByUsername(stationId, username)[0];
user.LastAccessDate = DateTime.Now;
adminAdapter.Update(user);
int userStationId;
if (user.Role == AdminRole.Root)
{
userStationId = 0;
}
else
{
userStationId = stationId;
}
Session["admin_station_id"] = userStationId;
HttpCookie cookie = Request.Cookies.Get(ADMIN_COOKIE_NAME);
if (cookie == null)
{
cookie = new HttpCookie(ADMIN_COOKIE_NAME);
}
cookie.Expires = DateTime.Now.AddYears(10);
if (IsDev)
{
cookie.Domain = EnvDomain;
}
else
{
cookie.Domain = ".dollarsavershow.com";
}
cookie["station_id"] = userStationId.ToString();
cookie["station_code"] = stationCode;
HttpContext.Current.Response.Cookies.Add(cookie);
FormsAuthentication.SetAuthCookie(user.AdminId.ToString(), true);
if (user.Role == AdminRole.Root)
{
if (stationId == 0)
{
Response.Redirect("~/admin/super/", false);
}
else
{
Response.Redirect("~/admin/Default.aspx?station_id=" + stationId, false);
}
}
else
{
Response.Redirect("~/admin/", false);
}
}
else
{
errorMessage = "Incorrect username, password or station";
}
}
private void parameterRepeater_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
DollarSaverDB.ParameterRow parameter = (DollarSaverDB.ParameterRow)e.Item.DataItem;
HiddenField paramIdHidden = (HiddenField)e.Item.FindControl("paramIdHidden");
paramIdHidden.Value = parameter.ParameterId.ToString();
Label paramNameLabel = (Label)e.Item.FindControl("paramNameLabel");
paramNameLabel.Text = parameter.Name;
Label paramTypeLabel = (Label)e.Item.FindControl("paramTypeLabel");
//paramTypeLabel.Text = parameter.ParameterType.Name;
PlaceHolder validatorHolder = (PlaceHolder)e.Item.FindControl("validatorHolder");
RegularExpressionValidator rev;
RequiredFieldValidator rfv;
paramNameLabel.Text = parameter.Name;
HiddenField paramValueHidden = (HiddenField)e.Item.FindControl("paramValueHidden");
Label paramValueLabel = (Label)e.Item.FindControl("paramValueLabel");
TextBox paramValueBox = (TextBox)e.Item.FindControl("paramValueBox");
CheckBox paramCheckBox = (CheckBox)e.Item.FindControl("paramCheckBox");
ListBox paramList = (ListBox)e.Item.FindControl("paramList");
PlaceHolder timeHolder = (PlaceHolder)e.Item.FindControl("timeHolder");
DropDownList hourList = (DropDownList)e.Item.FindControl("hourList");
DropDownList minuteList = (DropDownList)e.Item.FindControl("minuteList");
switch (parameter.ParameterTypeId)
{
case 1:
// bit
paramValueLabel.Visible = false;
paramValueBox.Visible = false;
paramCheckBox.Visible = true;
paramList.Visible = false;
timeHolder.Visible = false;
paramCheckBox.Checked = true;
if (parameter.Description != string.Empty)
{
paramTypeLabel.Text = " " + parameter.Description;
}
break;
case 2:
// date
paramValueLabel.Visible = false;
paramValueBox.Visible = true;
paramCheckBox.Visible = false;
paramList.Visible = false;
timeHolder.Visible = false;
paramValueBox.Columns = 10;
paramValueBox.MaxLength = 12;
// default value hacking..
if (parameter.Name.ToUpper().Trim() == "START DATE")
{
DateTime startDate = DateTime.Now;
startDate = startDate.AddMonths(-1);
startDate = new DateTime(startDate.Year, startDate.Month, 1);
paramValueBox.Text = startDate.ToString("MM/dd/yyyy");
}
else if (parameter.Name.ToUpper().Trim() == "END DATE")
{
DateTime startDate = DateTime.Now;
startDate = startDate.AddMonths(-1);
startDate = new DateTime(startDate.Year, startDate.Month, 1);
DateTime endDate = startDate.AddMonths(1).AddDays(-1);
paramValueBox.Text = endDate.ToString("MM/dd/yyyy");
}
Image calendarImage = (Image)e.Item.FindControl("calendarImage");
calendarImage.Visible = true;
calendarImage.ImageUrl = "~/images/calendar_button.gif";
calendarImage.Attributes["OnClick"] = "showCalendarControl('" + paramValueBox.ClientID + "');";
//paramValueBox.Attributes["onblur"] = "hideCalendarControl();";
rev = GenerateDateREV(paramValueBox);
validatorHolder.Controls.Add(rev);
rfv = GenerateRFV(paramValueBox);
validatorHolder.Controls.Add(rfv);
paramTypeLabel.Text = " (MM/DD/YYYY)";
break;
case 3:
// decimal
paramValueLabel.Visible = false;
paramValueBox.Visible = true;
paramCheckBox.Visible = false;
paramList.Visible = false;
timeHolder.Visible = false;
paramValueBox.Columns = 12;
paramValueBox.MaxLength = 20;
rev = GenerateDecimalREV(paramValueBox);
validatorHolder.Controls.Add(rev);
rfv = GenerateRFV(paramValueBox);
validatorHolder.Controls.Add(rfv);
if (parameter.Description != string.Empty)
{
paramTypeLabel.Text = " " + parameter.Description;
}
break;
case 4:
// int
paramValueLabel.Visible = false;
paramValueBox.Visible = true;
paramCheckBox.Visible = false;
paramList.Visible = false;
timeHolder.Visible = false;
paramValueBox.Columns = 12;
paramValueBox.MaxLength = 20;
rev = GenerateIntREV(paramValueBox);
validatorHolder.Controls.Add(rev);
rfv = GenerateRFV(paramValueBox);
validatorHolder.Controls.Add(rfv);
if (parameter.Description != string.Empty)
{
paramTypeLabel.Text = " " + parameter.Description;
}
break;
case 5:
// varchar
paramValueLabel.Visible = false;
paramValueBox.Visible = true;
paramCheckBox.Visible = false;
paramList.Visible = false;
timeHolder.Visible = false;
paramValueBox.Columns = 20;
paramValueBox.MaxLength = 50;
rfv = GenerateRFV(paramValueBox);
validatorHolder.Controls.Add(rfv);
if (parameter.Description != string.Empty)
{
paramTypeLabel.Text = " " + parameter.Description;
}
break;
case 6:
// Station
paramValueLabel.Visible = false;
paramValueBox.Visible = false;
paramCheckBox.Visible = false;
paramList.Visible = true;
timeHolder.Visible = false;
StationTableAdapter adapter = new StationTableAdapter();
DollarSaverDB.StationDataTable stations = adapter.GetStations();
paramList.DataSource = stations;
paramList.DataTextField = "Name";
paramList.DataValueField = "StationId";
paramList.DataBind();
break;
case 7:
// Char
paramValueLabel.Visible = false;
paramValueBox.Visible = true;
paramCheckBox.Visible = false;
paramList.Visible = false;
timeHolder.Visible = false;
paramValueBox.Columns = 20;
paramValueBox.MaxLength = 50;
rfv = GenerateRFV(paramValueBox);
validatorHolder.Controls.Add(rfv);
if (parameter.Description != string.Empty)
{
paramTypeLabel.Text = " " + parameter.Description;
}
break;
case 8:
// Date and Time
paramValueLabel.Visible = false;
paramValueBox.Visible = true;
paramCheckBox.Visible = false;
paramList.Visible = false;
timeHolder.Visible = true;
for (int i = 0; i < 24; i++)
{
hourList.Items.Add(i.ToString("00"));
}
for (int i = 0; i < 60; i++)
{
minuteList.Items.Add(i.ToString("00"));
}
paramValueBox.Columns = 10;
paramValueBox.MaxLength = 12;
/*
* if(reportToRun.TypeId == 2) { // MAC reports only
* if(parameter.Name.ToUpper().Trim() == "START DATE") {
* DateTime startDate = DateTime.Now;
* while(startDate.DayOfWeek != DayOfWeek.Saturday) {
* startDate = startDate.AddDays(-1);
* }
* paramValueBox.Text = startDate.ToString("MM/dd/yyyy");
* } else if (parameter.Name.ToUpper().Trim() == "END DATE") {
* paramValueBox.Text = DateTime.Now.ToString("MM/dd/yyyy");
* }
* }
* */
Image calendarImage2 = (Image)e.Item.FindControl("calendarImage");
calendarImage2.Visible = true;
calendarImage2.ImageUrl = "~/images/calendar_button.gif";
calendarImage2.Attributes["OnClick"] = "showCalendarControl('" + paramValueBox.ClientID + "');";
//paramValueBox.Attributes["onblur"] = "hideCalendarControl();";
rev = GenerateDateREV(paramValueBox);
validatorHolder.Controls.Add(rev);
rfv = GenerateRFV(paramValueBox);
validatorHolder.Controls.Add(rfv);
paramTypeLabel.Text = " (MM/DD/YYYY HH:MM)";
break;
default:
throw new Exception("ERROR: Unknown Parameter Type");
}
}
}
void saveButton_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
StationTableAdapter stationAdapter = new StationTableAdapter();
String name = nameBox.Text.Trim();
int siteTypeId = Int32.Parse(siteTypeList.SelectedValue);
int stationTypeId = Int32.Parse(stationTypeList.SelectedValue);
String phoneNumber = phoneNumberBox.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();
int timeZoneId = Int32.Parse(timeZoneList.SelectedValue);
//bool affectedByDST = daylightSavingsBox.Checked;
String stationUrl = stationUrlBox.Text.Trim();
String siteName = siteNameBox.Text.Trim();
String content1 = content1Box.Text.Trim();
String content2 = content2Box.Text.Trim();
//bool isActive = isActiveBox.Checked;
if (name == String.Empty)
{
ErrorMessage = "Name is required";
return;
}
if (phoneNumber == String.Empty)
{
ErrorMessage = "Phone Number is required";
return;
}
if (address1 == String.Empty)
{
ErrorMessage = "Address 1 is required";
return;
}
if (city == String.Empty)
{
ErrorMessage = "City is required";
return;
}
if (zipCode == String.Empty)
{
ErrorMessage = "Zip Code is required";
return;
}
if (stationUrl != String.Empty)
{
stationUrl = stationUrlStart.SelectedValue + stationUrl;
// come up with a better validation...
if (!Uri.IsWellFormedUriString(stationUrl, UriKind.Absolute))
{
ErrorMessage = "Please enter a valid Station Website";
return;
}
}
if (stationUrl.Length > 500)
{
stationUrl = stationUrl.Substring(0, 500);
}
/*
* if (content1 == String.Empty) {
* ErrorMessage = "Content 1 is required";
* return;
* }*/
if (content1.Length > 1000)
{
content1 = content1.Substring(0, 1000);
}
/*
* if (content2 == String.Empty) {
* ErrorMessage = "Content 2 is required";
* return;
* }*/
if (content2.Length > 1000)
{
content2 = content2.Substring(0, 1000);
}
siteName = siteName.Replace("<br />", "");
if (siteName.Length > 500)
{
siteName = siteName.Substring(0, 500);
}
String siteNameCheck = Regex.Replace(siteName, "<[^>]+>", "").Replace(" ", "").Trim();
if (siteNameCheck == String.Empty) // only leftover formatting in site name
{
siteName = String.Empty;
}
if (Station != null)
{
Station.Name = name;
Station.SiteTypeId = Int32.Parse(siteTypeList.SelectedValue);
Station.StationTypeId = Int32.Parse(stationTypeList.SelectedValue);
Station.PhoneNumber = phoneNumber;
Station.Address1 = address1;
Station.Address2 = address2;
Station.City = city;
Station.StateCode = stateList.SelectedValue;
Station.ZipCode = zipCode;
Station.TimeZoneId = Int32.Parse(timeZoneList.SelectedValue);
//Station.AffectedByDST = daylightSavingsBox.Checked;
if (stationUrl != String.Empty)
{
Station.StationUrl = stationUrl;
}
else
{
Station.SetStationUrlNull();
}
if (siteName != String.Empty)
{
Station.SiteName = siteName;
}
else
{
Station.SetSiteNameNull();
}
Station.Content1 = content1;
Station.Content2 = content2;
//Station.IsActive = isActiveBox.Checked;
Station.IsSiteActive = isSiteActiveBox.Checked;
stationAdapter.Update(Station);
InfoMessage = "Station Updated";
}
else
{
if (IsSuperAdmin)
{
String code = codeBox.Text.Trim().ToUpper();
if (code == String.Empty)
{
ErrorMessage = "Code is required";
return;
}
if (code.Length < 3 || code.Length > 20)
{
ErrorMessage = "Code must be between 3 and 20 characters";
return;
}
DollarSaverDB.StationDataTable stationCodeLookup = stationAdapter.GetByCode(code);
if (stationCodeLookup.Count == 1 && (Station == null || stationCodeLookup[0].StationId != Station.StationId))
{
InfoMessage = "Code is already in use";
return;
}
int stationId = Convert.ToInt32(stationAdapter.InsertPK(name, code, stationTypeId, siteTypeId, phoneNumber, address1, address2,
city, stateCode, zipCode, timeZoneId, false, DateTime.Now, DateTime.Now, true,
content1, content2, Globals.ConvertToNull(stationUrl), Globals.ConvertToNull(siteName), isSiteActiveBox.Checked, null));
Station = stationAdapter.GetStation(stationId)[0];
CategoryTableAdapter categoryAdapter = new CategoryTableAdapter();
categoryAdapter.Insert(stationId, null, "Restaurants & Food", 1);
categoryAdapter.Insert(stationId, null, "Things To Do", 2);
categoryAdapter.Insert(stationId, null, "Home & Garden", 3);
categoryAdapter.Insert(stationId, null, "Health & Beauty", 4);
categoryAdapter.Insert(stationId, null, "Retail", 5);
categoryAdapter.Insert(stationId, null, "Automotive", 6);
StationContentTableAdapter stationContentTableAdapter = new StationContentTableAdapter();
stationContentTableAdapter.Insert(stationId, null, null, null, null, null, null, null, null, null);
DealSettingsTableAdapter dealSettingsAdapter = new DealSettingsTableAdapter();
dealSettingsAdapter.Insert(stationId, 1, 8, 4, 10);
SpecialSettingsTableAdapter specialSettingAdapter = new SpecialSettingsTableAdapter();
specialSettingAdapter.Insert(stationId, true);
if (!Directory.Exists(Request.PhysicalApplicationPath + Station.StationDirUrl))
{
Directory.CreateDirectory(Request.PhysicalApplicationPath + Station.StationDirUrl);
}
if (!Directory.Exists(Request.PhysicalApplicationPath + Station.ImageDirUrl))
{
Directory.CreateDirectory(Request.PhysicalApplicationPath + Station.ImageDirUrl);
}
}
}
RedirectToHomePage();
}
}
