internal static string GetSupplyAnalysisExcelData(Dictionary <string, string> parameters, FutureTrendDataType dataType,
int scenarioId, int siteGroup, int fleetGroup, DataType timeZone, bool weeklyGrouping)
{
var toDate = timeZone == DataType.FrozenZone
? FutureTrendDataAccess.SetFrozenZoneToDateLimit(DateTime.Parse(parameters[ParameterNames.ToDate]))
: parameters[ParameterNames.ToDate];
var newParameters = new Dictionary <string, string>
{
{ ParameterNames.Country, parameters[ParameterNames.Country] },
{ ParameterNames.ToDate, toDate },
{ ParameterNames.FromDate, parameters[ParameterNames.FromDate] }
};
if (timeZone == DataType.DailyChanging)
{
//return new FutureTrendRepository().GetSupplyAnalysisCsvData(newParameters, scenarioId, siteGroup, fleetGroup
// , dataType, weeklyGrouping);
using (var dataContext = new MarsDBDataContext(MarsConnection.ConnectionString))
{
var joinedData = timeZone == DataType.DailyChanging
? GenericSizingDataAccess.GetFutureTrendRawData(dataContext, parameters,
scenarioId)
: FutureTrendDataAccess.GetRawFrozenZoneFutureTrendData(dataContext, newParameters,
(byte)scenarioId);
return(GenerateExcelDataFromRaw(dataContext, joinedData, siteGroup, fleetGroup, dataType, weeklyGrouping));
}
}
else
{
using (var dataContext = new MarsDBDataContext(MarsConnection.ConnectionString))
{
var joinedData = FutureTrendDataAccess.GetRawFrozenZoneFutureTrendData(dataContext,
newParameters,
(byte)scenarioId);
return(GenerateExcelDataFromRaw(dataContext, joinedData, siteGroup, fleetGroup, dataType,
weeklyGrouping));
}
}
return(null);
}
internal static string GetFutureTrendExcelData(Dictionary <string, string> parameters, FutureTrendDataType dataType, int scenarioId, int siteGroup, int fleetGroup, DataType timeZone)
{
var toDate = timeZone == DataType.FrozenZone
? SetFrozenZoneToDateLimit(DateTime.Parse(parameters[ParameterNames.ToDate]))
: parameters[ParameterNames.ToDate];
var newParameters = new Dictionary <string, string>
{
{ ParameterNames.Country, parameters[ParameterNames.Country] },
{ ParameterNames.ToDate, toDate },
{ ParameterNames.FromDate, parameters[ParameterNames.FromDate] }
};
using (var dataContext = new MarsDBDataContext(MarsConnection.ConnectionString))
{
var joinedData = timeZone == DataType.DailyChanging
? GenericSizingDataAccess.GetFutureTrendRawData(dataContext, parameters, scenarioId)
: GetRawFrozenZoneFutureTrendData(dataContext, newParameters, (byte)scenarioId);
return(GenerateExcelDataFromRaw(dataContext, joinedData, siteGroup, fleetGroup, dataType));
}
}