public PatientDetail GetPatientDetail(string patientNumber, string consentFormType, string location) { //PatientDetail patientDetail = null; //System.Configuration.Configuration config = WebConfigurationManager.OpenWebConfiguration(HttpContext.Current.Request.ApplicationPath); //var conStr = config.AppSettings.Settings["DBConnection"].Value; //using (var sqlConnection = new SqlConnection(conStr)) //{ // using (var sqlDataAdapter = new SqlDataAdapter("select * from Patient where PatientId=" + patientNumber, sqlConnection)) // { // var dataset = new DataSet(); // sqlDataAdapter.Fill(dataset); // if (dataset.Tables.Count > 0) // { // if (dataset.Tables[0].Rows.Count > 0) // { // DataRow record = dataset.Tables[0].Rows[0]; // patientDetail = new PatientDetail // { // name = record["FullName"].ToString(), // age = Convert.ToInt16(record["Age"]), // gender = record["Gender"].ToString(), // MRHash = record["MR#"].ToString(), // AttnDr = "Mr. Mathew Thomas", // AdmDate = Convert.ToDateTime(record["AdmDate"]), // DOB = Convert.ToDateTime(record["BirthDate"]), // PatientHash = record["Patient#"].ToString() // }; // try // { // patientDetail.PrimaryDoctorId = record["PrimaryDoctor"].ToString(); // } // catch (Exception) // { // patientDetail.PrimaryDoctorId = string.Empty; // } // try // { // patientDetail.AssociatedDoctorId = record["AssociatedDoctor"].ToString(); // } // catch (Exception) // { // patientDetail.AssociatedDoctorId = string.Empty; // } // } // } // } //} //return patientDetail; PatientDetail patientDetail = null; System.Configuration.Configuration config = WebConfigurationManager.OpenWebConfiguration(HttpContext.Current.Request.ApplicationPath); var conStr = config.AppSettings.Settings["BethesdaDBConnection"].Value; using (var sqlConnection = new SqlConnection(conStr)) { using (var sqlDataAdapter = new SqlDataAdapter("BMH_Consent_GetCurrentCensus", sqlConnection)) { sqlDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure; sqlDataAdapter.SelectCommand.Parameters.Add(new SqlParameter("@Entity", SqlDbType.NVarChar)).Value = location; sqlDataAdapter.SelectCommand.CommandTimeout = 0; var dataset = new DataSet(); sqlDataAdapter.Fill(dataset); if (dataset.Tables.Count > 0) { if (dataset.Tables[0].Rows.Count > 0) { DataRow record = dataset.Tables[0].Rows.Cast<DataRow>().FirstOrDefault(row => row["PatientAccountID"].ToString() == patientNumber); if (record != null) { patientDetail = new PatientDetail { name = record["FullName"].ToString(), age = record["Age"].ToString(), gender = record["Sex"].ToString(), MRHash = record["MRN"].ToString(), AttnDr = record["AttPhysicianName"].ToString(), AdmDate = Convert.ToDateTime(record["VisitStartDateTime"]), DOB = Convert.ToDateTime(record["BirthDate"]), PatientHash = record["PatientAccountID"].ToString() }; try { patientDetail.PrimaryDoctorId = record["PrimaryDoctor"].ToString(); } catch (Exception) { patientDetail.PrimaryDoctorId = string.Empty; } try { patientDetail.AssociatedDoctorId = record["AssociatedDoctor"].ToString(); } catch (Exception) { patientDetail.AssociatedDoctorId = string.Empty; } } } } } } return patientDetail; }
public PatientDetail GetPatientDetail(string patientNumber, string ConsentFormType) { PatientDetail patientDetail = null; using (SqlConnection sqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnection"].ToString())) { using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter("select * from Patient where PatientId=" + patientNumber, sqlConnection)) { DataSet dataset = new DataSet(); sqlDataAdapter.Fill(dataset); if (dataset.Tables.Count > 0) { if (dataset.Tables[0].Rows.Count > 0) { DataRow record = dataset.Tables[0].Rows[0]; patientDetail = new PatientDetail(); patientDetail.name = record["FullName"].ToString(); patientDetail.age = Convert.ToInt16(record["Age"]); patientDetail.gender = record["Gender"].ToString(); patientDetail.MRHash = record["MR#"].ToString(); patientDetail.AttnDr = "Mr. Mathew Thomas"; patientDetail.AdmDate = DateTime.Now.AddDays(-2); patientDetail.DOB = Convert.ToDateTime(record["BirthDate"]); try { patientDetail.PrimaryDoctorId = record["PrimaryDoctor"].ToString(); } catch (Exception) { patientDetail.PrimaryDoctorId = string.Empty; } try { patientDetail.AssociatedDoctorId = record["AssociatedDoctor"].ToString(); } catch (Exception) { patientDetail.AssociatedDoctorId = string.Empty; } using (SqlDataAdapter sqlDataAdapter2 = new SqlDataAdapter("select * from Treatments where PatientID='" + patientNumber + "' AND ConsentFormType='" + ConsentFormType + "'", sqlConnection)) { dataset = new DataSet(); sqlDataAdapter2.Fill(dataset); if (dataset.Tables.Count > 0) { if (dataset.Tables[0].Rows.Count > 0) { if (dataset.Tables[0].Rows[0]["Procedures"] != null) patientDetail.ProcedureName = dataset.Tables[0].Rows[0]["Procedures"].ToString(); if (dataset.Tables[0].Rows[0]["UnableToSignReason"] != null) patientDetail.UnableToSignReason = dataset.Tables[0].Rows[0]["UnableToSignReason"].ToString(); if (dataset.Tables[0].Rows[0]["Translatedby"] != null) patientDetail.Translatedby = dataset.Tables[0].Rows[0]["Translatedby"].ToString(); patientDetail.StatementOfConsent = null; if (dataset.Tables[0].Rows[0]["StatementType"] != null && !string.IsNullOrEmpty(dataset.Tables[0].Rows[0]["StatementType"].ToString())) { patientDetail.StatementOfConsent = new StatementOfConsent(); using (SqlDataAdapter sqlDataAdapterSC = new SqlDataAdapter("select * from StatementOfConsent where Id=" + dataset.Tables[0].Rows[0]["StatementType"], sqlConnection)) { DataSet datasetSC = new DataSet(); sqlDataAdapterSC.Fill(datasetSC); if (datasetSC.Tables.Count > 0) { if (datasetSC.Tables[0].Rows.Count > 0) { if (datasetSC.Tables[0].Rows[0]["AutologousUnits"] != null && datasetSC.Tables[0].Rows[0]["AutologousUnits"].ToString() == "1") patientDetail.StatementOfConsent.AutologousUnits = true; if (datasetSC.Tables[0].Rows[0]["DirectedUnits"] != null && datasetSC.Tables[0].Rows[0]["DirectedUnits"].ToString() == "1") patientDetail.StatementOfConsent.DirectedUnits = true; } } } } } } } } } } } return patientDetail; }