public static void SaveOrderMap(int varProductID, OrderCollection items) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM [Order Details] WHERE [Order Details].[ProductID] = PARM__ProductID", Product.Schema.Provider.Name); cmdDel.AddParameter("PARM__ProductID", varProductID, DbType.Int32); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (Order item in items) { OrderDetail varOrderDetail = new OrderDetail(); varOrderDetail.SetColumnValue("ProductID", varProductID); varOrderDetail.SetColumnValue("OrderID", item.GetPrimaryKeyValue()); varOrderDetail.Save(); } }
public static void SaveProductMap(int varOrderID, int[] itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM [Order Details] WHERE [Order Details].[OrderID] = @OrderID", Order.Schema.Provider.Name); cmdDel.AddParameter("@OrderID", varOrderID, DbType.Int32); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (int item in itemList) { OrderDetail varOrderDetail = new OrderDetail(); varOrderDetail.SetColumnValue("OrderID", varOrderID); varOrderDetail.SetColumnValue("ProductID", item); varOrderDetail.Save(); } }
public static void SaveProductMap(int varProductPhotoID, int[] itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM ProductProductPhoto WHERE ProductPhotoID=@ProductPhotoID", ProductPhoto.Schema.Provider.Name); cmdDel.AddParameter("@ProductPhotoID", varProductPhotoID); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (int item in itemList) { ProductProductPhoto varProductProductPhoto = new ProductProductPhoto(); varProductProductPhoto.SetColumnValue("ProductPhotoID", varProductPhotoID); varProductProductPhoto.SetColumnValue("ProductID", item); varProductProductPhoto.Save(); } }
public static void SaveProductModelMap(int varIllustrationID, ProductModelCollection items) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM ProductModelIllustration WHERE IllustrationID=@IllustrationID", Illustration.Schema.Provider.Name); cmdDel.AddParameter("@IllustrationID", varIllustrationID); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (ProductModel item in items) { ProductModelIllustration varProductModelIllustration = new ProductModelIllustration(); varProductModelIllustration.SetColumnValue("IllustrationID", varIllustrationID); varProductModelIllustration.SetColumnValue("ProductModelID", item.GetPrimaryKeyValue()); varProductModelIllustration.Save(); } }
public static void SaveEmployeeMap(byte varShiftID, byte[] itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM EmployeeDepartmentHistory WHERE ShiftID=@ShiftID", Shift.Schema.Provider.Name); cmdDel.AddParameter("@ShiftID", varShiftID); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (byte item in itemList) { EmployeeDepartmentHistory varEmployeeDepartmentHistory = new EmployeeDepartmentHistory(); varEmployeeDepartmentHistory.SetColumnValue("ShiftID", varShiftID); varEmployeeDepartmentHistory.SetColumnValue("EmployeeID", item); varEmployeeDepartmentHistory.Save(); } }
public static void SaveAspnetRoleMap(Guid varUserId, Guid[] itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM [aspnet_UsersInRoles] WHERE [aspnet_UsersInRoles].[UserId] = @UserId", AspnetUser.Schema.Provider.Name); cmdDel.AddParameter("@UserId", varUserId, DbType.Guid); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (Guid item in itemList) { AspnetUsersInRole varAspnetUsersInRole = new AspnetUsersInRole(); varAspnetUsersInRole.SetColumnValue("UserId", varUserId); varAspnetUsersInRole.SetColumnValue("RoleId", item); varAspnetUsersInRole.Save(); } }
public static void SaveAddressTypeMap(int varVendorID, AddressTypeCollection items) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM VendorAddress WHERE VendorID=@VendorID", Vendor.Schema.Provider.Name); cmdDel.AddParameter("@VendorID", varVendorID); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (AddressType item in items) { VendorAddress varVendorAddress = new VendorAddress(); varVendorAddress.SetColumnValue("VendorID", varVendorID); varVendorAddress.SetColumnValue("AddressTypeID", item.GetPrimaryKeyValue()); varVendorAddress.Save(); } }
public static void SaveProductMap(short varLocationID, short[] itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM ProductInventory WHERE LocationID=@LocationID", Location.Schema.Provider.Name); cmdDel.AddParameter("@LocationID", varLocationID); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (short item in itemList) { ProductInventory varProductInventory = new ProductInventory(); varProductInventory.SetColumnValue("LocationID", varLocationID); varProductInventory.SetColumnValue("ProductID", item); varProductInventory.Save(); } }
public static void SaveContactTypeMap(int varCustomerID, ContactTypeCollection items) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM StoreContact WHERE CustomerID=@CustomerID", Store.Schema.Provider.Name); cmdDel.AddParameter("@CustomerID", varCustomerID); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (ContactType item in items) { StoreContact varStoreContact = new StoreContact(); varStoreContact.SetColumnValue("CustomerID", varCustomerID); varStoreContact.SetColumnValue("ContactTypeID", item.GetPrimaryKeyValue()); varStoreContact.Save(); } }
public static void SaveKELENGKAPANMap(string varKODEPBJ, string[] itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM KELENGKAPANPBJ WHERE KODEBPJ=@KODEBPJ", PBJ.Schema.Provider.Name); cmdDel.AddParameter("@KODEBPJ", varKODEPBJ); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (string item in itemList) { KELENGKAPANPBJ varKELENGKAPANPBJ = new KELENGKAPANPBJ(); varKELENGKAPANPBJ.SetColumnValue("KODEBPJ", varKODEPBJ); varKELENGKAPANPBJ.SetColumnValue("KODEKELENGKAPAN", item); varKELENGKAPANPBJ.Save(); } }
public static void SaveEmployeeMap(string varTerritoryID, EmployeeCollection items) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM [EmployeeTerritories] WHERE [EmployeeTerritories].[TerritoryID] = @TerritoryID", Territory.Schema.Provider.Name); cmdDel.AddParameter("@TerritoryID", varTerritoryID, DbType.String); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (Employee item in items) { EmployeeTerritory varEmployeeTerritory = new EmployeeTerritory(); varEmployeeTerritory.SetColumnValue("TerritoryID", varTerritoryID); varEmployeeTerritory.SetColumnValue("EmployeeID", item.GetPrimaryKeyValue()); varEmployeeTerritory.Save(); } }
public static void SaveTemplateMap(int varTemplateRegionId, TemplateCollection items) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM dashCommerce_Content_Template_TemplateRegion_Map WHERE TemplateRegionId=@TemplateRegionId", TemplateRegion.Schema.Provider.Name); cmdDel.AddParameter("@TemplateRegionId", varTemplateRegionId); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (Template item in items) { TemplateTemplateRegionMap varTemplateTemplateRegionMap = new TemplateTemplateRegionMap(); varTemplateTemplateRegionMap.SetColumnValue("TemplateRegionId", varTemplateRegionId); varTemplateTemplateRegionMap.SetColumnValue("TemplateId", item.GetPrimaryKeyValue()); varTemplateTemplateRegionMap.Save(); } }
public static void SaveProductMap(int varDocumentID, ProductCollection items) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM ProductDocument WHERE DocumentID=@DocumentID", Document.Schema.Provider.Name); cmdDel.AddParameter("@DocumentID", varDocumentID); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (Product item in items) { ProductDocument varProductDocument = new ProductDocument(); varProductDocument.SetColumnValue("DocumentID", varDocumentID); varProductDocument.SetColumnValue("ProductID", item.GetPrimaryKeyValue()); varProductDocument.Save(); } }
public static void SaveVendorMap(int varContactID, VendorCollection items) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM VendorContact WHERE ContactID=@ContactID", Contact.Schema.Provider.Name); cmdDel.AddParameter("@ContactID", varContactID); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (Vendor item in items) { VendorContact varVendorContact = new VendorContact(); varVendorContact.SetColumnValue("ContactID", varContactID); varVendorContact.SetColumnValue("VendorID", item.GetPrimaryKeyValue()); varVendorContact.Save(); } }
public static void SaveSysUserMap(long varIRole, string[] itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM [tbl_RolesForUsers] WHERE [tbl_RolesForUsers].[FP_sBranchID] = @FP_sBranchID", SysRole.Schema.Provider.Name); cmdDel.AddParameter("@FP_sBranchID", varIRole, DbType.String); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (string item in itemList) { TblRolesForUser varTblRolesForUser = new TblRolesForUser(); varTblRolesForUser.SetColumnValue("FP_sBranchID", varIRole); varTblRolesForUser.SetColumnValue("FP_sBranchID", item); varTblRolesForUser.Save(); } }
public static void SavePageMap(int varRegionId, int[] itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM dashCommerce_Content_Page_Region_Map WHERE RegionId=@RegionId", Region.Schema.Provider.Name); cmdDel.AddParameter("@RegionId", varRegionId); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (int item in itemList) { PageRegionMap varPageRegionMap = new PageRegionMap(); varPageRegionMap.SetColumnValue("RegionId", varRegionId); varPageRegionMap.SetColumnValue("PageId", item); varPageRegionMap.Save(); } }
public static void SaveProductMap(int varCustomizedProductDisplayTypeId, int[] itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM dashCommerce_Store_CustomizedProductDisplayType_Product_Map WHERE CustomizedProductDisplayTypeId=@CustomizedProductDisplayTypeId", CustomizedProductDisplayType.Schema.Provider.Name); cmdDel.AddParameter("@CustomizedProductDisplayTypeId", varCustomizedProductDisplayTypeId); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (int item in itemList) { CustomizedProductDisplayTypeProductMap varCustomizedProductDisplayTypeProductMap = new CustomizedProductDisplayTypeProductMap(); varCustomizedProductDisplayTypeProductMap.SetColumnValue("CustomizedProductDisplayTypeId", varCustomizedProductDisplayTypeId); varCustomizedProductDisplayTypeProductMap.SetColumnValue("ProductId", item); varCustomizedProductDisplayTypeProductMap.Save(); } }
public static void SaveCustomerMap(int varAddressID, CustomerCollection items) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM CustomerAddress WHERE AddressID=@AddressID", Address.Schema.Provider.Name); cmdDel.AddParameter("@AddressID", varAddressID); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (Customer item in items) { CustomerAddress varCustomerAddress = new CustomerAddress(); varCustomerAddress.SetColumnValue("AddressID", varAddressID); varCustomerAddress.SetColumnValue("CustomerID", item.GetPrimaryKeyValue()); varCustomerAddress.Save(); } }
public static void SaveUnitMeasureMap(int varVendorID, int[] itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM ProductVendor WHERE VendorID=@VendorID", Vendor.Schema.Provider.Name); cmdDel.AddParameter("@VendorID", varVendorID); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (int item in itemList) { ProductVendor varProductVendor = new ProductVendor(); varProductVendor.SetColumnValue("VendorID", varVendorID); varProductVendor.SetColumnValue("UnitMeasureCode", item); varProductVendor.Save(); } }
public static void SaveContactMap(int varCreditCardID, int[] itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM ContactCreditCard WHERE CreditCardID=@CreditCardID", CreditCard.Schema.Provider.Name); cmdDel.AddParameter("@CreditCardID", varCreditCardID); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (int item in itemList) { ContactCreditCard varContactCreditCard = new ContactCreditCard(); varContactCreditCard.SetColumnValue("CreditCardID", varCreditCardID); varContactCreditCard.SetColumnValue("ContactID", item); varContactCreditCard.Save(); } }
public static void SaveContactTypeMap(int varVendorID, int[] itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM VendorContact WHERE VendorID=@VendorID", Vendor.Schema.Provider.Name); cmdDel.AddParameter("@VendorID", varVendorID); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (int item in itemList) { VendorContact varVendorContact = new VendorContact(); varVendorContact.SetColumnValue("VendorID", varVendorID); varVendorContact.SetColumnValue("ContactTypeID", item); varVendorContact.Save(); } }
public static void SaveCountryRegionMap(string varCurrencyCode, string[] itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM CountryRegionCurrency WHERE CurrencyCode=@CurrencyCode", Currency.Schema.Provider.Name); cmdDel.AddParameter("@CurrencyCode", varCurrencyCode); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (string item in itemList) { CountryRegionCurrency varCountryRegionCurrency = new CountryRegionCurrency(); varCountryRegionCurrency.SetColumnValue("CurrencyCode", varCurrencyCode); varCountryRegionCurrency.SetColumnValue("CountryRegionCode", item); varCountryRegionCurrency.Save(); } }
public static void SaveUserMap(int varId, int[] itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM [ProjectAssignments] WHERE [ProjectAssignments].[ProjectID] = @ProjectID", Project.Schema.Provider.Name); cmdDel.AddParameter("@ProjectID", varId, DbType.Int32); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (int item in itemList) { ProjectAssignment varProjectAssignment = new ProjectAssignment(); varProjectAssignment.SetColumnValue("ProjectID", varId); varProjectAssignment.SetColumnValue("UserID", item); varProjectAssignment.Save(); } }
public static void SaveProductMap(int varDownloadId, int[] itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM dashCommerce_Store_Product_Download_Map WHERE DownloadId=@DownloadId", Download.Schema.Provider.Name); cmdDel.AddParameter("@DownloadId", varDownloadId); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (int item in itemList) { ProductDownloadMap varProductDownloadMap = new ProductDownloadMap(); varProductDownloadMap.SetColumnValue("DownloadId", varDownloadId); varProductDownloadMap.SetColumnValue("ProductId", item); varProductDownloadMap.Save(); } }
public static void SaveTerritoryMap(int varEmployeeID, string[] itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM [EmployeeTerritories] WHERE [EmployeeTerritories].[EmployeeID] = @EmployeeID", Employee.Schema.Provider.Name); cmdDel.AddParameter("@EmployeeID", varEmployeeID, DbType.Int32); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (string item in itemList) { EmployeeTerritory varEmployeeTerritory = new EmployeeTerritory(); varEmployeeTerritory.SetColumnValue("EmployeeID", varEmployeeID); varEmployeeTerritory.SetColumnValue("TerritoryID", item); varEmployeeTerritory.Save(); } }
public static void SaveAddressMap(int varEmployeeID, int[] itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM EmployeeAddress WHERE EmployeeID=@EmployeeID", Employee.Schema.Provider.Name); cmdDel.AddParameter("@EmployeeID", varEmployeeID); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (int item in itemList) { EmployeeAddress varEmployeeAddress = new EmployeeAddress(); varEmployeeAddress.SetColumnValue("EmployeeID", varEmployeeID); varEmployeeAddress.SetColumnValue("AddressID", item); varEmployeeAddress.Save(); } }
public static void SaveProductMap(int varCategoryID, int[] itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM [Product_Category_Map] WHERE [Product_Category_Map].[CategoryID] = @CategoryID", Category.Schema.Provider.Name); cmdDel.AddParameter("@CategoryID", varCategoryID, DbType.Int32); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (int item in itemList) { ProductCategoryMap varProductCategoryMap = new ProductCategoryMap(); varProductCategoryMap.SetColumnValue("CategoryID", varCategoryID); varProductCategoryMap.SetColumnValue("ProductID", item); varProductCategoryMap.Save(); } }
public static void SaveShiftMap(int varEmployeeID, ShiftCollection items) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM EmployeeDepartmentHistory WHERE EmployeeID=@EmployeeID", Employee.Schema.Provider.Name); cmdDel.AddParameter("@EmployeeID", varEmployeeID); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (Shift item in items) { EmployeeDepartmentHistory varEmployeeDepartmentHistory = new EmployeeDepartmentHistory(); varEmployeeDepartmentHistory.SetColumnValue("EmployeeID", varEmployeeID); varEmployeeDepartmentHistory.SetColumnValue("ShiftID", item.GetPrimaryKeyValue()); varEmployeeDepartmentHistory.Save(); } }
public static void SaveCustomerMap(string varCustomerTypeID, string[] itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM [CustomerCustomerDemo] WHERE [CustomerCustomerDemo].[CustomerTypeID] = PARM__CustomerTypeID", CustomerDemographic.Schema.Provider.Name); cmdDel.AddParameter("PARM__CustomerTypeID", varCustomerTypeID, DbType.String); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (string item in itemList) { CustomerCustomerDemo varCustomerCustomerDemo = new CustomerCustomerDemo(); varCustomerCustomerDemo.SetColumnValue("CustomerTypeID", varCustomerTypeID); varCustomerCustomerDemo.SetColumnValue("CustomerID", item); varCustomerCustomerDemo.Save(); } }
public static void SaveProductMap(int varAttributeId, ProductCollection items) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM dashCommerce_Store_Product_Attribute_Map WHERE AttributeId=@AttributeId", Attribute.Schema.Provider.Name); cmdDel.AddParameter("@AttributeId", varAttributeId); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (Product item in items) { ProductAttributeMap varProductAttributeMap = new ProductAttributeMap(); varProductAttributeMap.SetColumnValue("AttributeId", varAttributeId); varProductAttributeMap.SetColumnValue("ProductId", item.GetPrimaryKeyValue()); varProductAttributeMap.Save(); } }