public void TestFind()
{
using (var repo = new CursusRepository(new DatabaseContext(_options)))
{
//Arrange
var cursus = new Cursus()
{
Cursuscode = "test",
Duur = 5,
Titel = "Name"
};
var cursusInstantie = new CursusInstantie()
{
Startdatum = new DateTime(2016, 10, 10),
Cursus = cursus
};
//Act
repo.Insert(cursusInstantie);
var res = repo.Find(1);
}
using (var repo = new CursusRepository(new DatabaseContext(_options)))
{
//Assert
var result = repo.Find(1);
Assert.AreEqual("test", result.Cursus.Cursuscode);
Assert.AreEqual(5, result.Cursus.Duur);
Assert.AreEqual("Name", result.Cursus.Titel);
}
}
public void TestCount()
{
// Arrange
using (var repo = new CursusRepository(new DatabaseContext(_options)))
{
// Act
repo.Insert(new Cursus()
{
Id = 1,
CursusCode = "Naam"
});
repo.Insert(new Cursus()
{
Id = 2,
CursusCode = "Andere naam"
});
repo.Insert(new Cursus()
{
Id = 3,
CursusCode = "Nieuwere naam"
});
repo.Insert(new Cursus()
{
Id = 4,
CursusCode = "Laatste naam"
});
}
// Assert
using (var repo = new CursusRepository(new DatabaseContext(_options)))
{
Assert.AreEqual(4, repo.Count());
}
}
public void TestFindBy3()
{
// Arrange
var result = new List <Cursus>();
using (var repo = new CursusRepository(new DatabaseContext(_options)))
{
// Act
repo.Insert(new Cursus {
Id = 1, Title = "C# Programmeren", AmountOfDays = 2, StartDate = new DateTime(2016, 5, 2)
});
repo.Insert(new Cursus {
Id = 3, Title = "C# Hands-on", AmountOfDays = 5, StartDate = new DateTime(2016, 5, 4)
});
repo.Insert(new Cursus {
Id = 2, Title = "Advanced C#", AmountOfDays = 3, StartDate = new DateTime(2016, 5, 3)
});
result.Add(repo.FindBy(x => x.Id == 1).FirstOrDefault());
}
// Assert
using (var repo = new CursusRepository(new DatabaseContext(_options)))
{
Assert.AreNotEqual(null, result);
Assert.AreEqual(1, result.First().Id);
}
}
public void TestFindAllCursuses()
{
using (var repo = new CursusRepository(new DatabaseContext(_options)))
{
var cursus = new Cursus()
{
Titel = "Cursus1",
Code = "C1",
Dagen = 3,
};
repo.Insert(cursus);
cursus = new Cursus()
{
Titel = "Cursus2",
Code = "C2",
Dagen = 3,
};
repo.Insert(cursus);
}
using (var repo = new CursusRepository(new DatabaseContext(_options)))
{
Assert.AreEqual(2, repo.Count());
}
}
public void TestAdd()
{
using (var repo = new CursusRepository(new DatabaseContext(_options)))
{
//Arrange
var cursus = new Cursus()
{
Cursuscode = "test",
Duur = 5,
Titel = "Name"
};
var cursusInstantie = new CursusInstantie()
{
Startdatum = new DateTime(2016, 10, 10),
Cursus = cursus
};
//Act
repo.Insert(cursusInstantie);
}
using (var repo = new CursusRepository(new DatabaseContext(_options)))
{
Assert.AreEqual(1, repo.Count());
}
}
public void VoegMeerdereCursusInstantiesVindSlechts1ContentCheckNonSame()
{
using (var repo = new CursusRepository(new DatabaseContext(_options)))
{
//Arrange
var cursus = new Cursus()
{
Cursuscode = "test",
Duur = 5,
Titel = "C# testing"
};
var cursusInstantie = new CursusInstantie()
{
Startdatum = new DateTime(2016, 10, 15),
Cursus = cursus
};
repo.Insert(cursusInstantie);
var cursusInstantie2 = new CursusInstantie()
{
Startdatum = new DateTime(2016, 3, 10),
Cursus = cursus
};
repo.Insert(cursusInstantie2);
DateTime targetDateStart = new DateTime(2016, 10, 10);
DateTime targetDateEind = new DateTime(2016, 10, 17);
//Act
var result = repo.FindBy(c => c.Startdatum >= targetDateStart && c.Startdatum < targetDateEind);
//Assert
Assert.AreEqual(targetDateStart.AddDays(5), result.First().Startdatum);
}
}
public void AddRangeMetCheckOpNietBestaandeCursusEnAutomatischToevoegenCursusInstantie()
{
using (var repo = new CursusInstantieRepository(new DatabaseContext(_options)))
{
repo.InsertRange(new List <CursusInstantie>()
{
new CursusInstantie()
{
CursusId = "C1",
StartDatum = new DateTime(2016, 10, 15),
Cursus = new Cursus()
{
Code = "C1",
Dagen = 2,
Titel = "Cursus 1"
},
},
new CursusInstantie()
{
CursusId = "C1",
StartDatum = new DateTime(2016, 11, 15),
Cursus = new Cursus()
{
Code = "C1",
Dagen = 2,
Titel = "Cursus 1"
},
},
});
}
using (var repo = new CursusInstantieRepository(new DatabaseContext(_options)))
{
var result = repo.FindAll();
Assert.AreEqual(2, repo.Count());
}
using (var repo = new CursusRepository(new DatabaseContext(_options)))
{
var result = repo.Find("C1");
Assert.AreEqual(1, repo.Count());
Assert.AreEqual(2, result.Dagen);
Assert.AreEqual("Cursus 1", result.Titel);
Assert.AreEqual("C1", result.Code);
}
}
public void TestAddCursus()
{
using (var repo = new CursusRepository(new DatabaseContext(_options)))
{
repo.Insert(new Cursus()
{
Titel = "Cursus1",
Code = "C1",
Dagen = 3,
});
}
using (var repo = new CursusRepository(new DatabaseContext(_options)))
{
Assert.AreEqual(1, repo.Count());
}
}
public void TestAdd()
{
// Arrange
using (var repo = new CursusRepository(new DatabaseContext(_options)))
{
// Act
repo.Insert(new Cursus()
{
Id = 1,
CursusCode = "Naam"
});
}
// Assert
using (var repo = new CursusRepository(new DatabaseContext(_options)))
{
Assert.AreEqual(1, repo.Count());
}
}
public void TestDeleteCursus()
{
using (var repo = new CursusRepository(new DatabaseContext(_options)))
{
var pen = new Inschrijving()
{
Titel = "Cursus1",
Code = "C1",
Dagen = 3,
};
repo.Insert(pen);
repo.Delete("C1");
}
using (var repo = new CursusRepository(new DatabaseContext(_options)))
{
Assert.AreEqual(0, repo.Count());
}
}
public void TestFindCursus()
{
using (var repo = new CursusRepository(new DatabaseContext(_options)))
{
repo.Insert(new Cursus()
{
Titel = "Cursus1",
Code = "C1",
Dagen = 3,
});
}
using (var repo = new CursusRepository(new DatabaseContext(_options)))
{
var result = repo.Find("C1");
Assert.AreEqual("C1", result.Code);
Assert.AreEqual("Cursus1", result.Titel);
Assert.AreEqual("C1", result.Code);
Assert.AreEqual(3, result.Dagen);
}
}
public void VoegMeerdereCursusInstantieToeMetAndereStartDatum()
{
using (var repo = new CursusRepository(new DatabaseContext(_options)))
{
//Arrange
var cursus = new Cursus()
{
Cursuscode = "test",
Duur = 5,
Titel = "C# testing"
};
var cursusInstantie = new CursusInstantie()
{
Startdatum = new DateTime(2016, 10, 10),
Cursus = cursus
};
//Act
repo.Insert(cursusInstantie);
//Assert
Assert.ThrowsException <DbUpdateException>(() => repo.Insert(cursusInstantie));
}
}
public void TestFindBy2()
{
// Arrange
using (var repo = new CursusRepository(new DatabaseContext(_options)))
{
// Act
repo.Insert(new Cursus {
Id = 1, Title = "C# Programmeren", AmountOfDays = 2, StartDate = new DateTime(2016, 5, 2)
});
repo.Insert(new Cursus {
Id = 3, Title = "C# Hands-on", AmountOfDays = 5, StartDate = new DateTime(2016, 5, 4)
});
repo.Insert(new Cursus {
Id = 2, Title = "Advanced C#", AmountOfDays = 3, StartDate = new DateTime(2016, 5, 3)
});
}
// Assert
using (var repo = new CursusRepository(new DatabaseContext(_options)))
{
Assert.AreEqual(2, repo.FindBy(x => x.Title.Contains("# ")).Count());
}
}
public void VoegMeerdereCursusInstantiesVindSlechts1()
{
using (var repo = new CursusRepository(new DatabaseContext(_options)))
{
//Arrange
var cursus = new Cursus()
{
Cursuscode = "test",
Duur = 5,
Titel = "C# testing"
};
var cursusInstantie = new CursusInstantie()
{
Startdatum = new DateTime(2016, 10, 10),
Cursus = cursus
};
repo.Insert(cursusInstantie);
var cursusInstantie2 = new CursusInstantie()
{
Startdatum = new DateTime(2016, 3, 10),
Cursus = cursus
};
repo.Insert(cursusInstantie2);
DateTime targetDateStart = new DateTime(2016, 10, 10);
DateTime targetDateEind = new DateTime(2016, 10, 10);
//Act
var result = repo.FindBy(c => c.Startdatum >= targetDateStart && c.Startdatum <= targetDateEind);
var resultTotaal = repo.FindAll();
//Assert
Assert.AreEqual(1, result.Count());
Assert.AreEqual(2, resultTotaal.Count());
}
}
public void CreateCursusTest()
{
// Arrange - We're mocking our dbSet & dbContext
// in-memory data
IQueryable <Cursus> cursussen = new List <Cursus>()
{
new Cursus()
{
Titel = "dotNET cursus",
Type = ".NET",
Prijs = 15.45,
Categorie = "Cursus",
IsBuyable = true,
Beschrijving = "Some example text some ...",
LangeBeschrijving = "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",
FotoURLCard = "https://52bec9fb483231ac1c712343-jebebgcvzf.stackpathdns.com/wp-content/uploads/2016/05/dotnet.jpg",
OrderNumber = 1
},
new Cursus()
{
Titel = "dotNET cursus 2",
Type = ".NET",
Prijs = 18.45,
IsBuyable = true,
Beschrijving = "Some example text some ...",
Categorie = "Cursus",
LangeBeschrijving = "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",
FotoURLCard = "https://52bec9fb483231ac1c712343-jebebgcvzf.stackpathdns.com/wp-content/uploads/2016/05/dotnet.jpg",
OrderNumber = 2
}
}.AsQueryable();
var mockSet = new Mock <DbSet <Cursus> >();
mockSet.As <IQueryable <Cursus> >().Setup(m => m.Provider).Returns(cursussen.Provider);
mockSet.As <IQueryable <Cursus> >().Setup(m => m.Expression).Returns(cursussen.Expression);
mockSet.As <IQueryable <Cursus> >().Setup(m => m.ElementType).Returns(cursussen.ElementType);
mockSet.As <IQueryable <Cursus> >().Setup(m => m.GetEnumerator()).Returns(cursussen.GetEnumerator());
var cursus = new Cursus()
{
Titel = "dotNET cursus 2",
Type = ".NET",
Prijs = 18.45,
IsBuyable = true,
Beschrijving = "Some example text some ...",
Categorie = "Cursus",
LangeBeschrijving = "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",
FotoURLCard = "https://52bec9fb483231ac1c712343-jebebgcvzf.stackpathdns.com/wp-content/uploads/2016/05/dotnet.jpg"
};
var mockContext = new Mock <DatabaseContext>();
mockContext.Setup(m => m.Cursussen).Returns(mockSet.Object);
var repo = new CursusRepository(mockContext.Object, contextFilter);
repo.AddCursus(cursus);
// Assert
mockSet.Verify(m => m.Add(It.IsAny <Cursus>()), Times.Once);
}
