public async Task NactiProdukty()
{
using (SqliteConnection connection = new SqliteConnection(connectionString))
{
await connection.OpenAsync();
using (SqliteCommand command = new SqliteCommand(connection))
{
command.CommandText = "SELECT produktId, nazev, cena FROM produkt";
DbDataReader reader = await command.ExecuteReaderAsync();
while (await reader.ReadAsync())
{
long produktId = (long)reader["produktId"];
string nazev = (string)reader["nazev"];
float cena = (float)reader["cena"];
Model.Produkt produkt = new Model.Produkt(produktId, nazev, cena);
Produkty.Add(produkt);
}
}
connection.Close();
}
}
public async Task Uloz()
{
Model.Produkt produkt = new Model.Produkt(Nazev, Cena);
int pocetZaznamu = await App.Databaze.InsertProductAsync(produkt);
}
public EditaceProduktu(Model.Produkt zvolenyProdukt)
{
BindingContext = viewModel = new ViewModel.EditaceProduktuViewModel(zvolenyProdukt);
InitializeComponent();
}
public EditaceProduktuViewModel(Model.Produkt produkt)
{
this.produkt = produkt;
Nazev = produkt.Nazev;
Cena = produkt.Cena;
}
