private LocomotiveDetails BuildDB(HtmlTableExtractLoco table, string uri)
{
var db = new LocomotiveDetails(table, uri);
db.Save();
return(db);
}
public void Init()
{
var files = Directory.GetFiles(_outputFolder, "*.xml", SearchOption.AllDirectories);
foreach (var file in files)
{
var ldbf = LocomotiveDetails.Load(file);
_locomotiveDetails.Add(ldbf);
}
}
public LocomotiveDetails ReadFullDetails(int identifier)
{
LocomotiveDetails locoDetails = new LocomotiveDetails();
using (var context = new RailwaysContextEF())
{
context.Database.Log = Console.WriteLine;
/* execute custom stored procedure, result set mapped to locomotivedetails entity */
var locoDetailsListOf = context.LocomotiveDetailsEF.SqlQuery("LocomotiveDetailsALL").ToList();
locoDetails = locoDetailsListOf.Single(x => x.LocoId == identifier);
}
return(locoDetails);
}
public void Add(LocomotiveDetails locomotiveDetails)
{
_locomotiveDetails.Add(locomotiveDetails);
}
