public jsResponse <EmployeesCollection, Employees> EmployeesCollection_LoadAll()
{
jsResponse <EmployeesCollection, Employees> response = new jsResponse <EmployeesCollection, Employees>();
try
{
EmployeesQuery q = new EmployeesQuery();
q.Select(q.EmployeeID, q.FirstName, q.LastName);
EmployeesCollection collection = new EmployeesCollection();
collection.Load(q);
if (collection.Count == 0)
{
EnsureData();
collection = new EmployeesCollection();
collection.LoadAll();
}
response.collection = collection;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return(response);
}
public jsResponse<EmployeesCollection, Employees> EmployeesCollection_LoadAll()
{
jsResponse<EmployeesCollection, Employees> response = new jsResponse<EmployeesCollection, Employees>();
try
{
EmployeesQuery q = new EmployeesQuery();
q.Select(q.EmployeeID, q.FirstName, q.LastName);
EmployeesCollection collection = new EmployeesCollection();
collection.Load(q);
if(collection.Count == 0)
{
EnsureData();
collection = new EmployeesCollection();
collection.LoadAll();
}
response.collection = collection;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse <EmployeesCollection, Employees> Employees_Save(Employees entity)
{
jsResponse <EmployeesCollection, Employees> response = new jsResponse <EmployeesCollection, Employees>();
try
{
entity.Save();
response.entity = entity;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return(response);
}
public jsResponse<EmployeesCollection, Employees> EmployeesCollection_Save(EmployeesCollection collection)
{
jsResponse<EmployeesCollection, Employees> response = new jsResponse<EmployeesCollection, Employees>();
try
{
collection.Save();
response.collection = collection;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<CategoriesCollection, Categories> CategoriesCollection_Save(CategoriesCollection collection)
{
jsResponse<CategoriesCollection, Categories> response = new jsResponse<CategoriesCollection, Categories>();
try
{
collection.Save();
response.collection = collection;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse <EmployeesCollection, Employees> EmployeesCollection_Save(EmployeesCollection collection)
{
jsResponse <EmployeesCollection, Employees> response = new jsResponse <EmployeesCollection, Employees>();
try
{
collection.Save();
response.collection = collection;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return(response);
}
public jsResponse<CategoriesCollection, Categories> CategoriesCollection_LoadAll()
{
jsResponse<CategoriesCollection, Categories> response = new jsResponse<CategoriesCollection, Categories>();
try
{
CategoriesCollection collection = new CategoriesCollection();
collection.LoadAll();
response.collection = collection;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<CategoriesCollection, Categories> Categories_LoadByPrimaryKey(System.Int32 categoryID)
{
jsResponse<CategoriesCollection, Categories> response = new jsResponse<CategoriesCollection, Categories>();
try
{
Categories entity = new Categories();
if (entity.LoadByPrimaryKey(categoryID))
{
response.entity = entity;
}
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse <EmployeesCollection, Employees> Employees_LoadByPrimaryKey(System.Int32 employeeID)
{
jsResponse <EmployeesCollection, Employees> response = new jsResponse <EmployeesCollection, Employees>();
try
{
Employees entity = new Employees();
if (entity.LoadByPrimaryKey(employeeID))
{
response.entity = entity;
}
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return(response);
}
public jsResponse <EmployeesCollection, Employees> Employees_LoadByPrimaryKeyHierarchical(int primaryKey)
{
jsResponse <EmployeesCollection, Employees> response = new jsResponse <EmployeesCollection, Employees>();
EmployeesQuery q = new EmployeesQuery();
q.Select(q.EmployeeID, q.FirstName, q.LastName, q.LastName.As("ExtraColumn"), q.EmployeeID.As("IDasExtraColumn"));
q.Where(q.EmployeeID == primaryKey);
Employees emp = new Employees();
emp.Load(q);
int count1 = emp.OrdersCollectionByEmployeeID.Count;
int count2 = emp.OrdersCollectionByEmployeeID[0].OrderDetailsCollectionByOrderID.Count;
response.entity = emp;
return(response);
}
public jsResponse<EmployeesCollection, Employees> Employees_LoadHierarchical()
{
jsResponse<EmployeesCollection, Employees> response = new jsResponse<EmployeesCollection, Employees>();
try
{
// The Main Query
EmployeesQuery q = new EmployeesQuery("e");
q.Select(q.EmployeeID, q.FirstName, q.LastName, q.City, q.Country, q.HomePhone, q.Region, q.PostalCode, q.Title);
q.Where(q.EmployeeID < 7);
// The OrdersCollection
OrdersQuery o1 = q.Prefetch<OrdersQuery>(Employees.Prefetch_OrdersCollectionByEmployeeID);
EmployeesQuery emp1 = o1.GetQuery<EmployeesQuery>();
o1.Where(emp1.EmployeeID < 7);
// The OrdersDetailsCollection
OrderDetailsQuery od = q.Prefetch<OrderDetailsQuery>(Employees.Prefetch_OrdersCollectionByEmployeeID, Orders.Prefetch_OrderDetailsCollectionByOrderID);
EmployeesQuery emp2 = od.GetQuery<EmployeesQuery>();
OrdersQuery o2 = od.GetQuery<OrdersQuery>();
od.Where(emp2.EmployeeID < 7);
// Load It
EmployeesCollection coll = new EmployeesCollection();
if (coll.Load(q))
{
response.collection = coll;
response.columnCollection["Employees"] = jsColumn.PopulateColumns(coll[0]);
response.columnCollection["Orders"] = jsColumn.PopulateColumns(coll[0].OrdersCollectionByEmployeeID[0]);
response.columnCollection["OrderDetails"] = jsColumn.PopulateColumns(coll[0].OrdersCollectionByEmployeeID[0].OrderDetailsCollectionByOrderID[0]);
}
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse <EmployeesCollection, Employees> Employees_LoadHierarchical()
{
jsResponse <EmployeesCollection, Employees> response = new jsResponse <EmployeesCollection, Employees>();
try
{
// The Main Query
EmployeesQuery q = new EmployeesQuery("e");
q.Select(q.EmployeeID, q.FirstName, q.LastName, q.City, q.Country, q.HomePhone, q.Region, q.PostalCode, q.Title);
q.Where(q.EmployeeID < 7);
// The OrdersCollection
OrdersQuery o1 = q.Prefetch <OrdersQuery>(Employees.Prefetch_OrdersCollectionByEmployeeID);
EmployeesQuery emp1 = o1.GetQuery <EmployeesQuery>();
o1.Where(emp1.EmployeeID < 7);
// The OrdersDetailsCollection
OrderDetailsQuery od = q.Prefetch <OrderDetailsQuery>(Employees.Prefetch_OrdersCollectionByEmployeeID, Orders.Prefetch_OrderDetailsCollectionByOrderID);
EmployeesQuery emp2 = od.GetQuery <EmployeesQuery>();
OrdersQuery o2 = od.GetQuery <OrdersQuery>();
od.Where(emp2.EmployeeID < 7);
// Load It
EmployeesCollection coll = new EmployeesCollection();
if (coll.Load(q))
{
response.collection = coll;
response.columnCollection["Employees"] = jsColumn.PopulateColumns(coll[0]);
response.columnCollection["Orders"] = jsColumn.PopulateColumns(coll[0].OrdersCollectionByEmployeeID[0]);
response.columnCollection["OrderDetails"] = jsColumn.PopulateColumns(coll[0].OrdersCollectionByEmployeeID[0].OrderDetailsCollectionByOrderID[0]);
}
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return(response);
}
public jsResponse<EmployeeTerritoriesCollection, EmployeeTerritories> EmployeeTerritoriesCollection_LoadAll()
{
jsResponse<EmployeeTerritoriesCollection, EmployeeTerritories> response = new jsResponse<EmployeeTerritoriesCollection, EmployeeTerritories>();
try
{
EmployeeTerritoriesCollection collection = new EmployeeTerritoriesCollection();
collection.LoadAll();
response.collection = collection;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<OrdersCollection, Orders> Employees_OrdersCollectionByEmployeeID(System.Int32 employeeID)
{
jsResponse<OrdersCollection, Orders> response = new jsResponse<OrdersCollection, Orders>();
try
{
Employees entity = new Employees();
entity.EmployeeID = employeeID;
response.collection = entity.OrdersCollectionByEmployeeID;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<CustomerCustomerDemoCollection, CustomerCustomerDemo> CustomerCustomerDemo_LoadByPrimaryKey(System.String customerID, System.String customerTypeID)
{
jsResponse<CustomerCustomerDemoCollection, CustomerCustomerDemo> response = new jsResponse<CustomerCustomerDemoCollection, CustomerCustomerDemo>();
try
{
CustomerCustomerDemo entity = new CustomerCustomerDemo();
if (entity.LoadByPrimaryKey(customerID, customerTypeID))
{
response.entity = entity;
}
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<EmployeesCollection, Employees> Employees_Save(Employees entity)
{
jsResponse<EmployeesCollection, Employees> response = new jsResponse<EmployeesCollection, Employees>();
try
{
entity.Save();
response.entity = entity;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<OrdersCollection, Orders> Orders_LoadByPrimaryKey(System.Int32 orderID)
{
jsResponse<OrdersCollection, Orders> response = new jsResponse<OrdersCollection, Orders>();
try
{
Orders entity = new Orders();
if (entity.LoadByPrimaryKey(orderID))
{
response.entity = entity;
}
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<CategoriesCollection, Categories> Categories_Save(Categories entity)
{
jsResponse<CategoriesCollection, Categories> response = new jsResponse<CategoriesCollection, Categories>();
try
{
entity.Save();
response.entity = entity;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<ProductsCollection, Products> OrderDetails_UpToProductsByProductID(System.Int32 orderID, System.Int32 productID)
{
jsResponse<ProductsCollection, Products> response = new jsResponse<ProductsCollection, Products>();
try
{
OrderDetails entity = new OrderDetails();
entity.OrderID = orderID;
entity.ProductID = productID;
response.entity = entity.UpToProductsByProductID;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<CustomerCustomerDemoCollection, CustomerCustomerDemo> CustomerDemographics_CustomerCustomerDemoCollectionByCustomerTypeID(System.String customerTypeID)
{
jsResponse<CustomerCustomerDemoCollection, CustomerCustomerDemo> response = new jsResponse<CustomerCustomerDemoCollection, CustomerCustomerDemo>();
try
{
CustomerDemographics entity = new CustomerDemographics();
entity.CustomerTypeID = customerTypeID;
response.collection = entity.CustomerCustomerDemoCollectionByCustomerTypeID;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<CustomerDemographicsCollection, CustomerDemographics> CustomerDemographics_Save(CustomerDemographics entity)
{
jsResponse<CustomerDemographicsCollection, CustomerDemographics> response = new jsResponse<CustomerDemographicsCollection, CustomerDemographics>();
try
{
entity.Save();
response.entity = entity;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<CustomerDemographicsCollection, CustomerDemographics> CustomerDemographicsCollection_Save(CustomerDemographicsCollection collection)
{
jsResponse<CustomerDemographicsCollection, CustomerDemographics> response = new jsResponse<CustomerDemographicsCollection, CustomerDemographics>();
try
{
collection.Save();
response.collection = collection;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<CustomerDemographicsCollection, CustomerDemographics> CustomerDemographicsCollection_LoadAll()
{
jsResponse<CustomerDemographicsCollection, CustomerDemographics> response = new jsResponse<CustomerDemographicsCollection, CustomerDemographics>();
try
{
CustomerDemographicsCollection collection = new CustomerDemographicsCollection();
collection.LoadAll();
response.collection = collection;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<CustomersCollection, Customers> CustomerCustomerDemo_UpToCustomersByCustomerID(System.String customerID, System.String customerTypeID)
{
jsResponse<CustomersCollection, Customers> response = new jsResponse<CustomersCollection, Customers>();
try
{
CustomerCustomerDemo entity = new CustomerCustomerDemo();
entity.CustomerID = customerID;
entity.CustomerTypeID = customerTypeID;
response.entity = entity.UpToCustomersByCustomerID;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<EmployeeTerritoriesCollection, EmployeeTerritories> Territories_EmployeeTerritoriesCollectionByTerritoryID(System.String territoryID)
{
jsResponse<EmployeeTerritoriesCollection, EmployeeTerritories> response = new jsResponse<EmployeeTerritoriesCollection, EmployeeTerritories>();
try
{
Territories entity = new Territories();
entity.TerritoryID = territoryID;
response.collection = entity.EmployeeTerritoriesCollectionByTerritoryID;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<TerritoriesCollection, Territories> EmployeeTerritories_UpToTerritoriesByTerritoryID(System.Int32 employeeID, System.String territoryID)
{
jsResponse<TerritoriesCollection, Territories> response = new jsResponse<TerritoriesCollection, Territories>();
try
{
EmployeeTerritories entity = new EmployeeTerritories();
entity.EmployeeID = employeeID;
entity.TerritoryID = territoryID;
response.entity = entity.UpToTerritoriesByTerritoryID;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<CustomerDemographicsCollection, CustomerDemographics> Customers_UpToCustomerDemographicsCollection(System.String customerID)
{
jsResponse<CustomerDemographicsCollection, CustomerDemographics> response = new jsResponse<CustomerDemographicsCollection, CustomerDemographics>();
try
{
Customers entity = new Customers();
entity.CustomerID = customerID;
response.collection = entity.UpToCustomerDemographicsCollection;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<OrdersCollection, Orders> OrdersCollection_LoadAll()
{
jsResponse<OrdersCollection, Orders> response = new jsResponse<OrdersCollection, Orders>();
try
{
OrdersCollection collection = new OrdersCollection();
collection.LoadAll();
response.collection = collection;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<OrdersCollection, Orders> Customers_OrdersCollectionByCustomerID(System.String customerID)
{
jsResponse<OrdersCollection, Orders> response = new jsResponse<OrdersCollection, Orders>();
try
{
Customers entity = new Customers();
entity.CustomerID = customerID;
response.collection = entity.OrdersCollectionByCustomerID;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<OrdersCollection, Orders> OrdersCollection_Save(OrdersCollection collection)
{
jsResponse<OrdersCollection, Orders> response = new jsResponse<OrdersCollection, Orders>();
try
{
collection.Save();
response.collection = collection;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<TerritoriesCollection, Territories> Territories_LoadByPrimaryKey(System.String territoryID)
{
jsResponse<TerritoriesCollection, Territories> response = new jsResponse<TerritoriesCollection, Territories>();
try
{
Territories entity = new Territories();
if (entity.LoadByPrimaryKey(territoryID))
{
response.entity = entity;
}
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<OrdersCollection, Orders> Orders_Save(Orders entity)
{
jsResponse<OrdersCollection, Orders> response = new jsResponse<OrdersCollection, Orders>();
try
{
entity.Save();
response.entity = entity;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<EmployeesCollection, Employees> Employees_UpToEmployeesByReportsTo(System.Int32 employeeID)
{
jsResponse<EmployeesCollection, Employees> response = new jsResponse<EmployeesCollection, Employees>();
try
{
Employees entity = new Employees();
entity.EmployeeID = employeeID;
response.entity = entity.UpToEmployeesByReportsTo;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<CustomersCollection, Customers> Customers_LoadByPrimaryKey(System.String customerID)
{
jsResponse<CustomersCollection, Customers> response = new jsResponse<CustomersCollection, Customers>();
try
{
Customers entity = new Customers();
if (entity.LoadByPrimaryKey(customerID))
{
response.entity = entity;
}
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<RegionCollection, Region> Territories_UpToRegionByRegionID(System.String territoryID)
{
jsResponse<RegionCollection, Region> response = new jsResponse<RegionCollection, Region>();
try
{
Territories entity = new Territories();
entity.TerritoryID = territoryID;
response.entity = entity.UpToRegionByRegionID;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse<EmployeesCollection, Employees> Employees_LoadByPrimaryKey(System.Int32 employeeID)
{
jsResponse<EmployeesCollection, Employees> response = new jsResponse<EmployeesCollection, Employees>();
try
{
Employees entity = new Employees();
if (entity.LoadByPrimaryKey(employeeID))
{
response.entity = entity;
}
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return response;
}
public jsResponse <EmployeesCollection, Employees> Employees_Pager(jsPagerRequest request)
{
jsResponse <EmployeesCollection, Employees> response = new jsResponse <EmployeesCollection, Employees>();
try
{
// We send the the same data they sent us back
response.pagerRequest = request;
EmployeesQuery q = null;
if (response.pagerRequest.getTotalRows == true)
{
// Get the total count of rows in the Employee table
q = new EmployeesQuery();
q.es.CountAll = true;
response.pagerRequest.totalRows = q.ExecuteScalar <int>();
}
q = new EmployeesQuery();
q.Select(q.EmployeeID, q.FirstName, q.LastName, q.Title);
if (request.sortCriteria != null && request.sortCriteria.Length > 0)
{
for (int i = 0; i < request.sortCriteria.Length; i++)
{
jsPagerSortCriteria sort = request.sortCriteria[i];
q.OrderBy(sort.column, sort.direction.ToUpper().StartsWith("A") ?
esOrderByDirection.Ascending : esOrderByDirection.Descending);
}
}
else
{
// Default sort if none is specified
q.OrderBy(q.EmployeeID.Ascending);
}
if (request.filterCriteria != null && request.filterCriteria.Length > 0)
{
esComparison comp = null;
for (int i = 0; i < request.filterCriteria.Length; i++)
{
jsPagerFilterCriteria filter = request.filterCriteria[i];
comp = q.ManualWhere(filter.column, filter.operation, filter.criteria1, filter.criteria2, filter.conjuction);
}
q.Where(comp);
}
// Set the paging indicators up
q.es.PageNumber = request.pageNumber;
q.es.PageSize = request.pageSize;
EmployeesCollection coll = new EmployeesCollection();
coll.Load(q);
response.pagerRequest.getTotalRows = false;
response.collection = coll;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return(response);
}
