public void Btnclick_Clicked(object sender, EventArgs e) { TempTbl tbr = new TempTbl(); SQLiteConnection s; s = DependencyService.Get <ISQLite>().GetConnection(); s.Table <TempTbl>(); // s.DeleteAll<TempTbl>(); TableName = (sender as Button).Text; tbr.TblName = TableName; TableQuery c = new TableQuery(); c.InsertDetails(tbr); Button btn = (Button)sender; if (btn.BackgroundColor.Equals(Color.Gray)) { btn.BackgroundColor = Color.FromHex("#22ac38"); } else { btn.BackgroundColor = Color.Gray; } Navigation.PushAsync(new MainTabbed()); //Navigation.PushAsync(new JsonParsingPage()); }
public void MainbtnClicked(object sender, EventArgs e) { // Navigation.PushAsync(new Dashboard()); Navigation.PushAsync(new FoodTabbedPage(), true); SQLiteConnection s; s = DependencyService.Get <ISQLite>().GetConnection(); TempTbl tbr = new TempTbl(); //SQLiteConnection s; s = DependencyService.Get <ISQLite>().GetConnection(); s.Table <TempTbl>(); // s.DeleteAll<TempTbl>(); // tablenow.Text = countremove; }
public void delete_btn_Clicked(object sender, EventArgs e) { CartQuery c = new CartQuery(); SQLiteConnection s; s = DependencyService.Get <ISQLite>().GetConnection(); s.Table <CartRecord>(); s.DeleteAll <CartRecord>(); cart.ItemsSource = update_Item; cart.ItemsSource = c.GetList(); total.Text = c.GetTotal() + ""; TempTbl tbr = new TempTbl(); //SQLiteConnection s; s = DependencyService.Get <ISQLite>().GetConnection(); s.Table <TempTbl>(); s.DeleteAll <TempTbl>(); tablenow.Text = countremove; }
//public Context ApplicationContext { get; private set; } public void table_Clicked(object sender, EventArgs e) { Navigation.PushAsync(new MasterDetail()); CartQuery c = new CartQuery(); SQLiteConnection s; s = DependencyService.Get <ISQLite>().GetConnection(); s.Table <CartRecord>(); s.DeleteAll <CartRecord>(); //cart.ItemsSource = update_Item; //cart.ItemsSource = c.GetList(); //total.Text = c.GetTotal() + ""; TempTbl tbr = new TempTbl(); //SQLiteConnection s; s = DependencyService.Get <ISQLite>().GetConnection(); s.Table <TempTbl>(); s.DeleteAll <TempTbl>(); // tablenow.Text = countremove; }
//public async void Higlight() //{ // if (Newtab == Usetab) // //{ // await DisplayAlert("ocupied tables are", Convert.ToString(Usetab), "OK"); // // //Button btn = new Button(); // // //btn.BackgroundColor = Color.FromHex("#22ac38"); // //} //} public async void GetTicketinfo() { //TableQuery p = new TableQuery(); //SQLiteConnection r; //r = DependencyService.Get<ISQLite>().GetConnection(); //r.Table<TempTbl>(); //var count = r.ExecuteScalar<string>("SELECT max(TblName) FROM TempTbl"); // await DisplayAlert("tableID", count, "OK"); var TicketNu = 0; var FlagNu = 0; long LocationId = OnlineLoginPage.LocationDetail; var client = RestService.HttpClient; var postData = new List <KeyValuePair <string, string> >(); postData.Add(new KeyValuePair <string, string>("LocationId", Convert.ToString(LocationId))); postData.Add(new KeyValuePair <string, string>("TableID", Convert.ToString(tablenew)));//////// postData.Add(new KeyValuePair <string, string>("IdentityID", Convert.ToString(resul))); var content = new FormUrlEncodedContent(postData); // var response = await client.PostAsync("http://192.168.43.226/GetTicketNew.php", content); var response = await client.PostAsync(RestService.ipupdate + "GetTicketNew.php", content); JsonTicketNewNum ObjContactList = new JsonTicketNewNum(); if (response.IsSuccessStatusCode) { string JsonTiket = response.Content.ReadAsStringAsync().Result; ObjContactList = JsonConvert.DeserializeObject <JsonTicketNewNum>(JsonTiket); foreach (TiketViewModel t in ObjContactList.TicketInfo) { TicketNu = t.TiketNumb; FlagNu = t.FlagNum; } } // await DisplayAlert("ticket", Convert.ToString(TicketNu), "OK"); TicketNumber tik = new TicketNumber(); SQLiteConnection s; s = DependencyService.Get <ISQLite>().GetConnection(); s.Table <TicketNumber>(); tik.TicketNum = Convert.ToString(TicketNu); //tbr.TblName = Convert.ToString(data.ID); TicketQuery c = new TicketQuery(); c.InsertDetails(tik); TempTbl tbr = new TempTbl(); SQLiteConnection p; p = DependencyService.Get <ISQLite>().GetConnection(); p.Table <TempTbl>(); tbr.TblNumbe = tablenew; //tbr.TblName = itemSelectedData.Name; TableQuery d = new TableQuery(); d.InsertDetails(tbr); decimal toti = 0; if (FlagNu == 0 && resul != 3) { //await DisplayAlert("ticket", Convert.ToString(TicketNu), "OK"); // await Navigation.PushAsync(new OnlineTabbed()); await Navigation.PushAsync(new StuwardSelect()); } else if (FlagNu == 1 && resul != 3) { // await DisplayAlert("ticket", Convert.ToString(TicketNu), "OK"); await Navigation.PushAsync(new OnlineCart(toti)); } else if (FlagNu > 1 || resul == 0) { // await DisplayAlert("ticket", Convert.ToString(TicketNu), "OK"); await Navigation.PushAsync(new CartTiketsPage()); } else if (FlagNu == 2 || resul == 2) { // await DisplayAlert("ticket", Convert.ToString(TicketNu), "OK"); await Navigation.PushAsync(new FoodTabbedPage()); } else if (FlagNu == 2 || resul == 3) { int flgyes = 3; // await DisplayAlert("ticket", Convert.ToString(TicketNu), "OK"); //await Navigation.PushAsync(new FoodTabbedPage()); await Navigation.PushAsync(new MainVedioPage(flgyes)); } //TicketQuery y = new TicketQuery(); //SQLiteConnection d; //d = DependencyService.Get<ISQLite>().GetConnection(); //d.Table<TicketNumber>(); //var tikcount = d.ExecuteScalar<string>("SELECT max(TicketNum) FROM TicketNumber"); //await DisplayAlert("tiket numb", tikcount, "OK"); //decimal toti = 0; //if (FlagNu == 0) //{ ////await DisplayAlert("ticket", Convert.ToString(TicketNu), "OK"); //// await Navigation.PushAsync(new OnlineTabbed()); //await Navigation.PushAsync(new StuwardSelect()); //} //else if(FlagNu == 1) // { // // await DisplayAlert("ticket", Convert.ToString(TicketNu), "OK"); // await Navigation.PushAsync(new OnlineCart(toti)); // } // else // { // // await DisplayAlert("ticket", Convert.ToString(TicketNu), "OK"); // await Navigation.PushAsync(new CartTiketsPage()); // } }
public void Btnclick_Clicked(object sender, EventArgs e) { TempTbl tbr = new TempTbl(); SQLiteConnection s; s = DependencyService.Get <ISQLite>().GetConnection(); s.Table <TempTbl>(); // s.DeleteAll<TempTbl>(); TableName = (sender as Button).Text; tbr.TblName = TableName; TableQuery c = new TableQuery(); c.InsertDetails(tbr); Button btn = (Button)sender; if (btn.BackgroundColor.Equals(Color.Gray)) { btn.BackgroundColor = Color.FromHex("#22ac38"); } else { btn.BackgroundColor = Color.Gray; } //ConnectivityManager connectivityManager = (ConnectivityManager)GetSystemService(ConnectivityService); //NetworkInfo networkInfo = connectivityManager.ActiveNetworkInfo; //bool isOnline = networkInfo.IsConnected; //bool isWifi = networkInfo.Type == ConnectivityType.Wifi; //if (isWifi) //{ // DisplayAlert("massage", "Connected", "ok"); //} //else //{ // DisplayAlert("massage", "DisConnected", "ok"); //} //int x = 0; //public static bool IsInternet() //{ if (CrossConnectivity.Current.IsConnected) { //CrossConnectivity.Current.IsReachable // Navigation.PushAsync(new JsonParsingPage()); Navigation.PushAsync(new OnlineTabbed()); } else { // write your code if there is no Internet available //int y = 1; //var status = CrossConnectivity.Current.IsRemoteReachable("google.com"); DisplayAlert("No Internet", "Offline mode activating.", "Ok"); Navigation.PushAsync(new MainTabbed()); } // } // Navigation.PushAsync(new MainTabbed()); // Navigation.PushAsync(new JsonParsingPage()); // DisplayAlert("sucess", "Network Is Available.", "Ok"); }