public bool UpdateCommisionType(CommisionTypeVM commisionTypeVM)
        {
            using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
            {
                try
                {
                    tblCommisionType commisionType = unitOfWork.TblCommisionTypeRepository.GetByID(commisionTypeVM.CommisionTypeID);
                    commisionType.CommisionType = commisionTypeVM.CommisionTypeName;
                    commisionType.ModifiedDate  = DateTime.Now;
                    commisionType.ModifiedBy    = commisionTypeVM.ModifiedBy;
                    unitOfWork.TblCommisionTypeRepository.Update(commisionType);
                    unitOfWork.Save();

                    //Complete the Transaction
                    dbTransaction.Commit();
                    return(true);
                }
                catch (Exception ex)
                {
                    //Roll back the Transaction
                    dbTransaction.Rollback();
                    return(false);
                }
            }
        }
        public bool DeleteCommisionType(int commisionTypeID)
        {
            using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
            {
                try
                {
                    tblCommisionType commisionType = unitOfWork.TblCommisionTypeRepository.GetByID(commisionTypeID);
                    unitOfWork.TblCommisionTypeRepository.Delete(commisionType);
                    unitOfWork.Save();

                    //Complete the Transaction
                    dbTransaction.Commit();
                    return(true);
                }
                catch (Exception ex)
                {
                    //Roll back the Transaction
                    dbTransaction.Rollback();
                    return(false);
                }
            }
        }
        public CommisionTypeVM GetCommisionTypeByID(int commisionTypeID)
        {
            try
            {
                tblCommisionType commisionTypeData = unitOfWork.TblCommisionTypeRepository.GetByID(commisionTypeID);

                CommisionTypeVM commisionTypeVM = new CommisionTypeVM();
                commisionTypeVM.CommisionTypeID   = commisionTypeData.CommisionTypeID;
                commisionTypeVM.CommisionTypeName = commisionTypeData.CommisionType;
                commisionTypeVM.CreatedDate       = commisionTypeData.CreatedDate != null?commisionTypeData.CreatedDate.ToString() : string.Empty;

                commisionTypeVM.ModifiedDate = commisionTypeData.ModifiedDate != null?commisionTypeData.ModifiedDate.ToString() : string.Empty;

                commisionTypeVM.CreatedBy = commisionTypeData.CreatedBy != null?Convert.ToInt32(commisionTypeData.CreatedBy) : 0;

                commisionTypeVM.ModifiedBy = commisionTypeData.ModifiedBy != null?Convert.ToInt32(commisionTypeData.ModifiedBy) : 0;

                return(commisionTypeVM);
            }
            catch (Exception ex)
            {
                throw;
            }
        }