public string teacherSync_project(string person_id, int type_person)
{
ResponseProjectList r = new ResponseProjectList();
ProjectOwner p = new ProjectOwner();
if (type_person == 0)
{
r.code = 11;
r.msg = "Parameter Wrong";
}
else
{
string constr = WebConfigurationManager.ConnectionStrings["Dbconnection"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
con.Open();
string sqlRequest = "SELECT * FROM Relation WHERE PersID = '" + person_id + "' AND Status_ID = '1' OR Status_ID = '2'";
SqlCommand qrRequest = new SqlCommand(sqlRequest, con);
SqlDataReader reader = qrRequest.ExecuteReader();
r.projectlist = new List <ProjectOwner>();
while (reader.Read())
{
p = new ProjectOwner();
p.project = getNameProject(reader["ProjID"].ToString());
r.projectlist.Add(p);
}
reader.Close();
con.Close();
}
return(JsonConvert.SerializeObject(r));
}
public string teacherSync_project(string person_id, int type_person)
{
ResponseProjectList r = new ResponseProjectList();
ProjectOwner p = new ProjectOwner();
if (type_person == 0)
{
r.code = 11;
r.msg = "Parameter Wrong";
}
else
{
string constr = WebConfigurationManager.ConnectionStrings["Dbconnection"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
con.Open();
string sqlRequest = "SELECT * FROM Relation WHERE PersID = '" + person_id + "' AND Status_ID = '1' OR Status_ID = '2'";
SqlCommand qrRequest = new SqlCommand(sqlRequest, con);
SqlDataReader reader = qrRequest.ExecuteReader();
r.projectlist = new List<ProjectOwner>();
while (reader.Read())
{
p = new ProjectOwner();
p.project = getNameProject(reader["ProjID"].ToString());
r.projectlist.Add(p);
}
reader.Close();
con.Close();
}
return JsonConvert.SerializeObject(r);
}