public override OperationStatus UpdateCustomer(Customer cust) { NorthwindDataContext context = null; try { context = DataContext; context.ap_UpdateCustomer( cust.CustomerID, cust.CompanyName, cust.ContactName, cust.ContactTitle, cust.Address, cust.City, cust.Region, cust.PostalCode, cust.Country, cust.Phone, cust.Fax); } catch (Exception exp) { return(new OperationStatus(false, exp.Message, exp)); } finally { if (context != null) { context.Dispose(); } } return(new OperationStatus(true, null, null)); }
public override OperationStatus DeleteCustomer(Customer cust) { NorthwindDataContext context = null; try { context = DataContext; context.ap_DeleteCustomer(cust.CustomerID); } catch (Exception exp) { return(new OperationStatus(false, exp.Message, exp)); } finally { if (context != null) { context.Dispose(); } } return(new OperationStatus(true, null, null)); }
public virtual OperationStatus InsertCustomer(Customer cust) { NorthwindDataContext context = null; try { context = DataContext; context.Customers.InsertOnSubmit(cust); context.SubmitChanges(); } catch (Exception exp) { return(new OperationStatus(false, exp.Message, exp)); } finally { if (context != null) { context.Dispose(); } } return(new OperationStatus(true, null, null)); }