public async Task<IActionResult> Create([Bind("ID,Title,MediaType,Format,Duration,Genre,Year,Rating,Location,Notes")] Media media) { if (ModelState.IsValid) { _context.Add(media); await _context.SaveChangesAsync(); return RedirectToAction(nameof(Index)); } return View(media); }
public async Task <IActionResult> Create([Bind("Format,LengthTime,Id,Name,Path,Width,Height")] Video video) { if (ModelState.IsValid) { _context.Add(video); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(video)); }
public async Task <bool> DeleteLibrary(int id) { var result = false; using (var mediaContext = new MediaContext()) { using (var transaction = mediaContext.Database.BeginTransaction()) { try { var library = await mediaContext.Libraries.FirstOrDefaultAsync(x => x.Id == id); library.IsDeleted = true; mediaContext.Libraries.Add(library); await mediaContext.SaveChangesAsync(); result = true; transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } return(result); }
public async Task <int> AddLibrary(LibraryViewModel entity) { var result = 0; using (var mediaContext = new MediaContext()) { 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 <bool> RemoveMaterialType(int id) { var result = false; using (var mediaContext = new MediaContext()) { using (var transaction = mediaContext.Database.BeginTransaction()) { try { var materialType = await mediaContext.MaterialTypes.FirstOrDefaultAsync(x => x.Id == id); materialType.IsDeleted = true; mediaContext.MaterialTypes.Add(materialType); await mediaContext.SaveChangesAsync(); result = true; transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } return(result); }
public async Task <int> AddMaterialType(MaterialTypeViewModel entity) { var result = 0; using (var mediaContext = new MediaContext()) { using (var transaction = mediaContext.Database.BeginTransaction()) { try { var materialType = new MaterialType { Name = entity.Name }; mediaContext.MaterialTypes.Add(materialType); await mediaContext.SaveChangesAsync(); result = materialType.Id; transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } return(result); }
public async Task <bool> UpdateDepartment(DepartmentViewModel entity) { var result = false; using (var mediaContext = new MediaContext()) { using (var transaction = mediaContext.Database.BeginTransaction()) { try { var department = await mediaContext.Departments.FirstOrDefaultAsync(x => x.Id == entity.Id); department.LibraryId = entity.LibraryId; department.Name = entity.Name; mediaContext.Departments.Add(department); await mediaContext.SaveChangesAsync(); result = true; transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } return(result); }
public async Task <int> AddDepartment(DepartmentViewModel entity) { var result = 0; using (var mediaContext = new MediaContext()) { 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 async Task <bool> UpdateCategory(CategoryViewModel entity) { var result = false; using (var mediaContext = new MediaContext()) { using (var transaction = mediaContext.Database.BeginTransaction()) { try { var category = new Category { Name = entity.Name, ParentCategoryId = entity.ParentCategoryId, MaterialTypeId = entity.MaterialTypeId, Id = entity.Id.Value }; mediaContext.Categories.Add(category); await mediaContext.SaveChangesAsync(); result = true; transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } return(result); }
public async Task <IActionResult> AddLanguage(long movieId, int languageId) { var language = await db.Languages .Where(x => x.Id == languageId) .SingleOrDefaultAsync(); if (language == null) { return(NotFound(new ResWrapper { args = new { movieId, languageId }, Status = "NotFound:Language" })); } var movie = await db.Movies .Where(x => x.Id == movieId) .SingleOrDefaultAsync(); if (movie == null) { return(NotFound(new ResWrapper { args = new { movieId, languageId }, Status = "NotFound:Movie" })); } var movieLanguage = await db.MovieLanguages .Where(x => x.MovieId == movieId && x.LanguageId == languageId) .SingleOrDefaultAsync(); if (movieLanguage != null) { return(Ok(new ResWrapper { args = new { movieId, languageId }, Status = "OK", Data = new { movie, language } })); } movieLanguage = new MovieLanguage { Movie = movie, Language = language, LanguageId = languageId, MovieId = movieId }; await db.AddAsync(movieLanguage); await db.SaveChangesAsync(); return(Ok(new ResWrapper { args = new { movieId, languageId }, Status = "OK", Data = new { movie, language } })); }
/// <summary> /// Represents the _UnitOfWork_ `Commit` method /// </summary> /// <returns></returns> public async Task <int> CommitAsync() => await _context.SaveChangesAsync();