public static int Update(Tym tym, MyDatabase pDb = null) { MyDatabase db; if (pDb == null) { db = new MyDatabase(); db.Connect(); } else { db = (MyDatabase)pDb; } SqlCommand command = db.CreateCommand(SQL_UPDATE); PrepareCommand(command, tym); int ret = db.ExecuteNonQuery(command); if (pDb == null) { db.Close(); } return(ret); }
public static void PrepareCommand(SqlCommand command, Tym tymy) { command.Parameters.AddWithValue("@tId", tymy.Tid); command.Parameters.AddWithValue("@lId", tymy.Lid); command.Parameters.AddWithValue("@dtId", tymy.Tid); command.Parameters.AddWithValue("@Nazev_tymu", tymy.Nazev_tymu); }
public static Tym Select(int tym_id) { var db = new Db(); db.Connect(); OracleCommand command = db.CreateCommand(SQL_SELECT); command.Parameters.Add(new OracleParameter(":tym_id", OracleDbType.Int32)); command.Parameters[":tym_id"].Value = tym_id; OracleDataReader reader = db.Select(command); Collection <Tym> tymy = Read(reader); Tym tym = null; if (tymy.Count == 1) { tym = tymy[0]; } reader.Close(); db.Close(); return(tym); }
//3.1 public static int Insert(Hrac hrac, Tym tym, Database pDb = null) { Database db; if (pDb == null) { db = new Database(); db.Connect(); } else { db = pDb; } using (db) using (SqlCommand command = db.CreateCommand("pridejHrace")) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@p_hrac", hrac.Jmeno); command.Parameters.AddWithValue("@p_tym", tym.Jmeno); command.Parameters.AddWithValue("@p_datum", hrac.Datum_narozeni); int status = db.ExecuteNonQuery(command); if (pDb == null) { db.Close(); } return(status); } }
private void listTymu_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (listTymu.SelectedItem != null) { tym = tymy.FirstOrDefault(t => t.tym_nazev == (string)(listTymu.SelectedItem as ListBoxItem)?.Content); } }
private void buttPridejHrace_Click(object sender, EventArgs e) { string jmeno = textPridejHraceJmeno.Text; string prijmeni = textPridejHracePrijmeni.Text; int rok = Int32.Parse(textPridejHraceRok.Text); int cislo = Int32.Parse(textPridejHraceCislo.Text); string pozice = textPridejHracePozice.Text; int tym = Int32.Parse(textPridejHraceTym.Text); Tym t = new Tym() { TymId = tym }; Hrac h = new Hrac() { Jmeno = jmeno, Prijmeni = prijmeni, CisloDresu = cislo, RokNarozeni = rok, Pozice = pozice, Tym = t }; z.PridejHrace(h); textPridejHraceJmeno.Text = ""; textPridejHracePrijmeni.Text = ""; textPridejHraceRok.Text = ""; textPridejHraceCislo.Text = ""; textPridejHracePozice.Text = ""; textPridejHraceTym.Text = ""; }
//5.2 public static int Update(Tym tym, Database pDb = null) { Database db; if (pDb == null) { db = new Database(); db.Connect(); } else { db = pDb; } using (db) using (SqlCommand command = db.CreateCommand(SQL_UPDATE)) { command.Parameters.AddWithValue("@idTym", tym.IdTym); PrepareCommand(command, tym); int status = db.ExecuteNonQuery(command); if (pDb == null) { db.Close(); } return(status); } }
//5.1 public static int Insert(Tym tym, Database pDb = null) { Database db; if (pDb == null) { db = new Database(); db.Connect(); } else { db = pDb; } using (db) using (SqlCommand command = db.CreateCommand(SQL_INSERT)) { PrepareCommand(command, tym); int status = db.ExecuteNonQuery(command); if (pDb == null) { db.Close(); } return(status); } }
public static int Insert(Tym tym, MyDatabase pDB = null) { MyDatabase db; if (pDB == null) { db = new MyDatabase(); db.Connect(); } else { db = (MyDatabase)pDB; } SqlCommand command = db.CreateCommand(SQL_INSERT); PrepareCommand(command, tym); int ret = db.ExecuteNonQuery(command); if (pDB == null) { db.Close(); } return(ret); }
public PrihlaseniDoTurnaje() { InitializeComponent(); lb_turnaje.DataSource = Turnaj.Find(); l_uzivatel.Text = Trener.Find(Global.IdTrener).ToString(); l_tym.Text = Tym.FindByCoach(Global.IdTrener).nazev; }
public void AktualizujGolyTymu(Zapas zapas) { TymyTable tymyTable = new TymyTable(); List <Tym> tymy = tymyTable.Select(); Tym domaci = new Tym(); Tym hoste = new Tym(); if (zapas.GolyDomaci > zapas.GolyHoste) { for (int i = 0; i < tymy.Count; i++) { if (tymy[i].TymId == zapas.Domaci.TymId) { tymy[i].PocetVyher += 1; domaci = tymy[i]; } else if (tymy[i].TymId == zapas.Hoste.TymId) { tymy[i].PocetProher += 1; hoste = tymy[i]; } } } else if (zapas.GolyDomaci == zapas.GolyHoste) { for (int i = 0; i < tymy.Count; i++) { if (tymy[i].TymId == zapas.Domaci.TymId) { tymy[i].PocetRemiz += 1; domaci = tymy[i]; } else if (tymy[i].TymId == zapas.Hoste.TymId) { tymy[i].PocetRemiz += 1; hoste = tymy[i]; } } } else { for (int i = 0; i < tymy.Count; i++) { if (tymy[i].TymId == zapas.Domaci.TymId) { tymy[i].PocetProher += 1; domaci = tymy[i]; } else if (tymy[i].TymId == zapas.Hoste.TymId) { tymy[i].PocetVyher += 1; hoste = tymy[i]; } } } tymyTable.Update(domaci); tymyTable.Update(hoste); }
private static void PrepareCommand(SqlCommand command, Tym tym) { command.Parameters.AddWithValue("@ID_tym", tym.ID_tym); command.Parameters.AddWithValue("@ID_pracoviste", tym.ID_pracoviste); command.Parameters.AddWithValue("@Nazev", tym.Nazev); command.Parameters.AddWithValue("@Min_zamestnancu", tym.Min_zamestnancu); command.Parameters.AddWithValue("@Datum", Convert.ToDateTime(tym.Datum).ToString("yyyy-MM-dd")); }
public Bodovani(Tym tym1, Tym tym2, int goly1, int goly2) { InitializeComponent(); this.tym1 = tym1; this.tym2 = tym2; this.goly1 = goly1; this.goly2 = goly2; listing(); }
public Form1() { InitializeComponent(); dataGridView1.DataSource = Administrator.Find(); dataGridView2.DataSource = Hrac.Find(); dataGridView3.DataSource = Organizator.Find(); dataGridView4.DataSource = Trener.Find(); dataGridView5.DataSource = Turnaj.Find(); dataGridView6.DataSource = Tym.Find(); dataGridView7.DataSource = TymVturnaji.Find(); dataGridView8.DataSource = Zapas.Find(); }
private static void PrepareCommand(OracleCommand command, Tym tym) { command.BindByName = true; //command.Parameters.AddWithValue(":klub_id", klub.klub_id); command.Parameters.AddWithValue(":tym_nazev", tym.tym_nazev); command.Parameters.AddWithValue(":klub_id", tym.klub_id); command.Parameters.AddWithValue(":smazano", tym.smazano ? "1" : "0"); foreach (OracleParameter p in command.Parameters) { Debug.WriteLine($"{p.ParameterName} = {p.Value}"); } }
private static Collection <Tym> Read(SqlDataReader reader) { Collection <Tym> tymy = new Collection <Tym>(); while (reader.Read()) { int i = -1; Tym tym = new Tym(); tym.kod = reader.GetString(++i); tym.nazev = reader.GetString(++i); tymy.Add(tym); } return(tymy); }
public int Update(Tym t) { using (db.GetConnection()) { db.Connect(); OracleCommand command = db.CreateCommand(update); command.Parameters.AddWithValue(":ID", t.TymId); command.Parameters.AddWithValue(":Vyhry", t.PocetVyher); command.Parameters.AddWithValue(":Remizy", t.PocetRemiz); command.Parameters.AddWithValue(":Prohry", t.PocetProher); int ret = db.ExecuteNonQuery(command); return(ret); } }
/*Read pro seznam týmů*/ private static Collection <Tym> Read(SqlDataReader reader) { Collection <Tym> teams = new Collection <Tym>(); while (reader.Read()) { Tym team = new Tym(); int i = -1; team.Nazev_tymu = reader.GetString(++i); teams.Add(team); } return(teams); }
public static int Update(Tym tym) { var db = new Db(); db.Connect(); OracleCommand command = db.CreateCommand(SQL_UPDATE); PrepareCommand(command, tym); command.Parameters.AddWithValue(":tym_id", tym.tym_id); int ret = db.ExecuteNonQuery(command); db.Close(); return(ret); }
public static int Update(Tym tym) { Database db; db = new Database(); db.Connect(); SqlCommand command = db.CreateCommand(SQL_UPDATE); PrepareCommand(command, tym); int ret = db.ExecuteNonQuery(command); db.Close(); return(ret); }
private static Collection <Tym> Read(SqlDataReader reader) { Collection <Tym> tymy = new Collection <Tym>(); while (reader.Read()) { int i = -1; Tym tym = new Tym() { IdTym = reader.GetInt32(++i), Jmeno = reader.GetString(++i), }; tymy.Add(tym); } return(tymy); }
private static Collection <Tym> Read(SqlDataReader reader) { Collection <Tym> tymy = new Collection <Tym>(); while (reader.Read()) { int i = -1; Tym tym = new Tym(); tym.ID_tym = reader.GetInt32(++i); tym.ID_pracoviste = reader.GetInt32(++i); tym.Nazev = reader.GetString(++i); tym.Min_zamestnancu = reader.GetInt32(++i); tym.Datum = reader.GetDateTime(++i); tymy.Add(tym); } return(tymy); }
public static int Vlozeni(Tym tym) { Database db; db = new Database(); db.Connect(); SqlCommand command = db.CreateCommand("VlozeniTymu"); command.CommandType = CommandType.StoredProcedure; PrepareCommand(command, tym); int ret = db.ExecuteNonQuery(command); db.Close(); return(ret); }
private static Collection <Tym> Read(OracleDataReader reader) { Collection <Tym> tymy = new Collection <Tym>(); while (reader.Read()) { Tym Tym = new Tym(); int i = -1; Tym.tym_id = reader.GetInt32(++i); Tym.tym_nazev = reader.GetString(++i); Tym.klub_id = reader.GetInt32(++i); Tym.smazano = reader.GetString(++i) == "1"; tymy.Add(Tym); } return(tymy); }
private void Button_Click(object sender, RoutedEventArgs e) { if (nazev == null) { MessageBox.Show("Vyplňte název týmu"); return; } Tym t = new Tym(); t.tym_nazev = nazev.Text; t.klub_id = tym.klub_id; t.smazano = false; TymTable.Update(t); MessageBox.Show("Tým vložen"); var w = new MainWindow(); w.Show(); this.Close(); }
private void Button_Click(object sender, RoutedEventArgs e) { if (listKlubu.SelectedItem == null) { MessageBox.Show("Zvolte klub"); return; } if (nazev == null) { MessageBox.Show("Vyplňte název týmu"); return; } Tym t = new Tym(); t.tym_nazev = nazev.Text; t.klub_id = klub.klub_id; t.smazano = false; TymTable.Insert(t); MessageBox.Show("Tým vložen"); }
public static Tym Select(int id, MyDatabase pDb = null) { MyDatabase db; if (pDb == null) { db = new MyDatabase(); db.Connect(); } else { db = (MyDatabase)pDb; } SqlCommand command = db.CreateCommand(SQL_SELECT_ID); command.Parameters.AddWithValue("@ID_tym", id); SqlDataReader reader = db.Select(command); Collection <Tym> tymy = Read(reader); Tym tym = null; if (tymy.Count == 1) { tym = tymy[0]; } reader.Close(); if (pDb == null) { db.Close(); } if (tym == null) { Console.WriteLine("Tym neexistuje"); } return(tym); }
public static int Insert(Tym tym) { var db = new Db(); db.Connect(); OracleCommand command = db.CreateCommand(SQL_INSERT); command.Parameters.Add(":tym_id", OracleDbType.Int32); command.Parameters[":tym_id"].Direction = ParameterDirection.ReturnValue; PrepareCommand(command, tym); db.ExecuteNonQuery(command); Console.WriteLine(command.Parameters[":tym_id"].Value.ToString()); string idString = command.Parameters[":tym_id"].Value.ToString(); int id = Convert.ToInt32(idString); db.Close(); return(id); }
public static Collection <Tym> SelectAll() { var db = new Db(); db.Connect(); OracleCommand command = db.CreateCommand(SQL_SELECT_ALL); OracleDataReader reader = db.Select(command); Collection <Tym> tymy = Read(reader); Tym tym = null; if (tymy.Count == 1) { tym = tymy[0]; } reader.Close(); db.Close(); return(tymy); }
public static Collection <Tym> Read(OracleDataReader reader) { var data = new Collection <Tym>(); while (reader.Read()) { int i = -1; var tym = new Tym { TymId = reader.GetInt32(++i), Nazev = reader.GetString(++i), PocetVyher = reader.GetInt32(++i), PocetRemiz = reader.GetInt32(++i), PocetProher = reader.GetInt32(++i), Trener = new Trener { TrenerId = reader.GetInt32(++i) } }; data.Add(tym); } return(data); }