public void Update(int CategoryID, int ProductID)
{
ProductCategoryMap item = new ProductCategoryMap();
item.CategoryID = CategoryID;
item.ProductID = ProductID;
item.MarkOld();
item.Save(UserName);
}
public void Insert(int CategoryID, int ProductID)
{
ProductCategoryMap item = new ProductCategoryMap();
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 CategoryID=@CategoryID", Category.Schema.Provider.Name);
cmdDel.AddParameter("@CategoryID", varCategoryID);
//add this in
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 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 ProductID=@ProductID", Product.Schema.Provider.Name);
cmdDel.AddParameter("@ProductID", varProductID);
//add this in
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (System.Web.UI.WebControls.ListItem l in itemList)
{
if (l.Selected)
{
ProductCategoryMap varProductCategoryMap = new ProductCategoryMap();
varProductCategoryMap.SetColumnValue("ProductID", varProductID);
varProductCategoryMap.SetColumnValue("CategoryID", l.Value);
varProductCategoryMap.Save();
}
}
}