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