public bool ChangeShipingAddress(int pCustomerID, int pSalesOrderID, int pAddressID) { var _result = false; using (var db = new AdventureWorks2016CTP3Entities()) { SalesOrderHeader _SalesOrderHeaders = db.SalesOrderHeaders.FirstOrDefault(s => s.SalesOrderID == pSalesOrderID); _SalesOrderHeaders.BillToAddressID = pAddressID; db.SaveChanges(); _result = true; } return(_result); }
public bool SaveNewItemToOrder(int pCustomerID, SalesOrderDetail pSalesOrderDetail) { using (var db = new AdventureWorks2016CTP3Entities()) { pSalesOrderDetail.rowguid = Guid.NewGuid(); db.SalesOrderDetails.Add(pSalesOrderDetail); SalesOrderHeader _SalesOrderHeader = db.SalesOrderHeaders.Where(t => t.SalesOrderID == pSalesOrderDetail.SalesOrderID).FirstOrDefault(); _SalesOrderHeader.SubTotal = _SalesOrderHeader.SubTotal + pSalesOrderDetail.LineTotal; _SalesOrderHeader.TotalDue = _SalesOrderHeader.TotalDue + pSalesOrderDetail.LineTotal; db.SaveChanges(); return(true); } }