public void TestDeleteToSql()
{
string sql = "";
var room = new ConferenceRoom { Id = 1, Size = 10 };
roomMock.Setup(x => x.ExecuteQuery(It.IsAny<string>())).Callback((string s) => sql = s);
crud.Delete(room);
Assert.AreEqual("DELETE FROM ConferenceRoom WHERE Id = 1;", sql);
}
public void TestCreateToSql()
{
string sql = "";
var room = new ConferenceRoom { Id = 1, Size = 10 };
roomMock.Setup(x => x.ExecuteQuery(It.IsAny<string>())).Callback((string s) => sql = s);
crud.Create(room);
Assert.AreEqual("INSERT INTO ConferenceRoom (Id, Capacity) VALUES (1, 10);", sql);
}
public void TestGetName()
{
ConferenceRoom room = new ConferenceRoom();
room.Id = 1;
Assert.AreEqual("Mødelokale 1", room.Name);
}
public void TestUpdateToSql()
{
string sql = "";
var room = new ConferenceRoom { Id = 1, Size = 10 };
roomMock.Setup(x => x.ExecuteQuery(It.IsAny<string>())).Callback((string s) => sql = s);
crud.Update(room);
Assert.AreEqual("UPDATE ConferenceRoom SET Capacity = 10 WHERE Id = 1;", sql);
}
private IEnumerable<Room> ParseToRoom(IEnumerable<IEnumerable<object>> objectToParse)
{
foreach (var row in objectToParse)
{
Room room = new ConferenceRoom();
room.Id = Convert.ToInt32(row.ElementAt(0));
room.Size = Convert.ToInt32(row.ElementAt(1));
foreach (var e in equipmentCrud.Read(room))
{
room.Equipments.Add(e);
equipmentCrud.Update(e, room);
}
yield return room;
}
}
