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)));
}
