public ScenarioLite GetScenarioLite(int scenarioId)
{
using (var context = new E2MASEntities())
{
return((from sc in context.ScenarioDetails
join input in context.ScenarioInputDetails on sc.ScenarioId equals input.ScenarioId
where sc.ScenarioId == scenarioId
select new ScenarioLite()
{
ScenarioId = sc.ScenarioId,
ScenarioName = sc.ScenarioName,
Description = input.Remarks,
StartYear = input.StartYear,
EndYear = input.EndYear,
Mode = sc.ScenarioMode
}).FirstOrDefault());
}
}
public ScenarioDAL(E2MASEntities dbContext)
{
_dbContext = dbContext;
}
public DashboardDAL(E2MASEntities dbContext)
{
_dbContext = dbContext;
}
