public static int Delete(Pracovny_oddiel oddiel, Database pDb)
{
Database db;
if (pDb == null)
{
db = new Database();
db.Connect();
}
else
{
db = pDb;
}
SqlCommand command = db.CreateCommand(SQL_DELETE_ID);
PrepareCommand(command, oddiel);
int ret = db.ExecuteNonQuery(command);
if (pDb == null)
{
db.Close();
}
return(ret);
}
public static Collection <Pracovny_oddiel> SelectDetail(Pracovny_oddiel po, 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, po);
SqlDataReader reader = db.Select(command);
Collection <Pracovny_oddiel> oddiely = Read(reader);
reader.Close();
if (pDb == null)
{
db.Close();
}
return(oddiely);
}
private static Collection <Pracovny_oddiel> Read(SqlDataReader reader)
{
Collection <Pracovny_oddiel> oddiely = new Collection <Pracovny_oddiel>();
while (reader.Read())
{
int i = -1;
Pracovny_oddiel oddiel = new Pracovny_oddiel();
oddiel.id_oddielu = reader.GetInt32(++i);
oddiel.nazov_oddielu = reader.GetString(++i);
oddiel.id_veduci = reader.GetInt32(++i);
oddiely.Add(oddiel);
}
return(oddiely);
}
private static void PrepareCommand(SqlCommand command, Pracovny_oddiel oddiely)
{
command.Parameters.AddWithValue("@id_oddielu", oddiely.id_oddielu);
command.Parameters.AddWithValue("@nazov_oddielu", oddiely.nazov_oddielu);
command.Parameters.AddWithValue("@id_veduci", oddiely.id_veduci);
}
