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;
Lokalita lokalita = new Lokalita
{
Id = reader.GetString(++i),
Kod = reader.GetString(++i),
Popis = !reader.IsDBNull(++i) ? reader.GetString(i) : null,
Poznamka = !reader.IsDBNull(++i) ? reader.GetString(i) : null
};
result.Add(lokalita);
}
return(result);
}
catch (OracleException oe)
{
Log(oe.Message);
return(null);
}
}
}
}
public override bool Update(Model obj)
{
Lokalita ins = (Lokalita)obj;
using (var c = ConnetionFactory.GetOracleConnection())
{
using (var cmd = c.CreateCommand())
{
try
{
cmd.CommandText = UPDATE;
cmd.Parameters.Add(":kod", ins.Kod);
cmd.Parameters.Add(":popis", ins.Popis);
cmd.Parameters.Add(":poznamka", ins.Poznamka);
cmd.Parameters.Add(":id", ins.Id);
cmd.ExecuteNonQuery();
return(true);
}
catch (OracleException oe)
{
Log(oe.Message);
return(false);
}
}
}
}
//7.4
public static Lokalita Select(int idLok, Database pDb = null)
{
Database db;
if (pDb == null)
{
db = new Database();
db.Connect();
}
else
{
db = pDb;
}
SqlCommand command = db.CreateCommand(SQL_SELECT_detail);
command.Parameters.AddWithValue("@idLok", idLok);
SqlDataReader reader = db.Select(command);
Lokalita lokalita = Read_lokalita_one(reader);
reader.Close();
if (pDb == null)
{
db.Close();
}
return(lokalita);
}
private static Lokalita Read_lokalita_one(SqlDataReader reader)
{
Lokalita lokalita = new Lokalita();
while (reader.Read())
{
int i = -1;
lokalita.Idlok = reader.GetInt32(++i);
lokalita.Ulice_cislo = reader.GetString(++i);
lokalita.Katastralni_uzemi = reader.GetString(++i);
lokalita.Mesto_idmes = ShowMesto.Detail_mesta(reader.GetInt32(++i));
lokalita.Pocet_zakazek = reader.GetInt32(++i);
lokalita.Trzba = reader.GetInt32(++i);
}
return(lokalita);
}
private static Collection <Lokalita> Read_lokalita(SqlDataReader reader)
{
Collection <Lokalita> lokality = new Collection <Lokalita>();
while (reader.Read())
{
Lokalita lokalita = new Lokalita();
int i = -1;
lokalita.Idlok = reader.GetInt32(++i);
lokalita.Ulice_cislo = reader.GetString(++i);
lokalita.Katastralni_uzemi = reader.GetString(++i);
lokalita.Mesto_idmes = ShowMesto.Detail_mesta(++i);
lokalita.Pocet_zakazek = reader.GetInt32(++i);
lokalita.Trzba = reader.GetInt32(++i);
lokality.Add(lokalita);
}
return(lokality);
}
public override bool Delete(Model obj)
{
Lokalita del = (Lokalita)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);
}
}
}
}
