public static object[] LoadProjectUsers() { StringBuilder sb = new StringBuilder(); Int16 devCount = 0; //get total amount of developers assigned to project List <MembershipUser> users = ProjectsDB.GetProjectUsers(ProjectsDB.GetProject(project_id)); List <ProjectUser> all_users = new List <ProjectUser>(); try { project this_project = ProjectsDB.GetProject(project_id); devCount = (Int16)users.Count; foreach (MembershipUser user in users) { ProjectUser new_user = new ProjectUser() { Username = user.UserName, User_id = user.ProviderUserKey.ToString(), Ticket_count = TicketsDB.GetUserProjectTicketCount(this_project, user), Remove_button = String.Format("<input type='button' value='X' data-user='******' class='RemoveUserFromProject' onclick='RemoveUserFromProject(this);'/>", user.ProviderUserKey) }; all_users.Add(new_user); } } catch (Exception ex) { LogsDB.AddLog("Error building project developers table", LogsDB.GetLogType("error").id, project_id, ex); } return(new object[] { all_users, devCount }); }
private void LoadUsers() { //get total amount of developers assigned to project List <MembershipUser> users = ProjectsDB.GetProjectUsers(this_project); ltlUserCount.Text = users.Count.ToString(); StringBuilder sb = new StringBuilder(); sb.Append("<table id='tblUsers' class='display project-users'>"); sb.Append("<thead>"); sb.Append("<th><strong>Name</strong></th>"); sb.Append("<th class='text-center'><strong>Total Tickets</strong></th>"); sb.Append("<th><strong>Remove</strong></th>"); sb.Append("</thead>"); sb.Append("<tbody>"); foreach (MembershipUser user in users) { sb.Append("<tr>"); sb.AppendFormat("<td>{0}</td>", user.UserName); sb.AppendFormat("<td>{0}</td>", TicketsDB.GetUserProjectTicketCount(this_project, user)); sb.AppendFormat("<td><input type='button' value='X' data-user='******' class='RemoveUserFromProject' onclick='RemoveUserFromProject(this);'/>", user.ProviderUserKey); sb.Append("</tr>"); } sb.Append("</tbody>"); sb.Append("</table>"); ltlUsers.Text = sb.ToString(); }