public string VypisVeliciny(VelicinyManager velicinyManager) { velicinyManager.VelicinyList.Add(new Veliciny(10, "pepicek", "jde do", "Vpředminulém čase")); string stav = ""; try { conn.Open(); string sql = "SELECT id, jmeno, znacka, jednotky FROM veliciny"; MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader rdr = cmd.ExecuteReader(); velicinyManager.VelicinyList.Add(new Veliciny(10, "pepicek", "jde do", "lesa")); while (rdr.Read()) { velicinyManager.VelicinyList.Add(new Veliciny((int)rdr[0], rdr[1].ToString(), rdr[2].ToString(), rdr[3].ToString())); //Console.WriteLine(rdr[0] + " -- " + rdr[1]); //Console.WriteLine(rdr[0]); } rdr.Close(); stav = "Veličiny načteny do listu"; } catch (Exception ex) { stav = ex.Message.ToString(); } conn.Close(); velicinyManager.VelicinyList.Add(new Veliciny(10, "pepicek", "jde do", "Podruhé do lesa")); return(stav); }
public string VratVelicinyList(VelicinyManager velicinyManager) { Databaze databaze = new Databaze(); VelicinyList.Add(new Veliciny(1, "nol", "m", "kk")); VelicinyList.Add(new Veliciny(2, "nol", "km", "kppp")); return(databaze.VypisVeliciny(velicinyManager)); }