public static void SaveOrderMap(int varProductID, int[] itemList) { 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 (int item in itemList) { OrderDetail varOrderDetail = new OrderDetail(); varOrderDetail.SetColumnValue("ProductID", varProductID); varOrderDetail.SetColumnValue("OrderID", item); varOrderDetail.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] = PARM__OrderID", Order.Schema.Provider.Name); cmdDel.AddParameter("PARM__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(); } } }