public bool UpdateLoadingType(LoadingTypeVM loadingTypeVM)
        {
            using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
            {
                try
                {
                    tblLoadingType loadingType = unitOfWork.TblLoadingTypeRepository.GetByID(loadingTypeVM.LoadingTypeID);
                    loadingType.Description  = loadingTypeVM.Description;
                    loadingType.ModifiedDate = DateTime.Now;
                    loadingType.ModifiedBy   = loadingTypeVM.ModifiedBy;
                    unitOfWork.TblLoadingTypeRepository.Update(loadingType);
                    unitOfWork.Save();

                    //Complete the Transaction
                    dbTransaction.Commit();
                    return(true);
                }
                catch (Exception ex)
                {
                    //Roll back the Transaction
                    dbTransaction.Rollback();
                    return(false);
                }
            }
        }
        public bool DeleteLoadingType(int loadingTypeID)
        {
            using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
            {
                try
                {
                    tblLoadingType loadingType = unitOfWork.TblLoadingTypeRepository.GetByID(loadingTypeID);
                    unitOfWork.TblLoadingTypeRepository.Delete(loadingType);
                    unitOfWork.Save();

                    //Complete the Transaction
                    dbTransaction.Commit();
                    return(true);
                }
                catch (Exception ex)
                {
                    //Roll back the Transaction
                    dbTransaction.Rollback();
                    return(false);
                }
            }
        }