public int GetMaxStudentId()
{
datasethasTableAdapters.studentTableAdapter studentTableAdapter = new datasethasTableAdapters.studentTableAdapter();
datasethas hasData = new datasethas();
return(int.Parse(studentTableAdapter.GetMaxId().ToString()));
}
public datasethas GetStudentsByPidAndCid(int pid, int cid)
{
datasethasTableAdapters.studentTableAdapter studentTableAdapter = new datasethasTableAdapters.studentTableAdapter();
datasethas hasData = new datasethas();
studentTableAdapter.FillStudentsByByPidAndCid(hasData.student, pid, cid);
return(hasData);
}
public string GetStudentMail(int sid)
{
datasethasTableAdapters.studentTableAdapter studentTableAdapter = new datasethasTableAdapters.studentTableAdapter();
datasethas hasData = new datasethas();
studentTableAdapter.FillStudentByStudentId(hasData.student, sid);
return(hasData.student[0].email);
}
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);
}
