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