public static int Delete(Planovane_lety lety, Database pDb)
{
Database db;
if (pDb == null)
{
db = new Database();
db.Connect();
}
else
{
db = pDb;
}
SqlCommand command = db.CreateCommand(SQL_DELETE_ID);
PrepareCommand(command, lety);
int ret = db.ExecuteNonQuery(command);
if (pDb == null)
{
db.Close();
}
return(ret);
}
public static Collection <Planovane_lety> SelectDetail(Planovane_lety let, Database pDb = null)
{
Database db;
if (pDb == null)
{
db = new Database();
db.Connect();
}
else
{
db = (Database)pDb;
}
SqlCommand command = db.CreateCommand(SQL_DETAIL);
PrepareCommand(command, let);
SqlDataReader reader = db.Select(command);
Collection <Planovane_lety> lety = Read(reader);
reader.Close();
if (pDb == null)
{
db.Close();
}
return(lety);
}
private static void PrepareCommand(SqlCommand command, Planovane_lety lety)
{
command.Parameters.AddWithValue("@id_letu", lety.id_letu);
command.Parameters.AddWithValue("@povod", lety.povod);
command.Parameters.AddWithValue("@destinacia", lety.destinacia);
command.Parameters.AddWithValue("@odlet", lety.odlet);
command.Parameters.AddWithValue("@stav", lety.stav);
}
private static Collection <Planovane_lety> Read(SqlDataReader reader)
{
Collection <Planovane_lety> lety = new Collection <Planovane_lety>();
while (reader.Read())
{
int i = -1;
Planovane_lety let = new Planovane_lety();
let.id_letu = reader.GetInt32(++i);
let.povod = reader.GetString(++i);
let.destinacia = reader.GetString(++i);
let.odlet = reader.GetDateTime(++i);
let.stav = reader.GetString(++i);
lety.Add(let);
}
return(lety);
}
