public static int Insert(VyukovyMaterial vm, Database pDb = null)
{
Database db;
if (pDb == null)
{
db = new Database();
db.Connect();
}
else
{
db = pDb;
}
SqlCommand command = db.CreateCommand(SQL_INSERT);
PrepareCommand(command, vm);
int ret = db.ExecuteNonQuery(command);
if (pDb == null)
{
db.Close();
}
return(ret);
}
private static void PrepareCommand(SqlCommand command, VyukovyMaterial vm)
{
command.Parameters.AddWithValue("@IdVyukovyMaterial", vm.IdVyukovyMaterial);
command.Parameters.AddWithValue("@Nazev", vm.Nazev);
command.Parameters.AddWithValue("@Text", vm.Text);
command.Parameters.AddWithValue("@Vlozen", vm.Vlozen);
command.Parameters.AddWithValue("@IdVyucujici", vm.IdVyucujici);
command.Parameters.AddWithValue("@IdKurz", vm.IdKurz);
}
public static int Update(VyukovyMaterial vm)
{
var db = new Database();
db.Connect();
SqlCommand command = db.CreateCommand(SQL_UPDATE);
PrepareCommand(command, vm);
int ret = db.ExecuteNonQuery(command);
db.Close();
return(ret);
}
private static Collection <VyukovyMaterial> Read(SqlDataReader reader, bool complete)
{
Collection <VyukovyMaterial> materialy = new Collection <VyukovyMaterial>();
while (reader.Read())
{
VyukovyMaterial vm = new VyukovyMaterial();
int i = -1;
vm.IdVyukovyMaterial = reader.GetInt32(++i);
vm.Nazev = reader.GetString(++i);
vm.Text = reader.GetString(++i);
vm.Vlozen = reader.GetDateTime(++i);
vm.IdVyucujici = reader.GetInt32(++i);
vm.IdKurz = reader.GetInt32(++i);
if (complete)
{
vm.Kurz = new Kurz();
vm.Kurz.IdKurz = vm.IdKurz;
vm.Kurz.Nazev = reader.GetString(++i);
vm.Kurz.Popis = reader.GetString(++i);
vm.Kurz.IdVyucujici = reader.GetInt32(++i);
vm.Kurz.IdObor = reader.GetInt32(++i);
vm.Kurz.Kapacita = reader.GetByte(++i);
}
vm.Autor = new Vyucujici();
vm.Autor.IdVyucujici = vm.IdVyucujici;
if (!reader.IsDBNull(++i))
{
vm.Autor.Titul = reader.GetString(i);
}
vm.Autor.Jmeno = reader.GetString(++i);
vm.Autor.Prijmeni = reader.GetString(++i);
materialy.Add(vm);
}
return(materialy);
}
