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