/// <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); }