//public class DispatchedQuantityFromSI //{ // public decimal? Quantity { get; set; } // public decimal? QuantityInMT { get; set; } //} //public DispatchedQuantityFromSI GetDispatchedAllocationFromSi(int hubId, int sis) //{ // var x = (from item in _context.DispatchAllocations // join dispatch in _context.Dispatches on item.DispatchAllocationID equals // dispatch.DispatchAllocationID // join dispatchDetail in _context.DispatchDetails on dispatch.DispatchID equals // dispatchDetail.DispatchID // join transaction in _context.Transactions on dispatchDetail.TransactionGroupID equals // transaction.TransactionGroupID // where // (item.ShippingInstructionID == sis && item.IsClosed && transaction.LedgerID == 9 && // dispatch.HubID == hubId) // select new RPT_Distribution_Result { Quantity = transaction.QuantityInMT, QuantityInUnit = transaction.QuantityInUnit } // ); // return new DispatchedQuantityFromSI() // {Quantity = x.Sum(t => t.Quantity), QuantityInMT = x.Sum(t => t.QuantityInMT)}; //} public System.Data.Objects.ObjectResult <BinCardReport> RPT_BinCardNonFood(int hubID, int?StoreID, int?CommodityID, string ProjectID) { var y = ( from item in _context.Dispatches join dispatchDetail in _context.DispatchDetails on item.DispatchID equals dispatchDetail.DispatchID join fdp in _context.FDPs on item.FDPID equals fdp.FDPID join @group in _context.TransactionGroups on dispatchDetail.TransactionGroupID equals @group.TransactionGroupID join transaction1 in _context.Transactions on @group.TransactionGroupID equals transaction1.TransactionGroupID join code in _context.ProjectCodes on transaction1.ProjectCodeID equals code.ProjectCodeID join instruction in _context.ShippingInstructions on transaction1.ShippingInstructionID equals instruction.ShippingInstructionID join transporter1 in _context.Transporters on item.TransporterID equals transporter1.TransporterID where transaction1.HubID == hubID && transaction1.StoreID == StoreID //in (from com in Commodity where ParentId==CommodityID || CommodityID==CommodityID select CommodityID) //) select new { Transporter = transporter1.Name, // transporter1.NameAM, item.DriverName, item.PlateNo_Prime, Date = item.DispatchDate, Identification = item.GIN, ToFrom = fdp.Name, Project = code.Value, SINumber = instruction.Value, transaction1.QuantityInMT, //Dispatched = null } ); return(_context.RPT_BinCardNonFood(hubID, StoreID, CommodityID, ProjectID)); }