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));
}
