/// <summary>
/// Inserts an import and handles storage into old databasing if necessary
/// </summary>
/// <param name="insert">InserQuery object must be provided as a param</param>
/// <returns>Returns last insert id</returns>
public int InsertImport(InsertQuery insert)
{
int id = 0;
// Insert the Import into the database
Database db = new Database(this.newDatabase);
db.Insert(insert);
id = db.GetLastColumn("import", "id");
return(id);
}
/// <summary>
/// Creates a loop exception and returns its ID
/// </summary>
private int CreateException()
{
// Connect to the database
Database db = new Database(this.database);
// Create insert query
InsertQuery insert = new InsertQuery();
insert.SetTable("loopexception");
insert.SetFields(new string[3] { "loop_id", "lexDate", "lexTime" });
insert.AddRowValues(new string[3] {
this.loopId.ToString(),
Utility.Now(this.gmtOffset).ToString("yyyy-MM-dd"),
Utility.Now(this.gmtOffset).ToString("HH:mm:ss")
});
// Insert
db.Insert(insert);
// Return last insert ID
return db.GetLastColumn("loopexception", "id");
}
/// <summary>
/// Inserts an import and handles storage into old databasing if necessary
/// </summary>
/// <param name="insert">InserQuery object must be provided as a param</param>
/// <returns>Returns last insert id</returns>
public int InsertImport(InsertQuery insert)
{
int id = 0;
// Insert the Import into the database
Database db = new Database(this.newDatabase);
db.Insert(insert);
id = db.GetLastColumn("import", "id");
return id;
}
