public void AddNewTable_InsertTableToEmptyDatabase()
{
var options = new DbContextOptionsBuilder <AppDbContext>().UseInMemoryDatabase("DatabaseForTesting").Options;
using (var context = new AppDbContext(options))
{
//Arrange
TableRepository tableRepository = new TableRepository(context);
MembersRepository memberRepository = new MembersRepository(context);
NewTableViewModel model = new NewTableViewModel();
model.TableName = "NewGroup";
model.NumberOfMembers = 3;
model.Names = new HashSet <string>()
{
"Adam", "Wiktor", "Piotr"
};
//Act
tableRepository.AddNewTable(model);
var data = tableRepository.GetTables();
var members = memberRepository.GetAllMembers(data[0].TableInfoId).ToList();
//Assert
Assert.AreEqual(1, data.Count);
Assert.IsNotNull(data);
Assert.AreEqual("NewGroup", data[0].TableName);
Assert.AreEqual(1, data[0].TableInfoId);
Assert.AreEqual(3, members.Count);
Assert.AreEqual("Adam", members[0].Name);
}
}
private void Fines_Click(object sender, EventArgs e)
{
try
{
List <Borrowed> borroweds = borrowedRepo.GetAllBorroweds();
DateTime now = DateTime.Now;
long value = 10000;
foreach (var item in borroweds)
{
//item.fines =
borrowedRepo.EvalFine(now, value);
}
//context.SaveChangesForBorroweds(borroweds);
List <Members> members = membersRepo.GetAllMembers();
var results = (from book in borroweds
join member in members on book.MemberId equals member.MemberId where book.fines > 0
select new
{
کدملی = member.NationalCode,
جریمه = book.fines
}).ToList();
dataGridStorageOfBooks.DataSource = results;
}
catch (Exception)
{
}
}
public void AddNewTable_InsertTableToDatabaseWithData()
{
var options = new DbContextOptionsBuilder <AppDbContext>().UseInMemoryDatabase("DatabaseForTesting2").Options;
using (var context = new AppDbContext(options))
{
//Arrange
TableRepository tableRepository = new TableRepository(context);
MembersRepository memberRepository = new MembersRepository(context);
context.Tables.Add(new TableInfo()
{
TableInfoId = 1,
TableName = "NewGroup",
Members = new List <MembersInfo>()
{
new MembersInfo {
Name = "Adam", MembersInfoId = 1, TableNumber = 1
},
new MembersInfo {
Name = "Wiktor", MembersInfoId = 2, TableNumber = 1
}
}
});
context.Tables.Add(new TableInfo()
{
TableInfoId = 3,
TableName = "NewGroup",
Members = new List <MembersInfo>()
{
new MembersInfo {
Name = "Adam", MembersInfoId = 5, TableNumber = 3
},
new MembersInfo {
Name = "Wiktor", MembersInfoId = 6, TableNumber = 3
}
}
});
context.SaveChanges();
NewTableViewModel model = new NewTableViewModel();
model.TableName = "Misiaki";
model.NumberOfMembers = 3;
model.Names = new HashSet <string>()
{
"Heniek", "Olgierd", "Piotr"
};
//Act
tableRepository.AddNewTable(model);
var data = tableRepository.GetTables();
var table = data.First(a => a.TableName == "Misiaki");
var members = memberRepository.GetAllMembers(table.TableInfoId).ToList();
var heniek = members.First(a => a.Name == "Heniek");
//Assert
Assert.AreEqual(3, data.Count);
Assert.IsNotNull(data);
Assert.AreEqual(4, table.TableInfoId);
Assert.AreEqual("Misiaki", table.TableName);
Assert.AreEqual(3, table.Members.Count);
Assert.AreEqual(3, members.Count);
Assert.AreEqual("Heniek", heniek.Name);
Assert.AreEqual(7, heniek.MembersInfoId);
Assert.AreEqual(4, heniek.TableNumber);
}
}