public static int Delete(Veduci v, Database pDb)
{
Database db;
if (pDb == null)
{
db = new Database();
db.Connect();
}
else
{
db = pDb;
}
SqlCommand command = db.CreateCommand(SQL_DELETE_ID);
PrepareCommand(command, v);
int ret = db.ExecuteNonQuery(command);
if (pDb == null)
{
db.Close();
}
return(ret);
}
public static int Insert(Veduci veduci, Database pDb)
{
Database db;
if (pDb == null)
{
db = new Database();
db.Connect();
}
else
{
db = pDb;
}
SqlCommand command = db.CreateCommand(SQL_INSERT);
PrepareCommand(command, veduci);
int ret = db.ExecuteNonQuery(command);
if (pDb == null)
{
db.Close();
}
return(ret);
}
private static Collection <Veduci> Read(SqlDataReader reader)
{
Collection <Veduci> veduciCollection = new Collection <Veduci>();
while (reader.Read())
{
int i = -1;
Veduci veduci = new Veduci();
veduci.id_veduci = reader.GetInt32(++i);
veduci.meno = reader.GetString(++i);
veduci.priezvisko = reader.GetString(++i);
veduciCollection.Add(veduci);
}
return(veduciCollection);
}
public void SpustVyskum()
{
Veduci veduci = new Veduci("Fero");
laboratorniPristroj1 = new Mikroskop();
laboratorniPristroj2 = new Odstredivka();
laboratorniPristroj1.Nazov = "mik200";
laboratorniPristroj2.Nazov = "ods300";
IOvladanie ovladanie = (IOvladanie)laboratorniPristroj1;
ovladanie.Zapni();
laboratorniPristroj1.VypisDetailneInfo();
laboratorniPristroj2.VypisDetailneInfo();
}
private static void PrepareCommand(SqlCommand command, Veduci veduci)
{
command.Parameters.AddWithValue("@id_veduci", veduci.id_veduci);
command.Parameters.AddWithValue("@meno", veduci.meno);
command.Parameters.AddWithValue("@priezvisko", veduci.priezvisko);
}
