public bool UpdateAttendance(AttendanceModel iList)
{
using (SqlConnection con = new SqlConnection(constring))
{
string query = "Update Attendance set ClassID =" + iList.Classes.ClassID + ", StudentID =" + iList.Students.StudentID + ",AttendanceDateTime = '" + iList.AttendanceDateTime + "' where AttendanceID = " + iList.AttendanceID;
using (SqlCommand cmd = new SqlCommand(query, con))
{
con.Open();
int i = cmd.ExecuteNonQuery();
if (i >= 1)
{
return(true);
}
else
{
return(false);
}
}
}
}
public bool InsertAttendance(AttendanceModel iList)
{
using (SqlConnection con = new SqlConnection(constring))
{
string query = "Insert Into Attendance(ClassID,StudentID,AttendanceDateTime) values(" + iList.Classes.ClassID + "," + iList.Students.StudentID + ",'" + iList.AttendanceDateTime + "')";
using (SqlCommand cmd = new SqlCommand(query, con))
{
con.Open();
int i = cmd.ExecuteNonQuery();
if (i >= 1)
{
return(true);
}
else
{
return(false);
}
}
}
}