public Int32 Update() { if (Session["bol.ticket"] != null) { BOL.tickets _ticket = (BOL.tickets)Session["bol.ticket"]; bol_ticketfeedback = new BOL.ticketfeedback(); manager_tickets = new Manager.tickets(); manager_ticketfeedback = new Manager.ticketfeedback(); if (_ticket != null) { _ticket.Title = txtTickettitle.Text; _ticket.Description = txtTicketDescription.Text; _ticket.Modifiedby = Convert.ToInt32(Session["userid"]); _ticket.Modifiedon = DateTime.Now; _ticket.Ticketstatusid = Convert.ToInt32(ddlTicketStatus.SelectedValue); manager_tickets.Update(_ticket); bol_ticketfeedback.Ticketid = _ticket.Ticketid; bol_ticketfeedback.Feedback = txtfeedback.Text; bol_ticketfeedback.Isdeleted = "F"; bol_ticketfeedback.Userid = _ticket.Modifiedby; manager_ticketfeedback.Insert(bol_ticketfeedback); } } return(0); }
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]; } } }