private List <AdditionDeletionGridViewHolder> GetGridData()
{
var repParams = new ReportsParameters();
DynamicParameters.SelectedParameters.AddOrUpdateInDictionary(ParameterNames.FromDate, DynamicParameters.SimpleDateSelected);
repParams.SetParametersFromDictionary(AddDelInformation.SelectedParameters);
EnumAdditionDeletion additionOrDeletion;
var succeeded = Enum.TryParse(ddlAddDelSelection.SelectedValue, out additionOrDeletion);
if (succeeded == false || string.IsNullOrEmpty(repParams.Country))
{
rptAddDel.DataSource = null;
rptAddDel.DataBind();
return(null);
}
if (repParams.GroupId == null && string.IsNullOrEmpty(repParams.Branch))
{
return(null);
}
var gridData = _addDelBl.GetAdditionDeletionGridViewHolders(repParams, additionOrDeletion);
return(gridData);
}
private IQueryable <ResAddition> GetAdditons(ReportsParameters selectedParams)
{
var returned = from ls in _dataContext.ResAdditions
select ls;
if (selectedParams.SelectedDate != null)
{
returned = returned.Where(d => d.RepDate.Date == selectedParams.SelectedDate);
}
if (selectedParams.Country != null)
{
returned = returned.Where(d => d.LOCATION.country == selectedParams.Country);;
}
if (selectedParams.CmsPoolId != null)
{
returned = returned.Where(d => d.LOCATION.CMS_LOCATION_GROUP.cms_pool_id == selectedParams.CmsPoolId);
}
if (selectedParams.CmsLocationGroupId != null)
{
returned = returned.Where(d => d.LOCATION.cms_location_group_id == selectedParams.CmsLocationGroupId);
}
if (selectedParams.OpsAreadId != null)
{
returned = returned.Where(d => d.LOCATION.ops_area_id == selectedParams.OpsAreadId);
}
if (selectedParams.OpsRegionId != null)
{
returned = returned.Where(d => d.LOCATION.OPS_AREA.ops_region_id == selectedParams.OpsRegionId);
}
if (selectedParams.Branch != null)
{
returned = returned.Where(d => d.LocId == int.Parse(selectedParams.Branch));
}
if (selectedParams.SegmentId != null)
{
returned = returned.Where(d => d.CAR_GROUP.CAR_CLASS.car_segment_id == selectedParams.SegmentId);
}
if (selectedParams.ClassId != null)
{
returned = returned.Where(d => d.CAR_GROUP.car_class_id == selectedParams.ClassId);
}
if (selectedParams.GroupId != null)
{
returned = returned.Where(d => d.CarGrpId == selectedParams.GroupId);
}
return(returned);
}
public List <BufferGridViewHolder> GetBufferGridViewHolders(ReportsParameters reportParams)
{
List <BufferGridViewHolder> returned;
using (var dataAccess = new BufferDataAccess())
{
returned = dataAccess.GetDataGridAdditions(reportParams);
}
return(returned);
}
private List <AdditionDeletionGridViewHolder> GetCountryGridData()
{
if (!DynamicParameters.SelectedParameters.ContainsKey(ParameterNames.Country))
{
return(null);
}
var country = DynamicParameters.SelectedParameters[ParameterNames.Country];
var repParams = new ReportsParameters
{
Country = country
};
var gridData = _addDelBl.GetAdditionDeletionGridViewHolders(repParams, EnumAdditionDeletion.Both);
return(gridData);
}
public List <BufferGridViewHolder> GetDataGridAdditions(ReportsParameters reportParameters)
{
var buffers = from ra in GetBuffers(reportParameters)
select new BufferGridViewHolder
{
Identifier = ra.Id,
LocationWwd = ra.LOCATION.location1,
LocationWwdId = ra.LocId,
CarGroup = ra.CAR_GROUP.car_group1,
CarGroupId = ra.CarGrpId,
Value = ra.Value,
};
return(buffers.ToList());
}
private List <BufferGridViewHolder> GetBufferGridData()
{
var repParams = new ReportsParameters();
DynamicParameters.SelectedParameters.AddOrUpdateInDictionary(ParameterNames.FromDate, DynamicParameters.SimpleDateSelected);
repParams.SetParametersFromDictionary(BufferInformation.SelectedParameters);
if (string.IsNullOrEmpty(repParams.Country))
{
rptBuffers.DataSource = null;
rptBuffers.DataBind();
return(null);
}
var gridData = _bufferBl.GetBufferGridViewHolders(repParams);
return(gridData);
}
public List <AdditionDeletionGridViewHolder> GetDataGridAdditions(ReportsParameters selectedParams, EnumAdditionDeletion type)
{
var additions = from ra in GetAdditons(selectedParams)
select new AdditionDeletionGridViewHolder
{
Identifier = ra.Id,
LocationWwd = ra.LOCATION.location1,
LocationWwdId = ra.LocId,
CarGroup = ra.CAR_GROUP.car_group1,
CarGroupId = ra.CarGrpId,
RepDate = ra.RepDate,
Value = ra.Value,
Addition = true,
};
var deletions = from ra in GetDeletions(selectedParams)
select new AdditionDeletionGridViewHolder
{
Identifier = ra.Id,
LocationWwd = ra.LOCATION.location1,
LocationWwdId = ra.LocId,
CarGroup = ra.CAR_GROUP.car_group1,
CarGroupId = ra.CarGrpId,
RepDate = ra.RepDate,
Value = ra.Value,
Addition = false
};
switch (type)
{
case EnumAdditionDeletion.Both:
return(additions.Union(deletions).ToList());
case EnumAdditionDeletion.Additions:
return(additions.ToList());
case EnumAdditionDeletion.Deletions:
return(deletions.ToList());
default:
throw new ArgumentOutOfRangeException("type");
}
}
public List <AdditionDeletionGridViewHolder> GetAdditionDeletionGridViewHolders(ReportsParameters selectedParams, EnumAdditionDeletion type)
{
List <AdditionDeletionGridViewHolder> returned;
using (var dataAccess = new AdditionDeletionDataAccess())
{
returned = dataAccess.GetDataGridAdditions(selectedParams, type);
}
return(returned);
}
