public List <AUTO_GR> GetAutoGr(RptAutoGrInput input)
{
Expression <Func <AUTO_GR, bool> > queryFilter = c => c.IS_POSTED.HasValue && c.IS_POSTED.Value;
if (input != null)
{
if (input.PeriodStart.HasValue)
{
queryFilter = queryFilter.And(x => x.PO_DATE >= input.PeriodStart);
}
if (input.PeriodEnd.HasValue)
{
queryFilter = queryFilter.And(x => x.PO_DATE <= input.PeriodEnd);
}
}
return(_autoGrRepository.Get(queryFilter, null, "").ToList());
}
public List <RptAutoGrDto> GetAutoGR(RptAutoGrInput rptAutoGrInput)
{
List <AUTO_GR> data = _grService.GetAutoGr(rptAutoGrInput);
var polineList = data.GroupBy(x => new { x.PO_NUMBER, x.LINE_ITEM }).Select(x => x.Key.PO_NUMBER + "_" + x.Key.LINE_ITEM).ToList();
var dataFleet = _fleetService.GetFleet().Where(x => polineList.Contains(x.PO_NUMBER + "_" + x.PO_LINE)).ToList();
//var dataFleetTerminated = dataFleet.Where(x => x.END_DATE.HasValue && x.END_DATE.Value < x.END_CONTRACT).ToList();
var autoGrDto = (from autoGr in data
from fleet in dataFleet.Where(x => autoGr.PO_NUMBER == x.PO_NUMBER &&
autoGr.LINE_ITEM.ToString() == x.PO_LINE)
select new RptAutoGrDto()
{
AutoGrId = autoGr.AUTO_GR_ID,
EndContract = fleet.END_CONTRACT,
StartContract = fleet.START_CONTRACT,
GrDate = autoGr.PO_DATE,
PoLine = autoGr.LINE_ITEM.HasValue ? autoGr.LINE_ITEM.Value.ToString() : "",
PoNumber = autoGr.PO_NUMBER,
PoliceNumber = fleet.POLICE_NUMBER,
QtyAutoGr = autoGr.QTY_ITEM.HasValue? autoGr.QTY_ITEM.Value : 0,
//QtyRemaining = ((fleet.END_CONTRACT.Value.Year - fleet.START_CONTRACT.Value.Year) * 12) + fleet.END_CONTRACT.Value.Month - fleet.START_CONTRACT.Value.Month,
//TerminationDate = fleet.END_DATE,
//QtyCalculated = calculatedGr.Where(x=> x.PoLine == autoGr.LINE_ITEM)
}).ToList();
foreach (var dto in autoGrDto)
{
var calculatedGr = data.Where(x => x.PO_DATE < dto.GrDate)
.GroupBy(x => new { x.LINE_ITEM, x.PO_NUMBER })
.Select(x => new RptAutoGrDto()
{
PoLine = x.Key.LINE_ITEM.HasValue ? x.Key.LINE_ITEM.Value.ToString() : "",
PoNumber = x.Key.PO_NUMBER,
QtyCalculated = x.Sum(y => y.QTY_ITEM.HasValue ? y.QTY_ITEM.Value : 0)
}).ToList();
dto.QtyCalculated =
calculatedGr.Where(x => x.PoLine == dto.PoLine && x.PoNumber == dto.PoNumber)
.Sum(x => x.QtyCalculated);
if (dto.StartContract != null && dto.EndContract != null)
{
var contractQty = ((dto.EndContract.Value.Year - dto.StartContract.Value.Year) * 12) +
dto.EndContract.Value.Month - dto.StartContract.Value.Month;
dto.QtyRemaining = contractQty - dto.QtyCalculated - dto.QtyAutoGr;
}
//var terminatedData = dataFleetTerminated.Where(x => x.PO_LINE == dto.PoLine && x.PO_NUMBER == dto.PoNumber
// && x.VEHICLE_USAGE != "CFM IDLE").FirstOrDefault();
//if (terminatedData != null)
//{
// dto.TerminationDate = terminatedData.END_DATE;
//}
}
return(autoGrDto);
}
