public VrabotenForma(OracleConnection conn, Vraboten vraboten)
{
InitializeComponent();
this.Conn = conn;
this.Vraboten = vraboten;
LoadingSemaphore = new Semaphore(0, 10);
Opacity = 0;
}
private void VrabotenForma_FormClosing(object sender, FormClosingEventArgs e)
{
try
{
Vraboten.OslobodiNaracki(Conn);
}
catch (Exception)
{
}
}
public PregledMeni(Restoran restoran, Vraboten vrab, OracleConnection conn)
{
InitializeComponent();
LoadingSemaphore = new Semaphore(0, 100);
IsChanged = false;
Conn = conn;
Restoran = restoran;
Vraboten = vrab;
Opacity = 0;
lblImeVraboten.Text = String.Format("{0} {1} ", Vraboten.Ime, Vraboten.Prezime);
lblImeRestoran.Text = String.Format("{0} ", Restoran.Ime);
}
private void VrabotenForma_Load(object sender, EventArgs e)
{
Naracki = new List <LabelFASAP>();
Naracki.Add(lbl1);
Naracki.Add(lbl2);
Naracki.Add(lbl3);
Naracki.Add(lbl4);
Naracki.Add(lbl5);
Naracki.Add(lbl6);
Naracki.Add(lbl7);
Naracki.Add(lbl8);
Naracki.Add(lbl9);
Naracki.Add(lbl10);
Naracki.Add(lbl11);
Naracki.Add(lbl12);
Stavki = new List <LabelFASAP>();
Stavki.Add(lblNaracka1);
Stavki.Add(lblNaracka2);
Stavki.Add(lblNaracka3);
Stavki.Add(lblNaracka4);
Stavki.Add(lblNaracka5);
Stavki.Add(lblNaracka6);
Stavki.Add(lblNaracka7);
Stavki.Add(lblNaracka8);
Stavki.Add(lblNaracka9);
if (Vraboten.GetFunkcija() == "Доставувач")
{
lblMasaOpis.Text = "Адреса за достава: ";
lblKontaktOpis.Visible = true;
lblKlient.Visible = true;
lblKontakt.Visible = true;
lblKlientOpis.Visible = true;
lblCenaZaDostavaOpis.Visible = true;
lblCenaZaDostava.Visible = true;
}
lblImeVraboten.Text = String.Format(":{0} - {1}: ", Vraboten.ToString(), Vraboten.GetFunkcija());
Vraboten.PostaviRestoran(Conn);
lblImeRestoran.Text = String.Format(":{0}: ", Vraboten.ImeRestoran);
naracki = new List <Naracka>();
buttonFASAP1_Click(null, null);
timer2.Start();
}
private void buttonFASAP1_Click(object sender, EventArgs e)
{
try
{
Vraboten.PrevzemiNaracka(Conn);
}
catch (Exception ex)
{
lblErrorMessage.Text = ex.Message;
lblErrorMessage.Visible = true;
timer1.Stop();
ErrorMessageTime = 3;
timer1.Start();
}
PrevzemiNaracki();
}
private void timer2_Tick(object sender, EventArgs e)
{
if (naracki.Count == 0)
{
try
{
Vraboten.PrevzemiNaracka(Conn);
PrevzemiNaracki();
}
catch (Exception)
{
}
}
else
{
timer2.Stop();
}
}
public void IncrementOrderNumber()
{
Vraboten.IncrementOrderNumber(Conn, CurrNaracka);
LoadingSemaphore.Release();
}
public void PrevzemiNaracki()
{
naracki = Vraboten.ListaNaracki(Conn);
PostaviNaracki();
}
private void logiranje()
{
{
username = tbUserName.Text;
password = tbPassword.Text;
if (username == "")
{
MessageBoxForm mbf = new MessageBoxForm("Внесeте корисничко име!", false);
mbf.ShowDialog();
tbUserName.Select();
}
else if (password == "")
{
MessageBoxForm mbf = new MessageBoxForm("Внесeте лозинка!", false);
mbf.ShowDialog();
tbPassword.Select();
}
else
{
string sql = @"SELECT LOZINKA FROM KORISNIK WHERE KORISNICHKO_IME = :KOR_IME"; // C#
OracleCommand cmd = new OracleCommand(sql, Conn);
try
{
OracleParameter prm = new OracleParameter("KOR_IME", OracleDbType.Varchar2);
prm.Value = username;
cmd.Parameters.Add(prm);
cmd.CommandType = CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader();
String realPass = ""; // tocniot password od bazata
if (dr.Read()) // ako uspee da procita znaci postoi toa korisnicko ime
{
realPass = dr.GetString(0);
tocenUser = true;
}
else // ne postoi toa korisnicko ime
{
tocenUser = false;
MessageBoxForm mbf = new MessageBoxForm("Не постои тоа корисничко име. Обидете се повторно.", false);
mbf.ShowDialog();
tbPassword.Clear();
tbUserName.Clear();
tbUserName.Select();
}
// ako postoi korisnickoto ime proveri dali vneseniot password (password) se sovpagja so vistinskiot (realPass)
if (tocenUser)
{
if (password == realPass)
{
//MessageBox.Show("tocen pasvord");
tocenPass = true;
}
else
{
MessageBoxForm mbf = new MessageBoxForm("Внесовте погрешна лозинка. Обидете се повторно.", false);
mbf.ShowDialog();
tocenPass = false;
tbPassword.Clear();
}
}
}
catch (Exception ex)
{
MessageBoxForm mbf = new MessageBoxForm("Настана грешка при поврзувањето со базата!", false);
if (mbf.ShowDialog() == DialogResult.Yes)
{
this.Close();
}
else
{
this.Close();
}
}
//ako e vnesen tocniot password
if (tocenPass)
{
//prvo vcitaj vrabotenID i restoranID
sql = @"Select VRABOTEN_ID,RESTORAN_ID from KORISNIK where KORISNICHKO_IME= : KOR_IME";
cmd = new OracleCommand(sql, Conn);
try
{
OracleParameter prm = new OracleParameter("KOR_IME", OracleDbType.Varchar2);
prm.Value = username;
cmd.Parameters.Add(prm);
cmd.CommandType = CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
VrabotenId = (int)dr.GetValue(0);
RestoranId = (int)dr.GetValue(1);
}
}
catch (Exception ex)
{
MessageBoxForm mbf = new MessageBoxForm("Настана грешка при поврзувањето со базата!", false);
if (mbf.ShowDialog() == DialogResult.Yes)
{
this.Close();
}
else
{
this.Close();
}
}
///////////////////////////////////////////
//ako vraboteniot e admin
if (VrabotenId == 0)
{
ManagerC manager = new ManagerC(VrabotenId, RestoranId, "ADMIN", "", username, password);
ManagerForma managerForma = new ManagerForma(Conn, manager);
managerForma.Show();
tbPassword.Clear();
}
else // ako vraboteniot ne e admin (vrabID!=0) vcitaj gi i dr informacii za nego
{
sql = @"Select v.ime_vraboten, v.prezime_vraboten, i.Pozicija, i.status From Korisnik k join Vraboten v on k.Vraboten_ID=v.Vraboten_ID Join Izvrshuva i on i.Vraboten_ID=v.Vraboten_ID Join Restoran r on r.Restoran_ID=i.Restoran_ID where korisnichko_ime = :KOR_IME";
cmd = new OracleCommand(sql, Conn);
try
{
OracleParameter prm = new OracleParameter("KOR_IME", OracleDbType.Varchar2);
prm.Value = username;
cmd.Parameters.Add(prm);
cmd.CommandType = CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
// VrabotenId = (int)dr.GetValue(0);
ime = dr.GetString(0);
prezime = dr.GetString(1);
pozicija = dr.GetString(2);
int st;
if (int.TryParse(dr.GetString(3), out st))
{
status = st;
}
// RestoranId = (int)dr.GetValue(5);
}
}
catch (Exception ex)
{
MessageBoxForm mbf = new MessageBoxForm("Настана грешка при поврзувањето со базата!", false);
if (mbf.ShowDialog() == DialogResult.Yes)
{
this.Close();
}
else
{
this.Close();
}
}
// otkako se procitani podatocite proveri koja funkcija ja izvrsuva
// i soodvetno otvori mu forma
if (status == 0) //ako vraboteniot e neaktiven, nema privilegii za pristap
{
MessageBoxForm mbf = new MessageBoxForm("Немате привилегии за пристап!", false);
if (mbf.ShowDialog() == DialogResult.Yes)
{
this.Close();
}
else
{
this.Close();
}
}
else
{
if (pozicija.ToLower() == "доставувач")
{
vraboten = new Dostavuvac(VrabotenId, RestoranId, ime, prezime, username, password);
}
else if (pozicija.ToLower() == "келнер")
{
vraboten = new Kelner(VrabotenId, RestoranId, ime, prezime, username, password);
}
if (pozicija.ToLower() == "менаџер") //ako e manager
{
ManagerC manager = new ManagerC(VrabotenId, RestoranId, ime, prezime, username, password);
ManagerForma managerForma = new ManagerForma(Conn, manager);
managerForma.Show();
tbPassword.Clear();
}
else //ako e obicen vraboten
{
VrabotenForma vf = new VrabotenForma(Conn, vraboten);
vf.Show();
tbPassword.Clear();
}
}
}
}
}
}
}
