public static SignificantTradeSS.AspnetRoleCollection GetAspnetRoleCollection(Guid varUserId)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand("SELECT * FROM [dbo].[aspnet_Roles] INNER JOIN [aspnet_UsersInRoles] ON [aspnet_Roles].[RoleId] = [aspnet_UsersInRoles].[RoleId] WHERE [aspnet_UsersInRoles].[UserId] = @UserId", AspnetUser.Schema.Provider.Name);
cmd.AddParameter("@UserId", varUserId, DbType.Guid);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
AspnetRoleCollection coll = new AspnetRoleCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static NorthwindAccess.CustomerCollection GetCustomerCollection(string varCustomerTypeID)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand("SELECT * FROM [Customers] INNER JOIN [CustomerCustomerDemo] ON [Customers].[CustomerID] = [CustomerCustomerDemo].[CustomerID] WHERE [CustomerCustomerDemo].[CustomerTypeID] = PARM__CustomerTypeID", CustomerDemographic.Schema.Provider.Name);
cmd.AddParameter("PARM__CustomerTypeID", varCustomerTypeID, DbType.String);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
CustomerCollection coll = new CustomerCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static LIS.DAL.SysUserCollection GetSysUserCollection(long varIRole)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand("SELECT * FROM [dbo].[Sys_Users] INNER JOIN [tbl_RolesForUsers] ON [Sys_Users].[FP_sBranchID] = [tbl_RolesForUsers].[FP_sBranchID] WHERE [tbl_RolesForUsers].[FP_sBranchID] = @FP_sBranchID", SysRole.Schema.Provider.Name);
cmd.AddParameter("@FP_sBranchID", varIRole, DbType.String);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
SysUserCollection coll = new SysUserCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static PMT.DAL.UserCollection GetUserCollection(int varId)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand("SELECT * FROM [dbo].[Users] INNER JOIN [ProjectAssignments] ON [Users].[ID] = [ProjectAssignments].[UserID] WHERE [ProjectAssignments].[ProjectID] = @ProjectID", Project.Schema.Provider.Name);
cmd.AddParameter("@ProjectID", varId, DbType.Int32);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
UserCollection coll = new UserCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static Northwind.TerritoryCollection GetTerritoryCollection(int varEmployeeID)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand("SELECT * FROM [dbo].[Territories] INNER JOIN [EmployeeTerritories] ON [Territories].[TerritoryID] = [EmployeeTerritories].[TerritoryID] WHERE [EmployeeTerritories].[EmployeeID] = @EmployeeID", Employee.Schema.Provider.Name);
cmd.AddParameter("@EmployeeID", varEmployeeID, DbType.Int32);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
TerritoryCollection coll = new TerritoryCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static Northwind.OrderCollection GetOrderCollection(int varProductID)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand("SELECT * FROM [dbo].[Orders] INNER JOIN [Order Details] ON [Orders].[OrderID] = [Order Details].[OrderID] WHERE [Order Details].[ProductID] = @ProductID", Product.Schema.Provider.Name);
cmd.AddParameter("@ProductID", varProductID, DbType.Int32);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
OrderCollection coll = new OrderCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static Northwind.ProductCollection GetProductCollection(int varCategoryID)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand("SELECT * FROM [dbo].[Products] INNER JOIN [Product_Category_Map] ON [Products].[ProductID] = [Product_Category_Map].[ProductID] WHERE [Product_Category_Map].[CategoryID] = @CategoryID", Category.Schema.Provider.Name);
cmd.AddParameter("@CategoryID", varCategoryID, DbType.Int32);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
ProductCollection coll = new ProductCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static NorthwindAccess.EmployeeCollection GetEmployeeCollection(string varTerritoryID)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand("SELECT * FROM [Employees] INNER JOIN [EmployeeTerritories] ON [Employees].[EmployeeID] = [EmployeeTerritories].[EmployeeID] WHERE [EmployeeTerritories].[TerritoryID] = PARM__TerritoryID", Territory.Schema.Provider.Name);
cmd.AddParameter("PARM__TerritoryID", varTerritoryID, DbType.String);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
EmployeeCollection coll = new EmployeeCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static AVManager.DAL.AddressCollection GetAddressCollection(int varEmployeeID)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM Address INNER JOIN EmployeeAddress ON " +
"Address.AddressID=EmployeeAddress.AddressID WHERE EmployeeAddress.EmployeeID=@EmployeeID", Employee.Schema.Provider.Name);
cmd.AddParameter("@EmployeeID", varEmployeeID, DbType.Int32);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
AddressCollection coll = new AddressCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static AVManager.DAL.CountryRegionCollection GetCountryRegionCollection(string varCurrencyCode)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM CountryRegion INNER JOIN CountryRegionCurrency ON " +
"CountryRegion.CountryRegionCode=CountryRegionCurrency.CountryRegionCode WHERE CountryRegionCurrency.CurrencyCode=@CurrencyCode", Currency.Schema.Provider.Name);
cmd.AddParameter("@CurrencyCode", varCurrencyCode, DbType.String);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
CountryRegionCollection coll = new CountryRegionCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static AVManager.DAL.ContactCollection GetContactCollection(int varCreditCardID)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM Contact INNER JOIN ContactCreditCard ON " +
"Contact.ContactID=ContactCreditCard.ContactID WHERE ContactCreditCard.CreditCardID=@CreditCardID", CreditCard.Schema.Provider.Name);
cmd.AddParameter("@CreditCardID", varCreditCardID, DbType.Int32);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
ContactCollection coll = new ContactCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static AVManager.DAL.IllustrationCollection GetIllustrationCollection(int varProductModelID)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM Illustration INNER JOIN ProductModelIllustration ON " +
"Illustration.IllustrationID=ProductModelIllustration.IllustrationID WHERE ProductModelIllustration.ProductModelID=@ProductModelID", ProductModel.Schema.Provider.Name);
cmd.AddParameter("@ProductModelID", varProductModelID, DbType.Int32);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
IllustrationCollection coll = new IllustrationCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static AVManager.DAL.ShiftCollection GetShiftCollection(short varDepartmentID)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM Shift INNER JOIN EmployeeDepartmentHistory ON " +
"Shift.ShiftID=EmployeeDepartmentHistory.ShiftID WHERE EmployeeDepartmentHistory.DepartmentID=@DepartmentID", Department.Schema.Provider.Name);
cmd.AddParameter("@DepartmentID", varDepartmentID, DbType.Int16);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
ShiftCollection coll = new ShiftCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static AVManager.DAL.CultureCollection GetCultureCollection(int varProductDescriptionID)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM Culture INNER JOIN ProductModelProductDescriptionCulture ON " +
"Culture.CultureID=ProductModelProductDescriptionCulture.CultureID WHERE ProductModelProductDescriptionCulture.ProductDescriptionID=@ProductDescriptionID", ProductDescription.Schema.Provider.Name);
cmd.AddParameter("@ProductDescriptionID", varProductDescriptionID, DbType.Int32);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
CultureCollection coll = new CultureCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static MettleSystems.dashCommerce.Store.ProductCollection GetProductCollection(int varCustomizedProductDisplayTypeId)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM dashCommerce_Store_Product INNER JOIN dashCommerce_Store_CustomizedProductDisplayType_Product_Map ON " +
"dashCommerce_Store_Product.ProductId=dashCommerce_Store_CustomizedProductDisplayType_Product_Map.ProductId WHERE dashCommerce_Store_CustomizedProductDisplayType_Product_Map.CustomizedProductDisplayTypeId=@CustomizedProductDisplayTypeId", CustomizedProductDisplayType.Schema.Provider.Name);
cmd.AddParameter("@CustomizedProductDisplayTypeId", varCustomizedProductDisplayTypeId, DbType.Int32);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
ProductCollection coll = new ProductCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static AVManager.DAL.StoreCollection GetStoreCollection(int varContactTypeID)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM Store INNER JOIN StoreContact ON " +
"Store.CustomerID=StoreContact.CustomerID WHERE StoreContact.ContactTypeID=@ContactTypeID", ContactType.Schema.Provider.Name);
cmd.AddParameter("@ContactTypeID", varContactTypeID, DbType.Int32);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
StoreCollection coll = new StoreCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static AVManager.DAL.VendorCollection GetVendorCollection(int varAddressTypeID)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM Vendor INNER JOIN VendorAddress ON " +
"Vendor.VendorID=VendorAddress.VendorID WHERE VendorAddress.AddressTypeID=@AddressTypeID", AddressType.Schema.Provider.Name);
cmd.AddParameter("@AddressTypeID", varAddressTypeID, DbType.Int32);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
VendorCollection coll = new VendorCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static AVManager.DAL.SalesPersonCollection GetSalesPersonCollection(int varTerritoryID)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM SalesPerson INNER JOIN SalesTerritoryHistory ON " +
"SalesPerson.SalesPersonID=SalesTerritoryHistory.SalesPersonID WHERE SalesTerritoryHistory.TerritoryID=@TerritoryID", SalesTerritory.Schema.Provider.Name);
cmd.AddParameter("@TerritoryID", varTerritoryID, DbType.Int32);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
SalesPersonCollection coll = new SalesPersonCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static AVManager.DAL.DepartmentCollection GetDepartmentCollection(int varEmployeeID)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM Department INNER JOIN EmployeeDepartmentHistory ON " +
"Department.DepartmentID=EmployeeDepartmentHistory.DepartmentID WHERE EmployeeDepartmentHistory.EmployeeID=@EmployeeID", Employee.Schema.Provider.Name);
cmd.AddParameter("@EmployeeID", varEmployeeID, DbType.Int32);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
DepartmentCollection coll = new DepartmentCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static AVManager.DAL.UnitMeasureCollection GetUnitMeasureCollection(int varVendorID)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM UnitMeasure INNER JOIN ProductVendor ON " +
"UnitMeasure.UnitMeasureCode=ProductVendor.UnitMeasureCode WHERE ProductVendor.VendorID=@VendorID", Vendor.Schema.Provider.Name);
cmd.AddParameter("@VendorID", varVendorID, DbType.Int32);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
UnitMeasureCollection coll = new UnitMeasureCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static MettleSystems.dashCommerce.Store.AttributeCollection GetAttributeCollection(int varProductId)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM dashCommerce_Store_Attribute INNER JOIN dashCommerce_Store_Product_Attribute_Map ON " +
"dashCommerce_Store_Attribute.AttributeId=dashCommerce_Store_Product_Attribute_Map.AttributeId WHERE dashCommerce_Store_Product_Attribute_Map.ProductId=@ProductId", Product.Schema.Provider.Name);
cmd.AddParameter("@ProductId", varProductId, DbType.Int32);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
AttributeCollection coll = new AttributeCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static Data.KELENGKAPANCollection GetKELENGKAPANCollection(string varKODEPBJ)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM KELENGKAPAN INNER JOIN KELENGKAPANPBJ ON " +
"KELENGKAPAN.KODEKELENGKAPAN=KELENGKAPANPBJ.KODEKELENGKAPAN WHERE KELENGKAPANPBJ.KODEBPJ=@KODEBPJ", PBJ.Schema.Provider.Name);
cmd.AddParameter("@KODEBPJ", varKODEPBJ, DbType.String);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
KELENGKAPANCollection coll = new KELENGKAPANCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static AVManager.DAL.ProductModelCollection GetProductModelCollection(string varCultureID)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM ProductModel INNER JOIN ProductModelProductDescriptionCulture ON " +
"ProductModel.ProductModelID=ProductModelProductDescriptionCulture.ProductModelID WHERE ProductModelProductDescriptionCulture.CultureID=@CultureID", Culture.Schema.Provider.Name);
cmd.AddParameter("@CultureID", varCultureID, DbType.String);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
ProductModelCollection coll = new ProductModelCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static AVManager.DAL.ContactTypeCollection GetContactTypeCollection(int varVendorID)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM ContactType INNER JOIN VendorContact ON " +
"ContactType.ContactTypeID=VendorContact.ContactTypeID WHERE VendorContact.VendorID=@VendorID", Vendor.Schema.Provider.Name);
cmd.AddParameter("@VendorID", varVendorID, DbType.Int32);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
ContactTypeCollection coll = new ContactTypeCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static AVManager.DAL.ProductCollection GetProductCollection(short varLocationID)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM Product INNER JOIN ProductInventory ON " +
"Product.ProductID=ProductInventory.ProductID WHERE ProductInventory.LocationID=@LocationID", Location.Schema.Provider.Name);
cmd.AddParameter("@LocationID", varLocationID, DbType.Int16);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
ProductCollection coll = new ProductCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static AVManager.DAL.EmployeeCollection GetEmployeeCollection(byte varShiftID)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM Employee INNER JOIN EmployeeDepartmentHistory ON " +
"Employee.EmployeeID=EmployeeDepartmentHistory.EmployeeID WHERE EmployeeDepartmentHistory.ShiftID=@ShiftID", Shift.Schema.Provider.Name);
cmd.AddParameter("@ShiftID", varShiftID, DbType.Byte);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
EmployeeCollection coll = new EmployeeCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static MettleSystems.dashCommerce.Content.PageCollection GetPageCollection(int varRegionId)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM dashCommerce_Content_Page INNER JOIN dashCommerce_Content_Page_Region_Map ON " +
"dashCommerce_Content_Page.PageId=dashCommerce_Content_Page_Region_Map.PageId WHERE dashCommerce_Content_Page_Region_Map.RegionId=@RegionId", Region.Schema.Provider.Name);
cmd.AddParameter("@RegionId", varRegionId, DbType.Int32);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
PageCollection coll = new PageCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static AVManager.DAL.CustomerCollection GetCustomerCollection(int varAddressID)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM Customer INNER JOIN CustomerAddress ON " +
"Customer.CustomerID=CustomerAddress.CustomerID WHERE CustomerAddress.AddressID=@AddressID", Address.Schema.Provider.Name);
cmd.AddParameter("@AddressID", varAddressID, DbType.Int32);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
CustomerCollection coll = new CustomerCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static AVManager.DAL.ProductCollection GetProductCollection(int varProductPhotoID)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM Product INNER JOIN ProductProductPhoto ON " +
"Product.ProductID=ProductProductPhoto.ProductID WHERE ProductProductPhoto.ProductPhotoID=@ProductPhotoID", ProductPhoto.Schema.Provider.Name);
cmd.AddParameter("@ProductPhotoID", varProductPhotoID, DbType.Int32);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
ProductCollection coll = new ProductCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static AVManager.DAL.VendorCollection GetVendorCollection(string varUnitMeasureCode)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM Vendor INNER JOIN ProductVendor ON " +
"Vendor.VendorID=ProductVendor.VendorID WHERE ProductVendor.UnitMeasureCode=@UnitMeasureCode", UnitMeasure.Schema.Provider.Name);
cmd.AddParameter("@UnitMeasureCode", varUnitMeasureCode, DbType.String);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
VendorCollection coll = new VendorCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
private static void UpdateOrderPoint(int orderId, decimal orderPoint)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand("UPDATE ORDERS SET OrderPoint = @OrderPoint where ID=@ID");
cmd.AddParameter("@OrderPoint", orderPoint, System.Data.DbType.Decimal);
cmd.AddParameter("@ID", orderId, System.Data.DbType.Int32);
SubSonic.DataService.ExecuteQuery(cmd);
}