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