private void lblRest1_Click(object sender, EventArgs e) { LabelFASAP lb = sender as LabelFASAP; if (lb.LblObject != null) { Restoran obj = lb.LblObject as Restoran; IzvrsuvanjeNaracka fasapNaracka = new IzvrsuvanjeNaracka(obj, Conn); if (fasapNaracka.ShowDialog() == DialogResult.OK) { refresh(); } else { refresh(); } } }
public override bool Equals(object obj) { if (obj == null) { return(false); } if (!(obj is Restoran)) { return(false); } Restoran res = obj as Restoran; if (RestoranID != res.RestoranID) { return(false); } return(true); }
public PregledMeni() { InitializeComponent(); LoadingSemaphore = new Semaphore(0, 1); Opacity = 0; Restoran = new Restoran(); Restoran.Ime = "Ресторан Бигор - Вруток"; Restoran.RestoranID = 2; string oradb = "Data Source=(DESCRIPTION=" + "(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1620))" + "(CONNECT_DATA=(SERVICE_NAME=ORCL)));" + "User Id=DBA_20132014L_GRP_020;Password=7734924;"; Conn = new OracleConnection(); Conn.ConnectionString = oradb; ShowInactive = false; IsDecorator = false; Conn.Open(); }
/// <summary> /// Vcituvanje na site podatoci za restoranot vo koj /// raboti menadzerot koj e tekovno najaven /// </summary> private void popolniRestoran() { string sqlRestoran = @"SELECT * FROM RESTORAN WHERE RESTORAN_ID = :REST_ID"; OracleCommand cmd = new OracleCommand(sqlRestoran, this.Conn); try { OracleParameter prm = new OracleParameter("REST_ID", OracleDbType.Int64); prm.Value = this.Manager.RestoranID; cmd.Parameters.Add(prm); cmd.CommandType = CommandType.Text; OracleDataReader dr = cmd.ExecuteReader(); CurrRestoran = new Restoran(); if (dr.Read()) { CurrRestoran.RestoranID = (int)dr.GetValue(0); CurrRestoran.Ime = dr.GetString(2); if (!dr.IsDBNull(3)) { CurrRestoran.Ulica = dr.GetString(3); } else { CurrRestoran.Ulica = ""; } if (!dr.IsDBNull(4)) { CurrRestoran.Grad = dr.GetString(4); } else { CurrRestoran.Grad = ""; } CurrRestoran.Rejting = (float)dr.GetValue(5); if (!dr.IsDBNull(6)) { CurrRestoran.RabotnoVreme = dr.GetString(6); } else { CurrRestoran.RabotnoVreme = ""; } if (!dr.IsDBNull(7)) { CurrRestoran.Kapacitet = dr.GetInt16(7); } else { CurrRestoran.Kapacitet = null; } if (!dr.IsDBNull(8)) { CurrRestoran.BrojMasi = dr.GetInt16(8); } else { CurrRestoran.BrojMasi = null; } if (!dr.IsDBNull(9)) { CurrRestoran.CenaZaDostava = dr.GetInt16(9); } else { CurrRestoran.CenaZaDostava = null; } if (!dr.IsDBNull(10)) { CurrRestoran.PragZaDostava = dr.GetInt16(10); } else { CurrRestoran.PragZaDostava = null; } if (!dr.IsDBNull(11)) { CurrRestoran.DatumNaOtvoranje = dr.GetDateTime(11); } else { CurrRestoran.DatumNaOtvoranje = null; } Object LogoUrl = dr.GetValue(13); if (LogoUrl == null) { CurrRestoran.LogoUrl = null; } else { CurrRestoran.LogoUrl = LogoUrl as String; } CurrRestoran.Kategorija = dr.GetString(12); } this.lblrest.Text = this.CurrRestoran.Ime; } catch (Exception ex) { MessageBoxForm mbf = new MessageBoxForm("Настана грешка при поврзувањето со базата!", false); if (mbf.ShowDialog() == DialogResult.Yes) { this.Close(); } else { this.Close(); } } }
public void vcitajRestorani() { Restorani = new List <Restoran>(); string sql = "Select * from RESTORAN"; // C# OracleCommand cmd = new OracleCommand(sql, Conn); cmd.CommandType = CommandType.Text; try { OracleDataReader dr = cmd.ExecuteReader(); Restoran res; while (dr.Read()) { res = new Restoran(); Object LogoUrl = dr.GetValue(13); if (LogoUrl == null) { res.LogoUrl = null; } else { res.LogoUrl = LogoUrl as String; } res.RestoranID = (int)dr.GetValue(0); res.Ime = dr.GetString(2); if (!dr.IsDBNull(3)) { res.Ulica = dr.GetString(3); } else { res.Ulica = ""; } if (!dr.IsDBNull(4)) { res.Grad = dr.GetString(4); } else { res.Grad = ""; } res.Rejting = (float)dr.GetValue(5); if (!dr.IsDBNull(6)) { res.RabotnoVreme = dr.GetString(6); } else { res.RabotnoVreme = ""; } if (!dr.IsDBNull(7)) { res.Kapacitet = dr.GetInt16(7); } else { res.Kapacitet = null; } if (!dr.IsDBNull(8)) { res.BrojMasi = dr.GetInt16(8); } else { res.BrojMasi = null; } if (!dr.IsDBNull(9)) { res.CenaZaDostava = dr.GetInt16(9); } else { res.CenaZaDostava = null; } if (!dr.IsDBNull(10)) { res.PragZaDostava = dr.GetInt16(10); } else { res.PragZaDostava = null; } if (!dr.IsDBNull(11)) { res.DatumNaOtvoranje = dr.GetDateTime(11); } else { res.DatumNaOtvoranje = null; } res.Kategorija = dr.GetString(12); Restorani.Add(res); } } catch (Exception ex) { MessageBoxForm mbf = new MessageBoxForm("Настана грешка при поврзувањето со базата!", false); if (mbf.ShowDialog() == DialogResult.Yes) { this.Close(); } else { this.Close(); } } sql = "Select * from IMENIK"; // C# cmd = new OracleCommand(sql, Conn); cmd.CommandType = CommandType.Text; try { OracleDataReader drr = cmd.ExecuteReader(); while (drr.Read()) { foreach (var obj in Restorani) { if (obj.RestoranID == (int)drr.GetValue(0)) { obj.Kontakt.Add(new Telefon(drr.GetString(1))); } } } } catch (Exception ex) { MessageBoxForm mbf = new MessageBoxForm("Настана грешка при поврзувањето со базата!", false); if (mbf.ShowDialog() == DialogResult.Yes) { this.Close(); } else { this.Close(); } } }