public static void SaveSalesOrderHeaderMap(int varSalesReasonID, int[] itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM SalesOrderHeaderSalesReason WHERE SalesReasonID=@SalesReasonID", SalesReason.Schema.Provider.Name); cmdDel.AddParameter("@SalesReasonID", varSalesReasonID); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (int item in itemList) { SalesOrderHeaderSalesReason varSalesOrderHeaderSalesReason = new SalesOrderHeaderSalesReason(); varSalesOrderHeaderSalesReason.SetColumnValue("SalesReasonID", varSalesReasonID); varSalesOrderHeaderSalesReason.SetColumnValue("SalesOrderID", item); varSalesOrderHeaderSalesReason.Save(); } }
public static void SaveSalesReasonMap(int varSalesOrderID, System.Web.UI.WebControls.ListItemCollection itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM SalesOrderHeaderSalesReason WHERE SalesOrderID=@SalesOrderID", SalesOrderHeader.Schema.Provider.Name); cmdDel.AddParameter("@SalesOrderID", varSalesOrderID); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (System.Web.UI.WebControls.ListItem l in itemList) { if (l.Selected) { SalesOrderHeaderSalesReason varSalesOrderHeaderSalesReason = new SalesOrderHeaderSalesReason(); varSalesOrderHeaderSalesReason.SetColumnValue("SalesOrderID", varSalesOrderID); varSalesOrderHeaderSalesReason.SetColumnValue("SalesReasonID", l.Value); varSalesOrderHeaderSalesReason.Save(); } } }