private void comboBox4_SelectedIndexChanged(object sender, EventArgs e)
{
string Constring = "datasource=localhost;port=3306;username=root;password="******"select * from youken_springs.employee where e_id ='" + comboBox4.Text + "';";
string quarry2 = "select * from youken_springs.job where e_id ='" + comboBox4.Text + "';";
MySqlConnection ConDataBase = new MySqlConnection(Constring);
MySqlConnection ConDataBase2 = new MySqlConnection(Constring);
MySqlCommand cmdDataBase = new MySqlCommand(quarry, ConDataBase);
MySqlCommand cmdDataBase2 = new MySqlCommand(quarry2, ConDataBase2);
MySqlDataReader MyReader;
MySqlDataReader MyReader2;
try
{
ConDataBase.Open();
MyReader = cmdDataBase.ExecuteReader();
/* IFormatProvider theCultureInfo = new System.Globalization.CultureInfo("en-GB", true);
* DateTime join_date = DateTime.ParseExact(txt_joinDate.Text, "dd/MM/yyyy", theCultureInfo);
* DateTime today = DateTime.Now;
* txt_wkdduration.Text = ((today - join_date).TotalDays).ToString();*/
//DateTime date = DateTime.ParseExact(this.Text, "dd/MM/yyyy", null)theCultureInfo
while (MyReader.Read())
{
txt_flname.Text = MyReader.GetString("e_full_name");
txt_add1.Text = MyReader.GetString("address_line1");
txt_add2.Text = MyReader.GetString("address_line2");
txt_addCity.Text = MyReader.GetString("city");
// txt_sal.Text = (MyReader["salary"].ToString());
lbl_em_id.Text = MyReader.GetUInt32("e_id").ToString();
lbl_pro_em_id.Text = MyReader.GetUInt32("e_id").ToString();
e_id = lbl_pro_em_id.Text;
lbl_fullAdd.Text = txt_add1.Text + "," + "" + txt_add2.Text + "," + "" + txt_addCity.Text;
}
ConDataBase.Close();
ConDataBase2.Open();
MyReader2 = cmdDataBase2.ExecuteReader();
while (MyReader2.Read())
{
txt_joinDate.Text = MyReader2.GetString("join_date");
txt_position.Text = MyReader2.GetString("designation");
}
ConDataBase2.Close();
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
private void cmb_mat_name2_SelectedIndexChanged(object sender, EventArgs e)
{
string Constring = "datasource=localhost;port=3306;username=root;password="******"select * from youken_springs.meterial where meterial_name ='" + cmb_mat_name2.Text + "';";
MySqlConnection ConDataBase = new MySqlConnection(Constring);
MySqlCommand cmdDataBase = new MySqlCommand(quarry, ConDataBase);
MySqlDataReader MyReader;
try
{
ConDataBase.Open();
MyReader = cmdDataBase.ExecuteReader();
while (MyReader.Read())
{
lbl_mat_id2.Text = MyReader.GetUInt32("meterial_id").ToString();
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
private void cmb_product_name1_SelectedIndexChanged(object sender, EventArgs e)
{
string Constring = "datasource=localhost;port=3306;username=root;password="******"select * from youken_springs.products where name ='" + cmb_product_name1.Text + "';";
MySqlConnection ConDataBase = new MySqlConnection(Constring);
MySqlCommand cmdDataBase = new MySqlCommand(quarry, ConDataBase);
MySqlDataReader MyReader;
try
{
ConDataBase.Open();
MyReader = cmdDataBase.ExecuteReader();
while (MyReader.Read())
{
lbl_prduct_id1.Text = MyReader.GetUInt32("product_id").ToString();
lbl_des1.Text = MyReader.GetString("description");
lbl_unitP1.Text = MyReader.GetUInt32("unit_price").ToString();
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
