/// <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; }