public void onCreateDatabase() { var pathToDatabase = Path.Combine(path, "JewelleryMortgageLocalDB.db"); SQLiteDatabase sqlDB = SQLiteDatabase.OpenOrCreateDatabase(pathToDatabase, null); string query; query = "CREATE TABLE IF NOT EXISTS `SettingMobileApp` (`SrNo` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, `CalculationDaysDifference` INTEGER NOT NULL DEFAULT 0);"; sqlDB.ExecSQL(query); var db = new SQLiteConnection(pathToDatabase); SettingMobileApp data = db.Query <SettingMobileApp>("Select * from SettingMobileApp where SrNo = '1'").FirstOrDefault(); if (data != null) { _ObjSettingMobileAppModel.CalculationDaysDifference = data.CalculationDaysDifference; } else { _ObjSettingMobileAppModel.CalculationDaysDifference = 0; db.Insert(_ObjSettingMobileAppModel); db.Commit(); } }
public void LoadData() { try { var pathToDatabase = Path.Combine(path, "JewelleryMortgageLocalDB.db"); var dbSettingMobileApp = new SQLiteConnection(pathToDatabase); SettingMobileApp DaysAddOrRemove = dbSettingMobileApp.Query <SettingMobileApp>("Select * from SettingMobileApp where SrNo = '1'").FirstOrDefault(); if (DaysAddOrRemove != null) { _ObjSettingMobileAppModel.CalculationDaysDifference = DaysAddOrRemove.CalculationDaysDifference; } else { _ObjSettingMobileAppModel.CalculationDaysDifference = 0; } } catch (Exception e) { String E = e.ToString(); } }