//
// GET: /ReceiveDetail/Create
public virtual ActionResult Create()
{
ViewBag.CommodityID = new SelectList(_commodityService.GetAllCommodity(), "CommodityID", "Name");
ViewBag.CommodityGradeID = new SelectList(_commodityGradeService.GetAllCommodityGrade(), "CommodityGradeID", "Name");
ViewBag.ReceiveID = new SelectList(_receiveService.GetAllReceive(), "ReceiveID", "SINumber");
ViewBag.UnitID = new SelectList(_unitService.GetAllUnit(), "UnitID", "Name");
return(View());
}
// 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()));
}