Пример #1
0
 private void suppliersList_SelectionChanged(object sender, SelectionChangedEventArgs e)
 {
     this.supplier = suppliersList.SelectedItem as Supplier;
     this.northwindContext.LoadProperty<Supplier>(this.supplier, s => s.Products);
     this.productsInfo = ((IListSource)supplier.Products).GetList();
     productsList.DataContext = this.productsInfo;
 }
Пример #2
0
        private void btnAdd_Click(object sender, EventArgs e)
        {
            Supplier newSup = new Supplier();
            newSup.SupplierID = -1;
            newSup.CompanyName = this.txtCompName.Text;
            newSup.Contactname = this.txtContname.Text;
            newSup.ContactTitle = this.txtContTitle.Text;
            newSup.Address = this.txtAddr.Text;
            newSup.City = this.txtCity.Text;
            newSup.Region = this.txtRegion.Text;
            newSup.Postalcode = this.txtPos.Text;
            newSup.Country = this.cbCountry.Text;
            newSup.Phone = this.txtPhone.Text;
            newSup.Fax = this.txtFax.Text;

            int check = newSup.isValid();
            if (check < 0)
            {
                MessageBox.Show(newSup.getErrorMessage(check));
            }
            else
            {
                this.dataModel.insertNewRow(newSup);
                MessageBox.Show("Completed");
                clearAll();
            }
        }
Пример #3
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            Supplier dataObj = new Supplier();
            dataObj.SupplierID = -1;
            dataObj.CompanyName = this.txtCompanyName.Text;
            dataObj.Contactname = this.txtContactName.Text;
            dataObj.ContactTitle = this.txtTitle.Text;
            dataObj.Address = this.txtAddress.Text;
            dataObj.City = this.txtCity.Text;
            dataObj.Region = this.txtRegion.Text;
            dataObj.Postalcode = this.txtPostalCode.Text;
            dataObj.Country = this.txtCountry.Text;
            dataObj.Phone = this.txtPhone.Text;
            dataObj.Fax = this.txtFax.Text;

            try
            {

                int check = dataObj.isValid();

                if (check < 0)
                {
                    //MessageBox.Show(newEmp.getErrorMessage(check));
                    this.script.Text = "<script>alert(\""+dataObj.getErrorMessage(check)+"\");</script>";
                    return;
                }
                else
                {
                    if (this.newEmpMode == true)
                        this.dataModel.insertNewRow(dataObj);
                    else
                    {
                        dataObj.SupplierID = this.suppID;
                        this.dataModel.updateRow(dataObj);
                    }

                    //Server.Transfer("Suppliers.aspx", true);
                }
            }
            catch (Exception ex)
            {
                Session["current_error"] = ex.Message;
                Response.Redirect("serverError.aspx");
            }

            Response.Redirect("Suppliers.aspx");
        }
Пример #4
0
        private void doSave_Update()
        {
            this.errorProvider.Clear();
            Supplier dataObj = new Supplier();
            dataObj.SupplierID = -1;
            dataObj.CompanyName = this.txtCompName.Text;
            dataObj.Contactname = this.txtContname.Text;
            dataObj.ContactTitle = this.txtContTitle.Text;
            dataObj.Address = this.txtAddr.Text;
            dataObj.City = this.txtCity.Text;
            dataObj.Region = this.txtRegion.Text;
            dataObj.Postalcode = this.txtPos.Text;
            dataObj.Country = this.cbCountry.Text;
            dataObj.Phone = this.txtPhone.Text;
            dataObj.Fax = this.txtFax.Text;

            int check = dataObj.isValid();
            if (check < 0)
            {
                showErrors(dataObj, check);
            }
            else
            {
                try
                {
                    if (this.AddNewMode == true)
                        this.dataModel.insertNewRow(dataObj);
                    else
                    {
                        dataObj.SupplierID = int.Parse(this.txtSupID.Text);
                        this.dataModel.updateRow(dataObj);
                    }

                    this.clearForm();
                    this.Close();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                    this.Close();
                }
            }
        }
Пример #5
0
 /// <summary>
 /// Create a new Supplier object.
 /// </summary>
 /// <param name="supplierID">Initial value of the SupplierID property.</param>
 /// <param name="companyName">Initial value of the CompanyName property.</param>
 public static Supplier CreateSupplier(global::System.Int32 supplierID, global::System.String companyName)
 {
     Supplier supplier = new Supplier();
     supplier.SupplierID = supplierID;
     supplier.CompanyName = companyName;
     return supplier;
 }
Пример #6
0
 /// <summary>
 /// Deprecated Method for adding a new object to the Suppliers EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
 /// </summary>
 public void AddToSuppliers(Supplier supplier)
 {
     base.AddObject("Suppliers", supplier);
 }
Пример #7
0
 private void showErrors(Supplier supp, int code)
 {
     if (code == -2)
     {
         if (this.txtCompName.Text.Equals(""))
             this.errorProvider.SetError(txtCompName,
                     supp.getErrorMessage(code));
         if (this.txtContname.Text.Equals(""))
             this.errorProvider.SetError(txtContname,
                     supp.getErrorMessage(code));
         if (this.txtContTitle.Text.Equals(""))
             this.errorProvider.SetError(txtContTitle,
                     supp.getErrorMessage(code));
         if (this.txtAddr.Text.Equals(""))
             this.errorProvider.SetError(txtAddr,
                     supp.getErrorMessage(code));
         if (this.txtCity.Text.Equals(""))
             this.errorProvider.SetError(txtCity,
                     supp.getErrorMessage(code));
         if (this.cbCountry.Text.Equals(""))
             this.errorProvider.SetError(cbCountry,
                     supp.getErrorMessage(code));
         if (this.txtPhone.Text.Equals(""))
             this.errorProvider.SetError(txtPhone,
                     supp.getErrorMessage(code));
     }
 }
Пример #8
0
        private void btnUpdate_Click(object sender, EventArgs e)
        {
            if (this.txtSupID.Text.Equals(""))
            {
                MessageBox.Show("You must select a Supplier first");
                return;
            }

            try
            {
                Supplier updateData = new Supplier();
                updateData.SupplierID = int.Parse(this.txtSupID.Text.Trim());
                updateData.CompanyName = this.txtCompName.Text;
                updateData.Contactname = this.txtContname.Text;
                updateData.ContactTitle = this.txtContTitle.Text;
                updateData.Address = this.txtAddr.Text;
                updateData.City = this.txtCity.Text;
                updateData.Region = this.txtRegion.Text;
                updateData.Postalcode = this.txtPos.Text;
                updateData.Country = this.cbCountry.Text;
                updateData.Phone = this.txtPhone.Text;
                updateData.Fax = this.txtFax.Text;

                this.dataModel.updateRow(updateData);
                MessageBox.Show("Updated");
                clearAll();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }