public override bool Update(Model obj)
{
OdvozniListek ins = (OdvozniListek)obj;
using (var c = ConnetionFactory.GetOracleConnection())
{
using (var cmd = c.CreateCommand())
{
try
{
cmd.CommandText = UPDATE;
cmd.Parameters.Add(":id_org3", ins.IdOrganizacniUroven3);
cmd.Parameters.Add(":id_sort", ins.IdSortiment);
cmd.Parameters.Add(":id_podvykon", ins.IdPodvykon);
cmd.Parameters.Add(":id_lokalita", ins.IdLokalita);
cmd.Parameters.Add(":id_psk", ins.IdPorostniSkupina);
cmd.Parameters.Add(":datum_odvozu", ins.DatumOdvozu);
cmd.Parameters.Add(":mnozstvi", ins.Mnozstvi);
cmd.Parameters.Add(":spz", ins.Spz);
cmd.Parameters.Add(":odberatel", ins.Odberatel);
cmd.Parameters.Add(":ujete_km", ins.UjeteKm);
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;
OdvozniListek odvozniListek = new OdvozniListek
{
Id = reader.GetString(++i),
IdOrganizacniUroven3 = reader.GetString(++i),
IdSortiment = reader.GetString(++i),
IdPodvykon = reader.GetString(++i),
IdLokalita = reader.GetString(++i),
IdPorostniSkupina = reader.GetString(++i),
DatumOdvozu = reader.GetDateTime(++i),
Mnozstvi = reader.GetDouble(++i),
Spz = !reader.IsDBNull(++i) ? reader.GetString(i) : null,
Odberatel = !reader.IsDBNull(++i) ? reader.GetString(i) : null,
UjeteKm = !reader.IsDBNull(++i) ? reader.GetInt32(i) : -1
};
result.Add(odvozniListek);
}
return(result);
}
catch (OracleException oe)
{
Log(oe.Message);
return(null);
}
}
}
}
public override bool Delete(Model obj)
{
OdvozniListek del = (OdvozniListek)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);
}
}
}
}
