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));
        }
Esempio n. 3
0
        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));
        }