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 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];
}
}
}
public void Initialize()
{
manager_customer = new customer();
manager_customer_address = new Manager.customer_address();
manager_tickets = new Manager.tickets();
manager_tattach = new Manager.ticketattachment();
_enums = new Manager.Enums();
//utility = new Utility();
bol_ticket = new BOL.tickets();
bol_customer = new BOL.customers();
bol_ticketattach = new BOL.ticketattachment();
bol_ticketses = new List <BOL.tickets>();
bol_customerses = new List <BOL.customers>();
bll_customer = new BLL.hunaidBLL();
bll_tickets = new BLL.tickets();
bll_ticketattach = new BLL.ticketattachment();
bll_utility = new BLL.Utility();
ConnectionString = Utility.GetConnectionString();
}
