コード例 #1
0
ファイル: Form2.cs プロジェクト: ZombieMK/MobilePhones
        public Form2(Form parrentForm, Vraboteni vraboten)
        {
            InitializeComponent();

            oppener = parrentForm;

            Ime.Text = vraboten.name;
            Prezime.Text = vraboten.lastName;
            Adresa.Text = vraboten.address;
            EMBG.Text = vraboten.EMBG;
            Br_tel.Text = vraboten.phone;
            textBox6.Text = vraboten.smena;
        }
コード例 #2
0
        public Form2(Form parrentForm, Vraboteni vraboten)
        {
            InitializeComponent();

            oppener = parrentForm;

            Ime.Text      = vraboten.name;
            Prezime.Text  = vraboten.lastName;
            Adresa.Text   = vraboten.address;
            EMBG.Text     = vraboten.EMBG;
            Br_tel.Text   = vraboten.phone;
            textBox6.Text = vraboten.smena;
        }
コード例 #3
0
        private void Najavabtn_Click(object sender, EventArgs e)
        {
            if ((Username.Text.Count() != 0) && (Password.Text.Count() != 0))
            {
                OracleConnection con = new OracleConnection();
                con.ConnectionString = "User Id=DBA_20122013L_GRP_038;Password=9910620;Data Source=(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)))(CONNECT_DATA=(SID=ORCL)))";
                con.Open();

                OracleCommand getUser = new OracleCommand();
                getUser.Connection  = con;
                getUser.CommandText = "SELECT * FROM VRABOTENI WHERE LOZINKA = '" + Password.Text + "'";

                OracleDataReader reader = getUser.ExecuteReader();

                bool ima = true;
                while (reader.Read())
                {
                    ima = false;
                    string tmpID       = reader[0].ToString();
                    string tmpName     = reader[1].ToString();
                    string tmpLastName = reader[2].ToString();
                    string tmpAdress   = reader[3].ToString();
                    string tmpPhone    = reader[4].ToString();
                    string tmpEmbg     = reader[5].ToString();
                    string tmpSmena    = reader[6].ToString();
                    string tmpLozinka  = reader[7].ToString();

                    Vraboteni vraboten = new Vraboteni(tmpID, tmpName, tmpLastName, tmpAdress, tmpPhone, tmpEmbg, tmpSmena, tmpLozinka);
                    Form2     form2    = new Form2(this, vraboten);
                    form2.Show();
                    this.Hide();
                }

                con.Close();

                if (ima)
                {
                    MessageBox.Show("Вработениот не постои!");
                }
            }
            else
            {
                MessageBox.Show("Внесете име и лозинка!");
            }
        }
コード例 #4
0
ファイル: Form1.cs プロジェクト: ZombieMK/MobilePhones
        private void Najavabtn_Click(object sender, EventArgs e)
        {
            if ((Username.Text.Count() != 0) && (Password.Text.Count() != 0))
            {
                OracleConnection con = new OracleConnection();
                con.ConnectionString = "User Id=DBA_20122013L_GRP_038;Password=9910620;Data Source=(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)))(CONNECT_DATA=(SID=ORCL)))";
                con.Open();

                OracleCommand getUser = new OracleCommand();
                getUser.Connection = con;
                getUser.CommandText = "SELECT * FROM VRABOTENI WHERE LOZINKA = '" + Password.Text + "'";

                OracleDataReader reader = getUser.ExecuteReader();

                bool ima = true;
                while (reader.Read())
                {
                    ima = false;
                    string tmpID = reader[0].ToString();
                    string tmpName = reader[1].ToString();
                    string tmpLastName = reader[2].ToString();
                    string tmpAdress = reader[3].ToString();
                    string tmpPhone = reader[4].ToString();
                    string tmpEmbg = reader[5].ToString();
                    string tmpSmena = reader[6].ToString();
                    string tmpLozinka = reader[7].ToString();

                    Vraboteni vraboten = new Vraboteni(tmpID, tmpName, tmpLastName, tmpAdress, tmpPhone, tmpEmbg, tmpSmena, tmpLozinka);
                    Form2 form2 = new Form2(this, vraboten);
                    form2.Show();
                    this.Hide();
                }

                con.Close();

                if (ima)
                {
                    MessageBox.Show("Вработениот не постои!");
                }
            }
            else
            {
                MessageBox.Show("Внесете име и лозинка!");
            }
        }