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