public int InsertCase(CaseDocumentations objCaseDocumentations)
        {
            objCaseDocumentations.CaseDocumentationID = 1;
            BeginTransaction();

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

            return objCaseDocumentations.CaseDocumentationID;
        }
        public int UpdateCase(CaseDocumentations objCaseDocumentations)
        {
            int rowsaffected = -1;
            BeginTransaction();
            try
            {
                String[] UpdateProperties = new String[] { "ReferralToID", 
                                                            "NonReferredReasonID", "ReferralStatusID", "DateOfReferral",
                                                            "IsDifficultyFaced", "DifficultyFacedRemarks", "UpdatedBy",
                                                            "UpdatedDate"
                                                            };
                rowsaffected = Update(objCaseDocumentations, UpdateProperties);

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

        }
 public static CaseDocumentations GetCaseDocumentation(int SaMIProfileID)
 {
     CaseDocumentations objCaseDocumentations = new CaseDocumentations();
     return (CaseDocumentations)(new CaseDocumentationsDAO().FillDTO(objCaseDocumentations, "SaMIProfileID=" + SaMIProfileID));
 }
 public static int UpdateCase(CaseDocumentations objCaseDocumentations)
 {
     return new CaseDocumentationsDAO().UpdateCase(objCaseDocumentations);
 }
 public static int InsertCase(CaseDocumentations objCaseDocumentations)
 {
     return new CaseDocumentationsDAO().InsertCase(objCaseDocumentations);
 }