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)); } }
public ActionResult EditIssue(int id) { var existingDnote = db.DeliveryNotes.Find(id); var ret = new DTOEditIssue() { Id = existingDnote.Id, MovementType_Id = "issue", MovementTypeName = "Kiadás", RowId = -1 }; foreach (var mt in db.MovementTypes) { ret.MovementType.Add(mt); } var dNote = new DTODeliveryNote() { Id = existingDnote.Id, DeliveryNoteDate = existingDnote.DeliveryNoteDate, Customer_Id = existingDnote.Customer_Id, CustomerName = db.Customers?.First(c => c.Id == existingDnote.Customer_Id).Name, Type = existingDnote.Type, Number = existingDnote.Number, Remark = existingDnote.Remark, CreatedBy = existingDnote.CreatedBy, CreatedDate = existingDnote.CreatedDate, CreatedByName = db.SystemUsers?.Find(existingDnote.CreatedBy)?.Username, ChangedBy = existingDnote.ChangedBy, ChangedDate = existingDnote.ChangedDate, ChangedByName = db.SystemUsers?.Find(existingDnote.ChangedBy)?.Username, }; foreach (var cu in db.Customers) { dNote.Customer.Add(cu); } foreach (var item in existingDnote.DeliveryNoteItems.Where(c => c.ProductMovement.IsActive)) { 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, Recipe_Id = pm.Recipe_Id, RecipeName = db.Recipes.Find(pm.Recipe_Id).Name, Quantity = pm.Quantity, Warehouse_Id = pm.Warehouse_Id, WarehouseName = pm.Warehouse.Name, ProductMovementIsActive = pm.IsActive }; ret.RowId++; foreach (var wh in db.Warehouses) { dni.Warehouse.Add(wh); } foreach (var rec in db.Recipes) { dni.Recipe.Add(rec); } dNote.DeliveryNoteItems.Add(dni); } ret.DeliveryNote = dNote; return(View(ret)); }
public ActionResult EditReceipt(int id) { var existingDnote = db.DeliveryNotes.Find(id); var ret = new DTOEditReceipt() { Id = existingDnote.Id, MovementType_Id = "receipt", MovementTypeName = "Bevételezés", RowId = -1 }; foreach (var mt in db.MovementTypes) { ret.MovementType.Add(mt); } var dNote = new DTODeliveryNote() { Id = existingDnote.Id, DeliveryNoteDate = existingDnote.DeliveryNoteDate, Customer_Id = existingDnote.Customer_Id, CustomerName = db.Customers?.First(c => c.Id == existingDnote.Customer_Id).Name, Type = existingDnote.Type, Number = existingDnote.Number, Remark = existingDnote.Remark, CreatedBy = existingDnote.CreatedBy, CreatedDate = existingDnote.CreatedDate, CreatedByName = db.SystemUsers?.Find(existingDnote.CreatedBy)?.Username, ChangedBy = existingDnote.ChangedBy, ChangedDate = existingDnote.ChangedDate, ChangedByName = db.SystemUsers?.Find(existingDnote.ChangedBy)?.Username, }; foreach (var cu in db.Customers) { dNote.Customer.Add(cu); } foreach (var item in existingDnote.DeliveryNoteItems.Where(c => c.IngredientMovement.IsActive)) { 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, Ingredient_Id = im.Ingredient_Id, IngredientName = db.Ingredients.Find(im.Ingredient_Id).Name, Quantity = im.Quantity, Warehouse_Id = im.Warehouse_Id, WarehouseName = im.Warehouse.Name, IngredientMovementIsActive = im.IsActive }; ret.RowId++; foreach (var wh in db.Warehouses) { dni.Warehouse.Add(wh); } foreach (var ing in db.Ingredients) { dni.Ingredient.Add(ing); } dNote.DeliveryNoteItems.Add(dni); } ret.DeliveryNote = dNote; return(View(ret)); }