//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));
}
