private void PopulateMinAndMaxSpreadDates() { using (var dataAccess = new BaseDataAccess()) { var minDate = dataAccess.MinCommercialDataDate(); var maxDate = dataAccess.MaxCommercialDataDate(); lblSpreadRange.Text = string.Format("{0:MMMM yyyy} - {1:MMMM yyyy}", minDate, maxDate); //dataAccess.MaxCommercialDataDate().ToString("MMMM yyyy") ; lblLastFleetHistory.Text = dataAccess.GetLastHistoryTimestamp().ToShortDateString(); } }
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; }