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