//-----------------------------------------------------NEW
public string student_sync(string person_id, int type_person)
{
ResponseMsgList q = new ResponseMsgList();
ProjectLogs s = new ProjectLogs();
if (type_person != 0)
{
q.code = 11;
q.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 Subject,Date FROM ProjectOperations WHERE ProjID = '" + project_id + "'";
SqlCommand qrproject = new SqlCommand(sqlproject, con);
SqlDataReader reader = qrproject.ExecuteReader();
q.Logs = new List <ProjectLogs>();
while (reader.Read())
{
s = new ProjectLogs();
s.logs_topic = reader["Subject"].ToString();
s.date = reader["Date"].ToString();
q.Logs.Add(s);
}
reader.Close();
con.Close();
q.code = 0;
q.msg = "OK";
if (getState(project_id) != -1)
{
q.state = getState(project_id);
}
else
{
q.code = 11;
q.msg = "Parameter Wrong";
}
}
catch
{
q.code = 9;
q.msg = "Database Error";
}
}
return(JsonConvert.SerializeObject(q));
}
//-----------------------------------------------------NEW
public string student_sync(string person_id, int type_person)
{
ResponseMsgList q = new ResponseMsgList();
ProjectLogs s = new ProjectLogs();
if (type_person != 0)
{
q.code = 11;
q.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 Subject,Date FROM ProjectOperations WHERE ProjID = '" + project_id + "'";
SqlCommand qrproject = new SqlCommand(sqlproject, con);
SqlDataReader reader = qrproject.ExecuteReader();
q.Logs = new List<ProjectLogs>();
while(reader.Read())
{
s = new ProjectLogs();
s.logs_topic = reader["Subject"].ToString();
s.date = reader["Date"].ToString();
q.Logs.Add(s);
}
reader.Close();
con.Close();
q.code = 0;
q.msg = "OK";
if (getState(project_id) != -1)
{
q.state = getState(project_id);
}
else
{
q.code = 11;
q.msg = "Parameter Wrong";
}
}
catch
{
q.code = 9;
q.msg = "Database Error";
}
}
return JsonConvert.SerializeObject(q);
}
