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);
}
