public static void SaveProductModelMap(int varProductDescriptionID, int[] itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM ProductModelProductDescriptionCulture WHERE ProductDescriptionID=@ProductDescriptionID", ProductDescription.Schema.Provider.Name); cmdDel.AddParameter("@ProductDescriptionID", varProductDescriptionID); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (int item in itemList) { ProductModelProductDescriptionCulture varProductModelProductDescriptionCulture = new ProductModelProductDescriptionCulture(); varProductModelProductDescriptionCulture.SetColumnValue("ProductDescriptionID", varProductDescriptionID); varProductModelProductDescriptionCulture.SetColumnValue("ProductModelID", item); varProductModelProductDescriptionCulture.Save(); } }
public static void SaveProductModelMap(string varCultureID, ProductModelCollection items) { 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 (ProductModel item in items) { ProductModelProductDescriptionCulture varProductModelProductDescriptionCulture = new ProductModelProductDescriptionCulture(); varProductModelProductDescriptionCulture.SetColumnValue("CultureID", varCultureID); varProductModelProductDescriptionCulture.SetColumnValue("ProductModelID", item.GetPrimaryKeyValue()); varProductModelProductDescriptionCulture.Save(); } }
public static void SaveCultureMap(int varProductDescriptionID, System.Web.UI.WebControls.ListItemCollection itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM ProductModelProductDescriptionCulture WHERE ProductDescriptionID=@ProductDescriptionID", ProductDescription.Schema.Provider.Name); cmdDel.AddParameter("@ProductDescriptionID", varProductDescriptionID); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (System.Web.UI.WebControls.ListItem l in itemList) { if (l.Selected) { ProductModelProductDescriptionCulture varProductModelProductDescriptionCulture = new ProductModelProductDescriptionCulture(); varProductModelProductDescriptionCulture.SetColumnValue("ProductDescriptionID", varProductDescriptionID); varProductModelProductDescriptionCulture.SetColumnValue("CultureID", l.Value); varProductModelProductDescriptionCulture.Save(); } } }