//بيان جرد اجمالى 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); }