public void InsertLojackEntryTest() { var rep = new LojackEntryRepository(new LojackContext()); var entry = new LojackEntry { computracefile = "78439", AgencyName = "", DateReportedToABT = DateTime.Now, Make = "Compaq Impresario", Model = "Dell", StolenDate = DateTime.Now, ReportedSerialNumber = "73849875" }; var record = rep.Insert(entry); Assert.IsTrue(record.lojackentryid > 0); }
public int InsertRecords(List<string> blacklistedSerials, LojackImportFileRecord importRecord, int counter) { using (var db = new LojackContext()) { DateTime date; var rep = new LojackEntryRepository(db); var lojack = new LojackEntry { computracefile = importRecord.CompuTraceFile, AgencyName = importRecord.AgencyName, DateReportedToABT = DateTime.TryParse(importRecord.DateReportedToAbt, out date) ? date : (DateTime?)null, Make = importRecord.Make.Length > 30 ? importRecord.Make.Remove(30) : importRecord.Make, Model = importRecord.Model.Length > 30 ? importRecord.Model.Remove(30) : importRecord.Model, StolenDate = DateTime.TryParse(importRecord.StolenDate, out date) ? date : (DateTime?)null }; if (importRecord.SerialNumber2 == importRecord.SerialNumber1 || importRecord.SerialNumber2 == importRecord.SerialNumber3) importRecord.SerialNumber2 = String.Empty; if (importRecord.SerialNumber3 == importRecord.SerialNumber1 || importRecord.SerialNumber3 == importRecord.SerialNumber2) importRecord.SerialNumber3 = String.Empty; int success = 0; for (int i = 1; i < 4; i++) { string serialNo = String.Empty; if (i == 1) serialNo = importRecord.SerialNumber1; if (i == 2) serialNo = importRecord.SerialNumber2; if (i == 3) serialNo = importRecord.SerialNumber3; if (!String.IsNullOrEmpty(serialNo) && !blacklistedSerials.Contains(serialNo)) { lojack.ReportedSerialNumber = serialNo; try { rep.Insert(lojack); ConsoleInsertSuccessMessage(counter + 1, lojack.computracefile, lojack.ReportedSerialNumber); success++; } catch (Exception) { ConsoleInsertFailureMessage(counter, lojack.computracefile, lojack.ReportedSerialNumber); } } } return success; } }