public override bool Insert() { DateTime datum; try { datum = DateTime.Parse(DatumInstalacie); } catch { ErrorMessage = "Nesprávny datum."; return(false); } char?typ = Typ; if (string.IsNullOrWhiteSpace(Typ + "")) { typ = null; } int?poradie = Poradie; if (string.IsNullOrWhiteSpace(Poradie + "")) { poradie = null; } if (poradie != null && poradie < -1) { poradie = null; } return(UseDbMethod(Databaza.InsertStlp(IdUlice, Vyska, datum, poradie, typ))); }
public VystupSelect(string paSelectString, params string[] paCollumnNames) { SelectString = paSelectString; _databaza = new Databaza(); Columns = new List <string>(); Columns.AddRange(paCollumnNames); }
public async Task <IActionResult> Edit(int id, [Bind("ID,Datump,datumo,Auto,Typ,Kod,Kilometre,SPZ,WIN,Oprava,Cena,Poznamky")] Databaza databaza) { if (id != databaza.ID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(databaza); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!DatabazaExists(databaza.ID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(databaza)); }
public ZobrazObjednavkyPage(MainWindow pMainWindow, Databaza pdatabaza) { InitializeComponent(); mainWindow = pMainWindow; DataContext = this; databaza = pdatabaza; tovaryNaZobrazenieList = new List <TovaryNaZobrazenie>(); }
public SStlpCely(SStlp paSStlp) { Doplnky = new LinkedList <TDoplnok>(); Databaza = new Databaza(); SStlp = paSStlp; SInformacie = new LinkedList <SInfo>(); SLampyNaStlpe = new LinkedList <SLampaNaStlpe>(); }
public override bool Insert() { if (string.IsNullOrEmpty(DatumDemontaze)) { return(UseDbMethod(Databaza.VlozDoplnokStlpu(Cislo, TypDoplnku, Popis, DatumInstalacie))); } return(UseDbMethod(Databaza.VlozDoplnokStlpu(Cislo, TypDoplnku, Popis, DatumInstalacie, DateTime.Parse(DatumDemontaze)))); }
public VystupProcedura(string paNazovProcedury, bool paPodporujeVysledok, IEnumerable <string> paCollumnNames, params ProcedureParameter[] paParameters) { NazovProcedury = paNazovProcedury; _databaza = new Databaza(); Columns = new List <string>(); Columns.AddRange(paCollumnNames); ParametrePreVystup = paParameters; _podporaVysledku = paPodporujeVysledok; KlucovyStlpec = null; }
public STechnikCely(STechnik technik) { Databaza = new Databaza(); Technik = technik; DeleteEnabled = true; KontrolyLamp = new LinkedList <SKontrolaLampy>(); KontrolyStlpov = new LinkedList <SKontrolaStlpu>(); ServisLamp = new LinkedList <SServisLampy>(); ServisStlpov = new LinkedList <SServisStlpu>(); }
public override bool Update() { DateTime?demontaz = null; if (DatumDemontaze != "") { demontaz = DateTime.Parse(DatumDemontaze); } return(UseDbMethod(Databaza.UpdateLampaNaStlpe(IdLampy, Cislo, IdTypu, Stav, DatumInstalacie, demontaz))); }
public async Task <IActionResult> Create([Bind("ID,Datump,datumo,Auto,Typ,Kod,Kilometre,SPZ,WIN,Oprava,Cena,Poznamky")] Databaza databaza) { if (ModelState.IsValid) { _context.Add(databaza); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(databaza)); }
public HlavnaPlochaFutbal(string pHostia, string pDomaci, RiadiaceOknoFutbal pOkno, Databaza pDat, int pId, int pHos, int pDom) { this.idZapasu = pId; this.iDTimDomaci = pDom; this.idTimHostia = pHos; dat = pDat; riadiaceOkno = pOkno; hostia = pHostia; domaci = pDomaci; InitializeComponent(); }
public override bool Insert() { if (ObsluhaStlpu != null && IdSluzby == ObsluhaStlpu.IdSluzby) { return(!Databaza.VlozServisStlpu(Sluzba.RodneCislo, ObsluhaStlpu.Cislo, Sluzba.Popis, Sluzba.Trvanie, DateTime.Parse(Sluzba.Datum), Cena).JeChyba); } if (ObsluhaLampy != null && IdSluzby == ObsluhaLampy.IdSluzby) { return(!Databaza.VlozServisLampy(Sluzba.RodneCislo, ObsluhaLampy.IdLampy, Sluzba.Popis, Sluzba.Trvanie, DateTime.Parse(Sluzba.Datum), Cena).JeChyba); } return(false); }
public HlavnaPlochaHokej(string pHostia, string pDomaci, RiadiaceOknoHokej pOkno, Databaza pDat, int pId, int pHos, int pDom) { this.idZapasu = pId; this.iDTimDomaci = pDom; this.idTimHostia = pHos; dat = pDat; riadiaceOkno = pOkno; hostia = pHostia; domaci = pDomaci; InitializeComponent(); vylucenyHostia = new List <int>(); vylucenyDomaci = new List <int>(); }
public override bool Insert() { if (ObsluhaStlpu != null && IdSluzby == ObsluhaStlpu.IdSluzby) { return(!Databaza.VlozKontroluStlpu(Sluzba.RodneCislo, ObsluhaStlpu.Cislo, Sluzba.Popis, Stav, Sluzba.Trvanie, DateTime.Parse(Sluzba.Datum)).JeChyba); } if (ObsluhaLampy != null && IdSluzby == ObsluhaLampy.IdSluzby) { return(!Databaza.VlozKontroluLampy(Sluzba.RodneCislo, ObsluhaLampy.IdLampy, Sluzba.Popis, Stav, Sluzba.Trvanie, DateTime.Parse(Sluzba.Datum), Svietivost).JeChyba); } return(false); }
public bool SelectPodlaId(object paIdEntity) { string select = $"SELECT cislo FROM s_stlp WHERE id_ulice = {SUlica.IdUlice} ORDER BY poradie"; var rows = Databaza.SpecialSelect(select); foreach (var row in rows) { var stlp = new SStlp(); stlp.SelectPodlaId(int.Parse(row["CISLO"].ToString())); Stlpy.AddLast(stlp); } return(true); }
public RiadiaceOknoFutbal(string pHostia, string pDomaci, UvodneMenuFutbal pOkno, Databaza pDat, int pId, int pHos, int pDom) { this.dat = pDat; this.iDTimDomaci = pDom; this.idTimHostia = pHos; this.hostia = pHostia; this.domaci = pDomaci; InitializeComponent(); this.okno = pOkno; this.tabula = new HlavnaPlochaFutbal(pHostia, pDomaci, this, pDat, pId, pHos, pDom); tabula.Show(); bGolDomaci.Text = pDomaci; bGolHostia.Text = pHostia; }
/// <summary> /// Pocet stĺpov na ktoré je treba generovať generuje sa od 1-2 doplnky /// na stĺpe a ako count sa berie Min(pocet stĺpov, paCount) /// </summary> /// <param name="paCount"></param> public override void Generate(int paCount) { var db = new Databaza(); var reader = db.SpecialSelect("select cislo, to_char(DATUM_INSTALACIE, 'DD.MM.YYYY') as datum from s_stlp where DATUM_INSTALACIE is not null"); var count = 0; const char znacka = 'Z'; const char reklama = 'R'; const char obmedzenie = 'O'; foreach (var row in reader) { var idStlpu = int.Parse(row["CISLO"].ToString()); var datumInstalacieStlpa = DateTime.Parse(row["DATUM"].ToString()); var prvyDatumInstalacieDoplnku = RandomDay(datumInstalacieStlpa, DateTime.Now); var druhyDatumInstalacieDoplnku = RandomDay(prvyDatumInstalacieDoplnku, DateTime.Now); var result = _random.Next() % 2; if (result == 0) { db.VlozDoplnokStlpu(idStlpu, reklama, GenerujReklamu(), prvyDatumInstalacieDoplnku); if (_random.Next() % 2 == 0) { db.VlozDoplnokStlpu(idStlpu, znacka, GenerujZnacku(), druhyDatumInstalacieDoplnku); } } else if (result == 1) { db.VlozDoplnokStlpu(idStlpu, znacka, GenerujZnacku(), prvyDatumInstalacieDoplnku); if (_random.Next() % 2 == 0) { db.VlozDoplnokStlpu(idStlpu, reklama, GenerujReklamu(), druhyDatumInstalacieDoplnku); } } else { db.VlozDoplnokStlpu(idStlpu, obmedzenie, GenerujRychlostneObmedzenie(), prvyDatumInstalacieDoplnku); } if (++count == paCount) { break; } } }
/// <summary> /// entita sa načíta podľa svojho id /// </summary> /// <param name="paIdEntity"></param> /// <returns></returns> public virtual bool SelectPodlaId(object paIdEntity) { var atribut = SqlClassAttribute.ExtractSqlClassAttribute(this); var db = new Databaza(); var stlpce = string.Join(", ", this.GetType().GetProperties() .Where(p => SqlClassAttribute.ExtractSqlClassAttribute(p)?.IsColumn == true && SqlClassAttribute.ExtractSqlClassAttribute(p)?.IsReference == false) .Select(p => SqlClassAttribute.ExtractSqlClassAttribute(p)?.ColumnName)); var iterator = db.SpecialSelect( $"select {stlpce} from {atribut.TableName} where {atribut.TableKey} = {paIdEntity}"); var enumerator = iterator.GetEnumerator(); if (enumerator.MoveNext()) { MapujRiadokSelectu(enumerator.Current, this); return(true); } return(false); }
public void PridajDatumyDemontaze() { var db = new Databaza(); var reader = db.SpecialSelect("SELECT cislo , nest.id, nest.typ_doplnku, nest.popis, nest.datum_instalacie FROM s_stlp ss, table(select doplnky from s_stlp c WHERE c.cislo = ss.cislo) nest"); foreach (var row in reader) { if (_random.Next() % 2 == 0) { var idStlpu = int.Parse(row["CISLO"].ToString()); var idDoplnku = int.Parse(row["ID"].ToString()); var typDoplnku = row["TYP_DOPLNKU"].ToString()[0]; var popisDoplnku = row["POPIS"].ToString(); var datumInstalacieDoplnku = DateTime.Parse(row["DATUM_INSTALACIE"].ToString()); var datumDemontazeDoplnku = RandomDay(datumInstalacieDoplnku, DateTime.Now); db.UpdateDoplnokStlpu(idStlpu, idDoplnku, typDoplnku, popisDoplnku, datumInstalacieDoplnku, datumDemontazeDoplnku); } } }
public override bool Insert() { DateTime?datum; if (!string.IsNullOrWhiteSpace(Datum)) { try { datum = DateTime.Parse(Datum); } catch { ErrorMessage = "Nespravny formát datumu."; return(false); } } else { ErrorMessage = "Nie je zadaný dátum."; return(false); } return(UseDbMethod(Databaza.VlozInfoStlpu(Cislo, Typ, datum, Data))); }
public override bool Drop() { return(Databaza.ZmazSluzbu(IdSluzby).JeChyba); }
public override bool Drop() { return(UseDbMethod(Databaza.ZmazSluzbu(IdSluzby))); }
public override bool Insert() { return(UseDbMethod(Databaza.VlozKontroluStlpu(RodneCislo, Cislo, Popis, Stav, Trvanie, Datum))); //DateTime.Parse(Datum))); }
public override bool Update() { return(UseDbMethod(Databaza.UpdateKontrolyStlpu(IdSluzby, RodneCislo, Cislo, Popis, Stav, Trvanie, Datum))); //DateTime.Parse(Datum))); }
public UvodneMenuHokej() { InitializeComponent(); dat = new Databaza(); dat.Pripoj(); }
public override bool Drop() { return(UseDbMethod(Databaza.DeleteStlp(Cislo))); }
static void Main(string[] args) { Databaza db = new Databaza(); /* * FileInfo fi = new FileInfo("D:stlp2.jpg"); * FileStream fileStream = fi.OpenRead(); * Image img = new Bitmap(fileStream); * * Vysledok res = db.UpdateInfoStlpu(5,0 ,'I', ImageToByteArray(img)); * if (res.JeChyba) * Console.WriteLine("error"); * * * Console.WriteLine(res.Popis); * * * int c = 0; * DataTable ds = db.GetAllInfo(); * foreach (DataRow row in ds.Rows) * { * if (row["typ"].ToString() == "I") * { * Image i = ByteArrayToImage(row["data"] as byte[]); * i.Save("D:img" + c + ".jpeg", ImageFormat.Jpeg); * c++; * } * * }*/ /* * Dictionary<int, Image> qrCodes = new Dictionary<int, Image>(); * Dictionary<int, Image> pictures = new Dictionary<int, Image>(); * for (int i = 0; i < 699; i++) * { * FileInfo fi = new FileInfo("D:qr/"+i+".jpg"); * FileStream fileStream = fi.OpenRead(); * Image img = new Bitmap(fileStream); * qrCodes.Add(i, img); * } * * for (int i = 0; i < 50; i++) * { * FileInfo fi = new FileInfo("D:stlpy/" + i + ".jpg"); * FileStream fileStream = fi.OpenRead(); * Image img = new Bitmap(fileStream); * pictures.Add(i, img); * } * * Random rand = new Random(); * * for (int i = 0; i < 9775; i++) * { * Image img = pictures[rand.Next(0, pictures.Count)]; * Vysledok res = db.VlozInfoStlpu(i,'I',ImageToByteArray(img)); * * img = qrCodes[rand.Next(0, qrCodes.Count)]; * res = db.VlozInfoStlpu(i, 'Q', ImageToByteArray(img)); * * Console.WriteLine(i); * } */ /* * using (var s = new FileStream("D:import.sql", FileMode.Open)) * { * * }*/ //StringBuilder b = db.Test(); //Console.WriteLine(b.ToString()); //Console.WriteLine("Done"); //var vysledok = new Vysledok(); //var resultProcedurWithoutResult = db.RunProcedureWithOutput("TEST_KOD", null, new ProcedureParameter("parameter1", "integer", 1)); //foreach (var row in resultProcedurWithoutResult) //{ // Console.WriteLine(row[0]); //} //vysledok = new Vysledok(); //var resultProcedureSuccess = db.RunProcedureWithOutput("TEST_KOD", vysledok, new ProcedureParameter("parameter1", "integer", 0)); //foreach (var row in resultProcedureSuccess) //{ // Console.WriteLine(row[0]); //} //Console.WriteLine($"vysledok je chyba:{vysledok.JeChyba}, sprava: {vysledok.Popis}"); //vysledok = new Vysledok(); //var resultProcedureError = db.RunProcedureWithOutput("TEST_KOD", vysledok, new ProcedureParameter("parameter1", "integer", 1)); //foreach (var row in resultProcedureError) //{ // Console.WriteLine(row[0]); //} //Console.WriteLine($"vysledok je chyba:{vysledok.JeChyba}, sprava: {vysledok.Popis}"); //string s = "select cislo, id_sluzby, to_char(datum, 'dd.mm.yyyy'), nvl(popis,''), trvanie, cena from s_obsluha_stlpu join s_sluzba using (id_sluzby) join s_servis using (id_sluzby) order by id_sluzby desc"; //foreach (var rows in db.SpecialSelect(s)) //{ // var a = string.Join(", ", rows.Values); //} var result = db.SpecialSelect("select * from s_stlp"); foreach (var row in result) { Console.WriteLine(String.Join(", ", row)); } Console.WriteLine("Done"); Console.ReadLine(); }
public override bool Drop() { return(UseDbMethod(Databaza.ZmazTechnika(RodneCislo))); }
public override bool Insert() { return(UseDbMethod(Databaza.VlozTechnika(RodneCislo, Meno, Priezvisko))); }
public override bool Update() { return(UseDbMethod(Databaza.UpdateTechnik(RodneCislo, Meno, Priezvisko))); }