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)));
}
