public int InsertRecommendation(ICRecommendationsPerService objICRecommendationsPerService)
        {
            objICRecommendationsPerService.ICRecommendationsPerServiceID = 1;
            BeginTransaction();

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

            return objICRecommendationsPerService.ICRecommendationsPerServiceID;
        }
        public int UpdateRecommendation(ICRecommendationsPerService objICRecommendationsPerService)
        {
            int rowsaffected = -1;
            BeginTransaction();
            try
            {
                String[] UpdateProperties = new String[] { "ServiceProvidedID"};
                rowsaffected = Update(objICRecommendationsPerService, UpdateProperties);

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

        }
 public static int UpdateRecommendation(ICRecommendationsPerService objICRecommendationsPerService)
 {
     return new ICRecommendationsPerServiceDAO().UpdateRecommendation(objICRecommendationsPerService);
 }
        public static ICRecommendationsPerService GetICRecommendationsPerService(int ServiceProvidedPerSaMIID)
        {
            ICRecommendationsPerService objICRecommendationsPerServiceID = new ICRecommendationsPerService();
            return (ICRecommendationsPerService)(new ICRecommendationsPerServiceDAO().FillDTO(objICRecommendationsPerServiceID, "ServiceProvidedPerSaMIID=" + ServiceProvidedPerSaMIID));

        }
 public static int InsertRecommendation(ICRecommendationsPerService objICRecommendationsPerService)
 {
     return new ICRecommendationsPerServiceDAO().InsertRecommendation(objICRecommendationsPerService);
 }