public ViewResult Log()
{
var dispatches = _dispatchService.GetAllDispatch();
var user = _userProfileService.GetUser(User.Identity.Name);
return(View(dispatches.Where(p => p.HubID == user.DefaultHub.HubID).ToList()));
}
// DRMFSS.BLL.CTSContext db = new BLL.CTSContext();
public virtual ActionResult SIReport(string siNumber)
{
if (!string.IsNullOrEmpty(siNumber))
{
// TODO: redo this report
var dispatches = from dis in _dispatchService.GetAllDispatch()
where dis.DispatchDetails.FirstOrDefault().ToString() == siNumber.Trim()
select dis;
// TODO: redo this report
var recieves = from res in _receiveService.GetAllReceive()
where res.ReceiveDetails.FirstOrDefault().TransactionGroup.Transactions.FirstOrDefault().ShippingInstruction.Value == siNumber.Trim()
select res;
Models.SIReportModel model = new Models.SIReportModel();
foreach (BLL.Dispatch p in dispatches)
{
foreach (BLL.DispatchDetail com in p.DispatchDetails)
{
Models.TransactedStock dis = new Models.TransactedStock();
dis.Warehouse = p.Hub.Name;
//dis.Store = p.Store.Name;
dis.GIN = p.GIN;
dis.Commodity = com.Commodity.Name;
dis.Date = p.DispatchDate;
dis.FDP = p.FDP.Name;
//dis.Quantity = com.DispatchedQuantityInMT;
dis.Region = p.FDP.AdminUnit.AdminUnit2.AdminUnit2.Name;
dis.Woreda = p.FDP.AdminUnit.Name;
dis.Zone = p.FDP.AdminUnit.AdminUnit2.Name;
model.Dispatched.Add(dis);
}
}
foreach (BLL.Receive p in recieves)
{
foreach (BLL.ReceiveDetail com in p.ReceiveDetails)
{
Models.TransactedStock dis = new Models.TransactedStock();
dis.Warehouse = p.Hub.Name;
//dis.Store = p.Store.Name;
dis.GRN = p.GRN;
dis.Commodity = com.Commodity.Name;
dis.Date = p.ReceiptDate;
//dis.Quantity = com.ReceivedQuantityInMT;
model.Recieved.Add(dis);
}
}
return(View(model));
}
return(View(new Models.SIReportModel()));
}
