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; }
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; }
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("Внесете име и лозинка!"); } }
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("Внесете име и лозинка!"); } }