public int CreateTreatment(gbmodel.appointment.Appointment p_oAppointment) { SqlConnection sqlCon = new SqlConnection(DBUtil.ConnectionString); sqlCon.Open(); int iRowsAffected = 0; try { string sSelectedFindings = ""; foreach (gbmodel.appointment.note.ch.TreatmentPlan of in p_oAppointment.Note.TreatmentPlan) { sSelectedFindings += of.ID + ","; } if (sSelectedFindings != null && sSelectedFindings.EndsWith(",")) { sSelectedFindings = sSelectedFindings.TrimEnd(','); } SqlCommand command = new SqlCommand("sp_create_event_treatment_plan", sqlCon); command.Parameters.AddWithValue("@i_event_id", p_oAppointment.ID); command.Parameters.AddWithValue("@sz_treatment_plan", sSelectedFindings); command.Parameters.AddWithValue("@sz_company_id", p_oAppointment.Patient.Account.ID); command.Parameters.AddWithValue("@sz_user_id", p_oAppointment.User.ID); command.CommandType = CommandType.StoredProcedure; iRowsAffected = command.ExecuteNonQuery(); } finally { if (sqlCon != null) { if (sqlCon.State == ConnectionState.Open) { sqlCon.Close(); } } sqlCon = null; } return(iRowsAffected); }
public ArrayList SelectTreatmentPlanNameAndLocation(model.account.Account p_oAccount) { DataSet ds = null; SqlConnection connection = new SqlConnection(DBUtil.ConnectionString); ArrayList list = new ArrayList(); try { connection.Open(); SqlCommand selectCommand = new SqlCommand(); ds = new DataSet(); SqlDataAdapter adapter_one = new SqlDataAdapter("exec sp_select_ch_treatment_plan_name @sz_company_id='" + p_oAccount.ID + "' EXEC sp_select_ch_treatment_plan_location @sz_company_id='" + p_oAccount.ID + "' EXEC sp_select_treatment_plan @sz_company_id='" + p_oAccount.ID + "'", connection); adapter_one.SelectCommand.CommandTimeout = 0; adapter_one.Fill(ds); gbmodel.appointment.Appointment oAppointment = new gbmodel.appointment.Appointment(); oAppointment.Note = new gbmodel.appointment.note.Note(); List <gbmodel.appointment.note.ch.TreatmentPlan> oTreatementPlanName = new List <gbmodel.appointment.note.ch.TreatmentPlan>(); List <gbmodel.appointment.note.ch.TreatmentPlan> oTreatmentPlanLocation = new List <gbmodel.appointment.note.ch.TreatmentPlan>(); gbmodel.appointment.Appointment p_oAppointment = new gbmodel.appointment.Appointment(); p_oAppointment.Note = new gbmodel.appointment.note.Note(); p_oAppointment.Note.TreatmentPlan = new List <gbmodel.appointment.note.ch.TreatmentPlan>(); gbmodel.appointment.note.ch.TreatmentPlan ch_plan_name = new gbmodel.appointment.note.ch.TreatmentPlan(); gbmodel.appointment.note.ch.TreatmentPlan ch_plan_location = new gbmodel.appointment.note.ch.TreatmentPlan(); foreach (DataRow dr in ds.Tables[0].Rows) { ch_plan_name = new gbmodel.appointment.note.ch.TreatmentPlan(); ch_plan_name.ID = Convert.ToInt32(dr["i_id"]); ch_plan_name.Name = dr["sz_treatment_plan_name"].ToString(); oTreatementPlanName.Add(ch_plan_name); } list.Add(oTreatementPlanName); foreach (DataRow dr_location in ds.Tables[1].Rows) { ch_plan_location = new gbmodel.appointment.note.ch.TreatmentPlan(); ch_plan_location.ID = Convert.ToInt32(dr_location["i_id"]); ch_plan_location.Location = dr_location["sz_treatment_plan_location_name"].ToString(); oTreatmentPlanLocation.Add(ch_plan_location); } list.Add(oTreatmentPlanLocation); list.Add(ds.Tables[2]); } finally { if (connection != null) { if (connection.State == ConnectionState.Open) { connection.Close(); } connection = null; } } return(list); }
/** * Required input model fields: * gbmodel.appointment.Appointment.ID * gbmodel.appointment.Appointment.Patient.Account.ID * * Returns the datatable with the **/ public DataTable SelectObjectiveFinding(gbmodel.appointment.Appointment p_oAppointment) { DataSet ds = null; SqlConnection connection = new SqlConnection(DBUtil.ConnectionString); DataTable tblMatrix = new DataTable(); try { connection.Open(); SqlCommand selectCommand = new SqlCommand("sp_select_event_objective_findings", connection); selectCommand.Parameters.AddWithValue("@i_event_id", p_oAppointment.ID); selectCommand.Parameters.AddWithValue("@sz_company_id", p_oAppointment.Patient.Account.ID); selectCommand.CommandType = CommandType.StoredProcedure; selectCommand.CommandTimeout = 0; ds = new DataSet(); new SqlDataAdapter(selectCommand).Fill(ds); //get the masters ArrayList alMasters = SelectFindingNameAndLocation(p_oAppointment.Patient.Account); if (alMasters != null) { if (alMasters.Count != 3) { throw new Exception("Masters for objective findings are not set OR there was a technical problem fetching them"); } else { List <chmodel.ObjectiveFinding> lstName = (List <chmodel.ObjectiveFinding>)alMasters[0]; List <chmodel.ObjectiveFinding> lstLocation = (List <chmodel.ObjectiveFinding>)alMasters[1]; tblMatrix.Columns.Add("Name"); foreach (chmodel.ObjectiveFinding of in lstLocation) { tblMatrix.Columns.Add(of.Location); } foreach (chmodel.ObjectiveFinding of in lstName) { DataRow row = tblMatrix.NewRow(); row["Name"] = of.Name; tblMatrix.Rows.Add(row); tblMatrix.AcceptChanges(); } } } if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { string szFindings = ds.Tables[0].Rows[0]["sz_objective_findings"].ToString(); string[] arrFinding = szFindings.Split(','); DataTable tblIntersect = (DataTable)alMasters[2]; for (int i = 0; i < arrFinding.Length; i++) { if (arrFinding[i] != "") { DataRow[] drLookup = tblIntersect.Select("ID = " + arrFinding[i]); if (drLookup != null && drLookup.Length > 0) { string szName = drLookup[0]["sz_objective_findings_name"].ToString(); string szLocation = drLookup[0]["sz_objective_findings_location_name"].ToString(); DataRow[] drFound = tblMatrix.Select("Name = '" + szName + "'"); int iNameIndex = tblMatrix.Rows.IndexOf(drFound[0]); int iLocationIndex = tblMatrix.Columns[szLocation].Ordinal; tblMatrix.Rows[iNameIndex][iLocationIndex] = "1"; } } } } } finally { if (connection != null) { if (connection.State == ConnectionState.Open) { connection.Close(); } } } return(tblMatrix); }