protected override void DisposeCore()
{
if (dbContext != null)
{
dbContext.Dispose();
}
}
protected override void Dispose(bool disposing)
{
if (disposing)
{
db.Dispose();
}
base.Dispose(disposing);
}
public async Task <int> RefreshInventoryMovement()
{
using (var transaction = DbContext.Database.BeginTransaction())
{
try
{
//int result = 0;
List <InventoryMovement> dbMovement = await DbContext.InventoryMovements.ToListAsync();
foreach (var groupedItem in dbMovement.GroupBy(x => new { x.StorageId, x.ProductId, x.UomId }).ToList())
{
var orderedItem = groupedItem.OrderBy(x => x._CreatedUtc).ThenBy(x => x.Id).ToList();
//result += orderedItem.Count;
for (int i = 1; i < orderedItem.Count; i++)
{
var item = orderedItem[i];
var previousItem = orderedItem[i - 1];
item.Before = previousItem.After;
item.After = item.Before + item.Quantity;
}
}
DbContext.UpdateRange(dbMovement);
var result = await DbContext.SaveChangesAsync();
transaction.Commit();
return(result);
}
catch (Exception e)
{
transaction.Rollback();
throw e;
}
finally
{
DbContext.Dispose();
}
}
}
public void Dispose()
{
//_dbContext.Database.EnsureDeleted();
_dbContext.Dispose();
}
public void Dispose()
{
_dbContext.Dispose();
}