public OfficeVisitModel FindVisitByVisitId(string visitId)
        {
            OfficeVisitModel officeVisitModel = null;

            visitId = visitId.MakeDBFriendly();
            decimal decimalVisitId = 0;
            if (decimal.TryParse(visitId, out decimalVisitId))
            {
                OfficeVisitData officeVisitData = new OfficeVisitData();
                officeVisitModel = officeVisitData.GetVisit(decimalVisitId);
            }

            return officeVisitModel;
        }
        public decimal? SaveOfficeVisit(OfficeVisitModel officeVisitModel)
        {
            OfficeVisitData officeVisitData = new OfficeVisitData();
            decimal? ov_idAfterSave = officeVisitModel.OfficeVisitId;

            FacilityHardwareInventoryRespository FacilityHardwareInventoryRespository =
                new FacilityHardwareInventoryRespository();

            List<faclty_hw_invtry> allFacilityHardwareInventoryRecords = FacilityHardwareInventoryRespository.GetAll();
            faclty_hw_invtry facilityHardwareInventory = (from webAdminFacilityHardwareInventoryIds in allFacilityHardwareInventoryRecords
                                                          where webAdminFacilityHardwareInventoryIds.itm_descn == "Website- Hip Admin"
                                                          select webAdminFacilityHardwareInventoryIds).FirstOrDefault();
            if (facilityHardwareInventory != null)
            {
                if (officeVisitModel.OfficeVisitId > 0)
                {
                    officeVisitModel.FacilityHardwareId = (decimal)facilityHardwareInventory.faclty_hw_invtry_id;
                    officeVisitData.UpdateVisit(officeVisitModel);
                }
                else
                {
                    ov_idAfterSave = officeVisitData.CreateVisit(officeVisitModel);
                }
            }

            return ov_idAfterSave;
        }