public List<string> GetExistingComputraceIds(SqlConnection conn)
{
ConsoleMessage(InsertStatus.Info, "Retrieving Existing Computrace IDs");
var rep = new LojackEntryRepository(new LojackContext());
var existingComputraceIDs = rep.GetExistingComputraceIds();
ConsoleMessage(InsertStatus.Info, "Done retrieving Existing Computrace IDs");
return existingComputraceIDs;
}
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 void GetExistingComputraceIdsFromRepositoryTest()
{
var rep = new LojackEntryRepository(new LojackContext());
var ids = rep.GetExistingComputraceIds();
Assert.IsTrue(ids.Any());
}
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;
}
}
