public void Update(int SalesOrderID, int SalesReasonID, DateTime ModifiedDate) { SalesOrderHeaderSalesReason item = new SalesOrderHeaderSalesReason(); item.SalesOrderID = SalesOrderID; item.SalesReasonID = SalesReasonID; item.ModifiedDate = ModifiedDate; item.MarkOld(); item.Save(UserName); }
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(); } } }