/// <summary>
/// Set the loop pre-warned status to true
/// </summary>
private void UpdatePreWarning()
{
Database db = new Database(this.database);
UpdateQuery update = new UpdateQuery();
update.SetTable("loop");
update.SetFields(new string[] { "looPreWarned" });
update.AddRowValue(1.ToString());
update.SetId(this.loopId.ToString());
db.Update(update);
this.preWarned = true;
}
/// <summary>
/// Updates the last check row in the table
/// </summary>
private void UpdateLastCheck()
{
Database db = new Database(this.database);
UpdateQuery update = new UpdateQuery();
update.SetTable("welfarecheck");
update.SetFields(new string[] { "welLastCheck" });
update.AddRowValue(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
update.SetId(this.welfareId.ToString());
db.Update(update);
}
/// <summary>
/// Updates the last completion row in the table
/// </summary>
/// <param name="dt"></param>
private void UpdateLastCompletion(DateTime dt)
{
Database db = new Database(this.database);
UpdateQuery update = new UpdateQuery();
update.SetTable("loop");
update.SetFields(new string[] { "looLastCompletion" });
update.AddRowValue(dt.ToString("yyyy-MM-dd HH:mm:ss"));
update.SetId(this.loopId.ToString());
db.Update(update);
this.lastCompletion = dt;
}
/// <summary>
/// Updates the last check row in the table
/// </summary>
private void UpdateLastCheck()
{
Database db = new Database(this.database);
DateTime dt = DateTime.Now;
UpdateQuery update = new UpdateQuery();
update.SetTable("loop");
update.SetFields(new string[] { "looLastCheck", "looPreWarned" });
update.AddRowValue(dt.ToString("yyyy-MM-dd HH:mm:ss"));
update.AddRowValue(0.ToString());
update.SetId(this.loopId.ToString());
db.Update(update);
this.lastCheck = dt;
}
private void UpdateLastCheck(int HighRiskRecord_Id)
{
Database db = new Database(this.database);
UpdateQuery update = new UpdateQuery();
update.SetTable("checkpointhighrisk");
update.SetFields(new string[] { "chrLastCheck" });
update.AddRowValue(DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:ss"));
update.SetId(HighRiskRecord_Id.ToString());
db.Update(update);
}
/// <summary>
/// Writes data to the database for the records and sets the chrStartDate and chrLastCheck
/// </summary>
/// <param name="HighRiskData"></param>
private void CheckandInitialiseNullRecords(CheckPointHighRisk HighRiskRecord)
{
Database db = new Database(this.database);
UpdateQuery update = new UpdateQuery();
update.SetTable("checkpointhighrisk");
update.SetFields(new string[] { "chrLastCheck", "chrStartTime" });
string _nullDateTime = DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:ss");
List<string> _nullDates = new List<string>();
_nullDates.Add(_nullDateTime);
_nullDates.Add(_nullDateTime);
update.SetRowValues(_nullDates);
update.SetId(HighRiskRecord.id.ToString());
db.Update(update);
}
/*********************************************************
* UPDATE STATEMENTS
*********************************************************/
public void UpdateTaskScheduler(UpdateQuery update)
{
// Insert the Import into the database
Database db = new Database(this.newDatabase);
db.Update(update);
}
