public void Add(StudentMedicalConditionAlertBase smca, int StudentId) { CommonFunctions.UpdateApostrophe(smca); StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO StudentMedicalConditionAlert (Definition,Description,Comments,StudentId,MedicalTypeAlertTypeId) VALUES ("); sb.Append("'" + smca.Definition.Trim() + "'"); sb.Append(",'" + smca.Description.Trim() + "'"); if (smca.Comments != null && smca.Comments != string.Empty) { sb.Append(",'" + smca.Comments + "'"); } else { sb.Append(",null"); } sb.Append("," + StudentId); sb.Append("," + smca.MedicalTypeAlertTypeId + ")"); string sql = sb.ToString(); dbc.ExecuteCommand(sql); }
public void Update(StudentMedicalConditionAlertBase smca) { CommonFunctions.UpdateApostrophe(smca); StringBuilder sb = new StringBuilder(); sb.Append("UPDATE StudentMedicalConditionAlert SET "); sb.Append("Definition='" + smca.Definition.Trim() + "' "); sb.Append(",Description='" + smca.Description.Trim() + "' "); if (smca.Comments != null && smca.Comments != string.Empty) { sb.Append(",Comments='" + smca.Comments.Trim() + "' "); } else { sb.Append(",Comments=null "); } sb.Append(",MedicalTypeAlertTypeId=" + smca.MedicalTypeAlertTypeId); sb.Append(" WHERE StudentMedicalConditionAlertId =" + smca.StudentMedicalConditionAlertId); string sql = sb.ToString(); dbc.ExecuteCommand(sql); }