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