コード例 #1
0
 public ManagerForma(OracleConnection conn, ManagerC manager)
 {
     InitializeComponent();
     LoadingSemaphore     = new Semaphore(0, 100);
     Manager              = manager;
     Conn                 = conn;
     pictureBoxLogo.Image = Resources.FASAP_LOGO;
     Init();
 }
コード例 #2
0
        public ManagerForma() //probno
        {
            InitializeComponent();
            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;
            Conn.Open();
            Manager = new ManagerC(8, 1, "Гордана", "Иванова-Крстевска", "*****@*****.**", "1804978455221");
            Init();
        }
コード例 #3
0
        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();
                                }
                            }
                        }
                    }
                }
            }
        }