public void UpdateAttendance(Attendance attendance)
{
using (var sqlConnection = GetSqlConnection())
{
string sql = "UPDATE Attendance SET blnConfirmed = @blnConfirmed WHERE intAttendanceId = @intAttendanceId";
sqlConnection.Execute(sql, attendance);
}
}
public Attendance GetAttendance(Attendance attendance)
{
Attendance existingAttendance;
using (var sqlConnection = GetSqlConnection())
{
attendance.DtmAttendanceDate = attendance.DtmAttendanceDate.Date;
string sql = "SELECT * FROM Attendance where intDivisionId = @intDivisionId and dtmAttendanceDate = @dtmAttendanceDate";
existingAttendance = sqlConnection.Query<Attendance>(sql, attendance).SingleOrDefault();
}
return existingAttendance;
}
public int CreateAttendance(Attendance attendance)
{
int attendanceId;
using (var sqlConnection = GetSqlConnection())
{
attendance.DtmAttendanceDate = attendance.DtmAttendanceDate.Date;
string sql = "INSERT INTO Attendance (varName, dtmAttendanceDate, intDivisionId, blnConfirmed) VALUES (@varName, @dtmAttendanceDate, @intDivisionId, @blnConfirmed); SELECT @@IDENTITY";
attendanceId = sqlConnection.Query<int>(sql, attendance).Single();
}
return attendanceId;
}
