public ProductsCollection Products_LoadWithExtraColumn()
{
ProductsQuery p = new ProductsQuery("p");
SuppliersQuery s = new SuppliersQuery("s");
// Bring back the suppliers name for the Product from the Supplier table
p.Select(p, s.CompanyName.As("SupplierName"));
p.InnerJoin(s).On(p.SupplierID == s.SupplierID);
ProductsCollection coll = new ProductsCollection();
coll.Load(p);
return coll;
}
private void buttonQuery_Click(object sender, EventArgs e)
{
// ListBox
ProductsCollection prdColl = new ProductsCollection();
prdColl.Query.Select(prdColl.Query.ProductID, prdColl.Query.ProductName);
prdColl.Query.Load();
listBox1.DisplayMember = ProductsMetadata.PropertyNames.ProductName;
listBox1.ValueMember = ProductsMetadata.PropertyNames.ProductID;
listBox1.DataSource = prdColl;
// DataGridView
// The main query
coll = new ProductsCollection();
coll.Query.Where(coll.Query.Discontinued == false);
coll.Query.Load();
bindingSource1.DataSource = coll;
dataGridView1.DataSource = bindingSource1;
}
public ProductsCollectionProxyStub Products_QueryForCollection(string serializedQuery)
{
ProductsQuery query = ProductsQuery.SerializeHelper.FromXml(
serializedQuery, typeof(ProductsQuery), AllKnownTypes) as ProductsQuery;
ProductsCollection coll = new ProductsCollection();
if (coll.Load(query))
{
return coll;
}
return null;
}
public ProductsCollectionProxyStub Products_LoadAll()
{
ProductsCollection coll = new ProductsCollection();
if (coll.LoadAll())
{
return coll;
}
return null;
}
public ProductsCollection Products_LoadByDynamic(string serializedQuery)
{
ProductsQuery query = ProductsQuery.SerializeHelper.FromXml(
serializedQuery, typeof(ProductsQuery), AllKnownTypes) as ProductsQuery;
ProductsCollection coll = new ProductsCollection();
coll.es.IsLazyLoadDisabled = true;
coll.Load(query);
return coll;
}
public ProductsCollection Products_LoadAll()
{
ProductsCollection coll = new ProductsCollection();
coll.es.IsLazyLoadDisabled = true;
coll.LoadAll();
return coll;
}
public jsResponse<ProductsCollection, Products> ProductsCollection_Save(ProductsCollection collection)
{
jsResponse<ProductsCollection, Products> response = new jsResponse<ProductsCollection, Products>();
try
{
collection.Save();
response.collection = collection;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<ProductsCollection, Products> ProductsCollection_LoadAll()
{
jsResponse<ProductsCollection, Products> response = new jsResponse<ProductsCollection, Products>();
try
{
ProductsCollection collection = new ProductsCollection();
collection.LoadAll();
response.collection = collection;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
