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