public static Objednavatel Detail_objednavatele(int idObj, Database pDb = null) { Database db; if (pDb == null) { db = new Database(); db.Connect(); } else { db = pDb; } SqlCommand command = db.CreateCommand(SQL_Detail); command.Parameters.AddWithValue("@idObj", idObj); SqlDataReader reader = db.Select(command); Objednavatel zakaznici = Read_one(reader); reader.Close(); if (pDb == null) { db.Close(); } return(zakaznici); }
private static Objednavatel Read_one(SqlDataReader reader) { Objednavatel zakaznici = new Objednavatel(); while (reader.Read()) { int i = -1; zakaznici.Idobj = reader.GetInt32(++i); zakaznici.Jmeno_objednavatele = reader.GetString(++i); zakaznici.Ulice_cislo = reader.GetString(++i); zakaznici.Bankovni_spojeni = reader.GetString(++i); zakaznici.Ico = reader.GetInt32(++i); zakaznici.Dic = reader.GetInt32(++i); zakaznici.Mesto_idmes = ShowMesto.Detail_mesta(reader.GetInt32(++i)); } return(zakaznici); }
private static Collection <Objednavatel> Read(SqlDataReader reader) { Collection <Objednavatel> zakaznici = new Collection <Objednavatel>(); while (reader.Read()) { Objednavatel objednavatel = new Objednavatel(); int i = -1; objednavatel.Idobj = reader.GetInt32(++i); objednavatel.Jmeno_objednavatele = reader.GetString(++i); objednavatel.Ulice_cislo = reader.GetString(++i); objednavatel.Bankovni_spojeni = reader.GetString(++i); objednavatel.Ico = reader.GetInt32(++i); objednavatel.Dic = reader.GetInt32(++i); objednavatel.Mesto_idmes = ShowMesto.Detail_mesta(reader.GetInt32(++i)); zakaznici.Add(objednavatel); } return(zakaznici); }