public static int Update(Pracoviste pracoviste, MyDatabase pDb = null)
{
MyDatabase db;
if (pDb == null)
{
db = new MyDatabase();
db.Connect();
}
else
{
db = (MyDatabase)pDb;
}
SqlCommand command = db.CreateCommand(SQL_UPDATE);
PrepareCommand(command, pracoviste);
int ret = db.ExecuteNonQuery(command);
if (pDb == null)
{
db.Close();
}
return(ret);
}
private static Collection <Pracoviste> Read(SqlDataReader reader)
{
Collection <Pracoviste> pracovisteC = new Collection <Pracoviste>();
while (reader.Read())
{
int i = -1;
Pracoviste pracoviste = new Pracoviste();
pracoviste.ID_pracoviste = reader.GetInt32(++i);
int ix = i++;
pracoviste.ID_nadrizenehoPracoviste = reader.IsDBNull(ix) ? (int?)reader.GetInt32(ix) : null;
pracoviste.Nazev = reader.GetString(++i);
pracovisteC.Add(pracoviste);
}
return(pracovisteC);
}
public static Pracoviste Select(int id, MyDatabase pDb = null)
{
MyDatabase db;
if (pDb == null)
{
db = new MyDatabase();
db.Connect();
}
else
{
db = (MyDatabase)pDb;
}
SqlCommand command = db.CreateCommand(SQL_SELECT_ID);
command.Parameters.AddWithValue("@ID_pracoviste", id);
SqlDataReader reader = db.Select(command);
Collection <Pracoviste> pracovisteC = Read(reader);
Pracoviste pracoviste = null;
if (pracovisteC.Count == 1)
{
pracoviste = pracovisteC[0];
}
reader.Close();
if (pDb == null)
{
db.Close();
}
if (pracoviste == null)
{
Console.WriteLine("Pracoviste neexistuje");
}
return(pracoviste);
}
private static void PrepareCommand(SqlCommand command, Pracoviste pracoviste)
{
command.Parameters.AddWithValue("@ID_pracoviste", pracoviste.ID_pracoviste);
command.Parameters.AddWithValue("@ID_nadrizenehoPracoviste", (object)pracoviste.ID_nadrizenehoPracoviste ?? DBNull.Value);
command.Parameters.AddWithValue("@Nazev", pracoviste.Nazev);
}
