public void InsertUpdateToDbTests_ShouldInsertUpdateInboundEmailsToDb() { foreach (List <string> emailX in InboundEmailsList) { string fileName = emailX[0]; string subject = emailX[1]; string emailUsername = emailX[2]; string response = emailX[3]; string responseDate = emailX[4]; string phase = emailX[5]; CreateEntryInboundStrEmails(fileName, emailUsername, "InboundStrEmails", subject, response, responseDate, phase); } foreach (List <string> emailX in OutboundEmailsList) { string fileName = emailX[0]; string subject = emailX[1]; string emailUsername = emailX[2]; string sentDate = emailX[3]; string phase = emailX[4]; CreateEntryOutboundStrEmails(fileName, emailUsername, "OutboundStrEmails", subject, sentDate, phase); } MyDbUtils muForRead = new MyDbUtils(this.DbPath); long actualCount = muForRead.CountEntries("InboundStrEmails"); long expectedCount = 11; Assert.Equal(expectedCount, actualCount); }
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 InsertToDbTests_ShouldInsertInboundEmailsToDb() { foreach (List <string> emailX in InboundEmailsList) { string fileName = emailX[0]; string subject = emailX[1]; string emailUsername = emailX[2]; string response = emailX[3]; string responseDate = emailX[4]; InboundStrEmailsHandler iSEHandler = new InboundStrEmailsHandler(this.DbPath, fileName, subject, emailUsername, response, responseDate); iSEHandler.InsertToDb(); } MyDbUtils muForRead = new MyDbUtils(this.DbPath); long actualCount = muForRead.CountEntries("InboundStrEmails"); long expectedCount = 12; Assert.Equal(expectedCount, actualCount); }
private void CreateEntryInboundStrEmails(string FileName, string EmailUsername, string TABLE_NAME, string Subject, string Response, string ResponseDate, string Phase) { Dictionary <string, string> criteriaX = new Dictionary <string, string>() { ["FileName"] = FileName, ["EmailUsername"] = EmailUsername, }; MyDbUtils mduForCount = new MyDbUtils(this.DbPath); long resultCount = mduForCount.CountEntries(TABLE_NAME, criteriaX); if (resultCount < 1) { Dictionary <string, string> recordsX = new Dictionary <string, string>() { ["FileName"] = FileName, ["Subject"] = Subject, ["EmailUsername"] = EmailUsername, ["Response"] = Response, ["ResponseDate"] = ResponseDate, ["Phase"] = Phase }; MyDbUtils mdu = new MyDbUtils(this.DbPath); mdu.CreateEntry(TABLE_NAME, recordsX); } else { Dictionary <string, string> recordsX = new Dictionary <string, string>() { ["Subject"] = Subject, ["Response"] = Response, ["ResponseDate"] = ResponseDate, ["Phase"] = Phase }; MyDbUtils mduForUpdate = new MyDbUtils(this.DbPath); mduForUpdate.UpdateEntry(TABLE_NAME, criteriaX, recordsX); } }