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