public string getProjects(int currentUserId) { projectTree = ""; try { dbConn.Open(); MySqlCommand cmd = new MySqlCommand("allProjects", dbConn); cmd.CommandType = CommandType.StoredProcedure; DataTable dt = new DataTable(); MySqlDataAdapter da = new MySqlDataAdapter(cmd); da.Fill(dt); allProjects = new List <project>(); for (int i = 0; i < dt.Rows.Count; i++) { project p = new project(); p.id = (int)dt.Rows[i][0]; p.name = (string)dt.Rows[i][1]; if (dt.Rows[i][2] != DBNull.Value) { p.parent_id = (int)dt.Rows[i][2]; } allProjects.Add(p); } List <project> projects = new List <project>(); MySqlCommand cmd2 = new MySqlCommand("slaProjectsByUsers", dbConn); cmd2.Parameters.AddWithValue("@user_id", currentUserId); cmd2.CommandType = CommandType.StoredProcedure; DataTable dt2 = new DataTable(); MySqlDataAdapter da2 = new MySqlDataAdapter(cmd2); da2.Fill(dt2); projectTree = "{value: null, options: ["; bool changed = false; for (int i = 0; i < dt2.Rows.Count; i++) { project p = new project(); p.id = Convert.ToInt32(dt2.Rows[i][0]); p.name = dt2.Rows[i][1].ToString(); if (dt2.Rows[i][2] != DBNull.Value) { p.parent_id = Convert.ToInt32(dt2.Rows[i][2]); } projects.Add(p); if (changed) { projectTree += ", "; } projectTree += "{ id: " + p.id + ", "; projectTree += "label: '" + p.name + "'"; getSubProject(p.id); projectTree += " }"; changed = true; } projectTree += "]}"; dbConn.Close(); } catch { } return(projectTree); }
public string getProjects(string projectsName) { selectedProjectsWithSub.Clear(); string last_state = ""; try { dbConn.Open(); MySqlCommand cmd = new MySqlCommand("allProjects", dbConn); cmd.CommandType = CommandType.StoredProcedure; DataTable dt = new DataTable(); MySqlDataAdapter da = new MySqlDataAdapter(cmd); da.Fill(dt); allProjects = new List <project>(); for (int i = 0; i < dt.Rows.Count; i++) { project p = new project(); p.id = (int)dt.Rows[i][0]; p.name = (string)dt.Rows[i][1]; if (dt.Rows[i][2] != DBNull.Value) { p.parent_id = (int)dt.Rows[i][2]; } allProjects.Add(p); } string[] projectsList = projectsName.Split(','); for (int i = 0; i < projectsList.Length; i++) { projectsList[i] = projectsList[i].Trim(); } List <project> selectedProjects = new List <project>(); for (int i = 0; i < projectsList.Count(); i++) { for (int j = 0; j < allProjects.Count; j++) { if (projectsList[i] == allProjects[j].name) { selectedProjects.Add(allProjects[j]); break; } } } for (int i = 0; i < selectedProjects.Count; i++) { selectedProjectsWithSub.Add(selectedProjects[i].id); getSubProject_StringMode(selectedProjects[i].id); } dbConn.Close(); bool first_control = false; for (int i = 0; i < selectedProjectsWithSub.Count; i++) { if (!first_control) { last_state += selectedProjectsWithSub[i]; first_control = true; } else { last_state += "," + selectedProjectsWithSub[i]; } } if (last_state == "") { last_state = "0"; } } catch { } return(last_state); }