public void Insert(int CategoryID, int ProductID) { Product_Category_Map item = new Product_Category_Map(); item.CategoryID = CategoryID; item.ProductID = ProductID; item.Save(UserName); }
public void Update(int CategoryID, int ProductID) { Product_Category_Map item = new Product_Category_Map(); item.MarkOld(); item.IsLoaded = true; item.CategoryID = CategoryID; item.ProductID = ProductID; item.Save(UserName); }
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) { Product_Category_Map varProduct_Category_Map = new Product_Category_Map(); varProduct_Category_Map.SetColumnValue("CategoryID", varCategoryID); varProduct_Category_Map.SetColumnValue("ProductID", item); varProduct_Category_Map.Save(); } }
public static void SaveCategoryMap(int varProductID, 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].[ProductID] = @ProductID", Product.Schema.Provider.Name); cmdDel.AddParameter("@ProductID", varProductID, DbType.Int32); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (System.Web.UI.WebControls.ListItem l in itemList) { if (l.Selected) { Product_Category_Map varProduct_Category_Map = new Product_Category_Map(); varProduct_Category_Map.SetColumnValue("ProductID", varProductID); varProduct_Category_Map.SetColumnValue("CategoryID", l.Value); varProduct_Category_Map.Save(); } } }
public bool Destroy(object CategoryID) { return(Product_Category_Map.Destroy(CategoryID) == 1); }
public bool Delete(object CategoryID) { return(Product_Category_Map.Delete(CategoryID) == 1); }