//-----------------------------------------------------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); }