public List <MedicalCondition> GetList(int PersonId)
{
List <MedicalCondition> mecicalConditions = new List <MedicalCondition>();
DataTable dt = dbc.GetDataTable("SELECT * FROM vw_StudentMedicalConditions WHERE StudentId=" + PersonId);
dbc.CloseConnection();
foreach (DataRow dr in dt.Rows)
{
MedicalCondition mc = new MedicalCondition();
mc.StudentMedicalConditionId = (int)dr["StudentMedicalConditionId"];
mc.StudentId = (int)dr["StudentId"];
mc.MedicalConditionName = dr["MedicalCondition"].ToString();
if (dr["Description"].ToString() != string.Empty)
{
mc.Description = dr["Description"].ToString();
}
else
{
mc.Description = "** please update **";
}
if (dr["DegreeOfDisability"].ToString() != string.Empty)
{
mc.DegreeOfDisability = dr["DegreeOfDisability"].ToString();
}
else
{
mc.DegreeOfDisability = "** please update **";
}
mc.Comments = dr["Comments"].ToString();
mecicalConditions.Add(mc);
}
return(mecicalConditions);
}
public void Add(MedicalCondition mc, int StudentId)
{
CommonFunctions.UpdateApostrophe(mc);
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO STUDENTMEDICALCONDITION (MedicalCondition,DegreeOfDisability,Description,Comments,StudentId) VALUES (");
sb.Append("'" + mc.MedicalConditionName.Trim() + "'");
sb.Append(",'" + mc.DegreeOfDisability.Trim() + "'");
sb.Append(",'" + mc.Description.Trim() + "'");
if (mc.Comments != null && mc.Comments != string.Empty)
{
sb.Append(",'" + mc.Comments + "'");
}
else
{
sb.Append(",null");
}
sb.Append("," + StudentId + ")");
string sql = sb.ToString();
dbc.ExecuteCommand(sql);
}
public void Update(MedicalCondition mc)
{
CommonFunctions.UpdateApostrophe(mc);
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE STUDENTMEDICALCONDITION SET ");
sb.Append("MedicalCondition='" + mc.MedicalConditionName.Trim() + "' ");
sb.Append(",DegreeOfDisability='" + mc.DegreeOfDisability.Trim() + "' ");
sb.Append(",Description='" + mc.Description.Trim() + "' ");
if (mc.Comments != null && mc.Comments != string.Empty)
{
sb.Append(",Comments='" + mc.Comments.Trim() + "' ");
}
else
{
sb.Append(",Comments=null ");
}
sb.Append("WHERE StudentMedicalConditionId =" + mc.StudentMedicalConditionId);
string sql = sb.ToString();
dbc.ExecuteCommand(sql);
}