public HttpResponseMessage Post(SearchString searchString)
        {
            try
            {
                SearchQueryResponse resp = LUISAdapter.GetSearchQuery(searchString.Query);

                if (!String.IsNullOrEmpty(resp.SearchQuery))
                {
                    List <DisplayOrder> orders = new List <DisplayOrder>();
                    using (MySqlConnection conn = DBUtils.GetConnection())
                    {
                        DisplayOrderHistoryRepository repo = new DisplayOrderHistoryRepository(conn);
                        orders = repo.GetByQuery(resp.SearchQuery).ToList <DisplayOrder>();
                    }

                    return(Request.CreateResponse(HttpStatusCode.OK, orders));
                }

                return(Request.CreateResponse(HttpStatusCode.OK, new List <DisplayOrder>()));
            }
            catch (Exception ex)
            {
                return(Request.CreateResponse(HttpStatusCode.OK, ex.Message));
            }
        }
Пример #2
0
        public ActionResult Index(string searchString)
        {
            List <DisplayOrder> orders = new List <DisplayOrder>();

            using (MySqlConnection conn = DBUtils.GetConnection())
            {
                DisplayOrderHistoryRepository repo = new DisplayOrderHistoryRepository(conn);
                orders = repo.GetByQuery(searchString).ToList <DisplayOrder>();
            }
            return(PartialView("Orders", orders));
        }
Пример #3
0
        // GET: Order
        public ActionResult Index()
        {
            List <DisplayOrder> orders = new List <DisplayOrder>();

            using (MySqlConnection conn = DBUtils.GetConnection())
            {
                DisplayOrderHistoryRepository repo = new DisplayOrderHistoryRepository(conn);
                orders = repo.GetAll().ToList <DisplayOrder>();
            }
            return(View(orders));
        }
        public HttpResponseMessage Orders()
        {
            try
            {
                List <DisplayOrder> orders = new List <DisplayOrder>();
                using (MySqlConnection conn = DBUtils.GetConnection())
                {
                    DisplayOrderHistoryRepository repo = new DisplayOrderHistoryRepository(conn);
                    orders = repo.GetAll().ToList <DisplayOrder>();
                }

                return(Request.CreateResponse(HttpStatusCode.OK, orders));
            }
            catch (Exception ex)
            {
                return(Request.CreateResponse(HttpStatusCode.OK, ex.Message));
            }
        }