private void zapasyToolStripMenuItem_Click(object sender, EventArgs e)
{
Zapasy form = new Zapasy();
form.Show();
Hide();
}
public Zapasy SelectId(int id)
{
Zapasy a = null;
var args = new Dictionary <string, string>
{
{ "@zID", id.ToString() }
};
using (var table = TableData.Querry(SqlSelectId, args))
{
if (table.Rows.Count != 0)
{
a = new Zapasy
{
zID = (int)table.Rows[0]["zID"],
domaci_nazev = (string)table.Rows[0]["domaci"],
hoste_nazev = (string)table.Rows[0]["hoste"],
jmeno = (string)table.Rows[0]["jmeno"],
prijmeni = (string)table.Rows[0]["prijmeni"],
domaci_skore = (int)table.Rows[0]["domaci_skore"],
hoste_skore = (int)table.Rows[0]["hoste_skore"],
datum_cas = DateTime.Parse(table.Rows[0]["datum_cas"].ToString())
};
}
}
return(a);
}
public IEnumerable <Zapasy> VyberVsechnyZapasy()
{
List <Zapasy> zapasy = new List <Zapasy>();
using (var table = TableData.Querry(SqlSelect))
{
foreach (DataRow column in table.Rows)
{
Zapasy _zapasy = new Zapasy
{
zID = int.Parse(column[0].ToString()),
domaciID = int.Parse(column[1].ToString()),
hosteID = int.Parse(column[2].ToString()),
rozhodci_rID = int.Parse(column[3].ToString()),
domaci_skore = int.Parse(column[4].ToString()),
hoste_skore = int.Parse(column[5].ToString())
};
zapasy.Add(_zapasy);
}
}
return(zapasy);
}
