//بيان جرد اجمالى
public dynamic GetTotalInventoryReport(Storing_DetailsVM d)
{
var addPerm = db.Storing_Details.Where(e => e.Storing_Master.AddingDate <= d.toDate && e.Storing_Master.AddingDate >= d.fromDate && e.Storing_Master.StoreId == d.storeId).ToList();
if (d.modelId != 0)
{
addPerm = addPerm.Where(e => e.PurchaseOrderDetail.ModelId == d.modelId).ToList();
}
if (d.brandId != 0)
{
addPerm = addPerm.Where(e => e.PurchaseOrderDetail.BrandId == d.brandId).ToList();
}
var addingPermission = addPerm.Select(s => new InventoryrVM
{
Id = s.Id,
brandId = s.PurchaseOrderDetail.Brand.Id,
brand = s.PurchaseOrderDetail.Brand.NameAr,
modelId = s.PurchaseOrderDetail.Model.Id,
model = s.PurchaseOrderDetail.Model.NameAr,
count = s.PurchaseOrderDetail.Count
}).ToList();
return(addingPermission);
}
//بيان جرد تفصيلى
public dynamic GetDetailedInventoryReport(Storing_DetailsVM d)
{
var addPerm = db.Storing_Details.Where(e => e.Storing_Master.AddingDate <= d.toDate && e.Storing_Master.AddingDate >= d.fromDate && e.Storing_Master.StoreId == d.storeId).ToList();
if (d.modelId != 0)
{
addPerm = addPerm.Where(e => e.PurchaseOrderDetail.ModelId == d.modelId).ToList();
}
if (d.brandId != 0)
{
addPerm = addPerm.Where(e => e.PurchaseOrderDetail.BrandId == d.brandId).ToList();
}
var addingPermission = addPerm.Select(s => new InventoryReportVM
{
Id = s.Id,
desiredCategoryId = s.DesiredCategoryId,
storeId = s.Storing_Master.StoreId,
approvalNo = s.Storing_Master.ApprovalNo,
addingDate = s.Storing_Master.AddingDate.Value.Year.ToString() + "-" + s.Storing_Master.AddingDate.Value.Month.ToString() + "-" + s.Storing_Master.AddingDate.Value.Day.ToString(),
purchaseOrdreId = s.Storing_Master.PurchaseOrderId,
addingNo = s.Storing_Master.Id,
//driverOrder = s.Storing_Master.purchaseOrder.Drivers_Orders.
vin = s.VIN,
plateNo = s.PlateNo,
motorNo = s.MotorNo,
brandId = s.PurchaseOrderDetail.Brand.Id,
brand = s.PurchaseOrderDetail.Brand.NameAr,
modelId = s.PurchaseOrderDetail.Model.Id,
model = s.PurchaseOrderDetail.Model.NameAr,
manufacturingYearId = s.PurchaseOrderDetail.ManufacturingYear.Id,
manufacturingYear = s.PurchaseOrderDetail.ManufacturingYear.Year,
isNew = s.PurchaseOrderDetail.IsNew,
isBuying = s.PurchaseOrderDetail.IsBuying,
isReceived = s.PurchaseOrderDetail.IsReceived,
colorId = s.PurchaseOrderDetail.Color.Id,
color = s.PurchaseOrderDetail.Color.NameAr,
categoryId = s.PurchaseOrderDetail.CarsCategory.Id,
category = s.PurchaseOrderDetail.CarsCategory.NameAr
}).ToList();
return(addingPermission);
}
