// Checks to see if the appointment data in session is in the database private string GetAppointmentDateString(string mrn, string physician, DateTime clinicDate) { string cmdText = "SELECT * FROM Appointments WHERE ApptMRN = @ApptMRN And ApptPhysician = @ApptPhysician And ApptClinicDate = @ApptClinicDate"; SqlCommand cmd = DataAccessHelper.CreateCommand(cmdText); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@ApptMRN", mrn); cmd.Parameters.Add("@ApptPhysician", physician); cmd.Parameters.Add("@ApptClinicDate", clinicDate); DataTable table = new DataTable(); DataAccessHelper.GetList(cmd, table); if (table.Rows.Count > 0) { DataRow row = table.Rows[0]; return(clinicDate.ToShortDateString()); } return(null); }
// sometimes occures in a transaction with insertion of new patient record public void InsertAppointmentRecord(Hashtable appointmentArgs, int patientId, SqlTransaction trans) { // add our appointment stuff here SqlCommand apptcmd = DataAccessHelper.CreateCommand(APPT_SQL, trans); // use the transaction from above, somehow apptcmd.CommandType = CommandType.Text; DataAccessHelper.AddIntInputParam(apptcmd, "ApptPatientId", patientId); DataAccessHelper.AddStringInputParam(apptcmd, "ApptFirstName", (string)appointmentArgs["ApptFirstName"]); DataAccessHelper.AddStringInputParam(apptcmd, "ApptLastName", (string)appointmentArgs["ApptLastName"]); DataAccessHelper.AddStringInputParam(apptcmd, "ApptMRN", (string)appointmentArgs["ApptMRN"]); DataAccessHelper.AddStringInputParam(apptcmd, "ApptPhysician", (string)appointmentArgs["ApptPhysician"]); DataAccessHelper.AddStringInputParam(apptcmd, "ApptVisitType", (string)appointmentArgs["ApptVisitType"]); DataAccessHelper.AddStringInputParam(apptcmd, "ApptDept", (string)appointmentArgs["ApptDept"]); DataAccessHelper.AddStringInputParam(apptcmd, "ApptNotes", (string)appointmentArgs["ApptNotes"]); DataAccessHelper.AddDateTimeInputParam(apptcmd, "ApptClinicDate", (DateTime)appointmentArgs["ApptClinicDate"]); DataAccessHelper.AddDateTimeInputParam(apptcmd, "ApptTime", (DateTime)appointmentArgs["ApptTime"]); SecurityController sc = new SecurityController(); string username = sc.GetUserName(); DateTime now = DateTime.Now; DataAccessHelper.AddStringInputParam(apptcmd, "EnteredBy", username); DataAccessHelper.AddDateTimeInputParam(apptcmd, "EnteredTime", now); DataAccessHelper.AddStringInputParam(apptcmd, "UpdatedBy", username); DataAccessHelper.AddDateTimeInputParam(apptcmd, "UpdatedTime", now); apptcmd.ExecuteNonQuery(); }
// Checks to see if the appointment data in session is in the database private void AddClinStageDate(string mrn, string physician, DateTime clinicDate) { string cmdText = "SELECT * FROM Appointments WHERE ApptMRN = @ApptMRN And ApptPhysician = @ApptPhysician And ApptClinicDate = @ApptClinicDate"; SqlCommand cmd = DataAccessHelper.CreateCommand(cmdText); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@ApptMRN", mrn); cmd.Parameters.Add("@ApptPhysician", physician); cmd.Parameters.Add("@ApptClinicDate", clinicDate); DataTable table = new DataTable(); DataAccessHelper.GetList(cmd, table); if (table.Rows.Count > 0) { DataRow row = table.Rows[0]; string clinicDateString = clinicDate.ToShortDateString(); ClinStageDateText.Value = clinicDateString; ClinStageDate.Value = clinicDateString; // re-disable ClinStageDate ClinStageDate.Disabled = true; } }
override protected void BuildFamilyHistory() { if (patientID != 0) { // Family History SqlCommand familyHistoryCom = DataAccessHelper.CreateCommand("spFormListFamilyMemberDiagnosis"); DataAccessHelper.AddIntInputParam(familyHistoryCom, "patientID", this.patientID); DataAccessHelper.AddStringInputParam(familyHistoryCom, "formName", "URONV"); DataAccessHelper.AddStringInputParam(familyHistoryCom, "formType", "dynamic"); DataSet familyHistoryDs = DataAccessHelper.GetList(familyHistoryCom); if (familyHistoryDs.Tables[0].Rows.Count == 0) { DataRow blankFamHistoryRow; blankFamHistoryRow = familyHistoryDs.Tables[0].NewRow(); blankFamHistoryRow["FamMemRelation"] = "<br><br><img src=\"../images/shim.gif\" border=\"0\" width=\"12\" height=\"1\">- Cancer:<br><br><br><br><br><img src=\"../images/shim.gif\" border=\"0\" width=\"12\" height=\"1\">- Other:"; familyHistoryDs.Tables[0].Rows.Add(blankFamHistoryRow); } if (familyHistoryDs.Tables[0].Rows.Count > 0) { FamilyHistoryFiller.Visible = false; familyHistory.DataSource = familyHistoryDs.Tables[0].DefaultView; familyHistory.DataBind(); } } }
protected void btnHelpSectionSave_Click(object sender, EventArgs e) { string sid = lblHelpSectionId.Text; string name = txtHelpSectionName.Text; string description = txtHelpSectionDescription.Text; int id; if (sid == "New") { SqlCommand cmd1 = DataAccessHelper.CreateCommand(INSERT_SQL); cmd1.CommandType = CommandType.Text; AddParameterWithNullCheck(cmd1, "@HelpSectionName", name); AddParameterWithNullCheck(cmd1, "@HelpSectionDescription", description); DataSet ds = DataAccessHelper.GetList(cmd1); id = int.Parse(ds.Tables[0].Rows[0][0].ToString()); } else { id = Int32.Parse(sid); SqlCommand cmd = DataAccessHelper.CreateCommand(UPDATE_SQL); cmd.CommandType = CommandType.Text; AddParameterWithNullCheck(cmd, "@HelpSectionId", id); AddParameterWithNullCheck(cmd, "@HelpSectionName", name); AddParameterWithNullCheck(cmd, "@HelpSectionDescription", description); DataAccessHelper.ExecuteScalar(cmd); } PopulateSectionList(); displayInfo(id); }
public static DataSet GetChronoListStatusEntries(int patientId) { SqlCommand com = DataAccessHelper.CreateCommand("spChronoListStatus"); DataAccessHelper.AddIntInputParam(com, "PatientId", patientId); DataSet ds = DataAccessHelper.GetList(com); return(ds); }
public static DataSet GetFirstRadiationTherapy(int patientId) { // SqlCommand com = DataAccessHelper.CreateCommand("spGetRadiationTherapyFirst"); SqlCommand com = DataAccessHelper.CreateCommand("spPluginPSAGraphGetRadiationTherapyFirst"); DataAccessHelper.AddIntInputParam(com, "PatientId", patientId); DataSet ds = DataAccessHelper.GetList(com); return(ds); }
/* * public static bool areSprocsInstalled() * { * try * { * // SqlCommand com = DataAccessHelper.CreateCommand("if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spGetBiopsiesFlash]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) SELECT 'true' ELSE Select 'false'"); * // return (bool)com.ExecuteScalar(); * return true; * } * catch ( SqlException e) * { * throw new Exception("Could not create the stored procedures necessary for the PSA Graph. Please contact your System Administrator or DBA",e); * } * } * * public static void installSprocs(string createSprocsSql) * { * SqlCommand com = DataAccessHelper.CreateCommand(createSprocsSql); * com.ExecuteNonQuery(); * } */ public static DataSet GetAllBiopsiesFlash(int patientId) { //SqlCommand com = DataAccessHelper.CreateCommand("spGetBiopsiesFlash"); SqlCommand com = DataAccessHelper.CreateCommand("spPluginPSAGraphGetBiopsiesFlash"); DataAccessHelper.AddIntInputParam(com, "PatientId", patientId); DataSet ds = DataAccessHelper.GetList(com); return(ds); }
public static string GetPtFullName(int PatientId) { // SqlCommand com = DataAccessHelper.CreateCommand("spGetPtFullName"); SqlCommand com = DataAccessHelper.CreateCommand("spGetPatientsRecord"); DataAccessHelper.AddIntInputParam(com, "PatientId", PatientId); DataSet ds = DataAccessHelper.GetList(com); return(ds.Tables[0].Rows[0]["PtFirstName"].ToString() + " " + ds.Tables[0].Rows[0]["PtMiddleName"].ToString() + " " + ds.Tables[0].Rows[0]["PtLastName"].ToString()); }
public static DataSet GetAllPSAs(int PatientId) { // SqlCommand com = DataAccessHelper.CreateCommand("spGetLabTestAllPSAs"); SqlCommand com = DataAccessHelper.CreateCommand("spPluginPSAGraphGetLabTestAllPSAs"); DataAccessHelper.AddIntInputParam(com, "PatientId", PatientId); DataSet ds = DataAccessHelper.GetList(com); return(ds); }
public static Hashtable GetProstSurgeryRecord(int PatientId) { SqlCommand com = DataAccessHelper.CreateCommand("spFormGetProcProstatectomyDate"); DataAccessHelper.AddIntInputParam(com, "PatientId", PatientId); DataAccessHelper.AddStringOutputParam(com, "RP_Date"); Hashtable ht = DataAccessHelper.ExecuteScalar(com); return(ht); }
public static DataSet GetPSADTVelocity(int patientId, DateTime startDt, DateTime endDt, string PSAThreshold) { //SqlCommand com = DataAccessHelper.CreateCommand("spGetPSADTVelocity"); SqlCommand com = DataAccessHelper.CreateCommand("spPluginPSAGraphGetPSADTVelocity"); DataAccessHelper.AddIntInputParam(com, "PatientId", patientId); DataAccessHelper.AddDateTimeInputParam(com, "StartDT", startDt); DataAccessHelper.AddDateTimeInputParam(com, "EndDT", endDt); DataAccessHelper.AddStringInputParam(com, "PSAThreshold", PSAThreshold); DataSet ds = DataAccessHelper.GetList(com); return(ds); }
protected void btnHelpSectionDelete_Click(object sender, EventArgs e) { SqlCommand cmd = null; cmd = DataAccessHelper.CreateCommand(DELETE_SQL); cmd.CommandType = CommandType.Text; string id = lblHelpSectionId.Text; AddParameterWithNullCheck(cmd, "@HelpSectionId", Int32.Parse(id)); DataAccessHelper.ExecuteScalar(cmd); PopulateSectionList(); setViewMode("start"); }
override protected void BuildSocialHistory() { if (patientID != 0) { // Social History SqlCommand socialHistoryCom = DataAccessHelper.CreateCommand("spFormGetSocialHistoriesRecord"); DataAccessHelper.AddIntInputParam(socialHistoryCom, "patientID", this.patientID); DataAccessHelper.AddStringInputParam(socialHistoryCom, "formName", "URONV"); DataAccessHelper.AddStringInputParam(socialHistoryCom, "formType", "dynamic"); DataSet socialHistoryDs = DataAccessHelper.GetList(socialHistoryCom); if (!socialHistoryDs.Tables.Count.Equals(0) && !socialHistoryDs.Tables[0].Rows.Count.Equals(0)) { socHxOccupation.Text = socialHistoryDs.Tables[0].Rows[0]["SocHxOccupation"].ToString(); socHxMaritalStatus.Text = socialHistoryDs.Tables[0].Rows[0]["SocHxMaritalStatus"].ToString(); socHxChildren.Text = socialHistoryDs.Tables[0].Rows[0]["SocHxChildren"].ToString(); // socHxTobaccoType.Text = socialHistoryDs.Tables[0].Rows[0]["SocHxTobaccoType"].ToString(); if (socialHistoryDs.Tables[0].Rows[0]["SocHxTobaccoPacksPerDay"] != null && socialHistoryDs.Tables[0].Rows[0]["SocHxTobaccoPacksPerDay"].ToString() != "") { socHxTobaccoPacksPerDay.Text = socialHistoryDs.Tables[0].Rows[0]["SocHxTobaccoPacksPerDay"].ToString(); socHxTobaccoPacksPerDayCheckBox.Checked = true; } if (socialHistoryDs.Tables[0].Rows[0]["SocHxTobaccoYears"] != null && socialHistoryDs.Tables[0].Rows[0]["SocHxTobaccoYears"].ToString() != "") { socHxTobaccoPacksPerDayCheckBox.Checked = true; socHxTobaccoYears.Text = socialHistoryDs.Tables[0].Rows[0]["SocHxTobaccoYears"].ToString(); } if (socialHistoryDs.Tables[0].Rows[0]["SocHxTobaccoQuitYear"] != null && socialHistoryDs.Tables[0].Rows[0]["SocHxTobaccoQuitYear"].ToString() != "") { socHxTobaccoQuitYearCheckbox.Checked = true; socHxTobaccoQuitYear.Text = socialHistoryDs.Tables[0].Rows[0]["SocHxTobaccoQuitYear"].ToString(); } socHxCarcinogen.Text = socialHistoryDs.Tables[0].Rows[0]["SocHxCarcinogen"].ToString(); if (socialHistoryDs.Tables[0].Rows[0]["SocHxAlcohol"] != null && socialHistoryDs.Tables[0].Rows[0]["SocHxAlcohol"].ToString().Length > 0) { socHxAlcohol.Text = socialHistoryDs.Tables[0].Rows[0]["SocHxAlcohol"].ToString(); } } } }
private DataTable GetDataTable(string sql) { SqlCommand cmd = null; DataTable table = null; try { cmd = DataAccessHelper.CreateCommand(sql); cmd.CommandType = CommandType.Text; DataSet ds = DataAccessHelper.GetList(cmd); table = ds.Tables[0]; } finally { cmd.Connection.Close(); } return(table); }
private DataTable GetHelpSectionDetails(int id) { SqlCommand cmd = null; DataTable table = null; try { cmd = DataAccessHelper.CreateCommand(SECTION_LIST_DETAILS_SQL); cmd.CommandType = CommandType.Text; AddParameterWithNullCheck(cmd, "@HelpSectionId", id); DataSet ds = DataAccessHelper.GetList(cmd); table = ds.Tables[0]; } finally { cmd.Connection.Close(); } return(table); }
// TODO: make this less ugly protected void MetadataGrid_UpdateCommand(object sender, DataGridCommandEventArgs e) { // setup the update command SqlCommand cmd = null; // extract controls from the command args // USE TEXTBOXES to Test string id = e.Item.Cells[1].Text; string name = e.Item.Cells[2].Text; string description = ((TextBox)e.Item.Cells[4].Controls[0]).Text; string label = ((TextBox)e.Item.Cells[3].Controls[0]).Text; // string ctype = ((DropDownList) e.Item.Cells["HelpFieldControlType"].Controls[0]).SelectedValue; DropDownList clist = (DropDownList)e.Item.FindControl("ControlTypes"); string ctype = null; if (!"".Equals(clist.SelectedValue)) { ctype = clist.SelectedValue; } DropDownList dlist = (DropDownList)e.Item.FindControl("Datatypes"); string dtype = null; if (!"".Equals(dlist.SelectedValue)) { dtype = dlist.SelectedValue; } // suppress required for now ... // bool required = ((CheckBox) e.Item.Cells["HelpFieldRequired"].Controls[0]).Checked; // string required = null; // string min = null; // string max = null; string rowsource = ((TextBox)e.Item.Cells[7].Controls[0]).Text; if (rowsource != null && "".Equals(rowsource)) { rowsource = null; } // string notes = null; cmd = DataAccessHelper.CreateCommand(UPDATE_SQL); cmd.CommandType = CommandType.Text; AddParameterWithNullCheck(cmd, "@FieldId", Int32.Parse(id)); AddParameterWithNullCheck(cmd, "@FieldName", name); AddParameterWithNullCheck(cmd, "@FieldDescription", description); AddParameterWithNullCheck(cmd, "@FieldLabel", label); AddParameterWithNullCheck(cmd, "@FieldControlType", ctype); AddParameterWithNullCheck(cmd, "@FieldDataType", dtype); AddParameterWithNullCheck(cmd, "@FieldRowSource", rowsource); // what about null values? //DataAccessHelper.AddStringInputParam(cmd, "HelpFieldRequired", required); // HelpFieldRequired is varchar(50) //DataAccessHelper.AddStringInputParam(cmd, "HelpFieldMin", min); //DataAccessHelper.AddStringInputParam(cmd, "HelpFieldMax", max); //DataAccessHelper.AddStringInputParam(cmd, "HelpFieldNotes", notes); DataAccessHelper.ExecuteScalar(cmd); // this handles connections // reset the grid to its default mode ResetGrid(); }