public void Update(RemainNomenclatureBalance item)
{
var itemForRemove = _table.Find(n => n.Id == item.Id);
var index = _table.IndexOf(itemForRemove);
_table.RemoveAt(index);
_table.Insert(index, item);
}
public List <RemainNomenclatureBalance> GetLeftoversRemainNomenclatureBalance(string nomenclatureDesc, string warehouseDesc)
{
var remainNomenclatureBalanceItem = RemainNomenclatureBalance
.Where(t => t.Nomenclature.Description == nomenclatureDesc && t.Warehouse.Description == warehouseDesc)
.GroupBy(t => new { t.Nomenclature, t.Warehouse })
.Select(g => new RemainNomenclatureBalance
{
Date = DateTime.Now,
Warehouse = g.Key.Warehouse,
Nomenclature = g.Key.Nomenclature,
Quantity = g.Sum(s => s.Quantity)
}).ToList();
return(remainNomenclatureBalanceItem);
}
private void RecalcRemainNomenclature()
{
RemainNomenclatureBalance.Clear();
foreach (var item in RemainNomenclature.Where(p => p.RecordType == RecordType.Expose))
{
if (item.Quantity > 0)
{
item.Quantity = -item.Quantity;
}
}
var remainNomenclatureBalanceItem = RemainNomenclature.GroupBy(t => new { t.Nomenclature, t.Warehouse }).Select(g => new RemainNomenclatureBalance
{
Date = DateTime.Now,
Warehouse = g.Key.Warehouse,
Nomenclature = g.Key.Nomenclature,
Quantity = g.Sum(s => s.Quantity)
}).ToList();
foreach (var item in remainNomenclatureBalanceItem)
{
RemainNomenclatureBalance.Add(item);
}
}
public void Delete(RemainNomenclatureBalance item)
{
var itemForRemove = _table.Find(n => n == item);
_table.Remove(itemForRemove);
}
public void Create(RemainNomenclatureBalance item)
{
_table.Add(item);
}
