public Supervisor(int user_id,string unit_name, User user, Supervisor supervisor) { this.USER_ID = user_id; this.UNIT_NAME = unit_name; this._USER = user; this._SUPERVISOR = supervisor; }
//add skills for the supervisor public Supervisor[] SearchSupervisorByUnits(string searchInput) { Unit[] unit_id = SearchUnits(searchInput); List<Supervisor> supervisor = new List<Supervisor>(); for (int i = 0; i < unit_id.Length; i++) { string sql = "SELECT `skill_id`, `experience`, `user_id` FROM `super_skills` WHERE `unit_id`=" + unit_id[i].UNIT_ID; con = new MySqlConnection(connectionString); cmd = new MySqlCommand(sql, con); try { con.Open();//open connection MySqlDataReader _dr = cmd.ExecuteReader(); while (_dr.Read()) { Supervisor s = new Supervisor((int)_dr["user_id"],unit_id[i].UNIT_NAME, LoadProfile((int)_dr["user_id"]), GetSupervisor((int)_dr["user_id"])); supervisor.Add(s); } _dr.Close(); } catch (MySqlException ex)// incase of errors catch them here { throw new Exception(ex.Message); } finally { con.Close(); } } return supervisor.ToArray(); }
// returns all the details of a supervisors details based on their profesions public Supervisor[] SearchSupervisorByProfession(string profession) { profession = profession.Trim(); List<Supervisor> supervisor = new List<Supervisor>(); if (!string.IsNullOrWhiteSpace(profession) && !string.IsNullOrEmpty(profession)) { string sql = "SELECT `supervisor`.`user_id`" + "FROM `supervisor` " + "LEFT JOIN `users` ON(`supervisor`.`user_id`=`users`.`user_id`) " + " WHERE `supervisor`.`super_profesion`LIKE '%" + profession + "%'" + " AND `users`.`user_type`<>0"; con = new MySqlConnection(connectionString); cmd = new MySqlCommand(sql, con); try { con.Open();//open connection MySqlDataReader _dr = cmd.ExecuteReader(); while (_dr.Read()) { Supervisor s = new Supervisor((int)_dr["user_id"], LoadProfile((int)_dr["user_id"]), GetSupervisor((int)_dr["user_id"])); supervisor.Add(s); } _dr.Close(); } catch (MySqlException ex)// incase of errors catch them here { throw new Exception(ex.Message); } finally { con.Close(); } } return supervisor.ToArray(); }
public Supervisor GetSupervisor(int user_id) { Supervisor supervisor = new Supervisor(); string sql = "SELECT `supervisor`.`super_id`,`supervisor`.`super_profesion`,`supervisor`.`physical_location` " + "FROM `supervisor` " + "LEFT JOIN `users` ON(`supervisor`.`user_id`=`users`.`user_id`) " + " WHERE `supervisor`.`user_id` =" + user_id + " AND `users`.`user_type`<>0"; con = new MySqlConnection(connectionString); cmd = new MySqlCommand(sql, con); try { con.Open();//open connection MySqlDataReader _dr = cmd.ExecuteReader(); if (_dr.Read()) { supervisor = new Supervisor( (int)_dr["super_id"], _dr["super_profesion"].ToString(), _dr["physical_location"].ToString()); } _dr.Close(); } catch (MySqlException ex)// incase of errors catch them here { throw new Exception(ex.Message); } finally { con.Close(); } return supervisor; }
public Supervisor(int user_id, User user, Supervisor supervisor) { this.USER_ID = user_id; this._USER = user; this._SUPERVISOR = supervisor; }