public void AddRangeMetCheckOpAlBestaandeCombinatieCursusInstantie()
{
using (var repo = new CursusInstantieRepository(new DatabaseContext(_options)))
{
repo.InsertRange(new List <CursusInstantie>()
{
new CursusInstantie()
{
CursusId = "C1",
StartDatum = new DateTime(2016, 10, 15),
},
new CursusInstantie()
{
CursusId = "C1",
StartDatum = new DateTime(2016, 10, 15),
},
});
}
using (var repo = new CursusInstantieRepository(new DatabaseContext(_options)))
{
var result = repo.FindAll();
Assert.AreEqual(1, repo.Count());
}
}
public void AddRangeCursusInstantie()
{
int numberOfSavedChanges = 0;
using (var repo = new CursusInstantieRepository(new DatabaseContext(_options)))
{
numberOfSavedChanges = repo.InsertRange(new List <CursusInstantie>()
{
new CursusInstantie()
{
CursusId = "C1",
StartDatum = new DateTime(2016, 10, 15),
},
new CursusInstantie()
{
CursusId = "C2",
StartDatum = new DateTime(2016, 11, 15),
},
});
}
using (var repo = new CursusInstantieRepository(new DatabaseContext(_options)))
{
var result = repo.FindAll();
Assert.AreEqual(2, repo.Count());
Assert.AreEqual(2, numberOfSavedChanges);
}
}
public void TestFindByDatumRangeCursusInstantie()
{
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"
},
},
new CursusInstantie()
{
CursusId = "C1",
StartDatum = new DateTime(2016, 10, 12),
Cursus = new Cursus()
{
Code = "C1",
Dagen = 2,
Titel = "Cursus 1"
},
},
});
}
using (var repo = new CursusInstantieRepository(new DatabaseContext(_options)))
{
var startDate = new DateTime(2016, 10, 11);
var endDate = new DateTime(2016, 10, 17);
var result = repo.FindBy(instantie => instantie.StartDatum >= startDate && instantie.StartDatum <= endDate);
Assert.AreEqual(2, result.Count());
Assert.AreEqual(10, result.FirstOrDefault().StartDatum.Month);
Assert.IsTrue(result.FirstOrDefault().StartDatum.Day >= 11 && result.FirstOrDefault().StartDatum.Day <= 17);
}
}
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 TestFindByCursusInstantieMetCursus()
{
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 startDate = new DateTime(2016, 10, 11);
var endDate = new DateTime(2016, 10, 17);
var result = repo.FindBy(instantie => instantie.StartDatum >= startDate && instantie.StartDatum <= endDate)
.FirstOrDefault();
Assert.AreEqual("C1", result.CursusId);
Assert.AreEqual("C1", result.Cursus.Code);
Assert.AreEqual(2, result.Cursus.Dagen);
Assert.AreEqual("Cursus 1", result.Cursus.Titel);
Assert.AreEqual(new DateTime(2016, 10, 15), result.StartDatum);
}
}