protected void Page_Load(object sender, EventArgs e)
{
lblErrorMessage.Visible = false;
lblProcessMessage.Text = string.Empty;
if (!IsPostBack)
{
hfLoggedOnUser.Value = ApplicationAuthentication.GetGlobalId();
ucDgcProgress.CurrentProgress = DemandGapCalculationStep.NotStarted;
PopulateScenarios();
PopulateMinAndMaxSpreadDates();
pnlGapFill.Visible = false;
}
if (ucDgcProgress.CurrentProgress == DemandGapCalculationStep.Complete ||
ucDgcProgress.CurrentProgress == DemandGapCalculationStep.Error)
{
hfLoading.Value = string.Empty;
btnCaluclate.Enabled = true;
pnlGapFill.Visible = true;
tbSummary.Text = ucDgcProgress.CurrentProgress == DemandGapCalculationStep.Complete
? SummaryText : string.Empty;
ucDgcProgress.CurrentProgress = DemandGapCalculationStep.NotStarted;
}
ucDemanGapStageOneGrid.GridItemType = typeof(WeeklyMaxMinValues);
ucDemanGapStageOneGrid.SessionNameForGridData = DemandGapDisplaySession;
ucDemanGapStageOneGrid.ColumnHeaders = WeeklyMaxMinValues.HeaderRows;
ucDemanGapStageOneGrid.ColumnFormats = WeeklyMaxMinValues.Formats;
ucResult.GridItemType = typeof(AdditionEntity);
ucResult.SessionNameForGridData = AdditionPlanSessionHolder;
ucResult.ColumnHeaders = AdditionEntity.HeaderRows;
ucResult.ColumnFormats = AdditionEntity.Formats;
}
public void UpdateMinCommercialSegments(double newMinCommSegPercent)
{
var comSegData = CommercialSegmentQueryable.GetCommercialCarSemgents(DataContext, Parameters);
var locations = LocationQueryable.GetLocations(DataContext, Parameters);
var carSegments = CarSegmentQueryable.GetCarSegments(DataContext, Parameters);
var fullComSeg = from ccs in comSegData
from l in locations
from cs in carSegments
select new
{
LocationId = l.dim_Location_id,
CarSegmentId = cs.car_segment_id,
ccs.CommercialCarSegmentId
};
var minCommIdsToUpdate = from fullCs in fullComSeg
join mcs in DataContext.MinCommercialSegments on
new { fullCs.LocationId, fullCs.CarSegmentId, fullCs.CommercialCarSegmentId }
equals new { mcs.LocationId, mcs.CarSegmentId, mcs.CommercialCarSegmentId }
select mcs;
minCommIdsToUpdate.ForEach(d => d.Percentage = newMinCommSegPercent);
minCommIdsToUpdate.ForEach(d => d.UpdatedBy = ApplicationAuthentication.GetGlobalId());
minCommIdsToUpdate.ForEach(d => d.UpdatedOn = DateTime.Now);
var entriesToCreate = from fullCs in fullComSeg
join mcs in DataContext.MinCommercialSegments on
new { fullCs.LocationId, fullCs.CarSegmentId, fullCs.CommercialCarSegmentId }
equals new { mcs.LocationId, mcs.CarSegmentId, mcs.CommercialCarSegmentId }
into joinedComSeg
from comSegFigures in joinedComSeg.DefaultIfEmpty()
where comSegFigures == null
select new
{
LocationId = fullCs.LocationId,
CarSegmentId = fullCs.CarSegmentId,
CommercialCarSegmentId = fullCs.CommercialCarSegmentId,
Percentage = newMinCommSegPercent,
LastChangedOn = DateTime.Now,
LastChangedBy = ApplicationAuthentication.GetGlobalId()
};
var localEntities = from etc in entriesToCreate.AsEnumerable()
select new MinCommercialSegment
{
LocationId = etc.LocationId,
CarSegmentId = etc.CarSegmentId,
CommercialCarSegmentId = etc.CommercialCarSegmentId,
Percentage = newMinCommSegPercent,
UpdatedOn = DateTime.Now,
UpdatedBy = ApplicationAuthentication.GetGlobalId()
};
DataContext.MinCommercialSegments.InsertAllOnSubmit(localEntities);
DataContext.SubmitChanges();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
UserActivity.LogPageAccess(ApplicationAuthentication.GetGlobalId(), Request.Url.AbsolutePath, ApplicationAuthentication.GetUserName());
}
//Check session timeout
base.CheckSessionTimeout();
this.ControlPanelRibbon.UserLoggedIn = @"User Logged In: " + ApplicationAuthentication.GetUserName();
this.ControlPanelRibbon.ControlTitle = @"Application Home";
this.ChangeMenuStyles();
}
public List <ListItem> GetFleetTypesList(ModuleType modType)
{
var returned = NonRevParameterDataAccess.GetFleetTypes(DataContext);
switch (modType)
{
case ModuleType.Availability:
returned.ForEach(d => d.Selected =
d.Text.ToLower() != "licensee" &&
d.Text.ToLower() != "inactive" &&
d.Text.ToLower() != "undefined" &&
d.Text.ToLower() != "firefly" &&
d.Text.ToLower() != "hertz on demand" &&
d.Text.ToLower() != "sold");
break;
case ModuleType.NonRev:
returned.ForEach(d => d.Selected =
d.Text.ToLower() != "licensee" &&
d.Text.ToLower() != "inactive" &&
d.Text.ToLower() != "sold");
break;
default:
throw new ArgumentOutOfRangeException("modType");
}
var loggedOnEmployee = ApplicationAuthentication.GetEmployeeId();
if (loggedOnEmployee == string.Empty) //Special case for Itdemo
{
loggedOnEmployee = ApplicationAuthentication.GetGlobalId();
}
var marsUserEntity = DataContext.MarsUsers.FirstOrDefault(d => d.EmployeeId == loggedOnEmployee);
if (marsUserEntity != null)
{
if (marsUserEntity.CompanyType.CompanyTypeName == CompanyTypeEnum.Licensee.ToString())
{
var item = returned.SingleOrDefault(d => d.Text.ToLower() == "licensee");
if (item != null)
{
item.Selected = true;
}
}
}
return(returned);
}
public void UpdateMaxFleetFactors(double?nonRevPercent, double?utilizationPercent)
{
if (!Parameters.ContainsValueAndIsntEmpty(DictionaryParameter.DayOfWeek))
{
return;
}
var splitDaysOfWeek =
Parameters[DictionaryParameter.DayOfWeek].Split(VehicleFieldRestrictions.Separator.ToCharArray())
.Select(int.Parse)
.ToList();
var locations = LocationQueryable.GetLocations(DataContext, Parameters);
var carGroups = CarGroupQueryable.GetCarGroups(DataContext, Parameters);
var weekDays = from wd in DataContext.WeekDays
where splitDaysOfWeek.Contains(wd.DayOfWeekId)
select wd.DayOfWeekId;
var locationsAndGroups = from l in locations
from cg in carGroups
from wd in weekDays
select new
{
LocationId = l.dim_Location_id,
CarGroupId = cg.car_group_id,
DayOfWeekId = wd
};
var entriesToUpdate = from lag in locationsAndGroups
join mff in DataContext.MaxFleetFactors on
new { lag.CarGroupId, lag.LocationId, lag.DayOfWeekId } equals
new { mff.CarGroupId, mff.LocationId, mff.DayOfWeekId }
select mff;
if (nonRevPercent.HasValue)
{
entriesToUpdate.ForEach(d => d.NonRevPercentage = nonRevPercent.Value);
}
if (utilizationPercent.HasValue)
{
entriesToUpdate.ForEach(d => d.UtilizationPercentage = utilizationPercent.Value);
}
entriesToUpdate.ForEach(d => d.UpdatedBy = ApplicationAuthentication.GetGlobalId());
entriesToUpdate.ForEach(d => d.UpdatedOn = DateTime.Now);
var entriesToCreate = from fullCs in locationsAndGroups
join mff in DataContext.MaxFleetFactors on
new { fullCs.LocationId, fullCs.CarGroupId, fullCs.DayOfWeekId }
equals new { mff.LocationId, mff.CarGroupId, mff.DayOfWeekId }
into joinedFleetFactors
from fleetFactors in joinedFleetFactors.DefaultIfEmpty()
where fleetFactors == null
select new
{
LocationId = fullCs.LocationId,
CarGroupId = fullCs.CarGroupId,
DayOfWeekId = fullCs.DayOfWeekId,
NonRev = nonRevPercent,
Utilization = utilizationPercent,
LastChangedOn = DateTime.Now,
LastChangedBy = ApplicationAuthentication.GetGlobalId()
};
var localEntities = from etc in entriesToCreate.AsEnumerable()
select new MaxFleetFactor
{
LocationId = etc.LocationId,
CarGroupId = etc.CarGroupId,
DayOfWeekId = etc.DayOfWeekId,
NonRevPercentage = etc.NonRev,
UtilizationPercentage = etc.Utilization,
UpdatedOn = DateTime.Now,
UpdatedBy = ApplicationAuthentication.GetGlobalId()
};
DataContext.MaxFleetFactors.InsertAllOnSubmit(localEntities);
DataContext.SubmitChanges();
}