void InsertValues() { ContentValues values = new ContentValues(); values.Put(LocationContentProvider._ID, 1); values.Put(LocationContentProvider.NAME, "Brüel & Kjær"); values.Put(LocationContentProvider.LATITUTDE, 55.816932); values.Put(LocationContentProvider.LONGITUDE, 12.532697); Android.Net.Uri uri = ContentResolver.Insert(LocationContentProvider.CONTENT_URI, values); System.Diagnostics.Debug.WriteLine("Insert: " + uri.ToString()); values.Clear(); values.Put(LocationContentProvider._ID, 2); values.Put(LocationContentProvider.NAME, "Technical University of Denmark"); values.Put(LocationContentProvider.LATITUTDE, 55.786323); values.Put(LocationContentProvider.LONGITUDE, 12.524135); uri = ContentResolver.Insert(LocationContentProvider.CONTENT_URI, values); System.Diagnostics.Debug.WriteLine("Insert: " + uri.ToString()); }
public void putRecord(long time, String difficulty, Context context) { dbHelper = new DBHelper(context); ContentValues cv = new ContentValues(); SQLiteDatabase db = dbHelper.WritableDatabase; SQLiteCursor c = (SQLiteCursor)db.Query("records", null, " difficulty = ?", new String[]{difficulty}, null, null, null); int count = 1; if (c.MoveToFirst()) { int idColIndex = c.GetColumnIndex("id"); int timeColIndex = c.GetColumnIndex("time"); int maxDBindex = c.GetInt(idColIndex); int maxDBtime = c.GetInt(timeColIndex); count++; while (c.MoveToNext()) { if (c.GetInt(timeColIndex) > maxDBtime){ maxDBtime = c.GetInt(timeColIndex); maxDBindex = c.GetInt(idColIndex); } count++; } if (count == 6){ if (time < maxDBtime){ db.Delete("records", " id = ?", new String[]{maxDBindex + ""}); } else { c.Close(); db.Close(); return; } } } cv.Put("time", time); cv.Put("difficulty", difficulty); db.Insert("records", null, cv); cv.Clear(); SQLiteCursor gc = (SQLiteCursor)db.Query("general", null, "difficulty = ?", new String[]{difficulty}, null, null, null); gc.MoveToFirst(); int avgTimeColIndex = gc.GetColumnIndex("avgTime"); int gamesCountColIndex = gc.GetColumnIndex("gamesCount"); int avgTime = 0; int gamesCount = 0; if (gc.MoveToFirst()){ avgTime = gc.GetInt(avgTimeColIndex); gamesCount = gc.GetInt(gamesCountColIndex); } int newGamesCount = gamesCount + 1; int newAvgTime = (avgTime * gamesCount / newGamesCount) + (int)(time / newGamesCount); cv.Put("difficulty", difficulty); cv.Put("avgTime", newAvgTime); cv.Put("gamesCount", newGamesCount); db.Delete("general", " difficulty = ?", new String[]{difficulty}); db.Insert("general", null, cv); db.Close(); c.Close(); gc.Close(); }
public void initDB(SQLiteDatabase db) { db.ExecSQL("DROP TABLE IF EXISTS " + "general"); db.ExecSQL("DROP TABLE IF EXISTS " + "records"); db.ExecSQL("create table records (" + "id integer primary key autoincrement," + "time int," + "difficulty text" + ");"); db.ExecSQL("create table general (" + "difficulty text primary key," + "avgTime int," + "gamesCount int" + ");"); ContentValues cv = new ContentValues(); cv.Put("difficulty", "Easy"); cv.Put("avgTime", 0); cv.Put("gamesCount", 0); db.Insert("general", null, cv); cv.Clear(); cv.Put("difficulty", "Normal"); cv.Put("avgTime", 0); cv.Put("gamesCount", 0); db.Insert("general", null, cv); cv.Clear(); cv.Put("difficulty", "Hard"); cv.Put("avgTime", 0); cv.Put("gamesCount", 0); db.Insert("general", null, cv); }