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