public void OnDelete(object sender, EventArgs e) { //ObservableCollection<JsonCartone> update_Item = new ObservableCollection<JsonCartone>(); if (CrossConnectivity.Current.IsConnected) { try { TotalQuery c = new TotalQuery(); SQLiteConnection s; s = DependencyService.Get <ISQLite>().GetConnection(); s.Table <TotalTbl>(); var mi = ((MenuItem)sender); //await DisplayAlert("Delete Context Action", mi.CommandParameter + " delete context action", "OK"); // cartone.ItemsSource = YourList; // cartone.BeginRefresh(); // var clienttwo = RestService.HttpClient; var clienttwo = new HttpClient(); var postData = new List <KeyValuePair <string, string> >(); postData.Add(new KeyValuePair <string, string>("ItemCode", Convert.ToString(mi.CommandParameter))); var content = new FormUrlEncodedContent(postData); //var responseon = clienttwo.PostAsync("http://192.168.43.226/DeleteItem.php", content); var responseon = clienttwo.PostAsync(RestService.ipupdate + "DeleteItem.php", content); s.Delete <TotalTbl>(mi.CommandParameter); // cartone.ItemsSource = update_Item; // cartone.ItemsSource = c.GetTablelist(); total.Text = c.GetTotal() + ""; GetJSON(); // string contactsJso = responseon.Content.ReadAsStringAsync().Result; // response.Content.ReadAsStringAsync().Result; //JsonCartone ObjContactList = new JsonCartone(); //if (responseon.IsCompleted) //{ // // ObjContactList = JsonConvert.DeserializeObject<JsonCartone>(contactsJso); // cartone.ItemsSource = ObjContactList.CartDetails; //} } catch (Exception ex) { // Console.WriteLine("An error occurred: '{0}'", ex); } } else { // write your code if there is no Internet available DisplayAlert("NETWORK ERROR", "SYSTEM IS OFFLINE", "Ok"); } //Convert.ToString(mi.CommandParameter) }
//public Command DeleteCommand { get; } public OnlineCart(decimal totalnew) { InitializeComponent(); IPQuery IPBC = new IPQuery(); SQLiteConnection IPB; IPB = DependencyService.Get <ISQLite>().GetConnection(); IPB.Table <IPaddressDB>(); // var tikcount = d.ExecuteScalar<string>("SELECT TicketNum FROM TicketNumber"); var backnow = IPB.ExecuteScalar <string>("SELECT backgrund FROM IPaddressDB ORDER BY Id DESC LIMIT 1"); //if (backnow == bone) //{ // this.BackgroundImage = saveback; saveback = backnow; if (saveback == "Style1") { this.BackgroundImage = "background.png"; } else if (saveback == "Style2") { this.BackgroundImage = "backgroundnew.png"; } else if (saveback == "Style3") { this.BackgroundImage = "backnewtwo.png"; } //this.BackgroundImage = "background.png"; NavigationPage.SetHasBackButton(this, true); this.Title = "MENU"; GC.Collect(1); if (CrossConnectivity.Current.IsConnected) { try { if (totalnew > 0) { // DisplayAlert("one", "1", "OK"); foodback.IsVisible = false; } else { // DisplayAlert("two", "2", "OK"); foodback.IsVisible = true; } try { int newnumber = 2; ToolbarItem cartItem = new ToolbarItem(); cartItem.Order = ToolbarItemOrder.Primary; cartItem.Text = "START NEW ORDER"; // cartItem.Icon = "orderNewThree.png"; cartItem.Command = new Command(() => Navigation.PushAsync(new JsonTable(newnumber))); ToolbarItems.Add(cartItem); //SQLiteConnection m; //m = DependencyService.Get<ISQLite>().GetConnection(); //TempTbl mit = new TempTbl(); //m.Table<TempTbl>(); //m.DeleteAll<TempTbl>(); } catch (Exception ex) { // Console.WriteLine("An error occurred: '{0}'", ex); } try { // int newnumber = 2; ToolbarItem RefreshPage = new ToolbarItem(); RefreshPage.Order = ToolbarItemOrder.Primary; RefreshPage.Text = "REFRESH"; // cartItem.Icon = "orderNewThree.png"; //decimal tot; RefreshPage.Command = new Command(() => Navigation.PushAsync(new OnlineCart(totalnew))); ToolbarItems.Add(RefreshPage); //SQLiteConnection m; //m = DependencyService.Get<ISQLite>().GetConnection(); //TempTbl mit = new TempTbl(); //m.Table<TempTbl>(); //m.DeleteAll<TempTbl>(); } catch (Exception ex) { // Console.WriteLine("An error occurred: '{0}'", ex); } // this.ToolbartItems.Add(new ToolbarItem { Text = "BTN 1", Icon = "myicon.png" }); //CrossConnectivity.Current.ConnectivityChanged += Current_ConnectivityChanged; //var items = new List<JsonCartone>(); //cartone.ItemsSource = items; //decimal tot; TotalTbl tbr = new TotalTbl(); SQLiteConnection s; s = DependencyService.Get <ISQLite>().GetConnection(); s.Table <TotalTbl>(); // tbr.ItmID = id; tbr.ItmTotal = totalnew; //tbr.TblName = Convert.ToString(data.ID); TotalQuery c = new TotalQuery(); c.InsertDetails(tbr); // this.total = totalnav; // decimal tot ; // tot =+ totalnew ; // total.Text = c.GetTotal() + ""; // decimal tax = 15; total.Text = c.GetTotal() + ""; decimal tota = Convert.ToDecimal(total.Text); // gandtot.Text = Convert.ToString(tota + tax); // ItemInfo.Text += Convert.ToString(id); // cartone.SelectedItem += ItemInfo.Text; cartone.ItemsSource = update_Item; // DisplayAlert("item IDs", ItemInfo.Text, "OK"); // cartone.IsPullToRefreshEnabled = true; GetJSON(); //long freeMemory = Java.Lang.Runtime.GetRuntime().FreeMemory(); //DisplayAlert("freemomory", Convert.ToString(freeMemory), "OK"); } catch (Exception ex) { // Console.WriteLine("An error occurred: '{0}'", ex); } } else { // write your code if there is no Internet available DisplayAlert("NETWORK ERROR", "SYSTEM IS OFFLINE", "Ok"); } }