public JsonResult FillTickets(Int64 ID_Tickets)
        {
            try
            {
                DataTable dtbl      = new DataTable();
                BlTickets bltickets = new BlTickets();
                bltickets.UserCode   = Convert.ToInt64(Session["ID_Agent"]);
                bltickets.FK_Company = Convert.ToInt64(Session["ID_Company"]);
                bltickets.MasterID   = ID_Tickets;
                dtbl = bltickets.SelectAllData();

                return(Json(Converttojson(dtbl), JsonRequestBehavior.AllowGet));
            }
            catch (Exception ex)
            {
                return(Json(ex));
            }
        }
        public JsonResult SelectTicketsAll(string PageIndex = "1", string SearchItem = "", string Status = "0")
        {
            try
            {
                int       statusCode = 1;
                DataTable dtbl       = new DataTable();
                BlTickets bltickets  = new BlTickets();
                bltickets.UserCode    = Convert.ToInt64(Session["ID_Agent"]);
                bltickets.FK_Company  = Convert.ToInt64(Session["ID_Company"]);
                bltickets.TickStatus  = Convert.ToInt16(Status);
                bltickets.TickNo      = SearchItem;
                bltickets.TickSubject = SearchItem;
                bltickets.ClientName  = SearchItem;
                bltickets.PageIndex   = Convert.ToInt32(PageIndex);
                dtbl = bltickets.SelectAllData();

                return(Json(Converttojson(dtbl), JsonRequestBehavior.AllowGet));
            }
            catch (Exception ex)
            {
                ///
                return(Json(ex));
            }
        }