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