public static Employee getEmployee(string no)
{
//try
//{
DBConnector dbcon = new DBConnector();
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "SELECT * FROM employee WHERE employee_no=N'" + no + "'";
cmd.Connection = dbcon.connection;
MySqlDataReader reader = cmd.ExecuteReader();
Employee e = null;
if (reader.Read())
{
e = new Employee();
Employee.employee_id = int.Parse(reader["idemployee"].ToString());
Employee.emp_no = reader["employee_no"].ToString();
Employee.employee_name = reader["full_name"].ToString();
Console.Write(Employee.employee_id+"\n");
e.setAction_status(reader["action_status"].ToString());
e.setBlood_grouph(reader["blood_group"].ToString());
e.setDate_issued(reader["date_issued"].ToString());
e.setDate_of_birth(Convert.ToDateTime(reader["date_of_birth"]));
e.setDate_of_marriage(Convert.ToDateTime(reader["date_of_marriage"]));
e.setEmployee_no(reader["employee_no"].ToString());
e.setEmployee_type(reader["employee_type"].ToString());
e.setEpf_no(reader["epf_no"].ToString());
e.setFirst_name(reader["first_name"].ToString());
e.setLast_name(reader["last_name"].ToString());
e.setFull_name(reader["full_name"].ToString());
e.setImg_url(reader["image_url"].ToString());
e.setInitials(reader["initials"].ToString());
if (reader["married"].ToString() == "True") { e.setMarried(1); }
else { e.setMarried(0); }
e.setNationality(reader["nationality"].ToString());
e.setNic_no(reader["nic_no"].ToString());
e.setOccupation(reader["occupation"].ToString());
e.setOld_employee_no(reader["old_employee_no"].ToString());
e.setPlace_of_birth(reader["place_of_birth"].ToString());
e.setReligion(reader["religion"].ToString());
e.setSalutation(reader["salutation"].ToString());
}
reader.Close();
dbcon.closeConnection();
return e;
}
else
{
return null;
}
//}
//catch (MySqlException e)
//{
//int errorcode = e.Number;
//return null;
//}
}