public IActionResult Update(SessionAttendanceModel item)
{
using (MySqlConnection connection = new MySqlConnection(defaultConnection))
{
IEnumerable <SessionAttendanceModel> output = connection.Query <SessionAttendanceModel>("UPDATE SessionAttendance SET rsvpCheckin = @_rsvpCheckin WHERE sessionID = @_sessionID AND userID = @_userID", new { _sessionAttendanceID = item.sessionAttendanceID, _sessionID = item.sessionID, _userID = item.userID, _rsvpCheckin = item.rsvpCheckin });
return(NoContent());
}
}
public IActionResult Create(SessionAttendanceModel item)
{
using (MySqlConnection connection = new MySqlConnection(defaultConnection))
{
IEnumerable <SessionAttendanceModel> output = connection.Query <SessionAttendanceModel>("INSERT INTO SessionAttendance (sessionID, userID, rsvpCheckin) VALUES ((@_sessionID), (@_userID), (@_rsvpCheckin))", new { _sessionID = item.sessionID, _userID = item.userID, _rsvpCheckin = item.rsvpCheckin });
return(NoContent());
}
}
