public string get_committee(string project_id, int type_person) { ComitteeList c = new ComitteeList(); Committee stg = new Committee(); c.commitee = new List <Committee>(); string pers_id = ""; try { string constr = WebConfigurationManager.ConnectionStrings["Dbconnection"].ConnectionString; SqlConnection con = new SqlConnection(constr); con.Open(); string sqlproject = "SELECT PersID FROM Relation WHERE Status_ID = '3' AND ProjID='" + project_id + "'"; SqlCommand qrproject = new SqlCommand(sqlproject, con); SqlDataReader reader = qrproject.ExecuteReader(); if (reader.Read()) { pers_id = reader["PersID"].ToString(); } reader.Close(); con.Close(); } catch { c.code = 1; c.msg = "Error"; return(JsonConvert.SerializeObject(c)); } try { string constr = WebConfigurationManager.ConnectionStrings["Dbconnection"].ConnectionString; SqlConnection con = new SqlConnection(constr); con.Open(); string sqlproject = "SELECT Title, Fname, Lname FROM person WHERE PersID='" + pers_id + "'"; SqlCommand qrproject = new SqlCommand(sqlproject, con); SqlDataReader reader = qrproject.ExecuteReader(); while (reader.Read()) { stg = new Committee(); stg.title_person = reader["Title"].ToString(); stg.firstName = reader["Fname"].ToString(); stg.lastName = reader["Lname"].ToString(); c.commitee.Add(stg); } reader.Close(); con.Close(); c.code = 0; c.msg = "OK"; return(JsonConvert.SerializeObject(c)); } catch { c.code = 1; c.msg = "Error"; return(JsonConvert.SerializeObject(c)); } }
public string get_committee(string project_id, int type_person) { ComitteeList c = new ComitteeList(); Committee stg = new Committee(); c.commitee = new List<Committee>(); string pers_id = ""; try { string constr = WebConfigurationManager.ConnectionStrings["Dbconnection"].ConnectionString; SqlConnection con = new SqlConnection(constr); con.Open(); string sqlproject = "SELECT PersID FROM Relation WHERE Status_ID = '3' AND ProjID='" + project_id + "'"; SqlCommand qrproject = new SqlCommand(sqlproject, con); SqlDataReader reader = qrproject.ExecuteReader(); if (reader.Read()) { pers_id = reader["PersID"].ToString(); } reader.Close(); con.Close(); } catch { c.code = 1; c.msg = "Error"; return JsonConvert.SerializeObject(c); } try { string constr = WebConfigurationManager.ConnectionStrings["Dbconnection"].ConnectionString; SqlConnection con = new SqlConnection(constr); con.Open(); string sqlproject = "SELECT Title, Fname, Lname FROM person WHERE PersID='" + pers_id + "'"; SqlCommand qrproject = new SqlCommand(sqlproject, con); SqlDataReader reader = qrproject.ExecuteReader(); while (reader.Read()) { stg = new Committee(); stg.title_person = reader["Title"].ToString(); stg.firstName = reader["Fname"].ToString(); stg.lastName = reader["Lname"].ToString(); c.commitee.Add(stg); } reader.Close(); con.Close(); c.code = 0; c.msg = "OK"; return JsonConvert.SerializeObject(c); } catch { c.code = 1; c.msg = "Error"; return JsonConvert.SerializeObject(c); } }