private void button5_Click(object sender, EventArgs e)
{
string code = this.textBox1.Text;
string name = this.textBox2.Text;
employees frm = new employees();
frm.showdi(ref code, ref name);
this.textBox2.Text = name;
this.textBox1.Text = code;
try
{
con.OpenConection();
SqlCommand cmd = new SqlCommand("fill_evaluation", con.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("emp_id", Int32.Parse(textBox1.Text));
var b = cmd.Parameters.Add("presidence", SqlDbType.VarChar, 255);
b.Direction = ParameterDirection.Output;
var c = cmd.Parameters.Add("arrival_time", SqlDbType.VarChar, 255);
c.Direction = ParameterDirection.Output;
var d = cmd.Parameters.Add("work_evaluation", SqlDbType.VarChar, 255);
d.Direction = ParameterDirection.Output;
var l = cmd.Parameters.Add("apperance_evaluation", SqlDbType.VarChar, 255);
l.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
textBox3.Text = b.Value.ToString();
textBox4.Text = c.Value.ToString();
comboBox1.SelectedItem = d.Value.ToString();
comboBox2.SelectedItem = l.Value.ToString();
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
private void button5_Click(object sender, EventArgs e)
{
string code = this.textBox1.Text;
string name = this.textBox2.Text;
employees frm = new employees();
frm.showdi(ref code, ref name);
this.textBox2.Text = name;
this.textBox1.Text = code;
}
private void button5_Click(object sender, EventArgs e)
{
string code = this.textBox1.Text;
string name = this.textBox2.Text;
employees frm = new employees();
frm.showdi(ref code, ref name);
this.textBox2.Text = name;
this.textBox1.Text = code;
try
{
con.OpenConection();
SqlCommand cmd = new SqlCommand("fill_emp", con.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("emp_id", Int32.Parse(textBox1.Text));
var b = cmd.Parameters.Add("name", SqlDbType.VarChar, 255);
b.Direction = ParameterDirection.Output;
var c = cmd.Parameters.Add("addreess", SqlDbType.VarChar, 255);
c.Direction = ParameterDirection.Output;
var d = cmd.Parameters.Add("phone", SqlDbType.VarChar, 255);
d.Direction = ParameterDirection.Output;
var a = cmd.Parameters.Add("statuus", SqlDbType.VarChar, 255);
a.Direction = ParameterDirection.Output;
var f = cmd.Parameters.Add("email", SqlDbType.VarChar, 255);
f.Direction = ParameterDirection.Output;
var g = cmd.Parameters.Add("gender", SqlDbType.VarChar, 255);
g.Direction = ParameterDirection.Output;
var h = cmd.Parameters.Add("birth_date", SqlDbType.Date);
h.Direction = ParameterDirection.Output;
var i = cmd.Parameters.Add("religion", SqlDbType.VarChar, 255);
i.Direction = ParameterDirection.Output;
var j = cmd.Parameters.Add("birth_place", SqlDbType.VarChar, 255);
j.Direction = ParameterDirection.Output;
var k = cmd.Parameters.Add("nationality", SqlDbType.VarChar, 255);
k.Direction = ParameterDirection.Output;
var l = cmd.Parameters.Add("card_id", SqlDbType.Int);
l.Direction = ParameterDirection.Output;
var m = cmd.Parameters.Add("card_realease_place", SqlDbType.VarChar, 255);
m.Direction = ParameterDirection.Output;
var n = cmd.Parameters.Add("card_realease_date", SqlDbType.Date);
n.Direction = ParameterDirection.Output;
var o = cmd.Parameters.Add("qualification", SqlDbType.VarChar, 255);
o.Direction = ParameterDirection.Output;
var p = cmd.Parameters.Add("qualification_date", SqlDbType.Date);
p.Direction = ParameterDirection.Output;
var q = cmd.Parameters.Add("years_of_experience", SqlDbType.Int);
q.Direction = ParameterDirection.Output;
var r = cmd.Parameters.Add("experience", SqlDbType.VarChar, 255);
r.Direction = ParameterDirection.Output;
var s = cmd.Parameters.Add("prevoius_jobs", SqlDbType.VarChar, 255);
s.Direction = ParameterDirection.Output;
var t = cmd.Parameters.Add("hiring_date", SqlDbType.Date);
t.Direction = ParameterDirection.Output;
var u = cmd.Parameters.Add("personal_picture", SqlDbType.VarChar, 255);
u.Direction = ParameterDirection.Output;
var v = cmd.Parameters.Add("career_level", SqlDbType.VarChar, 255);
v.Direction = ParameterDirection.Output;
var w = cmd.Parameters.Add("career_name", SqlDbType.VarChar, 255);
w.Direction = ParameterDirection.Output;
var x = cmd.Parameters.Add("career_state", SqlDbType.VarChar, 255);
x.Direction = ParameterDirection.Output;
var y = cmd.Parameters.Add("dep_code", SqlDbType.Int);
y.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
textBox2.Text = b.Value.ToString();
textBox3.Text = c.Value.ToString();
textBox4.Text = d.Value.ToString();
comboBox2.SelectedItem = a.Value.ToString();
textBox6.Text = f.Value.ToString();
comboBox1.SelectedItem = g.Value.ToString();
dateTimePicker1.Value = (DateTime)h.Value;
textBox7.Text = i.Value.ToString();
textBox8.Text = j.Value.ToString();
textBox9.Text = k.Value.ToString();
textBox10.Text = l.Value.ToString();
textBox11.Text = m.Value.ToString();
dateTimePicker2.Value = (DateTime)n.Value;
textBox13.Text = o.Value.ToString();
dateTimePicker3.Value = (DateTime)p.Value;
textBox16.Text = q.Value.ToString();
textBox17.Text = r.Value.ToString();
textBox19.Text = s.Value.ToString();
dateTimePicker4.Value = (DateTime)t.Value;
textBox12.Text = u.Value.ToString();
comboBox3.SelectedItem = v.Value.ToString();
textBox23.Text = w.Value.ToString();
comboBox4.SelectedItem = x.Value.ToString();
textBox5.Text = y.Value.ToString();
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
con.CloseConnection();
}
