public string teacherSync_request(string person_id, int type_person)
{
ResponseRequestList r = new ResponseRequestList();
ProjectRequest p = new ProjectRequest();
if (type_person == 0)
{
r.code = 11;
r.msg = "Parameter Wrong";
}
else
{
try
{
string constr = WebConfigurationManager.ConnectionStrings["Dbconnection"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
con.Open();
//project_id = getProjectID(person_id);
string sqlproject = "SELECT * FROM Request_Title WHERE AcceptanceID = '" + person_id + "'";
SqlCommand qrproject = new SqlCommand(sqlproject, con);
SqlDataReader reader = qrproject.ExecuteReader();
r.request = new List <ProjectRequest>();
while (reader.Read())
{
p = new ProjectRequest();
p.project_id = reader["ProjID"].ToString();
// p.project_id = getNameProject(reader["ProjID"].ToString());
p.project_title = getRequest(reader["ReqID"].ToString());
p.date = reader["Date"].ToString();
r.request.Add(p);
}
reader.Close();
con.Close();
r.code = 0;
r.msg = "OK";
}
catch
{
r.code = 9;
r.msg = "Database Error";
}
}
return(JsonConvert.SerializeObject(r));
}
public string teacherSync_request(string person_id, int type_person)
{
ResponseRequestList r = new ResponseRequestList();
ProjectRequest p = new ProjectRequest();
if (type_person == 0)
{
r.code = 11;
r.msg = "Parameter Wrong";
}
else
{
try
{
string constr = WebConfigurationManager.ConnectionStrings["Dbconnection"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
con.Open();
//project_id = getProjectID(person_id);
string sqlproject = "SELECT * FROM Request_Title WHERE AcceptanceID = '" + person_id + "'";
SqlCommand qrproject = new SqlCommand(sqlproject, con);
SqlDataReader reader = qrproject.ExecuteReader();
r.request = new List<ProjectRequest>();
while (reader.Read())
{
p = new ProjectRequest();
p.project_id = reader["ProjID"].ToString();
// p.project_id = getNameProject(reader["ProjID"].ToString());
p.project_title = getRequest(reader["ReqID"].ToString());
p.date = reader["Date"].ToString();
r.request.Add(p);
}
reader.Close();
con.Close();
r.code = 0;
r.msg = "OK";
}
catch
{
r.code = 9;
r.msg = "Database Error";
}
}
return JsonConvert.SerializeObject(r);
}
