public void UpdateAttendence(Attendence attendence)
{
string updateQuery = "UPDATE Attendences " +
"SET Condition = '" + attendence.Condition + "', Date = '" + attendence.Date + "', StudentID = " + attendence.StudentID + ", TimetableID = " + attendence.TimetableID + " WHERE AttendenceID = " + attendence.AttendenceID + " ;";
ExecuteQuery(updateQuery);
}
public List <Attendence> GetAttendence()
{
string retriveStudentList = "SELECT TimeTableID, StudentID, Date, Condition FROM Attendence ;";
List <Attendence> attendenceList = new List <Attendence>();
SqlCommand cmd = new SqlCommand(retriveStudentList, con);
try
{
con.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.HasRows)
{
while (reader.Read())
{
Attendence attendence = new Attendence();
attendence.TimetableID = reader.GetInt32(0);
attendence.StudentID = reader.GetInt32(0);
attendence.Date = reader.GetDateTime(3).Date;
attendence.Condition = reader.GetString(4);
attendenceList.Add(attendence);
}
reader.NextResult();
}
con.Close();
}
return(attendenceList);
}
finally
{
con.Close();
}
}
public void CreateAttendence(Attendence attendence)
{
string createQuery = "INSERT INTO Attendences (StudentID, TimetableID, Date, Condition)" +
"VALUES('" + attendence.StudentID + "','" + attendence.TimetableID + "','" + attendence.Date.Date + "','" + attendence.Condition + "' )";
ExecuteQuery(createQuery);
}
public Attendence ReadAttendence(SqlDataReader reader)
{
Attendence attendence = new Attendence();
while (reader.Read())
{
attendence.AttendenceID = reader.GetInt32(0);
attendence.StudentID = reader.GetInt32(1);
attendence.TimetableID = reader.GetInt32(2);
attendence.Date = reader.GetDateTime(3).Date;
attendence.Condition = reader.GetString(4);
}
return(attendence);
}
