private void PopulateAdditionPlanData()
{
var parameters = new Dictionary <DictionaryParameter, string>();
using (var dataAccess = new AdditionPlanDataAccess(parameters))
{
var additionData = dataAccess.GetAdditionPlanEntryEntries(SelectedScenarioId, LocationLevelGroupings.Location, VehicleLevelGrouping.CarGroup);
var additionPlan = dataAccess.GetAdditionPlan(SelectedScenarioId);
SwitchApplyUnApplyButtons(additionPlan.Applied);
lblUpdateLessonLabel.Text = string.Format(hfUpdateLessonLabel.Value, additionPlan.Name);
lblAdditionPlanDateCreated.Text = additionPlan.DateCreated.ToString("dd/MM/yyyy HH:mm");
lblAdditionPlanName.Text = additionPlan.Name;
tbUpdatedLesson.Text = additionPlan.LessonLearnt;
tbLessonsLearnt.Text = additionPlan.LessonLearnt;
var additionEntities = from ad in additionData
select new AdditionEntity
{
Year = ad.Year,
IsoWeek = ad.IsoWeek,
CarGroupId = ad.CarGroupId,
LocationId = ad.LocationId,
CarGroup = ad.CarGroup,
Location = ad.Location,
Amount = ad.Amount,
Contribution = (double)ad.CpU
};
agAdditionPlanDetails.GridData = additionEntities.ToList();
}
}
private void ApplyAdditionPlan(bool applied)
{
using (var dataAccess = new AdditionPlanDataAccess())
{
dataAccess.ApplyAdditionPlan(SelectedScenarioId, applied);
}
}
private void FillAdditionPlanHistory()
{
using (var dataAccess = new AdditionPlanDataAccess())
{
var planData = dataAccess.GetAdditionPlanHistory();
agAdditionPlanHistory.GridData = planData;
}
}
private void FillAdditionPlanHistory()
{
using (var dataAccess = new AdditionPlanDataAccess())
{
var appliedOnly = cbActiveOnly.Checked;
var planData = dataAccess.GetAdditionPlanHistory(appliedOnly);
agAdditionPlanHistory.GridData = planData;
}
}
protected void SaveUpdatedLesson(object sender, EventArgs e)
{
var lessonLearnt = tbUpdatedLesson.Text;
tbLessonsLearnt.Text = lessonLearnt;
using (var dataAccess = new AdditionPlanDataAccess())
{
dataAccess.UpdateLessonsLearnt(SelectedScenarioId, lessonLearnt);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
PopulateDropdowns();
using (var dataAccess = new AdditionPlanDataAccess())
{
var countryId = int.Parse(ddlCountry.SelectedValue);
var additionPlansA = dataAccess.GetAdditionPlanListItems(countryId);
var additionPlansB = dataAccess.GetAdditionPlanListItems(countryId);
ddlAdditionPlanA.Items.AddRange(additionPlansA.ToArray());
ddlAdditionPlanB.Items.AddRange(additionPlansB.ToArray());
if (additionPlansB.Count > 1)
{
ddlAdditionPlanB.SelectedIndex = 1;
}
}
}
}
private void PopulateAdditionTables(AdditionPlanDataAccess dataAccess, LocationLevelGroupings locationGrouping
, VehicleLevelGrouping vehicleGrouping, int scenarioId, AutoGrid gridToUpdate, bool scenarioASelected)
{
var additionData = dataAccess.GetAdditionPlanEntryEntries(scenarioId, locationGrouping, vehicleGrouping);
var additionPlan = dataAccess.GetAdditionPlan(scenarioId);
var bottomLevelGrouping = locationGrouping == LocationLevelGroupings.Location &&
vehicleGrouping == VehicleLevelGrouping.CarGroup;
gridToUpdate.HideLastColumn = !bottomLevelGrouping;
if (scenarioASelected)
{
rbAScenario.Text = additionPlan.Name;
lblMaxScenASelected.Text = additionPlan.MaxFleetScenarioName;
lblMinScenASelected.Text = additionPlan.MinComSegScenarioName;
}
else
{
rbBScenario.Text = additionPlan.Name;
lblMaxScenBSelected.Text = additionPlan.MaxFleetScenarioName;
lblMinScenBSelected.Text = additionPlan.MinComSegScenarioName;
}
var additionEntities = from ad in additionData
select new AdditionEntity
{
Year = ad.Year,
IsoWeek = ad.IsoWeek,
CarGroupId = ad.CarGroupId,
LocationId = ad.LocationId,
CarGroup = ad.CarGroup,
Location = ad.Location,
Amount = ad.Amount,
Contribution = (double)ad.CpU
};
gridToUpdate.GridData = additionEntities.ToList();
gridToUpdate.Visible = true;
}
private void SaveAdditionPlan()
{
AdditionPlanEntity ape;
using (var dataAccess = new BaseDataAccess())
{
ape = new AdditionPlanEntity
{
Name = tbAdditionPlanName.Text,
MinComSegScenarioName = ddlMinCommSeg.SelectedItem.Text,
MinComSegScenarioDescription = imgMinFleetDescription.ToolTip,
MaxFleetScenarioName = ddlMaxFleetFactor.SelectedItem.Text,
MaxFleetScenarioDescription = imgMaxFleetDescription.ToolTip,
WeeksCalculated = int.Parse(tbWeeks.Text),
CurrentDate = dataAccess.GetLastHistoryTimestamp(),
StartRevenueDate = dataAccess.MinCommercialDataDate(),
EndRevenueDate = dataAccess.MinCommercialDataDate(),
};
}
var additions = (List <AdditionEntity>)Session[AdditionPlanSessionHolder];
if (additions == null)
{
return;
}
var minMaxValues = (List <WeeklyMaxMinValues>)Session[DemandGapDisplaySession];
var countryId = int.Parse(ddlCountry.SelectedValue);
using (var additionPlanDataAccess = new AdditionPlanDataAccess())
{
additionPlanDataAccess.CreateAdditionPlan(ape, additions, minMaxValues, countryId);
}
pnlGapFill.Visible = false;
}
private void PopulateHistoryTables()
{
var parameters = FaoParameter.GetParameters();
using (var dataAccess = new AdditionPlanDataAccess(parameters))
{
if (ComparisonTypeSelected() == AdditionPlanComparisonTypes.Additions)
{
var locationGrouping = (LocationLevelGroupings)Enum.Parse(typeof(LocationLevelGroupings), rblLocationGrouping.SelectedValue);
var vehicleGrouping = (VehicleLevelGrouping)Enum.Parse(typeof(VehicleLevelGrouping), rblCarGrouping.SelectedValue);
if (hfSelectedScenarioAId.Value != string.Empty)
{
var scenarioId = int.Parse(hfSelectedScenarioAId.Value);
PopulateAdditionTables(dataAccess, locationGrouping, vehicleGrouping, scenarioId,
agV1AdditionPlanEntries, true);
}
if (hfSelectedScenarioBId.Value != string.Empty)
{
var scenarioId = int.Parse(hfSelectedScenarioBId.Value);
PopulateAdditionTables(dataAccess, locationGrouping, vehicleGrouping, scenarioId,
agV2AdditionPlanEntries, false);
}
}
else
{
if (hfSelectedScenarioAId.Value != string.Empty)
{
var scenarioId = int.Parse(hfSelectedScenarioAId.Value);
PopulateMinMaxTables(dataAccess, scenarioId, agV1AdditionPlanMinMaxValues);
}
if (hfSelectedScenarioBId.Value != string.Empty)
{
var scenarioId = int.Parse(hfSelectedScenarioAId.Value);
PopulateMinMaxTables(dataAccess, scenarioId, agV2AdditionPlanMinMaxValues);
}
}
}
}
private void PopulateMinMaxTables(AdditionPlanDataAccess dataAccess, int scenarioId, AutoGrid gridToUpdate)
{
var minMaxValues = dataAccess.GetAdditionPlanMinMaxRows(scenarioId);
var additionPlan = dataAccess.GetAdditionPlan(scenarioId);
if (rbAScenario.Checked)
{
rbAScenario.Text = additionPlan.Name;
lblMaxScenASelected.Text = additionPlan.MaxFleetScenarioName;
lblMinScenASelected.Text = additionPlan.MinComSegScenarioName;
}
else
{
rbBScenario.Text = additionPlan.Name;
lblMaxScenBSelected.Text = additionPlan.MaxFleetScenarioName;
lblMinScenBSelected.Text = additionPlan.MinComSegScenarioName;
}
gridToUpdate.GridData = minMaxValues.ToList();
gridToUpdate.Visible = true;
}
