public async Task <int> AddLibrary(LibraryViewModel entity) { var result = 0; using (var transaction = mediaContext.Database.BeginTransaction()) { try { var library = new Library { Name = entity.Name }; mediaContext.Libraries.Add(library); await mediaContext.SaveChangesAsync(); result = library.Id; transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } return(result); }
public async Task <int> AddCategory(CategoryViewModel entity) { var result = 0; using (var transaction = mediaContext.Database.BeginTransaction()) { try { var category = new Category { Name = entity.Name, ParentCategoryId = entity.ParentCategoryId, MaterialTypeId = entity.MaterialTypeId }; mediaContext.Categories.Add(category); await mediaContext.SaveChangesAsync(); result = category.Id; transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } return(result); }
public async Task <int> AddDepartment(DepartmentViewModel entity) { var result = 0; using (var transaction = mediaContext.Database.BeginTransaction()) { try { var department = new Department { Name = entity.Name, LibraryId = entity.LibraryId }; mediaContext.Departments.Add(department); await mediaContext.SaveChangesAsync(); result = department.Id; transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } return(result); }
public Task <int> SaveChangesAsync() { return(context.SaveChangesAsync()); }