public void TestUserCheckin() { Assert.True(CheckinDBConnector.Checkin(dataSource, "*****@*****.**", "*****@*****.**")); //Code to cleanup the tables so that the test case would run successfully the next time. string checkinDelete = "DELETE FROM Checkin WHERE user = '******' AND admin = '*****@*****.**'"; string userRoleDelete = "DELETE FROM AspNetUserRoles WHERE UserId = 7 AND RoleId = 2"; using (SqliteConnection conn = new SqliteConnection(dataSource)) { conn.Open(); SqliteCommand deleteSQL = new SqliteCommand(checkinDelete, conn); try { deleteSQL.ExecuteNonQuery(); } catch (Exception ex) { Console.WriteLine(ex.Message); } deleteSQL = new SqliteCommand(userRoleDelete, conn); try { deleteSQL.ExecuteNonQuery(); } catch (Exception ex) { Console.WriteLine(ex.Message); } } }
public IActionResult CheckinUser(User user) { CheckinDBConnector.Checkin(Constants.DATA_SOURCE, user.Username, User.Identity.Name); return(Redirect("/Checkin")); }