/// <summary>
        /// getPatientDetail
        /// </summary>
        /// <param name="patientId"></param>
        /// <returns></returns>
        public PatientModel getPatientDetail(int patientId)
        {
            PatientModel patientModel = null;
            var          dbManager    = new DBManager(connectionStringSettings.Name);
            var          parameters   = new List <IDbDataParameter>();

            parameters.Add(dbManager.createParameter("@PATIENT_ID", patientId, DbType.Int32));
            var dataTable = dbManager.getDataTable("SP_GET_PATIENT_DETAIL", CommandType.StoredProcedure, parameters.ToArray());

            try
            {
                if (null != dataTable && dataTable.Rows.Count > 0)
                {
                    DataRow row = dataTable.Rows[0];
                    patientModel = new PatientModel();
                    patientModel.DataRowToObjectMapper(row);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(patientModel);
        }