Example #1
0
        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;
            }
        }
Example #4
0
        public void Remove(BookTransactionModel entity)
        {
            try
            {
                _dbContext.Entry(entity).State = EntityState.Deleted;

                //return await (_dbContext.SaveChangesAsync());
            }
            catch (Exception ex)
            {
                LogException(ex);
                throw ex;
            }
        }
Example #5
0
        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;
            }
        }