public static void setCurrentVehicle(int vehicleID)
{
//Get vehicle make / model
var context = new seleniumScrapeEntities();
globalMake = (from v in context.tblVehicles
where v.Vehicle_ID_Pk == vehicleID
select v.Vehicle_Make).First();
globalModel = (from db in context.tblVehicles
where db.Vehicle_ID_Pk == vehicleID
select db.Vehicle_Model).First();
//var makeList = makeQuery.ToList();
// IQueryable<string> modelQuery = from db in context.tblVehicles
// where db.Vehicle_ID_Pk == vehicleID
// select db.Vehicle_Model;
//var modelList = modelQuery.ToList();
// var vehicleData = new Vehicle()
// {
// vehicleMake = makeList[0],
// vehicleModel = modelList[0]
// };
}
public void SaveToDB(tblVehicle vehicle)
{
var ctx = new seleniumScrapeEntities();
ctx.tblVehicles.AddObject(vehicle);
ctx.SaveChanges();
}
public int InsertSearchSession(tblSearchSession searchSession)
{
// Create database context.
var ctx = new seleniumScrapeEntities();
ctx.tblSearchSessions.AddObject(searchSession);
ctx.SaveChanges();
return searchSession.Search_Session_ID_PK;
}
private int GetHtmlTableId()
{
var ctx = new seleniumScrapeEntities();
var htmlTableId = (from h in ctx.tblHtmls
where h.html_id_pk > 0
orderby h.html_id_pk descending
select h.html_id_pk).FirstOrDefault();
return htmlTableId;
}
public IQueryable<DataRow> getRow()
{
var ctx = new seleniumScrapeEntities();
var query = from hr in ctx.tblHtmlRows
where hr.Search_Session_ID_fk == 500
select new DataRow()
{
id = hr.html_row_id_PK,
dataRowHtml = hr.html_row_data
};
return query;
}
