public ActionResult ListIssues()
{
using (db = new MecsekTransitEntities())
{
var ret = new List <DTOIssue>();
foreach (var delNote in db.DeliveryNotes.Include(c => c.DeliveryNoteItems).Where(c => c.Type == "issue").OrderByDescending(c => c.CreatedDate).ToList())
{
var dn = new DTODeliveryNote()
{
Id = delNote.Id,
DeliveryNoteDate = delNote.DeliveryNoteDate,
Customer_Id = delNote.Id,
CustomerName = db.Customers?.First(c => c.Id == delNote.Customer_Id).Name,
Type = delNote.Type,
Number = delNote.Number,
Remark = delNote.Remark,
CreatedBy = delNote.CreatedBy,
CreatedDate = delNote.CreatedDate,
CreatedByName = db.SystemUsers?.Find(delNote.CreatedBy)?.Username,
ChangedBy = delNote.ChangedBy,
ChangedDate = delNote.ChangedDate,
ChangedByName = db.SystemUsers?.Find(delNote.ChangedBy)?.Username,
};
foreach (var item in delNote.DeliveryNoteItems)
{
var pm = db.ProductMovements.First(c => c.Id == item.ProductMovement_Id);
var dni = new DTODeliveryNoteItem()
{
Id = item.Id,
DeliveryNote_Id = item.DeliveryNote_Id,
ProductMovement_Id = item.ProductMovement_Id,
ProductMovementRemark = pm.Remark,
RecipeName = db.Recipes.Find(pm.Recipe_Id).Name,
Quantity = pm.Quantity,
Warehouse_Id = pm.Warehouse_Id,
WarehouseName = pm.Warehouse.Name,
};
dn.DeliveryNoteItems.Add(dni);
}
var r = new DTOIssue()
{
DeliveryNote = dn,
MovementType_Id = "issue",
MovementTypeName = "Kiadás",
};
ret.Add(r);
}
return(View(ret));
}
}
public ActionResult ListReceipts()
{
using (db = new MecsekTransitEntities())
{
var ret = new List <DTOReceipt>();
foreach (var delNote in db.DeliveryNotes.Include(c => c.DeliveryNoteItems).Where(c => c.Type == "receipt" && c.IsActive).OrderByDescending(c => c.CreatedDate).ToList())
{
var dn = new DTODeliveryNote()
{
Id = delNote.Id,
DeliveryNoteDate = delNote.DeliveryNoteDate,
Customer_Id = delNote.Id,
CustomerName = db.Customers?.First(c => c.Id == delNote.Customer_Id).Name,
Type = delNote.Type,
Number = delNote.Number,
Remark = delNote.Remark,
CreatedBy = delNote.CreatedBy,
CreatedDate = delNote.CreatedDate,
CreatedByName = db.SystemUsers?.Find(delNote.CreatedBy)?.Username,
ChangedBy = delNote.ChangedBy,
ChangedDate = delNote.ChangedDate,
ChangedByName = db.SystemUsers?.Find(delNote.ChangedBy)?.Username,
};
foreach (var item in delNote.DeliveryNoteItems)
{
var im = db.IngredientMovements.First(c => c.Id == item.IngredientMovement_Id);
var dni = new DTODeliveryNoteItem()
{
Id = item.Id,
DeliveryNote_Id = item.DeliveryNote_Id,
IngredientMovement_Id = item.IngredientMovement_Id,
IngredientMovementRemark = im.Remark,
IngredientName = db.Ingredients.Find(im.Ingredient_Id).Name,
Quantity = im.Quantity,
Warehouse_Id = im.Warehouse_Id,
WarehouseName = im.Warehouse.Name,
};
dn.DeliveryNoteItems.Add(dni);
}
var r = new DTOReceipt()
{
DeliveryNote = dn,
MovementType_Id = "receipt",
MovementTypeName = "Bevételezés",
};
ret.Add(r);
}
return(View(ret));
}
}
