public bool Update(BookTransactionModel entity) { try { entity.Book = _dbContext.Books.FirstOrDefault(x => x.BookId == entity.BookId); entity.Student = _dbContext.Students.FirstOrDefault(x => x.StudentId == entity.StudentId); var currentEntity = _dbContext.Set <BookTransactionModel>().AsQueryable().FirstOrDefault(x => x.BookTransactionId == entity.BookTransactionId); if (currentEntity == null) { return(false); } currentEntity.IssueDate = entity.IssueDate; currentEntity.ReturnDate = entity.ReturnDate; currentEntity.StudentId = entity.StudentId; currentEntity.Student = entity.Student; currentEntity.BookId = entity.BookId; currentEntity.Book = entity.Book; return(true); } catch (Exception ex) { LogException(ex); throw ex; } }
//Update BookTransaction (async) public async Task <BookTransactionDTO> UpdateBookTransactionAsync(BookTransactionDTO modelDTO) { try { using (var unitOfWork = unitOfWorkFactory.Create()) { BookTransactionModel model = _Mapper_ToModel.Map <BookTransactionDTO, BookTransactionModel>(modelDTO); bool result = unitOfWork.BookTransactionRepository.Update(model); BookTransactionDTO modelRTN = null; if (result) { await unitOfWork.SaveChangesAsync(); modelRTN = _Mapper_ToDTO.Map <BookTransactionModel, BookTransactionDTO>(model); } return(modelRTN); } } catch (Exception ex) { LogException(ex); throw ex; } }
//Add BookTransaction (async) public async Task <int> AddBookTransactionAsync(BookTransactionDTO modelDTO) { try { using (var unitOfWork = unitOfWorkFactory.Create()) { //BookModel tempBook = unitOfWork.BookRepository.GetSingleOrDefaultBook(x => x.BookId == modelDTO.BookId); //modelDTO.BookId = tempBook.BookId; //StudentModel tempStudent = unitOfWork.StudentRepository.GetSingleOrDefaultStudent(x => x.StudentId == modelDTO.StudentId); //modelDTO.StudentId = tempStudent.StudentId; BookTransactionModel model = _Mapper_ToModel.Map <BookTransactionDTO, BookTransactionModel>(modelDTO); unitOfWork.BookTransactionRepository.Add(model); //unitOfWork.Repository.Add<BookTransactionModel>(model); await unitOfWork.SaveChangesAsync(); return(model.BookTransactionId); } } catch (Exception ex) { LogException(ex); throw ex; } }
public void Remove(BookTransactionModel entity) { try { _dbContext.Entry(entity).State = EntityState.Deleted; //return await (_dbContext.SaveChangesAsync()); } catch (Exception ex) { LogException(ex); throw ex; } }
public void Add(BookTransactionModel entity) { try { entity.Book = _dbContext.Books.FirstOrDefault(x => x.BookId == entity.BookId); entity.Student = _dbContext.Students.FirstOrDefault(x => x.StudentId == entity.StudentId); _dbContext.Entry(entity).State = EntityState.Added; } catch (Exception ex) { LogException(ex); throw ex; } }
//Find Single BookTransaction base on "term" (async) //public async Task<BookTransactionDTO> SearchSingleBookTransactionByNameAsync(string term) //{ // try // { // using (var unitOfWork = unitOfWorkFactory.Create()) // { // BookTransactionModel model = unitOfWork.BookTransactionRepository.GetSingleOrDefaultBookTransaction(x => x.BookTransactionName.Contains(term)); // return _Mapper_ToDTO.Map<BookTransactionModel, BookTransactionDTO>(model); // } // } // catch (Exception ex) // { // LogException(ex); // throw ex; // } //} //Find Single BookTransaction base on "term" (async) public async Task <BookTransactionDTO> SearchSingleBookTransactionByIdAsync(int Id) { try { using (var unitOfWork = unitOfWorkFactory.Create()) { BookTransactionModel model = await Task.Run(() => unitOfWork.BookTransactionRepository.GetSingleOrDefaultBookTransaction(x => x.BookTransactionId == Id)); return(_Mapper_ToDTO.Map <BookTransactionModel, BookTransactionDTO>(model)); } } catch (Exception ex) { LogException(ex); throw ex; } }