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; }