//public void getMonthComboValues()
//{
// String[] m = {"January","February","March","April","May","June","July","August","September","October","November","December"};
// MySqlConnection MyConn = ConnectionOld.getConnection();
// MySqlCommand SelectCommand = new MySqlCommand("select distinct Month from ot;", MyConn);
// MySqlDataReader MyReader;
// MyConn.Open();
// MyReader = SelectCommand.ExecuteReader();
// while (MyReader.Read())
// {
// String mon = MyReader.GetString("Month");
// for (int i = 0; i < m.Length; i++)
// {
// if (mon != m[0])
// {
// combo_Month.Items.Add(mon);
// }
// }
// }
//}
public void getDetails()
{
MySqlConnection MyConn = ConnectionOld.getConnection();
MySqlCommand SelectCommand = new MySqlCommand("select * from itp.employee where EmpId = '" + Connection.getUserIdFromConnectionString() + "' ;", MyConn);
MySqlDataReader MyReader;
MyConn.Open();
MyReader = SelectCommand.ExecuteReader();
while (MyReader.Read())
{
Emp_txt.Text = MyReader.GetInt32("EmpId").ToString();
First_txt.Text = MyReader.GetString("FirstName");
Last_txt.Text = MyReader.GetString("LastName");
dateTimePicker1.Text = MyReader.GetString("DOB");
if ((MyReader.GetString("Nationality") == "SriLankan"))
{
combo_Nat.Text = "SriLankan";
}
else
{
combo_Nat.Text = "Foreigner";
Nat_txt.Text = MyReader.GetString("Nationality");
}
NIC_txt.Text = MyReader.GetString("NIC");
Add_txt.Text = MyReader.GetString("Address");
Email_txt.Text = MyReader.GetString("Email");
Mob_txt.Text = MyReader.GetString("MobileNo");
Posi_combo.Text = MyReader.GetString("Position");
Dep_txt.Text = MyReader.GetString("DepId");
textBox5.Text = MyReader.GetDouble("BasicSalary").ToString();
String gender = MyReader.GetChar("Gender").ToString();
if (gender == "M")
{
radioButton1.Checked = true;
}
else
{
radioButton2.Checked = true;
}
}
}
