public IActionResult Index([FromHeader] string sendJson)
{
ViewBag.Active = "Checkin";
List <Checkin> checkins = CheckinDBConnector.GetCheckins(Constants.DATA_SOURCE);
List <User> nonCheckedinUsers = CheckinDBConnector.GetNonCheckedinUsers(Constants.DATA_SOURCE);
UserCheckinInfo model = new UserCheckinInfo(checkins, nonCheckedinUsers);
return(sendJson != null && sendJson.Equals("True") ? Json(model) : (IActionResult)View(model));
}
public void TestCheckedinUsers()
{
List <Checkin> checkins = CheckinDBConnector.GetCheckins(dataSource);
Assert.NotNull(checkins);
Assert.NotNull(checkins[0].participant);
Assert.NotNull(checkins[0].admin);
Assert.Equal("*****@*****.**", checkins[0].participant.Username);
Assert.Equal("*****@*****.**", checkins[0].admin.Username);
}
public void TestNonCheckedinUsers()
{
List <User> users = CheckinDBConnector.GetNonCheckedinUsers(dataSource);
Assert.NotNull(users);
Assert.Equal(4, users.Count);
Assert.Equal("*****@*****.**", users[0].Username);
Assert.Equal("*****@*****.**", users[1].Username);
Assert.Equal("*****@*****.**", users[2].Username);
Assert.Equal("*****@*****.**", users[3].Username);
}
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"));
}
