/// <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> /// Creates an exception and inserts it to the database. /// </summary> private void CreateException() { // Create insert query InsertQuery insert = new InsertQuery(); insert.SetTable("welfarecheckexception"); insert.SetFields(new string[4] { "welfarecheck_id", "excDate", "excTime", "excRSN" }); insert.AddRowValues(new string[4] { this.welfareId.ToString(), Utility.Now(this.gmtOffset).ToString("yyyy-MM-dd"), Utility.Now(this.gmtOffset).ToString("HH:mm:ss"), this.recorderSerial.ToString() }); // Database Database db = new Database(this.database); db.Insert(insert); }
private void CreateException(int HighRiskRecord_Id) { // Create insert query InsertQuery insert = new InsertQuery(); insert.SetTable("checkpointhighriskexception"); insert.SetFields(new string[] { "checkpointhighrisk_id", "hreDate", "hreTime" }); insert.AddRowValues(new string[] { HighRiskRecord_Id.ToString(), Utility.Now(this.gmtOffset).ToString("yyyy-MM-dd"), Utility.Now(this.gmtOffset).ToString("HH:mm:ss") }); // Database Database db = new Database(this.database); db.Insert(insert); }
/// <summary> /// Insert data into exception /// </summary> /// <param name="loopExceptionId"></param> /// <param name="checkpointId"></param> private void InsertIntoException(int loopExceptionId, int checkpointId) { // Connect to the database Database db = new Database(this.database); // Create insert query InsertQuery insert = new InsertQuery(); insert.SetTable("loopexceptioncheckpoint"); insert.SetFields(new string[2] { "loopexception_id", "checkpoint_id" }); insert.AddRowValues(new string[2] { loopExceptionId.ToString(), checkpointId.ToString() }); // Insert db.Insert(insert); }
public void InsertVoltage(InsertQuery insert) { // Insert the Patrol into the database Database db = new Database(this.newDatabase); db.Insert(insert); }
/********************************************************* * INSERT STATEMENTS *********************************************************/ /// <summary> /// Inserts an uploadactivity record into database /// </summary> /// <param name="insert">InsertQuery</param> public void InsertUploadActivity(InsertQuery insert) { Database db = new Database(); db.Insert(insert); }
/// <summary> /// Specialised method to store shock data into the database, optionally /// it will store data to the old legacy databases also /// </summary> /// <param name="insert">InsertQuery previously inserted</param> public void InsertShock(InsertQuery insert) { // Insert the shock data Database db = new Database(this.newDatabase); db.Insert(insert); }
/// <summary> /// Inserts low voltage data into database /// </summary> /// <param name="insert"></param> public void InsertLowVoltage(InsertQuery insert) { // Insert the Event into the database Database db = new Database(this.newDatabase); db.Insert(insert); }
/// <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; }