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