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 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; Drevina drevina = new Drevina { Id = reader.GetString(++i), Kod = reader.GetString(++i), Popis = !reader.IsDBNull(++i) ? reader.GetString(i) : null, Poznamka = !reader.IsDBNull(++i) ? reader.GetString(i) : null, Hustota = !reader.IsDBNull(++i) ? reader.GetDouble(i) : 0.0 }; result.Add(drevina); } return(result); } catch (OracleException oe) { Log(oe.Message); return(null); } } } }
public List <Model> SelectByPorost(Model por) { List <Model> result = new List <Model>(); using (var c = ConnetionFactory.GetOracleConnection()) { using (var cmd = c.CreateCommand()) { try { cmd.CommandText = SELECT_POR; cmd.Parameters.Add(":id_por", por.Id); OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { int i = -1; PorostniSkupina porec = new PorostniSkupina { Id = reader.GetString(++i), IdPorost = reader.GetString(++i), Kod = reader.GetString(++i), }; result.Add(porec); } return(result); } catch (OracleException oe) { Log(oe.Message); return(null); } } } }
public override bool Update(Model obj) { Uzivatel ins = (Uzivatel)obj; using (var c = ConnetionFactory.GetOracleConnection()) { using (var cmd = c.CreateCommand()) { try { cmd.CommandText = UPDATE; cmd.Parameters.Add(":username", ins.Username); cmd.Parameters.Add(":pass_sha256", ins.Password); cmd.Parameters.Add(":role", ins.Role); cmd.Parameters.Add(":jmeno", ins.Jmeno); cmd.Parameters.Add(":email", ins.Email); cmd.Parameters.Add(":id", ins.Id); cmd.ExecuteNonQuery(); return(true); } catch (OracleException oe) { Log(oe.Message); return(false); } } } }
public override bool Insert(Model obj) { Oddeleni ins = (Oddeleni)obj; using (var c = ConnetionFactory.GetOracleConnection()) { using (var cmd = c.CreateCommand()) { try { cmd.CommandText = INSERT; cmd.Parameters.Add(":id", ins.Id); cmd.Parameters.Add(":id_lhc", ins.IdLesniHospodarskyCelek); cmd.Parameters.Add(":kod", ins.Kod); cmd.ExecuteNonQuery(); return(true); } catch (OracleException oe) { Log(oe.Message); return(false); } } } }
public List <Model> SelectByDilec(Model dil) { List <Model> result = new List <Model>(); using (var c = ConnetionFactory.GetOracleConnection()) { using (var cmd = c.CreateCommand()) { try { cmd.CommandText = SELECT_DIL; cmd.Parameters.Add(":id_dil", dil.Id); OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { int i = -1; Porost dilec = new Porost { Id = reader.GetString(++i), IdDilec = reader.GetString(++i), Kod = reader.GetString(++i), }; result.Add(dilec); } return(result); } catch (OracleException oe) { Log(oe.Message); return(null); } } } }
public override bool Update(Model obj) { OrganizacniUroven3 ins = (OrganizacniUroven3)obj; using (var c = ConnetionFactory.GetOracleConnection()) { using (var cmd = c.CreateCommand()) { try { cmd.CommandText = UPDATE; cmd.Parameters.Add(":id_org2", ins.IdOrganizacniUroven2); 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); } } } }
public override bool Update(Model obj) { LesniHospodarskaEvidence ins = (LesniHospodarskaEvidence)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_podvykon", ins.IdPodvykon); cmd.Parameters.Add(":id_druzhtezby", ins.IdDruhTezby); cmd.Parameters.Add(":id_drevina", ins.IdDrevina); cmd.Parameters.Add(":plocha", ins.Plocha); cmd.Parameters.Add(":mnozstvi", ins.Mnozstvi); cmd.Parameters.Add(":datum", ins.Datum); cmd.Parameters.Add(":poznamka", ins.Poznamka); 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; Dilec oddec = new Dilec { Id = reader.GetString(++i), IdOddeleni = reader.GetString(++i), Kod = reader.GetString(++i), }; result.Add(oddec); } return(result); } catch (OracleException oe) { Log(oe.Message); return(null); } } } }
public override bool Insert(Model obj) { Lokalita ins = (Lokalita)obj; using (var c = ConnetionFactory.GetOracleConnection()) { using (var cmd = c.CreateCommand()) { try { cmd.CommandText = INSERT; cmd.Parameters.Add(":id", ins.Id); cmd.Parameters.Add(":kod", ins.Kod); cmd.Parameters.Add(":popis", ins.Popis); cmd.Parameters.Add(":poznamka", ins.Poznamka); cmd.ExecuteNonQuery(); return(true); } catch (OracleException oe) { Log(oe.Message); return(false); } } } }
public override bool Update(Model obj) { Holina ins = (Holina)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(":souradnice", ins.Souradnice); cmd.Parameters.Add(":rok_vzniku", ins.RokVzniku); cmd.Parameters.Add(":poznamka", ins.Poznamka); cmd.Parameters.Add(":plocha", ins.Plocha); cmd.Parameters.Add(":id", ins.Id); cmd.ExecuteNonQuery(); return(true); } catch (OracleException oe) { Log(oe.Message); return(false); } } } }
public List <Model> SelectByUser(Uzivatel uzivatel) { List <Model> result = new List <Model>(); using (var c = ConnetionFactory.GetOracleConnection()) { using (var cmd = c.CreateCommand()) { try { cmd.CommandText = SELECT_ALL; cmd.Parameters.Add(":id_uzivatel", uzivatel.Id); 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 override bool Insert(Model obj) { Porost ins = (Porost)obj; using (var c = ConnetionFactory.GetOracleConnection()) { using (var cmd = c.CreateCommand()) { try { cmd.CommandText = INSERT; cmd.Parameters.Add(":id", ins.Id); cmd.Parameters.Add(":id_dil", ins.IdDilec); cmd.Parameters.Add(":kod", ins.Kod); cmd.ExecuteNonQuery(); return(true); } catch (OracleException oe) { Log(oe.Message); return(false); } } } }
public override bool Insert(Model obj) { Zalesneni ins = (Zalesneni)obj; using (var c = ConnetionFactory.GetOracleConnection()) { using (var cmd = c.CreateCommand()) { try { cmd.CommandText = INSERT; cmd.Parameters.Add(":id", ins.Id); 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.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; OrganizacniUroven3 organizacniUroven3 = new OrganizacniUroven3 { Id = reader.GetString(++i), IdOrganizacniUroven2 = 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(organizacniUroven3); } return(result); } catch (OracleException oe) { Log(oe.Message); return(null); } } } }
public override bool Update(Model obj) { Dilec ins = (Dilec)obj; using (var c = ConnetionFactory.GetOracleConnection()) { using (var cmd = c.CreateCommand()) { try { cmd.CommandText = UPDATE; cmd.Parameters.Add(":id_odd", ins.IdOddeleni); 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 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 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; LesniHospodarskaEvidence lesniHospodarskaEvidence = new LesniHospodarskaEvidence { Id = reader.GetString(++i), IdPorostniSkupina = reader.GetString(++i), IdPodvykon = reader.GetString(++i), IdDruhTezby = reader.GetString(++i), IdDrevina = reader.GetString(++i), Plocha = reader.GetDouble(++i), Mnozstvi = reader.GetDouble(++i), Datum = reader.GetDateTime(++i), Poznamka = !reader.IsDBNull(++i) ? reader.GetString(i) : null }; result.Add(lesniHospodarskaEvidence); } return(result); } catch (OracleException oe) { Log(oe.Message); return(null); } } } }
public Model SelectByName(string username) { List <Model> result = new List <Model>(); using (var c = ConnetionFactory.GetOracleConnection()) { using (var cmd = c.CreateCommand()) { try { cmd.CommandText = SELECT_BY_NAME; cmd.Parameters.Add(":username", username); OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { int i = -1; Uzivatel uzivatel = new Uzivatel { Id = reader.GetString(++i), Username = reader.GetString(++i), Password = reader.GetString(++i), Role = reader.GetInt16(++i), Jmeno = reader.GetString(++i), Email = reader.GetString(++i) }; result.Add(uzivatel); } return(result.Count > 0 ? result[0] : null); } catch (OracleException oe) { Log(oe.Message); return(null); } } } }
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 List <Model> SelectByVykon(Model vykon) { List <Model> result = new List <Model>(); using (var c = ConnetionFactory.GetOracleConnection()) { using (var cmd = c.CreateCommand()) { try { cmd.CommandText = SELECT_VYKON; cmd.Parameters.Add(":id_vykon", vykon.Id); OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { int i = -1; Podvykon podvykon = new Podvykon { Id = reader.GetString(++i), IdVykon = 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(podvykon); } return(result); } catch (OracleException oe) { Log(oe.Message); return(null); } } } }
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; Uzivatel uzivatel = new Uzivatel { Id = reader.GetString(++i), Username = reader.GetString(++i), Password = reader.GetString(++i), Role = reader.GetInt16(++i), Jmeno = reader.GetString(++i), Email = reader.GetString(++i) }; result.Add(uzivatel); } return(result); } catch (OracleException oe) { Log(oe.Message); return(null); } } } }
public override bool Delete(Model obj) { Dilec del = (Dilec)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); } } } }