private void LoadDevs() { //get total amount of developers assigned to project List <MembershipUser> devs = ProjectsDB.GetProjectDevs(this_project); ltlDevCount.Text = devs.Count.ToString(); StringBuilder sb = new StringBuilder(); sb.Append("<table id='tblDevelopers' 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 dev in devs) { sb.Append("<tr>"); sb.AppendFormat("<td>{0}</td>", dev.UserName); sb.AppendFormat("<td>{0}</td>", TicketsDB.GetDevProjectTicketCount(this_project, dev)); sb.AppendFormat("<td><input type='button' value='X' data-user='******' class='RemoveUserFromProject' onclick='RemoveUserFromProject(this);'/>", dev.ProviderUserKey); sb.Append("</tr>"); } sb.Append("</tbody>"); sb.Append("</table>"); ltlDevs.Text = sb.ToString(); }
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 }); }
protected void btnCreateTicket_Click(object sender, EventArgs e) { ticket new_ticket = new ticket(); string ticket_message = null; try { new_ticket.created_by = new Guid(Session["userid"].ToString().Trim()); new_ticket.created_date = DateTime.Now; new_ticket.title = txtTicketTitle.Text; new_ticket.description = txtTicketDescr.Text; new_ticket.priority = Convert.ToInt32(ddlTicketPriority.SelectedValue); new_ticket.status = TicketsDB.GetStatus("Open").id; TicketsDB.AddEditTicket(new_ticket); ticket_message = TicketsDB.GenerateTicketNumber(new_ticket); } catch (Exception ex) { log_type type = LogsDB.GetLogType("error"); LogsDB.AddLog("Error creating new ticket", type.id, ex); ticket_message = "Unexpected error creating ticket. Refresh page and try again or contact IT"; } ltlMessage.Text = String.Format("<span class='success-message'>{0}</span>", ticket_message); }
private void LoadTicketPriority() { List <ticket_priority> ticket_priorities = TicketsDB.GetTicket_Priorities(); ListItem item; foreach (ticket_priority priority in ticket_priorities) { item = new ListItem() { Text = priority.description, Value = priority.id.ToString() }; ddlTicketPriority.Items.Add(item); } }
private void LoadTickets() { List <project_detail> tickets = ProjectsDB.GetProjectTickets(this_project); ltlTicketCount.Text = tickets.Count().ToString(); StringBuilder sb = new StringBuilder(); sb.Append("<table id='tblTickets' class='display'>"); sb.Append("<thead>"); sb.Append("<th><strong>ID</strong></th>"); sb.Append("<th><strong>Title</strong></th>"); sb.Append("<th class='text-center'><strong>Created By</strong></th>"); sb.Append("<th class='text-center'><strong>Created Date</strong></th>"); sb.Append("<th><strong>Status</strong></th>"); sb.Append("<th><strong>Priority</strong></th>"); sb.Append("<th><strong>Assigned To</strong></th>"); sb.Append("</thead>"); sb.Append("<tbody>"); foreach (project_detail ticket in tickets) { sb.Append("<tr>"); sb.AppendFormat("<td>{0}</td>", TicketsDB.GenerateTicketNumber(TicketsDB.GetTicketHeader(ticket.ticket_id))); sb.AppendFormat("<td>{0}</td>", ticket.title); sb.AppendFormat("<td>{0}</td>", ticket.created_by); sb.AppendFormat("<td>{0: dd/MM/yyyy}</td>", ticket.created_date); sb.AppendFormat("<td>{0}</td>", ticket.status); sb.AppendFormat("<td>{0}</td>", ticket.priority); sb.AppendFormat("<td>{0}</td>", ticket.dev); sb.Append("</tr>"); } sb.Append("</tbody>"); sb.Append("</table>"); ltlTicketsOpen.Text = sb.ToString(); }