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