private void OnSelectCommandThreaded(IPooledDbConnection connection, DataTable table, object state) { connection.Release(); DispatchService.GuiDispatch(delegate() { QueryResultView view = new QueryResultView(table); IdeApp.Workbench.OpenDocument(view, true); }); }
private void eqValidate_Click(object sender, RoutedEventArgs e) { QueryResult rez = new QueryResult(computationKernel, txtInput.Text); QueryResultView view = new QueryResultView(); view.DataContext = rez; view.AppWindow = this; panelResult.Children.Add(view); txtInput.Text = ""; mainScrolView.ScrollToEnd(); }
public JsonResult Query(ProductView productView) { QueryResultView <Product> products = this._productDao.Query(productView); //var product = null; //object model=null; //foreach (var product in products) //{ // model = product; //} return(Json(products)); }
public JsonResult Query(CustomerView customerView) { this._logger.LogInformation("enter 'Query' method."); QueryResultView <Customer> customers = this._customerDao.Query(customerView); this._logger.LogInformation("++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++"); this._logger.LogInformation($"Get {customers.TotalData} data."); foreach (Customer customer in customers.Results) { this._logger.LogInformation(customer.ToString()); } this._logger.LogInformation("++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++"); return(Json(customers)); }
public QueryResultView <Store> Query(StoreView queryObject) { QueryResultView <Store> results = new QueryResultView <Store>(); IQueryable <Store> stores = null; if (queryObject != null) { stores = this._context.Stores.Where(s => s.Name.Contains(queryObject.NameQry) && s.Address.Contains(queryObject.AddressQry)); } else { stores = this._context.Stores; } results.TotalData = stores.Count(); results.Results = stores.Skip(queryObject.SkipData).Take(queryObject.DataPerPage).ToList(); return(results); }
public QueryResultView <Customer> Query(CustomerView queryCustomer) { QueryResultView <Customer> queryResult = new QueryResultView <Customer>(); IQueryable <Customer> customers = null; if (queryCustomer != null) { customers = _context.Customers .Where(c => c.Name.Contains(queryCustomer.NameQry) && c.Address.Contains(queryCustomer.AddressQry)); } else { customers = _context.Customers; } queryResult.TotalData = customers.Count(); queryResult.Results = customers.Skip(queryCustomer.SkipData).Take(queryCustomer.DataPerPage).ToList(); return(queryResult); }
public QueryResultView <Product> Query(ProductView queryObject) { QueryResultView <Product> queryResults = new QueryResultView <Product>(); IQueryable <Product> products = null; if (queryObject != null) { products = _context.Products.Where(p => p.Name.Contains(queryObject.NameQry) && p.Price == (queryObject.PriceQry == 0 ? p.Price : queryObject.PriceQry)); } else { products = _context.Products; } queryResults.TotalData = products.Count(); queryResults.Results = products.Skip(queryObject.SkipData).Take(queryObject.DataPerPage).ToList(); return(queryResults); }
public QueryResultView <Sales> Query(SalesView queryObject) { QueryResultView <Sales> results = new QueryResultView <Sales>(); IQueryable <Sales> sales = null; if (queryObject != null) { sales = this._context.Sales.Where(s => s.DateSold.Contains(queryObject.DateSoldQry) && s.Customer.Id == (queryObject.CustomerId == 0?s.Customer.Id : queryObject.CustomerId) && s.Product.Id == (queryObject.ProductId == 0?s.Product.Id:queryObject.ProductId) && s.Store.Id == (queryObject.StoreId == 0?s.Store.Id:queryObject.StoreId)).Include(x => x.Customer).Include(x => x.Product).Include(x => x.Store); } else { sales = this._context.Sales; } results.TotalData = sales.Count(); results.Results = sales.Skip(queryObject.SkipData).Take(queryObject.DataPerPage).ToList(); return(results); }
public JsonResult Query(SalesView salesView) { QueryResultView <Sales> saless = this._salesDao.Query(salesView); return(Json(saless)); }
public JsonResult Query(StoreView storeView) { QueryResultView <Store> stores = this._storeDao.Query(storeView); return(Json(stores)); }