public IEnumerable <Consignment> GetConsignmentsBySupplierDepartmentID(Guid Id, SupplierDepartmentSearch supplierDepartmentSearch)
{
var consignments = _repository.Query(x => x.SupplierDepartmentID == Id)
.Include(inc => inc.ConsignmentItems)
.Select()
.Where(
c =>
c.DespatchDate >= supplierDepartmentSearch.From && c.DespatchDate <= supplierDepartmentSearch.To);
return(consignments);
}
public SupplierDepartmentWithConsigmentViewModel GetSupplierDepartmentWithConsignmentsModel(Guid id, SupplierDepartmentSearch supplierDepartmentSearch)
{
var supplierDepartment = _supplierDepartmentService.SupplierDepartmentBasicById(id);
var consignments = _consignmentService.GetConsignmentsBySupplierDepartmentID(id, supplierDepartmentSearch);
SupplierDepartmentWithConsigmentViewModel model = new SupplierDepartmentWithConsigmentViewModel()
{
SupplierDepartmentID = supplierDepartment.SupplierDepartmentID,
SupplierDepartmentName = supplierDepartment.SupplierDepartmentName,
Commission = supplierDepartment.Commission ?? 0,
Handling = supplierDepartment.Handling ?? 0,
Consignments = consignments.Select(
sba => new ConsignmentBasicViewModel()
{
ConsignmentReference = sba.ConsignmentReference,
TotalEstitamedPurcahseCost = sba.ConsignmentItems.Sum(ci => ci.EstimatedPurchaseCost),
DepatchedDate = sba.DespatchDate.ToString(),
ConsignmentID = sba.ConsignmentID
})
};
return(model);
}
