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