public bool PurchaseOrderHeaderUpdate(PurchaseOrderHeader purchaseorderheader)
        {
            return Execute<bool>(dal =>
            {
                PurchaseOrderHeader purchaseorderheaderUpdate = dal.PurchaseOrderHeader.Where(x => x.PurchaseOrderID == purchaseorderheader.PurchaseOrderID).FirstOrDefault();
                if (purchaseorderheaderUpdate != null)
                {
                    purchaseorderheaderUpdate.PurchaseOrderID=purchaseorderheader.PurchaseOrderID;
            purchaseorderheaderUpdate.RevisionNumber=purchaseorderheader.RevisionNumber;
            purchaseorderheaderUpdate.Status=purchaseorderheader.Status;
            purchaseorderheaderUpdate.EmployeeID=purchaseorderheader.EmployeeID;
            purchaseorderheaderUpdate.VendorID=purchaseorderheader.VendorID;
            purchaseorderheaderUpdate.ShipMethodID=purchaseorderheader.ShipMethodID;
            purchaseorderheaderUpdate.OrderDate=purchaseorderheader.OrderDate;
            purchaseorderheaderUpdate.ShipDate=purchaseorderheader.ShipDate;
            purchaseorderheaderUpdate.SubTotal=purchaseorderheader.SubTotal;
            purchaseorderheaderUpdate.TaxAmt=purchaseorderheader.TaxAmt;
            purchaseorderheaderUpdate.Freight=purchaseorderheader.Freight;
            purchaseorderheaderUpdate.TotalDue=purchaseorderheader.TotalDue;
            purchaseorderheaderUpdate.ModifiedDate=purchaseorderheader.ModifiedDate;

                    dal.SubmitChanges();
                    return  true;
                }
                return false;

            });
        }
        public bool PurchaseOrderHeaderDelete(PurchaseOrderHeader purchaseorderheader)
        {
            return Execute<bool>(dal =>
            {
                PurchaseOrderHeader purchaseorderheaderDelete = dal.PurchaseOrderHeader.Where(x => x.PurchaseOrderID == purchaseorderheader.PurchaseOrderID).FirstOrDefault();
                if (purchaseorderheaderDelete != null)
                {
                    dal.PurchaseOrderHeader.DeleteOnSubmit(purchaseorderheaderDelete);
                    dal.SubmitChanges();
                    return true;
                }
                return false;

            });
        }
 partial void DeletePurchaseOrderHeader(PurchaseOrderHeader instance);
 partial void UpdatePurchaseOrderHeader(PurchaseOrderHeader instance);
 partial void InsertPurchaseOrderHeader(PurchaseOrderHeader instance);
		private void detach_PurchaseOrderHeaders(PurchaseOrderHeader entity)
		{
			this.SendPropertyChanging();
			entity.Vendor = null;
		}
		private void attach_PurchaseOrderHeaders(PurchaseOrderHeader entity)
		{
			this.SendPropertyChanging();
			entity.ShipMethod = this;
		}
 public void PurchaseOrderHeaderUpdate(PurchaseOrderHeader purchaseorderheader)
 {
     adventureWorks_BC.PurchaseOrderHeaderUpdate(purchaseorderheader);
 }