public datasethas GetAlert(int aid)
{
datasethasTableAdapters.alertTableAdapter alertTableAdapter = new datasethasTableAdapters.alertTableAdapter();
datasethas hasData = new datasethas();
alertTableAdapter.FillAlertById(hasData.alert, aid);
return(hasData);
}
public datasethas GetAlertClassAndStudentsByAlertId(int aid)
{
datasethasTableAdapters.alertTableAdapter alertTableAdapter = new datasethasTableAdapters.alertTableAdapter();
datasethasTableAdapters.studentTableAdapter studentTableAdapter = new datasethasTableAdapters.studentTableAdapter();
datasethasTableAdapters.classTableAdapter classTableAdapter = new datasethasTableAdapters.classTableAdapter();
datasethas hasData = new datasethas();
alertTableAdapter.FillAlertById(hasData.alert, aid);
classTableAdapter.FillByClassId(hasData._class, hasData.alert[0].classid);
studentTableAdapter.FillStudentsByAlertId(hasData.student, aid);
return(hasData);
}
internal void UpdateAlertStatus(int aid)
{
datasethasTableAdapters.alertTableAdapter alertTableAdapter = new datasethasTableAdapters.alertTableAdapter();
alertTableAdapter.UpdateQueryAlertSent(DateTime.Now, aid);
}
