public override bool Update(Model obj) { Zalesneni ins = (Zalesneni)obj; using (var c = ConnetionFactory.GetOracleConnection()) { using (var cmd = c.CreateCommand()) { try { cmd.CommandText = UPDATE; cmd.Parameters.Add(":id_psk", ins.IdPorostniSkupina); cmd.Parameters.Add(":id_drevina", ins.IdDrevina); cmd.Parameters.Add(":plocha", ins.Plocha); cmd.Parameters.Add(":souradnice", ins.Souradnice); cmd.Parameters.Add(":rok_vzniku", ins.RokVzniku); cmd.Parameters.Add(":procent_pudy", ins.ProcentPudy); cmd.Parameters.Add(":id", ins.Id); cmd.ExecuteNonQuery(); return(true); } catch (OracleException oe) { Log(oe.Message); return(false); } } } }
public override List <Model> SelectAll() { List <Model> result = new List <Model>(); using (var c = ConnetionFactory.GetOracleConnection()) { using (var cmd = c.CreateCommand()) { try { cmd.CommandText = SELECT_ALL; OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { int i = -1; Zalesneni zalesneni = new Zalesneni { Id = reader.GetString(++i), IdPorostniSkupina = reader.GetString(++i), IdDrevina = reader.GetString(++i), Plocha = reader.GetDouble(++i), Souradnice = reader.GetString(++i), RokVzniku = reader.GetInt32(++i), ProcentPudy = reader.GetDouble(++i) }; result.Add(zalesneni); } return(result); } catch (OracleException oe) { Log(oe.Message); return(null); } } } }
public override bool Delete(Model obj) { Zalesneni del = (Zalesneni)obj; using (var c = ConnetionFactory.GetOracleConnection()) { using (var cmd = c.CreateCommand()) { try { cmd.CommandText = DELETE; cmd.Parameters.Add(":id", del.Id); cmd.ExecuteNonQuery(); return(true); } catch (OracleException oe) { Log(oe.Message); return(false); } } } }