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 AddCursusInstantie()
{
using (var repo = new CursusInstantieRepository(new DatabaseContext(_options)))
{
repo.Insert(new CursusInstantie()
{
CursusId = "C1",
StartDatum = new DateTime(2016, 10, 15),
Cursus = new Cursus()
{
Code = "C1",
Dagen = 3,
Titel = "Cursus1"
}
});
}
using (var repo = new CursusInstantieRepository(new DatabaseContext(_options)))
{
var result = repo.Find(1);
Assert.AreEqual(1, repo.Count());
Assert.AreEqual("C1", result.CursusId);
Assert.AreEqual(new DateTime(2016, 10, 15), result.StartDatum);
}
}
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);
}
}
public void TestFindAllCursusInstantie()
{
using (var repo = new CursusInstantieRepository(new DatabaseContext(_options)))
{
repo.Insert(new CursusInstantie()
{
CursusId = "C1",
StartDatum = new DateTime(2016, 10, 15),
});
repo.Insert(new CursusInstantie()
{
CursusId = "C2",
StartDatum = new DateTime(2016, 10, 15),
});
}
using (var repo = new CursusInstantieRepository(new DatabaseContext(_options)))
{
Assert.AreEqual(2, repo.Count());
}
}
public void TestMethod1()
{
//Arrange
var testData = GetCursusInstantieList(3);
var dbSetMock = new Mock <DbSet <CursusInstantie> >();
dbSetMock.As <IQueryable <CursusInstantie> >().Setup(s => s.Provider).Returns(testData.AsQueryable().Provider);
dbSetMock.As <IQueryable <CursusInstantie> >().Setup(s => s.Expression).Returns(testData.AsQueryable().Expression);
dbSetMock.As <IQueryable <CursusInstantie> >().Setup(s => s.ElementType).Returns(testData.AsQueryable().ElementType);
dbSetMock.As <IQueryable <CursusInstantie> >().Setup(s => s.GetEnumerator()).Returns(testData.AsQueryable().GetEnumerator());
var context = new Mock <CursusAdminContext>();
context.Setup(s => s.Set <CursusInstantie>()).Returns(dbSetMock.Object);
//Act
var repository = new CursusInstantieRepository(context.Object);
var result = repository.GetAllCursusInstanties();
//Assert
CollectionAssert.AreEqual(testData, result.ToList());
}
public void TestFindCursusInstantie()
{
using (var repo = new CursusInstantieRepository(new DatabaseContext(_options)))
{
repo.Insert(new CursusInstantie()
{
CursusId = "C1",
StartDatum = new DateTime(2016, 10, 15),
});
repo.Insert(new CursusInstantie()
{
CursusId = "C2",
StartDatum = new DateTime(2016, 10, 15),
});
}
using (var repo = new CursusInstantieRepository(new DatabaseContext(_options)))
{
var result = repo.Find(1);
Assert.AreEqual(1, result.Id);
Assert.AreEqual("C1", result.CursusId);
Assert.AreEqual(new DateTime(2016, 10, 15), result.StartDatum);
}
}
