public ActionResult AffiliatesGridData(GridSettings gridSettings) { using (var dataTable = CRCDataAccess.GetAffiliates()) { return(InfJqGridData(dataTable, gridSettings)); } }
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(); }