private void GetStations() { using (var freeWheelEntities = new DB.FreeWheelEntities()) { stationList = (from s in freeWheelEntities.STATION select s).ToList(); } }
private void GetAllCells() { using (var freeWheelEntities = new DB.FreeWheelEntities()) { cellsList = (from c in freeWheelEntities.CELLS select c.CELL_ID).ToList(); } }
private void GetAllMarkets() { using (var freeWheelEntities = new DB.FreeWheelEntities()) { marketList = (from m in freeWheelEntities.MARKET select m.MARKET_ID).ToList(); } }
private void FetchData() { using (var freeWheelEntities = new DB.FreeWheelEntities()) { pgmNameList = (from p in freeWheelEntities.PROGRAM select p.PROGRAM_NAME).ToList(); } }
private void GetAllMarketPops() { using (var freeWheelEntities = new DB.FreeWheelEntities()) { marketPopList = (from m in freeWheelEntities.MARKET_POP select new MarketPop { MarketId = m.MARKET_ID, CellsId = m.CELL_ID }).ToList(); } }
private void InsertMissingItems(List <DB.MARKET_POP> missingItems) { Console.WriteLine($"Total # of missing records in MARKET_POP table: {missingItems.Count}"); Console.WriteLine("Press <ENTER> to insert missing data into MARKET_POP table, or press any other ket to exit"); if (Console.ReadKey().Key == ConsoleKey.Enter) { Console.WriteLine("Inserting data..."); using (var freeWheelEntities = new DB.FreeWheelEntities()) { freeWheelEntities.MARKET_POP.AddRange(missingItems); freeWheelEntities.SaveChanges(); } Console.WriteLine("Data insert completed. Press any key to exit."); } }
private void DisplayProgram(int stationId) { if (stationId <= stationList.Count) { var stationName = stationList[stationId - 1].STATION_NAME; using (var freeWheelEntities = new DB.FreeWheelEntities()) { var programDetails = (from p in freeWheelEntities.PROGRAM join s in freeWheelEntities.STATION on p.STATION_ID equals s.STATION_ID where s.STATION_NAME.Equals(stationName) select new { s.STATION_NAME, p.PROGRAM_NAME, p.FLIGHT_DATE }) .GroupBy(g => g.FLIGHT_DATE).OrderByDescending(g => g.Key).ToList(); if (programDetails != null && programDetails.Count > 0) { var programList = programDetails[0].ToList(); programList.Sort((a, b) => a.PROGRAM_NAME.CompareTo(b.PROGRAM_NAME)); Console.WriteLine("Program Details"); Console.WriteLine("```````````````"); Console.WriteLine($"{programList[0].STATION_NAME} || {programList[0].PROGRAM_NAME} || {programList[0].FLIGHT_DATE.Value.ToString("MMM dd, yyyy")}"); } else { Console.WriteLine("Sorry, no programs found for the requested station"); } } } else { Console.WriteLine($"Sorry, requested station# {stationId} is not available!"); } }