// refresh the grid
        // links:
        //  docLink: http://sql2x.org/documentationLink/a90065e7-8ace-4de7-9367-d4653a7c637f
        public void RefreshCrudeCartProductPrice()
        {
            var cartProductPrice = new CrudeCartProductPriceServiceClient();

            try {
                var bindingSource = new BindingSource();
                bindingSource.DataSource = cartProductPrice.FetchWithFilter(
                    Guid.Empty
                    , Guid.Empty
                    , maskedTextBoxAmount.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxAmount.Text)
                    , financialCurrencyPicker.SelectedValue
                    , textBoxState.Text
                    , Guid.Empty
                    , DateTime.MinValue
                    );
                dataGridViewCrudeCartProductPrice.AutoGenerateColumns = false;
                dataGridViewCrudeCartProductPrice.DataSource          = bindingSource;
                dataGridViewCrudeCartProductPrice.AutoResizeColumns();
                dataGridViewCrudeCartProductPrice.Refresh();
            } catch (Exception ex) {
                if (ex == null)
                {
                }
                else
                {
                    System.Diagnostics.Debugger.Break();
                }
            } finally {
                cartProductPrice.Close();
            }
        }
        // saves the form
        // links:
        //  docLink: http://sql2x.org/documentationLink/c9522930-91f8-4468-a936-8030bb2a6482
        private void buttonSave_Click(object sender, EventArgs e)
        {
            var service = new CrudeCartProductPriceServiceClient();

            try {
                _contract.Amount = maskedTextBoxAmount.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxAmount.Text);
                _contract.FinancialCurrencyId = (Guid)financialCurrencyPicker.SelectedValue;
                _contract.StateRcd            = textBoxState.Text;
                _contract.UserId = (Guid)userPicker.SelectedValue;

                if (_isNew)
                {
                    service.Insert(_contract);
                }
                else
                {
                    service.Update(_contract);
                }
            } catch (Exception ex) {
                if (ex == null)
                {
                }
                else
                {
                    System.Diagnostics.Debugger.Break();
                }
            } finally {
                service.Close();
            }

            Close();
        }
        public ActionResult CrudeCartProductPriceEdit(
            System.Guid cartProductPriceId
            )
        {
            CrudeCartProductPriceContract contract = new CrudeCartProductPriceServiceClient().FetchByCartProductPriceId(cartProductPriceId);

            ViewBag.ProductId =
                new SelectList(new CrudeProductServiceClient().FetchAll(),
                               "ProductId",
                               "ProductName",
                               contract.ProductId
                               );

            ViewBag.FinancialCurrencyId =
                new SelectList(new CrudeFinancialCurrencyServiceClient().FetchAll(),
                               "FinancialCurrencyId",
                               "FinancialCurrencyTypeName",
                               contract.FinancialCurrencyId
                               );

            ViewBag.DefaultUserName =
                new CrudeDefaultUserServiceClient().FetchByDefaultUserId(contract.UserId).DefaultUserName;


            return(View(
                       "~/Views/Crude/Cart/CrudeCartProductPrice/CrudeCartProductPriceEdit.cshtml",
                       contract
                       ));
        }
        // shows the form in edit modus
        // links:
        //  docLink: http://sql2x.org/documentationLink/49afd26c-4f21-4992-967b-be190eacef77
        public void ShowAsEdit(System.Guid cartProductPriceId)
        {
            var service = new CrudeCartProductPriceServiceClient();

            _isNew = false;
            try {
                _contract = service.FetchByCartProductPriceId(cartProductPriceId);
                maskedTextBoxAmount.Text = _contract.Amount.ToString();
                financialCurrencyPicker.SelectedValue = _contract.FinancialCurrencyId;
                textBoxState.Text           = _contract.StateRcd;
                userPicker.SelectedValue    = _contract.UserId;
                _contract.DateTime          = DateTime.UtcNow;
                dateTimePickerDateTime.Text = _contract.DateTime.ToString();

                Show();
            } catch (Exception ex) {
                if (ex == null)
                {
                }
                else
                {
                    System.Diagnostics.Debugger.Break();
                }
            } finally {
                service.Close();
            }
        }