public LeadInLeadOutViewModel()
{
CarriageType = new[] { "Regular", "NPR Newscasts" }.ToSelectListItems();
ProgramEnabledList = new[] { "Yes", "No", "Both" }.ToSelectListItems();
//ProgramList = new[] { "abc", "abc", "abc" }.ToSelectListItems();
ProgramList = CRCDataAccess.GetProgramLookup_ED("Yes").ToSelectListItems("ProgramID", "ProgramName").OrderBy(li => li.Text).AddBlankFirstItem();;
MonthsFromList = CRCDataAccess.GetMonthsList().ToSelectListItems("MonthNumber", "MonthName").SetSelected(DateTime.UtcNow.Month);
YearsFromList = CRCDataAccess.GetScheduleYearsList(2).ToSelectListItems().SetSelected(DateTime.UtcNow.Year);
MonthsToList = CRCDataAccess.GetMonthsList().ToSelectListItems("MonthNumber", "MonthName").SetSelected(DateTime.UtcNow.Month);
YearsToList = CRCDataAccess.GetScheduleYearsList(2).ToSelectListItems().SetSelected(DateTime.UtcNow.Year);
ReportFormatList = new[] { "Excel", "CSV", "PDF" }.ToSelectListItems();
//BandList = new[] { "Terrestrial", "Terrestrial & HD Multicast", "HD Multicast", "HD All" }.ToSelectListItems();
GetBandList();
StationEnabledList = new[] { "Yes", "No", "Both" }.ToSelectListItems();
MemberStatusList = CRCDataAccess.GetMemberStatusEnabled().ToSelectListItems().OrderBy(li => li.Text).AddBlankFirstItem();
StationList = CRCDataAccess.GetStationsList().ToSelectListItems("StationId", "DisplayName").OrderBy(li => li.Text).AddBlankFirstItem();
StationStateList = CRCDataAccess.GetStates().ToSelectListItems("StateId", "Abbreviation").OrderBy(li => li.Text).AddBlankFirstItem();
StationCityList = CRCDataAccess.GetCities().ToSelectListItems("City", "City").OrderBy(li => li.Text).AddBlankFirstItem();
DaysList = new[] { "Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat" }.ToSelectListItems();
StartTimeList = new[] {
"12:00 AM", "12:15 AM", "12:30 AM", "12:45 AM", "1:00 AM", "1:15 AM", "1:30 AM", "1:45 AM", "2:00 AM", "2:15 AM", "2:30 AM", "2:45 AM", "3:00 AM", "3:15 AM", "3:30 AM", "3:45 AM", "4:00 AM", "4:15 AM", "4:30 AM", "4:45 AM", "5:00 AM", "5:15 AM", "5:30 AM", "5:45 AM", "6:00 AM", "6:15 AM", "6:30 AM", "6:45 AM", "7:00 AM", "7:15 AM", "7:30 AM", "7:45 AM", "8:00 AM", "8:15 AM", "8:30 AM", "8:45 AM", "9:00 AM", "9:15 AM", "9:30 AM", "9:45 AM", "10:00 AM", "10:15 AM", "10:30 AM", "10:45 AM", "11:00 AM", "11:15 AM", "11:30 AM", "11:45 AM", "12:00 PM", "12:15 PM", "12:30 PM", "12:45 PM", "1:00 PM", "1:15 PM", "1:30 PM", "1:45 PM", "2:00 PM", "2:15 PM", "2:30 PM", "2:45 PM", "3:00 PM", "3:15 PM", "3:30 PM", "3:45 PM", "4:00 PM", "4:15 PM", "4:30 PM", "4:45 PM", "5:00 PM", "5:15 PM", "5:30 PM", "5:45 PM", "6:00 PM", "6:15 PM", "6:30 PM", "6:45 PM", "7:00 PM", "7:15 PM", "7:30 PM", "7:45 PM", "8:00 PM", "8:15 PM", "8:30 PM", "8:45 PM", "9:00 PM", "9:15 PM", "9:30 PM", "9:45 PM", "10:00 PM", "10:15 PM", "10:30 PM", "10:45 PM", "11:00 PM", "11:15 PM", "11:30 PM", "11:45 PM"
}.ToSelectListItems();
EndTimeList = new[] {
"12:15 AM", "12:30 AM", "12:45 AM", "1:00 AM", "1:15 AM", "1:30 AM", "1:45 AM", "2:00 AM", "2:15 AM", "2:30 AM", "2:45 AM", "3:00 AM", "3:15 AM", "3:30 AM", "3:45 AM", "4:00 AM", "4:15 AM", "4:30 AM", "4:45 AM", "5:00 AM", "5:15 AM", "5:30 AM", "5:45 AM", "6:00 AM", "6:15 AM", "6:30 AM", "6:45 AM", "7:00 AM", "7:15 AM", "7:30 AM", "7:45 AM", "8:00 AM", "8:15 AM", "8:30 AM", "8:45 AM", "9:00 AM", "9:15 AM", "9:30 AM", "9:45 AM", "10:00 AM", "10:15 AM", "10:30 AM", "10:45 AM", "11:00 AM", "11:15 AM", "11:30 AM", "11:45 AM", "12:00 PM", "12:15 PM", "12:30 PM", "12:45 PM", "1:00 PM", "1:15 PM", "1:30 PM", "1:45 PM", "2:00 PM", "2:15 PM", "2:30 PM", "2:45 PM", "3:00 PM", "3:15 PM", "3:30 PM", "3:45 PM", "4:00 PM", "4:15 PM", "4:30 PM", "4:45 PM", "5:00 PM", "5:15 PM", "5:30 PM", "5:45 PM", "6:00 PM", "6:15 PM", "6:30 PM", "6:45 PM", "7:00 PM", "7:15 PM", "7:30 PM", "7:45 PM", "8:00 PM", "8:15 PM", "8:30 PM", "8:45 PM", "9:00 PM", "9:15 PM", "9:30 PM", "9:45 PM", "10:00 PM", "10:15 PM", "10:30 PM", "10:45 PM", "11:00 PM", "11:15 PM", "11:30 PM", "11:45 PM", "Midnight"
}.ToSelectListItems();
}
public RawDataViewModel()
{
DurationList = new[] { "18 hours", "24 hours", "Custom" }.ToSelectListItems();
GetStartHoursList("StartHours");
GetStartHoursList("EndingHours");
GetMonthList();
YearList = CRCDataAccess.GetScheduleYearsList(2).ToSelectListItems().SetSelected(DateTime.UtcNow.Year);
StationStatusList = new[] { "Flagship and Non-100%(Partial) Repeater", "100% Repeater", "All Statuses" }.ToSelectListItems();
GetStationStatusList();
GetMemberStatusList();
//StationList = CRCDataAccess.GetStationsList().ToSelectListItems().OrderBy(li => li.Text).AddBlankFirstItem();
StationList = CRCDataAccess.GetStationsList().ToSelectListItems().AddBlankFirstItem();
//FormatTypeList = new[] { "Excel", "CSV", "PDF" }.ToSelectListItems();
FormatTypeList = new[] { "Excel", "CSV" }.ToSelectListItems();
GetBandList();
}
public ParticipatingStationViewModel()
{
CurrentSeasonList = new[] { "Winter", "Spring", "Summer", "Fall" }.ToSelectListItems();
CurrentYearList = CRCDataAccess.GetScheduleYearsList(2).ToSelectListItems().SetSelected(DateTime.UtcNow.Year);
PastSeasonList = new[] { "Winter", "Spring", "Summer", "Fall" }.ToSelectListItems();
PastYearList = CRCDataAccess.GetScheduleYearsList(2).ToSelectListItems().SetSelected(DateTime.UtcNow.Year);
GetBandList();
FormatList = new[] { "EXCEL", "PDF", "CSV" }.ToSelectListItems();
}
public GridDataViewModel()
{
StationTypeList = GetStationTypeList();
StationEnabledList = new[] { "Yes", "No", "Both" }.ToSelectListItems();
RepeaterStatusList = GetRepeaterList();
ProgramTypeList = GetProgramTypeList();
MonthsList = GetMonthList();
YearsList = CRCDataAccess.GetScheduleYearsList(2).ToSelectListItems().SetSelected(DateTime.UtcNow.Year);
FormatList = new[] { "CSV", "Txt" }.ToSelectListItems();
}
public CarriageWorkbookViewModel()
{
GetCarriageTypeList();
GetSeasonList();
YearsList = CRCDataAccess.GetScheduleYearsList(2).ToSelectListItems().SetSelected(DateTime.UtcNow.Year);
GetBandList();
GetStationEnabledList();
GetMemberStatusList();
FormatList = new[] { "Excel" }.ToSelectListItems();
}
public ProgramLineUpViewModel()
{
//ProgramSearch = new ProgramSearch();
ProgramList = CRCDataAccess.GetProgramLookup().ToSelectListItems("ProgramID", "ProgramName").OrderBy(li => li.Text).AddBlankFirstItem();;
GetSeasonList();
YearList = CRCDataAccess.GetScheduleYearsList(2).ToSelectListItems().SetSelected(DateTime.UtcNow.Year);
GetBandList();
MemberStatusList = CRCDataAccess.GetMemberStatuses().ToSelectListItems().AddBlankFirstItem();
GetStationEnabledList();
FormatList = new[] { "Excel", "CSV", "PDF" }.ToSelectListItems();
}
public CarriageListByStationViewModel()
{
CarriageType = new[] { "Regular", "NPR Newscasts" }.ToSelectListItems();
StationStatusList = new[] { "Yes", "No", "Both" }.ToSelectListItems();
StationList = CRCDataAccess.GetStationAllList().ToSelectListItems();
MonthsFromList = CRCDataAccess.GetMonthsList().ToSelectListItems("MonthNumber", "MonthName").SetSelected(DateTime.UtcNow.Month);
YearsFromList = CRCDataAccess.GetScheduleYearsList(2).ToSelectListItems().SetSelected(DateTime.UtcNow.Year);
MonthsToList = CRCDataAccess.GetMonthsList().ToSelectListItems("MonthNumber", "MonthName").SetSelected(DateTime.UtcNow.Month);
YearsToList = CRCDataAccess.GetScheduleYearsList(2).ToSelectListItems().SetSelected(DateTime.UtcNow.Year);
FormatList = new[] { "EXCEL", "PDF", "CSV" }.ToSelectListItems();
//BandList = new[] {"Terrestrial", "Terrestrial & HD Multicast","HD Multicast" ,"HD All" }.ToSelectListItems();
GetBandList();
MemberStatusList = CRCDataAccess.GetMemberStatusEnabled().ToSelectListItems().OrderBy(li => li.Text).AddBlankFirstItem();
}
public AddDropProgramViewModel()
{
//StationTypeList = new[] {"Terrestrial","HD Multicast","HD All","All Terrestrial & HD"}.ToSelectListItems();
GetStationTypeList();
StationStatusList = new[] { "Enabled", "Disabled", "Both" }.ToSelectListItems();
//RepeaterStatusList= new[] {"Flagship and Non-100% (Partial) Repeater","100% Repeater","All"}.ToSelectListItems();
GeRepeaterList();
//ProgramList = CRCDataAccess.GetEnabledProgram().ToSelectListItems().OrderBy(li => li.Text).AddBlankFirstItem();
ProgramList = CRCDataAccess.GetProgramLookup().ToSelectListItems("ProgramID", "ProgramName").OrderBy(li => li.Text).AddBlankFirstItem();;
FromMonthList = new[] { "Winter", "Spring", "Summer", "Fall" }.ToSelectListItems();
FromYearList = CRCDataAccess.GetScheduleYearsList(2).ToSelectListItems().SetSelected(DateTime.UtcNow.Year);
ToMonthList = new[] { "Winter", "Spring", "Summer", "Fall" }.ToSelectListItems();
ToYearList = CRCDataAccess.GetScheduleYearsList(2).ToSelectListItems().SetSelected(DateTime.UtcNow.Year);
FormatList = new[] { "Excel", "PDF", "CSV" }.ToSelectListItems();
}
public CarriageListByProgramViewModel()
{
CarriageType = new[] { "Regular", "NPR Newscasts" }.ToSelectListItems();
ProgramEnabledList = new[] { "Yes", "No", "Both" }.ToSelectListItems();
//ProgramList = new[] { "abc", "abc", "abc" }.ToSelectListItems();
ProgramList = CRCDataAccess.GetProgramLookup().ToSelectListItems("ProgramID", "ProgramName").OrderBy(li => li.Text).AddBlankFirstItem();;
MonthsFromList = CRCDataAccess.GetMonthsList().ToSelectListItems("MonthNumber", "MonthName").SetSelected(DateTime.UtcNow.Month);
YearsFromList = CRCDataAccess.GetScheduleYearsList(2).ToSelectListItems().SetSelected(DateTime.UtcNow.Year);
MonthsToList = CRCDataAccess.GetMonthsList().ToSelectListItems("MonthNumber", "MonthName").SetSelected(DateTime.UtcNow.Month);
YearsToList = CRCDataAccess.GetScheduleYearsList(2).ToSelectListItems().SetSelected(DateTime.UtcNow.Year);
ReportFormatList = new[] { "Excel", "CSV", "PDF" }.ToSelectListItems();
//BandList = new[] { "Terrestrial", "Terrestrial & HD Multicast", "HD Multicast", "HD All" }.ToSelectListItems();
GetBandList();
StationEnabledList = new[] { "Yes", "No", "Both" }.ToSelectListItems();
MemberStatusList = CRCDataAccess.GetMemberStatusEnabled().ToSelectListItems().OrderBy(li => li.Text).AddBlankFirstItem();
StationList = CRCDataAccess.GetStationsList().ToSelectListItems("StationId", "DisplayName").OrderBy(li => li.Text).AddBlankFirstItem();
StationStateList = CRCDataAccess.GetStates().ToSelectListItems("StateId", "Abbreviation").OrderBy(li => li.Text).AddBlankFirstItem();
StationCityList = CRCDataAccess.GetCities().ToSelectListItems("City", "City").OrderBy(li => li.Text).AddBlankFirstItem();
}
public ProgrammingSchedulesViewModel(long userId)
{
StationList = CRCDataAccess.GetStationsActiveList(userId).ToSelectListItems().OrderBy(li => li.Text).AddBlankFirstItem();
MonthsList = CRCDataAccess.GetMonthsList().ToSelectListItems("MonthNumber", "MonthName").SetSelected(DateTime.UtcNow.Month);
YearsList = CRCDataAccess.GetScheduleYearsList(2).ToSelectListItems().SetSelected(DateTime.UtcNow.Year);
}
public ManageSchedulesViewModel()
{
MonthsList = CRCDataAccess.GetMonthsList().ToSelectListItems("MonthNumber", "MonthName").SetSelected(DateTime.UtcNow.Month);
YearsList = CRCDataAccess.GetScheduleYearsList(2).ToSelectListItems().SetSelected(DateTime.UtcNow.Year);
StatusList = new[] { "All", "Unsubmitted", "Unaccepted", "Accepted" }.ToSelectListItems();
}