public JsonResult SelectAllTickets(string PageIndex = "1", string Status = "0", string SearchItem = "")
        {
            try
            {
                int           statusCode    = 1;
                DataTable     dtbl          = new DataTable();
                BlUserTickets blusertickets = new BlUserTickets();
                blusertickets.UserCode   = Convert.ToInt64(Session["ID_Users"]);
                blusertickets.FK_Company = Convert.ToInt64(Session["ID_Company"]);

                blusertickets.TickNo      = SearchItem;
                blusertickets.TickSubject = SearchItem;
                blusertickets.ProdName    = SearchItem;


                blusertickets.TickStatus = Convert.ToInt16(Status);
                blusertickets.PageIndex  = Convert.ToInt32(PageIndex);
                dtbl = blusertickets.SelectAllData();
                return(Json(Converttojson(dtbl), JsonRequestBehavior.AllowGet));
            }
            catch (Exception ex)
            {
                ///
                return(Json(ex));
            }
        }