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