public List <BOL.tickets> TicketsbyUserid(BOL.tickets _ticket) { manager_tickets = new Manager.tickets(); if (manager_tickets != null && _ticket != null && _ticket.Userid > 0) { List <BOL.tickets> _ticketses = manager_tickets.Select(_ticket); if (_ticketses != null && _ticketses.Count > 0) { return(_ticketses); } } return(new List <BOL.tickets>()); }
public void LoadTicket() { if (Request.QueryString["id"] != null && Convert.ToInt32(Convert.ToString(Request.QueryString["id"])) > 0) { manager_tickets = new Manager.tickets(); manager_ticketfeedback = new Manager.ticketfeedback(); manager_ticketattachment = new Manager.ticketattachment(); bol_tickets = new BOL.tickets(); bol_ticketfeedback = new BOL.ticketfeedback(); bol_ticketattachment = new BOL.ticketattachment(); bol_tickets.Ticketid = Convert.ToInt32(Convert.ToString(Request.QueryString["id"])); List <BOL.tickets> _ticketses = manager_tickets.Select(bol_tickets); if (_ticketses != null && _ticketses.Count > 0 && _ticketses[0].Ticketid > 0) { txtTickettitle.Text = _ticketses[0].Title; txtTicketDescription.Text = _ticketses[0].Description; ddlTicketStatus.SelectedValue = _ticketses[0].Ticketstatusid.ToString(); bol_ticketfeedback.Ticketid = _ticketses[0].Ticketid; bol_ticketattachment.Ticketid = _ticketses[0].Ticketid; _ticketses[0].Ticketfeedbacks = manager_ticketfeedback.GetAllFeedbacksByTicket(bol_ticketfeedback); _ticketses[0].Ticketattachments = manager_ticketattachment.Select(bol_ticketattachment); if (_ticketses[0].Ticketfeedbacks != null && _ticketses[0].Ticketfeedbacks.Count > 0) { _ticketses[0].Ticketfeedbacks.OrderByDescending(t => t.Ticketfeedbackid); txtfeedback.Text = _ticketses[0].Ticketfeedbacks[0].Feedback; repFeedbackHistory.DataSource = _ticketses[0].Ticketfeedbacks.OrderByDescending(t => t.Ticketfeedbackid); repFeedbackHistory.DataBind(); } repAttachment.DataSource = _ticketses[0].Ticketattachments.OrderByDescending(t => t.Ticketattachmentid); repAttachment.DataBind(); Session["bol.ticket"] = _ticketses[0]; } } }