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