public void LoadData() { try { //var db = new SQLiteConnection(dbPath); //var data = db.Query<GirviMaster>("Select * from GirviMaster").ToList(); //Result = data; //mListView.Adapter = new GirviSodvaAdapter(this, Result); 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(); } }
protected override void OnCreate(Bundle savedInstanceState) { base.OnCreate(savedInstanceState); SetContentView(Resource.Layout.GirviSodvalayout); var toolbar = FindViewById <Android.Support.V7.Widget.Toolbar>(Resource.Id.app_bar); SetSupportActionBar(toolbar); SupportActionBar.SetTitle(Resource.String.app_name); SupportActionBar.SetDisplayHomeAsUpEnabled(true); //SupportActionBar.SetDisplayShowHomeEnabled(true); SupportActionBar.SetHomeButtonEnabled(true); Search = FindViewById <AutoCompleteTextView>(Resource.Id.autoGSSearch); mListView = FindViewById <ListView>(Resource.Id.listViewKhatawaniList); CustomerNameSearch(); Search.ItemClick += Search_ItemClick; mListView.ItemClick += MListView_ItemClick; var pathToDatabase = Path.Combine(path, "JewelleryMortgageLocalDB.db"); var db = new SQLiteConnection(pathToDatabase); SettingMobileApp data = db.Query <SettingMobileApp>("Select * from SettingMobileApp where SrNo = '1'").FirstOrDefault(); }
private void LoadData() { var pathToDatabase = Path.Combine(path, "JewelleryMortgageLocalDB.db"); var db = new SQLiteConnection(pathToDatabase); SettingMobileApp data = db.Query <SettingMobileApp>("Select * from SettingMobileApp where SrNo = '1'").FirstOrDefault(); if (data != null) { edDaysAddOrRemove.Text = data.CalculationDaysDifference.ToString(); } else { _ObjSettingMobileAppModel.CalculationDaysDifference = 0; db.Insert(_ObjSettingMobileAppModel); db.Commit(); } }