protected override Obec select(Obec obec)
{
Database db = new Database();
db.Connect();
OracleCommand cmd = db.CreateCommand(SELECT);
cmd.Parameters.Add("obecId", obec.ObecId);
List <Obec> vystup = new List <Obec>();
OracleDataReader readshit = db.Select(cmd);
while (readshit.Read())
{
Obec tmp = new Obec();
tmp.ObecId = readshit.GetInt32(0);
tmp.Nazev = readshit.GetString(1);
tmp.Visible = readshit.GetInt32(2);
vystup.Add(tmp);
}
Obec wtf = null;
if (vystup.Count == 1)
{
wtf = vystup[0];
}
readshit.Close();
db.Close();
return(wtf);
}
protected override void delete(Obec obec)
{
Database db = new Database();
db.Connect();
OracleCommand cmd = db.CreateCommand(DELETE);
// Prepare(cmd, obec);
cmd.Parameters.Add("obecId", obec.ObecId);
db.ExecuteNonQuery(cmd);
db.Close();
}
protected override void insert(Obec tmp)
{
Database db = new Database();
db.Connect();
OracleCommand cmd = db.CreateCommand(INSERT);
// Prepare(cmd, tmp);
cmd.Parameters.Add("nazev", tmp.Nazev);
db.ExecuteNonQuery(cmd);
db.Close();
}
protected override void update(Obec obec)
{
Database db = new Database();
db.Connect();
OracleCommand cmd = db.CreateCommand(UPDATE);
// Prepare(cmd, obec);
cmd.Parameters.Add("nazev", obec.Nazev);
cmd.Parameters.Add("vis", obec.Visible);
cmd.Parameters.Add("obecId", obec.ObecId);
db.ExecuteNonQuery(cmd);
db.Close();
}
protected override List <Obec> select()
{
Database db = new Database();
db.Connect();
OracleCommand cmd = db.CreateCommand(SELECT_ALL);
List <Obec> vystup = new List <Obec>();
OracleDataReader readshit = db.Select(cmd);
while (readshit.Read())
{
Obec tmp = new Obec();
tmp.ObecId = readshit.GetInt32(0);
tmp.Nazev = readshit.GetString(1);
tmp.Visible = readshit.GetInt32(2);
vystup.Add(tmp);
}
readshit.Close();
db.Close();
return(vystup);
}
public Obec Select(Obec obec)
{
return(chmpff.select(obec));
}
public static void Delete(Obec obec)
{
chmpff.delete(obec);
}
public static void Update(Obec obec)
{
chmpff.update(obec);
}
public static void Insert(Obec obec)
{
chmpff.insert(obec);
}
protected abstract Obec select(Obec obec);
protected abstract void delete(Obec obec);
protected abstract void update(Obec obec);
protected abstract void insert(Obec obec);
public static void Prepare(OracleCommand cmd, Obec chmpff)
{
cmd.Parameters.Add("nazev", chmpff.Nazev);
cmd.Parameters.Add("vis", chmpff.Visible);
}
