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); }