private void LvOrders_ItemSelected(object sender, SelectedItemChangedEventArgs e) { OrderByUser selectedItem = e.SelectedItem as OrderByUser; if (selectedItem != null) { Navigation.PushModalAsync(new OrderDetailPage(selectedItem.id)); } ((ListView)sender).SelectedItem = null; }
public List <int> getOrderByUserId(OrderByUser order) { List <int> list = new List <int>(); using (MySqlConnection conn = new MySqlConnection(ConnectionString)) { conn.Open(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "select bestilling.bestilling_id from bestilling inner join kunde on kunde.kunde_id = bestilling.kunde_kunde_id where kunde_id=@id;"; cmd.Parameters.AddWithValue("@id", order.Id); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { list.Add( Convert.ToInt32(reader[0]) ); } } conn.Close(); } return(list); }
public IActionResult GetOrdersForUser([FromBody] OrderByUser order) { return(Ok(_context.getOrderByUserId(order))); }