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 ProductID=@ProductID", Product.Schema.Provider.Name); cmdDel.AddParameter("@ProductID", varProductID); //add this in 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 SaveTerritoryMap(int varEmployeeID, System.Web.UI.WebControls.ListItemCollection 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 (System.Web.UI.WebControls.ListItem l in itemList) { if (l.Selected) { EmployeeTerritory varEmployeeTerritory = new EmployeeTerritory(); varEmployeeTerritory.SetColumnValue("EmployeeID", varEmployeeID); varEmployeeTerritory.SetColumnValue("TerritoryID", l.Value); varEmployeeTerritory.Save(); } } }
public static void SaveEmployeeMap(byte varShiftID, System.Web.UI.WebControls.ListItemCollection 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 (System.Web.UI.WebControls.ListItem l in itemList) { if (l.Selected) { EmployeeDepartmentHistory varEmployeeDepartmentHistory = new EmployeeDepartmentHistory(); varEmployeeDepartmentHistory.SetColumnValue("ShiftID", varShiftID); varEmployeeDepartmentHistory.SetColumnValue("EmployeeID", l.Value); varEmployeeDepartmentHistory.Save(); } } }
public static void SaveUserMap(int varId, System.Web.UI.WebControls.ListItemCollection 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 (System.Web.UI.WebControls.ListItem l in itemList) { if (l.Selected) { ProjectAssignment varProjectAssignment = new ProjectAssignment(); varProjectAssignment.SetColumnValue("ProjectID", varId); varProjectAssignment.SetColumnValue("UserID", l.Value); varProjectAssignment.Save(); } } }
public static void SaveContactTypeMap(int varVendorID, System.Web.UI.WebControls.ListItemCollection 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 (System.Web.UI.WebControls.ListItem l in itemList) { if (l.Selected) { VendorContact varVendorContact = new VendorContact(); varVendorContact.SetColumnValue("VendorID", varVendorID); varVendorContact.SetColumnValue("ContactTypeID", l.Value); varVendorContact.Save(); } } }
public static void SaveAspnetRoleMap(Guid varUserId, System.Web.UI.WebControls.ListItemCollection 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 (System.Web.UI.WebControls.ListItem l in itemList) { if (l.Selected) { AspnetUsersInRole varAspnetUsersInRole = new AspnetUsersInRole(); varAspnetUsersInRole.SetColumnValue("UserId", varUserId); varAspnetUsersInRole.SetColumnValue("RoleId", l.Value); varAspnetUsersInRole.Save(); } } }
public static void SaveProductModelMap(string varCultureID, System.Web.UI.WebControls.ListItemCollection itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM ProductModelProductDescriptionCulture WHERE CultureID=@CultureID", Culture.Schema.Provider.Name); cmdDel.AddParameter("@CultureID", varCultureID); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (System.Web.UI.WebControls.ListItem l in itemList) { if (l.Selected) { ProductModelProductDescriptionCulture varProductModelProductDescriptionCulture = new ProductModelProductDescriptionCulture(); varProductModelProductDescriptionCulture.SetColumnValue("CultureID", varCultureID); varProductModelProductDescriptionCulture.SetColumnValue("ProductModelID", l.Value); varProductModelProductDescriptionCulture.Save(); } } }
public static void SaveProductMap(int varProductPhotoID, System.Web.UI.WebControls.ListItemCollection 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 (System.Web.UI.WebControls.ListItem l in itemList) { if (l.Selected) { ProductProductPhoto varProductProductPhoto = new ProductProductPhoto(); varProductProductPhoto.SetColumnValue("ProductPhotoID", varProductPhotoID); varProductProductPhoto.SetColumnValue("ProductID", l.Value); varProductProductPhoto.Save(); } } }
public static void SaveAddressMap(int varEmployeeID, System.Web.UI.WebControls.ListItemCollection 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 (System.Web.UI.WebControls.ListItem l in itemList) { if (l.Selected) { EmployeeAddress varEmployeeAddress = new EmployeeAddress(); varEmployeeAddress.SetColumnValue("EmployeeID", varEmployeeID); varEmployeeAddress.SetColumnValue("AddressID", l.Value); varEmployeeAddress.Save(); } } }
public static void SaveCountryRegionMap(string varCurrencyCode, System.Web.UI.WebControls.ListItemCollection 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 (System.Web.UI.WebControls.ListItem l in itemList) { if (l.Selected) { CountryRegionCurrency varCountryRegionCurrency = new CountryRegionCurrency(); varCountryRegionCurrency.SetColumnValue("CurrencyCode", varCurrencyCode); varCountryRegionCurrency.SetColumnValue("CountryRegionCode", l.Value); varCountryRegionCurrency.Save(); } } }
public static void SaveContactMap(int varCreditCardID, System.Web.UI.WebControls.ListItemCollection 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 (System.Web.UI.WebControls.ListItem l in itemList) { if (l.Selected) { ContactCreditCard varContactCreditCard = new ContactCreditCard(); varContactCreditCard.SetColumnValue("CreditCardID", varCreditCardID); varContactCreditCard.SetColumnValue("ContactID", l.Value); varContactCreditCard.Save(); } } }
public static void SavePageMap(int varRegionId, System.Web.UI.WebControls.ListItemCollection 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 (System.Web.UI.WebControls.ListItem l in itemList) { if (l.Selected) { PageRegionMap varPageRegionMap = new PageRegionMap(); varPageRegionMap.SetColumnValue("RegionId", varRegionId); varPageRegionMap.SetColumnValue("PageId", l.Value); varPageRegionMap.Save(); } } }
public static void SaveKELENGKAPANMap(string varKODEPBJ, System.Web.UI.WebControls.ListItemCollection 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 (System.Web.UI.WebControls.ListItem l in itemList) { if (l.Selected) { KELENGKAPANPBJ varKELENGKAPANPBJ = new KELENGKAPANPBJ(); varKELENGKAPANPBJ.SetColumnValue("KODEBPJ", varKODEPBJ); varKELENGKAPANPBJ.SetColumnValue("KODEKELENGKAPAN", l.Value); varKELENGKAPANPBJ.Save(); } } }
public static void SaveSalesPersonMap(int varTerritoryID, System.Web.UI.WebControls.ListItemCollection itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM SalesTerritoryHistory WHERE TerritoryID=@TerritoryID", SalesTerritory.Schema.Provider.Name); cmdDel.AddParameter("@TerritoryID", varTerritoryID); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (System.Web.UI.WebControls.ListItem l in itemList) { if (l.Selected) { SalesTerritoryHistory varSalesTerritoryHistory = new SalesTerritoryHistory(); varSalesTerritoryHistory.SetColumnValue("TerritoryID", varTerritoryID); varSalesTerritoryHistory.SetColumnValue("SalesPersonID", l.Value); varSalesTerritoryHistory.Save(); } } }
public static void SaveProductMap(int varOrderID, System.Web.UI.WebControls.ListItemCollection 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 (System.Web.UI.WebControls.ListItem l in itemList) { if (l.Selected) { OrderDetail varOrderDetail = new OrderDetail(); varOrderDetail.SetColumnValue("OrderID", varOrderID); varOrderDetail.SetColumnValue("ProductID", l.Value); varOrderDetail.Save(); } } }
public static void SaveSysUserMap(long varIRole, System.Web.UI.WebControls.ListItemCollection 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 (System.Web.UI.WebControls.ListItem l in itemList) { if (l.Selected) { TblRolesForUser varTblRolesForUser = new TblRolesForUser(); varTblRolesForUser.SetColumnValue("FP_sBranchID", varIRole); varTblRolesForUser.SetColumnValue("FP_sBranchID", l.Value); varTblRolesForUser.Save(); } } }
public static void SaveProductMap(int varCategoryID, System.Web.UI.WebControls.ListItemCollection 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 (System.Web.UI.WebControls.ListItem l in itemList) { if (l.Selected) { ProductCategoryMap varProductCategoryMap = new ProductCategoryMap(); varProductCategoryMap.SetColumnValue("CategoryID", varCategoryID); varProductCategoryMap.SetColumnValue("ProductID", l.Value); varProductCategoryMap.Save(); } } }
public static void SaveProductMap(int varCustomizedProductDisplayTypeId, System.Web.UI.WebControls.ListItemCollection 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 (System.Web.UI.WebControls.ListItem l in itemList) { if (l.Selected) { CustomizedProductDisplayTypeProductMap varCustomizedProductDisplayTypeProductMap = new CustomizedProductDisplayTypeProductMap(); varCustomizedProductDisplayTypeProductMap.SetColumnValue("CustomizedProductDisplayTypeId", varCustomizedProductDisplayTypeId); varCustomizedProductDisplayTypeProductMap.SetColumnValue("ProductId", l.Value); varCustomizedProductDisplayTypeProductMap.Save(); } } }
public static void SaveCustomerMap(string varCustomerTypeID, System.Web.UI.WebControls.ListItemCollection 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 (System.Web.UI.WebControls.ListItem l in itemList) { if (l.Selected) { CustomerCustomerDemo varCustomerCustomerDemo = new CustomerCustomerDemo(); varCustomerCustomerDemo.SetColumnValue("CustomerTypeID", varCustomerTypeID); varCustomerCustomerDemo.SetColumnValue("CustomerID", l.Value); varCustomerCustomerDemo.Save(); } } }
public static void SaveVendorMap(string varUnitMeasureCode, System.Web.UI.WebControls.ListItemCollection itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM ProductVendor WHERE UnitMeasureCode=@UnitMeasureCode", UnitMeasure.Schema.Provider.Name); cmdDel.AddParameter("@UnitMeasureCode", varUnitMeasureCode); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (System.Web.UI.WebControls.ListItem l in itemList) { if (l.Selected) { ProductVendor varProductVendor = new ProductVendor(); varProductVendor.SetColumnValue("UnitMeasureCode", varUnitMeasureCode); varProductVendor.SetColumnValue("VendorID", l.Value); varProductVendor.Save(); } } }