public ActionResult MemberStatusGridData(GridSettings gridSettings) { using (var dataTable = CRCDataAccess.GetMemberStatuses()) { return(InfJqGridData(dataTable, gridSettings)); } }
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 AddEditStationViewModel() { CopyInd = "N"; BandList = CRCDataAccess.GetBands().ToSelectListItems().OrderBy(li => li.Text).AddBlankFirstItem(); RepeaterStatusList = CRCDataAccess.GetRepeaterStatuses().ToSelectListItems().OrderBy(li => li.Text).AddBlankFirstItem(); FlagshipStationList = CRCDataAccess.GetFlagshipStationsList().ToSelectListItems().OrderBy(li => li.Text).AddBlankFirstItem(); MemberStatusList = CRCDataAccess.GetMemberStatuses().ToSelectListItems().OrderBy(li => li.Text).AddBlankFirstItem(); MinorityStatusList = CRCDataAccess.GetMinorityStatuses().ToSelectListItems().OrderBy(li => li.Text).AddBlankFirstItem(); LicenseeTypeList = CRCDataAccess.GetDropDownLicenseeTypes().ToSelectListItems().OrderBy(li => li.Text).AddBlankFirstItem(); MetroMarketList = CRCDataAccess.GetMetroMarkets().ToSelectListItems().OrderBy(li => li.Text).AddBlankFirstItem(); DMAMarketList = CRCDataAccess.GetDMAMarkets().ToSelectListItems().OrderBy(li => li.Text).AddBlankFirstItem(); TimeZoneList = CRCDataAccess.GetTimeZones().ToSelectListItems().AddBlankFirstItem(); AffiliateList = CRCDataAccess.GetAffiliates().ToSelectListItems().OrderBy(li => li.Text); }
public SearchStationsViewModel() { StationList = CRCDataAccess.GetStationsList().ToSelectListItems().OrderBy(li => li.Text).AddBlankFirstItem(); RepeaterStatusList = CRCDataAccess.GetRepeaterStatuses().ToSelectListItems().OrderBy(li => li.Text).AddBlankFirstItem(); MetroMarketList = CRCDataAccess.GetMetroMarkets().ToSelectListItems().OrderBy(li => li.Text).AddBlankFirstItem(); DMAMarketList = CRCDataAccess.GetDMAMarkets().ToSelectListItems().OrderBy(li => li.Text).AddBlankFirstItem(); MemberStatusList = CRCDataAccess.GetMemberStatuses().ToSelectListItems().OrderBy(li => li.Text).AddBlankFirstItem(); GetBandList(); //BandList = CRCDataAccess.GetBands().ToSelectListItems().OrderBy(li => li.Text).AddBlankFirstItem(); StateList = CRCDataAccess.GetStates().ToSelectListItems("StateId", "Abbreviation").OrderBy(li => li.Text).AddBlankFirstItem(); LicenseeTypeList = CRCDataAccess.GetDropDownLicenseeTypes().ToSelectListItems().OrderBy(li => li.Text).AddBlankFirstItem(); AffiliateList = CRCDataAccess.GetAffiliates().ToSelectListItems().OrderBy(li => li.Text).AddBlankFirstItem(); EnabledList = new[] { "Yes", "No", "Both" }.ToSelectListItems(); }