Beispiel #1
0
        public static LtaPartDetail getLtaPartInfo(string part)
        {
            //Session Login Check
            if (HttpContext.Current.Session["Connection"] == null)
            {
                throw new Exception("Session State Timeout");
            }

            //Create paging request
            LtaViewRequest gridRequest = new LtaViewRequest();

            gridRequest.search = part.Trim().ToUpper();

            //Validate request input
            if (!gridRequest.search_isValid())
            {
                //Return an empty grid
                LtaPartDetail empty = new LtaPartDetail();
                return(empty);
            }

            //Query database using request
            LtaPartDetail result;

            using (Interface db = new Interface())
            {
                result = db.getLtaPartDetail(gridRequest.search);
            }

            return(result);
        }
Beispiel #2
0
        public static LtaGrid getLtaGrid(double RequestDTStamp, string SearchValue)
        {
            //Session Login Check
            if (HttpContext.Current.Session["Connection"] == null)
            {
                throw new Exception("Session State Timeout");
            }

            //Create paging request
            LtaViewRequest gridRequest = new LtaViewRequest();

            gridRequest.search = SearchValue.Trim().ToUpper();

            //Validate request input
            if (!gridRequest._isValid())
            {
                //Return an empty grid
                LtaGrid emptyGrid = new LtaGrid();
                emptyGrid.totalRows = 0;

                return(emptyGrid);
            }

            //Query database using request
            LtaGrid results;

            using (Interface db = new Interface())
            {
                results = db.getLtaGrid(gridRequest);
            }

            return(results);
        }