public int InsertDifficulty(CounselorDifficultiesPerService objCounselorDifficultiesPerService)
        {
            objCounselorDifficultiesPerService.CounseloDifficultyPerServiceID = 1;
            BeginTransaction();

            try
            {
                objCounselorDifficultiesPerService.CounseloDifficultyPerServiceID = Insert(objCounselorDifficultiesPerService);
                CommitTransaction();
            }
            catch (Exception ex)
            {
                RollBackTransaction();
                objCounselorDifficultiesPerService.CounseloDifficultyPerServiceID = -1;
            }

            return objCounselorDifficultiesPerService.CounseloDifficultyPerServiceID;
        }
        public int UpdateDifficulty(CounselorDifficultiesPerService objCounselorDifficultiesPerService)
        {
            int rowsaffected = -1;
            BeginTransaction();
            try
            {
                String[] UpdateProperties = new String[] { "CounselorDifficultyID"};
                rowsaffected = Update(objCounselorDifficultiesPerService, UpdateProperties);

                CommitTransaction();
            }
            catch (Exception e)
            {
                RollBackTransaction();
                rowsaffected = -1;
            }
            return rowsaffected;

        }
        public static CounselorDifficultiesPerService GetCounselorDifficultiesPerService(int ServiceProvidedPerSaMIID)
        {
            CounselorDifficultiesPerService objCounselorDifficultyID = new CounselorDifficultiesPerService();
            return (CounselorDifficultiesPerService)(new CounselorDifficultiesPerServiceDAO().FillDTO(objCounselorDifficultyID, "ServiceProvidedPerSaMIID=" + ServiceProvidedPerSaMIID));

        }
 public static int UpdateDifficulty(CounselorDifficultiesPerService objCounselorDifficultiesPerService)
 {
     return new CounselorDifficultiesPerServiceDAO().UpdateDifficulty(objCounselorDifficultiesPerService);
 }
 public static int InsertDifficulty(CounselorDifficultiesPerService objCounselorDifficultiesPerService)
 {
     return new CounselorDifficultiesPerServiceDAO().InsertDifficulty(objCounselorDifficultiesPerService);
 }