public Station GetStationInfoWithMatrix(StationOptions stationOptions)
{
try
{
Station station = new Station(stationOptions);
return station;
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(new Exception(string.Format("An error occurred while trying to load info for StationId: {0}", stationOptions.stationId), ex));
throw new Exception("An error occurred while trying to load the Station info.");
}
}
/// <summary>TBD</summary>
public void GetReportData()
{
DataSet reportData;
using (IO io = new IO(WebCommon.DigitalAvailsConnectionString))
{
reportData = io.ExecuteDataSetQuery(IO.CreateCommandFromStoredProc("DigitalAvails_GetSpotMatrixForMarket",
Param.CreateParam("MARKET", SqlDbType.VarChar, this.Market),
Param.CreateParam("STARTMONTH", SqlDbType.Int, this.StartMonth),
Param.CreateParam("STARTYEAR", SqlDbType.Int, this.StartYear),
Param.CreateParam("NUMBEROFMONTHS", SqlDbType.Int, this.NumberOfMonths)));
}
//}
//Load all the spots for the market
//this.MarketSpotMatrix = Spot.LoadSpotMatrix(reportData.Tables[2]);
this.MarketSpotMatrix = Spot.LoadSpotMatrix(reportData.Tables[2]);
//Load all the spot type breakdowns for the market
//this.MarketSpotTypeBreakdown = SpotTypeBreakdown.LoadSpotTypeBreakdown(reportData.Tables[3]);
this.MarketSpotTypeBreakdown = SpotTypeBreakdown.LoadSpotTypeBreakdown(reportData.Tables[3]);
//Load all the station spots for the market
//this.MarketStationSpots = StationSpot.LoadStationSpots(reportData.Tables[1]);
this.MarketStationSpots = StationSpot.LoadStationSpots(reportData.Tables[1]);
//Load the stations
this.MarketStations = new List<Station>();
Station station;
int stationId;
foreach (DataRow stationRow in reportData.Tables[0].Rows)
{
stationId = (int)stationRow["StationId"];
station = new Station();
station.LoadStationData(stationRow);
station.SpotMatrix = this.MarketSpotMatrix.Where(m => m.StationId == stationId).ToList();
station.SpotTypeBreakdown = this.MarketSpotTypeBreakdown.Where(b => b.StationId == stationId).OrderBy(b => b.BreakdownOrder).ToList();
station.StationSpots = this.MarketStationSpots.Where(s => s.StationId == stationId).OrderBy(s => s.Order).ToList();
this.MarketStations.Add(station);
}
//Sort the station list
this.MarketStations = this.MarketStations.OrderBy(s => s.Name).ToList();
//Retrieve the Spot Types for this market
this.MarketSpotTypes = SpotType.GetSpotTypesByMarket(this.Market);
}