public List <MedicationAndTreatment> GetList(int PersonId) { List <MedicationAndTreatment> medicationAndTreatment = new List <MedicationAndTreatment>(); DataTable dt = dbc.GetDataTable("SELECT * FROM vw_StudentMedicationAndTreatment WHERE StudentId=" + PersonId); dbc.CloseConnection(); foreach (DataRow dr in dt.Rows) { MedicationAndTreatment at = new MedicationAndTreatment(); at.StudentMedicationAndTreatmentId = (int)dr["StudentMedicationAndTreatmentId"]; at.StudentId = (int)dr["StudentId"]; at.Frequency = dr["Frequency"].ToString(); at.Medication = dr["Medication"].ToString(); if (dr["Description"].ToString() != string.Empty) { at.Description = dr["Description"].ToString(); } else { at.Description = "** please update **"; } at.Comments = dr["Comments"].ToString(); medicationAndTreatment.Add(at); } return(medicationAndTreatment); }
public void Add(MedicationAndTreatment mt, int StudentId) { CommonFunctions.UpdateApostrophe(mt); StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO StudentMedicationAndTreatment (Frequency,Medication,Description,Comments,StudentId) VALUES ("); sb.Append("'" + mt.Frequency.Trim() + "'"); sb.Append(",'" + mt.Medication.Trim() + "'"); sb.Append(",'" + mt.Description.Trim() + "'"); if (mt.Comments != null && mt.Comments != string.Empty) { sb.Append(",'" + mt.Comments + "'"); } else { sb.Append(",null"); } sb.Append("," + StudentId + ")"); string sql = sb.ToString(); dbc.ExecuteCommand(sql); }
public void Update(MedicationAndTreatment mt) { CommonFunctions.UpdateApostrophe(mt); StringBuilder sb = new StringBuilder(); sb.Append("UPDATE StudentMedicationAndTreatment SET "); sb.Append("Frequency='" + mt.Frequency.Trim() + "' "); sb.Append(",Medication='" + mt.Medication.Trim() + "' "); sb.Append(",Description='" + mt.Description.Trim() + "' "); if (mt.Comments != null && mt.Comments != string.Empty) { sb.Append(",Comments='" + mt.Comments.Trim() + "' "); } else { sb.Append(",Comments=null "); } sb.Append("WHERE StudentMedicationAndTreatmentId =" + mt.StudentMedicationAndTreatmentId); string sql = sb.ToString(); dbc.ExecuteCommand(sql); }