private async Task InsertOrder() { try { var order = new TBL_Orders { users_id = user_id, order_date = Now.ToString("yyyy-MM-dd"), stat = "0", order_status = "Carted" }; await TBL_Orders.Insert(order); //***************************** //Retrieving the orderID will continue coz of the logic userid and order status //the user Needs to complete the transaction for it to change the status, or cancel it in the server side //for the new order of the user //var getorderid = (await App.MobileService.GetTable<TBL_Orders>().Where(order_ => order_.users_id == App.user_id && order_.order_status == "Carted").ToListAsync()).FirstOrDefault(); //if (getorderid != null) App.CurrentOrderId = getorderid.id; await XGetOrderID(); //There's a chance that getting the order id will also be triggered in the menu //To identify if there is currently existing order when an internet //interruption occured. await InsertOrder_Details(); } catch { progressaddtocart.IsVisible = false; await Navigation.PushAsync(new NoInternetPage(), true); } }
private async void SwipeItemdeLete_OnInvoked(object sender, EventArgs e) { var item = sender as SwipeItem; var model = item.BindingContext as TBL_Orders; var ans = await DisplayAlert("Delete", "Are you sure to remove this order?", "Yes", "No"); if (!ans) { return; } var orderDetails = new TBL_Orders() { id = model.id, }; await TBL_Orders.Void(orderDetails); var getorders = await MobileService.GetTable <TBL_Orders>().Where(orders => orders.users_id.ToLower().Contains(user_id)).ToListAsync(); OrdersList.ItemsSource = getorders; }
private async void Voiditem_OnClicked(object sender, EventArgs e) { try { if (itemcount == 0) { await DisplayAlert("Void", "Nothing to void", "OK"); } else { var answer = await DisplayAlert("Void", "Do you want to void this order?", "Yes", "No"); if (!answer) { return; } progressplaceorder.IsVisible = true; lblorderstate.Text = "Voiding your order . . ."; var orderDetails = new TBL_Orders() { id = CurrentOrderId, }; await TBL_Orders.Void(orderDetails); itemid = null; Selected_ProdId = null; CurrentOrderId = null; progressplaceorder.IsVisible = true; await DisplayAlert("Order cancelled", "Your order has been cancelled successfully.", "OK"); await Navigation.PopToRootAsync(true); } } catch { progressplaceorder.IsVisible = false; await Navigation.PushAsync(new NoInternetPage(), true); } }
private async void Btncheckout_OnClicked(object sender, EventArgs e) { //try //{ if (SignedIn) { if (progressplaceorder.IsVisible) { return; } if (totalpayable.Text != "0") { var stat = (await MobileService.GetTable <TBL_MarketStatus>().ToListAsync()).FirstOrDefault(); if (stat != null) { MarketStatus = stat.status; } if (MarketStatus == "1") { var answer = await DisplayAlert("Confirm", "Do you want to confirm this order?", "Yes", "No"); if (!answer) { return; } progressplaceorder.IsVisible = true; lblorderstate.Text = "Placing your order . . ."; if (Switch.IsToggled) { //Save delivery order var orderDetails = new TBL_Orders() { id = CurrentOrderId, users_id = user_id, order_date = Now.ToString("yyyy-MM-dd"), cart_datetime = Now.ToString("ddd, dd MMM yyyy h:mm tt"), stat = "1", order_status = "Ordered", order_choice = "Delivery", del_address = order_rcvr_add, notes = order_notes, del_lat = order_lat.ToString(CultureInfo.InvariantCulture), del_long = order_long.ToString(CultureInfo.InvariantCulture), pickup_time = "-", itms_qty = itemcount.ToString(), tot_payable = totaSum.ToString(CultureInfo.InvariantCulture) }; await TBL_Orders.Update(orderDetails); } else { //Save Pickup order var orderDetails = new TBL_Orders() { id = CurrentOrderId, users_id = user_id, order_date = Now.ToString("yyyy-MM-dd"), cart_datetime = Now.ToString("ddd, dd MMM yyyy h:mm tt"), stat = "1", order_status = "Ordered", order_choice = "Pickup", del_address = "-", notes = "-", del_lat = "-", del_long = "-", pickup_time = pickupTime.Time.ToString(), itms_qty = itemcount.ToString(), tot_payable = totaSum.ToString(CultureInfo.InvariantCulture) }; await TBL_Orders.Update(orderDetails); } checkout = true; progressplaceorder.IsVisible = false; await Navigation.PushModalAsync(new ConfirmationPage(), true); await Navigation.PopToRootAsync(true); refresh = false; } else { progressplaceorder.IsVisible = false; await Navigation.PushAsync(new MarketClosePage(), true); } } else { progressplaceorder.IsVisible = false; await DisplayAlert("Cart empty", "Your cart is empty!", "OK"); } } else { await DisplayAlert("Login", "Please login or create an account first before doing any transaction in the market! It's FREE!", "OK"); await Navigation.PushAsync(new LoginPage()); } //} //catch //{ // progressplaceorder.IsVisible = false; // await Navigation.PushAsync(new NoInternetPage(), true); //} }
private async void Deleteitem_OnClicked(object sender, EventArgs e) { try { if (itemcount == 1) { if (itemid != null) { var answer = await DisplayAlert("Void", "There's only one item remaining on the list. Do you want to void this transaction?", "Yes", "No"); if (!answer) { return; } progressplaceorder.IsVisible = true; lblorderstate.Text = "Voiding your order . . ."; var orderDetails = new TBL_Orders() { id = CurrentOrderId, }; await TBL_Orders.Void(orderDetails); itemid = null; Selected_ProdId = null; CurrentOrderId = null; progressplaceorder.IsVisible = false; await DisplayAlert("Order cancelled", "You have successfully cancelled your order.", "OK"); await Navigation.PopToRootAsync(true); } else { await DisplayAlert("No item selected", "Please select an item on your cart to remove!", "OK"); } } else if (itemcount == 0) { await DisplayAlert("Remove", "Nothing to remove", "OK"); } else { //ordercollection. if (itemid != null) { var confirm = await DisplayAlert("Remove", "Do you really want to remove this item on your cart?", "Yes", "No"); if (!confirm) { return; } progressplaceorder.IsVisible = true; lblorderstate.Text = "Removing item . . ."; var order_details = new TBL_Order_Details { id = itemid, }; await TBL_Order_Details.Delete(order_details); itemid = null; Selected_ProdId = null; progressplaceorder.IsVisible = false; OnAppearing(); } else { await DisplayAlert("No item selected", "Please select an item on your cart to remove!", "OK"); } } } catch { progressplaceorder.IsVisible = false; await Navigation.PushAsync(new NoInternetPage(), true); } }