private void getServer(long serverId) { database = dbhelper.ReadableDatabase; ICursor sc; try { sc = database.Query(YastroidOpenHelper.SERVERS_TABLE_NAME, new string[] { "_id", "name", "scheme", "hostname", "port", "user", "pass", "grp" }, YastroidOpenHelper.SERVERS_ID + "=" + serverId, null, null, null, null); sc.MoveToFirst(); s = new Server(sc.GetInt(0), sc.GetString(1), sc.GetString(2), sc .GetString(3), sc.GetInt(4), sc.GetString(5), sc .GetString(6), sc.GetInt(7)); sc.Close(); database.Close(); } catch (Exception e) { Log.Error("BACKGROUND_PROC", e.Message); } }
public Server getServer(int id) { database = dbhelper.ReadableDatabase; Server s = null; try { ICursor sc = database.Query(YastroidOpenHelper.SERVERS_TABLE_NAME, new string[] { "_id", "name", "scheme", "hostname", "port", "user", "pass", "grp" }, "_id="+id, null, null, null, null); if(sc.Count == 1) { s = new Server(sc.GetInt(0), sc.GetString(1), sc .GetString(2), sc.GetString(3), sc.GetInt(4), sc .GetString(5), sc.GetString(6), sc.GetInt(7)); } sc.Close(); database.Close(); } catch (Exception e) { Log.Error("BACKGROUND_PROC", e.Message); } return s; }
private bool saveServer() { database = dbhelper.WritableDatabase; bool result = false; try { URI uri = new URI(FindViewById<EditText>(Resource.Id.edit_server_host).Text); string name = FindViewById<EditText>(Resource.Id.edit_server_name).Text; string scheme = null; string host = uri.Host; string port = FindViewById<EditText>(Resource.Id.edit_server_port).Text; string user = FindViewById<EditText>(Resource.Id.edit_server_user).Text; string pass = FindViewById<EditText>(Resource.Id.edit_server_pass).Text; if (uri.Scheme == null) { scheme = "http"; host = uri.SchemeSpecificPart; } else { scheme = uri.Scheme; } if (name.Length == 0 || host.Length == 0 || port.Length == 0 || user.Length == 0) { Toast.MakeText(this, "One or more fields are empty", ToastLength.Short).Show(); return false; } ContentValues values = new ContentValues(); values.Put(YastroidOpenHelper.SERVERS_NAME, name); values.Put(YastroidOpenHelper.SERVERS_SCHEME, scheme); values.Put(YastroidOpenHelper.SERVERS_HOST, host); values.Put(YastroidOpenHelper.SERVERS_PORT, port); values.Put(YastroidOpenHelper.SERVERS_USER, user); if(pass.Length == 0 ) values.Put(YastroidOpenHelper.SERVERS_PASS, s.getPass()); else values.Put(YastroidOpenHelper.SERVERS_PASS, pass); values.Put(YastroidOpenHelper.SERVERS_GROUP, s.getGroupId()); database.Update(YastroidOpenHelper.SERVERS_TABLE_NAME, values, YastroidOpenHelper.SERVERS_ID + "=" + s.getId(), null); database.Close(); Log.Info("ARRAY", "WebYaST server " + name + " has been updated."); result = true; } catch (Exception e) { Log.Error("BACKGROUND_PROC", e.Message); } Toast.MakeText(this, "Server Updated", ToastLength.Short).Show(); return result; }
void getServers() { database = dbhelper.ReadableDatabase; ICursor sc; try { if (groupId == YastroidOpenHelper.GROUP_DEFAULT_ALL) { sc = database.Query(YastroidOpenHelper.SERVERS_TABLE_NAME, new [] { "_id", "name", "scheme", "hostname", "port", "user", "pass", "grp" }, null, null, null, null, null); } else { sc = database.Query(YastroidOpenHelper.SERVERS_TABLE_NAME, new [] { "_id", "name", "scheme", "hostname", "port", "user", "pass", "grp" }, YastroidOpenHelper.SERVERS_GROUP + "=" + groupId, null, null, null, null); } sc.MoveToFirst(); Server s; serverList.Clear (); if (!sc.IsAfterLast) { do { s = new Server(sc.GetInt(0), sc.GetString(1), sc.GetString(2), sc.GetString(3), sc.GetInt(4), sc.GetString(5), sc.GetString(6), sc.GetInt(7)); serverList.Add(s); } while (sc.MoveToNext()); } sc.Close(); database.Close(); Log.Info("Server Array", "" + serverList.Count); } catch (Exception e) { Log.Error("BACKGROUND_PROC", e.Message); } serverAdapter.Clear(); if (serverList != null && serverList.Count > 0) { for (int i = 0; i < serverList.Count; i++) serverAdapter.Add(serverList[i]); } else { // Add button 'Add new Server' } serverAdapter.NotifyDataSetChanged(); }