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