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