public bool UpdateBusinessUnit(BusinessUnitVM businessUnitVM)
        {
            using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
            {
                try
                {
                    tblBussinessUnit bussinessUnit = unitOfWork.TblBussinessUnitRepository.GetByID(businessUnitVM.BusinessUnitID);
                    bussinessUnit.BussinessUnit = businessUnitVM.BusinessUnit;
                    bussinessUnit.CompID        = businessUnitVM.CompanyID;
                    bussinessUnit.IsActive      = businessUnitVM.IsActive;
                    bussinessUnit.ModifiedDate  = DateTime.Now;
                    bussinessUnit.ModifiedBy    = businessUnitVM.ModifiedBy;
                    unitOfWork.TblBussinessUnitRepository.Update(bussinessUnit);
                    unitOfWork.Save();

                    //Complete the Transaction
                    dbTransaction.Commit();
                    return(true);
                }
                catch (Exception ex)
                {
                    //Roll back the Transaction
                    dbTransaction.Rollback();
                    return(false);
                }
            }
        }
        public bool DeleteBusinessUnit(int businessUnitID)
        {
            using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
            {
                try
                {
                    tblBussinessUnit bussinessUnit = unitOfWork.TblBussinessUnitRepository.GetByID(businessUnitID);
                    unitOfWork.TblBussinessUnitRepository.Delete(businessUnitID);
                    unitOfWork.Save();

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