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; //} }