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