/// <summary>
/// Inserts some values
/// </summary>
public static void ExecuteUpdate(EntityProcess entityProcess)
{
Guid guid = entityProcess.guid;
int status = entityProcess.status;
DateTime?date = entityProcess.date;
string sql = "UPDATE Process SET status=" + status + " WHERE guid='" + guid.ToString() + "'";
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
command.ExecuteNonQuery();
}
/// <summary>
/// Inserts some values
/// </summary>
public static void ExecuteInsert(EntityProcess entityProcess)
{
Guid guid = entityProcess.guid;
int status = entityProcess.status;
DateTime date = entityProcess.date;
string sql = "INSERT INTO Process (guid, status, date) VALUES ('" + guid.ToString() + "', " + status + ", '" + date.ToString("yyyy-MM-dd hh:mm:ss") + "')";
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
command.ExecuteNonQuery();
}
