public void InsertToDbTest_ShouldInsertEntriesToOuboundStrEmails() { foreach (List <string> entryX in this.OutboundEmailsList) { string fileName = entryX[0]; string subject = entryX[1]; string emailUsername = entryX[2]; string sentDate = entryX[3]; OutboundStrEmailsHandler outH = new OutboundStrEmailsHandler(this.DbPath, fileName, subject, emailUsername, sentDate); outH.InsertToDb(); } MyDbUtils muForRead = new MyDbUtils(this.DbPath); long actualCount = muForRead.CountEntries("OutboundStrEmails"); long expectedCount = 3; Assert.Equal(expectedCount, actualCount); }
public void LoadPhaseXFromDb_ShouldLoadEntriesViaGivenPhase() { foreach (List <string> entryX in this.OutboundEmailsList) { string fileName = entryX[0]; string subject = entryX[1]; string emailUsername = entryX[2]; string sentDate = entryX[3]; OutboundStrEmailsHandler outH = new OutboundStrEmailsHandler(this.DbPath, fileName, subject, emailUsername, sentDate); outH.InsertToDb(); } OutboundStrEmailsHandler outH2 = new OutboundStrEmailsHandler(this.DbPath); DataTable dtX = outH2.LoadPhaseXFromDb("PHASE1"); long expectedCount = 2; long actualCount = (long)dtX.Rows.Count; Assert.Equal(expectedCount, actualCount); }