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;
LesniHospodarskyCelek lesniHospodarskyCelek = new LesniHospodarskyCelek
{
Id = reader.GetString(++i),
Kod = reader.GetString(++i),
};
result.Add(lesniHospodarskyCelek);
}
return(result);
}
catch (OracleException oe)
{
Log(oe.Message);
return(null);
}
}
}
}
public List <Model> SelectByLhc(LesniHospodarskyCelek lhc)
{
List <Model> result = new List <Model>();
using (var c = ConnetionFactory.GetOracleConnection())
{
using (var cmd = c.CreateCommand())
{
try
{
cmd.CommandText = SELECT_LHC;
cmd.Parameters.Add(":id_lhc", lhc.Id);
OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
int i = -1;
Oddeleni oddeleni = new Oddeleni
{
Id = reader.GetString(++i),
IdLesniHospodarskyCelek = reader.GetString(++i),
Kod = reader.GetString(++i),
};
result.Add(oddeleni);
}
return(result);
}
catch (OracleException oe)
{
Log(oe.Message);
return(null);
}
}
}
}
public override bool Update(Model obj)
{
LesniHospodarskyCelek ins = (LesniHospodarskyCelek)obj;
using (var c = ConnetionFactory.GetOracleConnection())
{
using (var cmd = c.CreateCommand())
{
try
{
cmd.CommandText = UPDATE;
cmd.Parameters.Add(":kod", ins.Kod);
cmd.Parameters.Add(":id", ins.Id);
cmd.ExecuteNonQuery();
return(true);
}
catch (OracleException oe)
{
Log(oe.Message);
return(false);
}
}
}
}
public List <Oddeleni> LoadOddeleni(LesniHospodarskyCelek lhc)
{
return(db.OddeleniTableGateway.SelectByLhc(lhc).Cast <Oddeleni>().ToList());
}
