public void LoadSettingValuesForCountry() { string policeNumber = ""; string ambulanceNumber = ""; string fireNumber = ""; string notes = ""; try { if (SettingKey != null && SettingKey == "EmergencyLocale") { if (SettingValue != null && SettingValue.Trim() != "") { GlobalData.GetEmergencyNumbersForCountry(SettingValue.Trim(), out policeNumber, out ambulanceNumber, out fireNumber, out notes); } PoliceNumber = policeNumber; AmbulanceNumber = ambulanceNumber; FireNumber = fireNumber; Notes = notes; } } catch (Exception e) { Log.Error(TAG, "LoadSettingValuesForCountry: Exception - " + e.Message); throw; } }
public void SaveSetting() { Globals dbHelp = new Globals(); SQLiteDatabase sqlDatabase = null; try { if (dbHelp != null) { dbHelp.OpenDatabase(); sqlDatabase = dbHelp.GetSQLiteDatabase(); if (sqlDatabase != null && sqlDatabase.IsOpen) { ContentValues values = new ContentValues(); values.Put("SettingKey", SettingKey.Trim()); values.Put("SettingValue", SettingValue.Trim()); if (IsNew) { SettingId = (int)sqlDatabase.Insert("Settings", null, values); IsNew = false; IsDirty = false; } if (IsDirty) { string whereClause = "ID = ?"; sqlDatabase.Update("Settings", values, whereClause, new string[] { SettingId.ToString() }); IsDirty = false; } sqlDatabase.Close(); } } } catch (Exception e) { Log.Error(TAG, "SaveSetting: Exception - " + e.Message); if (sqlDatabase != null && sqlDatabase.IsOpen) { sqlDatabase.Close(); } } }