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