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