//private async void Current_ConnectivityChanged(object sender, Plugin.Connectivity.Abstractions.ConnectivityChangedEventArgs e) //{ // if (!e.IsConnected) // { // await DisplayAlert("fail", "No Internet Connection. Offline Menu activated", "Ok"); // await Navigation.PushAsync(new MainTabbed()); // } // else // { // // await DisplayAlert("sucess", " Network Is Available.", "Ok"); // // sendJSON(); // GetJSON(); // } //} //protected async override void OnAppearing() //{ // base.OnAppearing(); // if (!CrossConnectivity.Current.IsConnected) // { // await DisplayAlert("fail", "No Internet Connection.Offline Menu Activated", "Ok"); // await Navigation.PushAsync(new MainTabbed()); // } // else // { // // await DisplayAlert("sucess", " Network Is Available.", "Ok"); // // sendJSON(); // GetJSON(); // } //} //public ObservableCollection<JsonCartone> YourList //{ // get // { // return itemsList; // } // set // { // itemsList = value; // //RaisePropertyChanged(); // //NotifyPropertyChanged("YourList"); // } //} public async void GetJSON() { //TableQuery p = new TableQuery(); //SQLiteConnection s; //s = DependencyService.Get<ISQLite>().GetConnection(); //s.Table<TempTbl>(); //var count = s.ExecuteScalar<string>("SELECT max(TblName) FROM TempTbl"); // tablenow.Text = count; TicketQuery y = new TicketQuery(); SQLiteConnection d; d = DependencyService.Get <ISQLite>().GetConnection(); d.Table <TicketNumber>(); var tikcount = d.ExecuteScalar <string>("SELECT TicketNum FROM TicketNumber ORDER BY Id DESC LIMIT 1"); // ticketnow.Text = tikcount; var client = new HttpClient(); var postData = new List <KeyValuePair <string, string> >(); // postData.Add(new KeyValuePair<string, string>("TestTicket", tikcount.Replace("\r\n", ""))); postData.Add(new KeyValuePair <string, string>("TestTicket", tikcount)); var content = new FormUrlEncodedContent(postData); // var response = await client.PostAsync("http://192.168.43.226/cardorderGetNew.php", content); var response = await client.PostAsync(RestService.ipupdate + "cardorderGetNew.php", content); string contactsJson = response.Content.ReadAsStringAsync().Result; JsonCartone ObjContactList = new JsonCartone(); if (response.IsSuccessStatusCode) { ObjContactList = JsonConvert.DeserializeObject <JsonCartone>(contactsJson); // itemCartList = JsonConvert.DeserializeObject<JsonCartone>(contactsJson); cartone.ItemsSource = ObjContactList.CartDetails; foreach (JsonCart t in ObjContactList.CartDetails) { newtot = t.Total + newtot; //FlagNu = t.FlagNum; } } total.Text = Convert.ToString(newtot); // gandtot.Text = Convert.ToString(newtot + tax); gandtot.Text = Convert.ToString(newtot); GC.Collect(1); // super.finalize(); }
public async void GetJSON() { //Check network status //if (NetworkCheck.IsNetworkConnected()) //{ //TableQuery p = new TableQuery(); //SQLiteConnection s; //s = DependencyService.Get<ISQLite>().GetConnection(); //s.Table<TempTbl>(); //var count = s.ExecuteScalar<string>("SELECT TblName FROM TempTbl"); TicketQuery y = new TicketQuery(); SQLiteConnection d; d = DependencyService.Get <ISQLite>().GetConnection(); d.Table <TicketNumber>(); // var tikcount = d.ExecuteScalar<string>("SELECT TicketNum FROM TicketNumber"); var tikcount = d.ExecuteScalar <string>("SELECT TicketNum FROM TicketNumber ORDER BY Id DESC LIMIT 1"); // ticketnow.Text = tikcount; // string flag = "1"; var client = new System.Net.Http.HttpClient(); var postData = new List <KeyValuePair <string, string> >(); //postData.Add(new KeyValuePair<string, string>("TestTicket", tikcount)); postData.Add(new KeyValuePair <string, string>("TestTicket", tikcount)); // postData.Add(new KeyValuePair<string, string>("Flag", flag)); var content = new FormUrlEncodedContent(postData); var response = await client.PostAsync(RestService.ipupdate + "KOTCheckNew.php", content); string contactsJson = response.Content.ReadAsStringAsync().Result; JsonCartone ObjContactList = new JsonCartone(); if (response.IsSuccessStatusCode) { ObjContactList = JsonConvert.DeserializeObject <JsonCartone>(contactsJson); cartwo.ItemsSource = ObjContactList.CartDetails; } }