コード例 #1
0
ファイル: frmSupplier.cs プロジェクト: zeedurwesh/Mobile-Fix
        public void loadSuppliers()
        {
            clsDBSupplier dbSupplier = new clsDBSupplier();
            List<clsSupplier> suppliers = dbSupplier.SupplierList();

            Int32 Index = 0;
            
            lstSupplier.Items.Clear();
            while (Index < suppliers.Count)
            {
                clsSupplier supplier = suppliers[Index];

                ListViewItem NewItem = new ListViewItem();
                NewItem.Text = supplier.Name;
                NewItem.SubItems.Add(supplier.Address);
                NewItem.SubItems.Add(supplier.Town);
                NewItem.SubItems.Add(supplier.Postcode);
                NewItem.SubItems.Add(supplier.ContactName);
                NewItem.SubItems.Add(supplier.ContactNumber);
              
                NewItem.Tag = supplier;
                lstSupplier.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent);
                lstSupplier.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
                lstSupplier.Items.Add(NewItem); //Add the item to ListView

                Index++; //move the index to the next record
            }
        }
コード例 #2
0
ファイル: frmSupplier.cs プロジェクト: zeedurwesh/Mobile-Fix
        private void btnDelete_Click(object sender, EventArgs e)
        {

            if (lstSupplier.SelectedItems.Count > 0)
            {
                ListViewItem selectedItem = lstSupplier.SelectedItems[0];
                clsSupplier supplier = (clsSupplier)selectedItem.Tag;
                // Display a message box asking users if they
                // want to delete the selected Supplier.
                if (MessageBox.Show("Are you sure to Delete this Supplier " + supplier.Name + "?", "Delete Supplier",
                    MessageBoxButtons.YesNo, MessageBoxIcon.Question)
                      == DialogResult.Yes)
                {
                    // code for deleting the record goes here
                    clsDBSupplier dbSupplier = new clsDBSupplier();
                    dbSupplier.DeleteSupplier(supplier.ID);
                    loadSuppliers();
                }
            }
        }
コード例 #3
0
        private void btnAdd_Click(object sender, EventArgs e)
        {
            if (isValid())
            {
                clsSupplier supplier = new clsSupplier();
                supplier.Name          = txtSupplierName.Text;
                supplier.Address       = txtAddress.Text;
                supplier.Town          = txtTown.Text;
                supplier.Postcode      = txtPostCode.Text;
                supplier.ContactName   = txtContactName.Text;
                supplier.ContactNumber = txtContactNo.Text;

                clsDBSupplier fbs   = new clsDBSupplier();
                Int32         added = 0;
                if (txtID.Text.Length > 0)
                {
                    supplier.ID = Convert.ToInt32(txtID.Text);
                    added       = fbs.UpdateSupplier(supplier);
                }
                else
                {
                    added = fbs.InsertSupplier(supplier);
                }

                if (added > 0)
                {
                    frmListSupplier.loadSuppliers();
                    Close();
                }
                else
                {
                    txtErrorMessage.Text    = "Could not added Supplier.";
                    txtErrorMessage.Visible = true;
                }
            }
            else
            {
                txtErrorMessage.Text    = "Specify valid values";
                txtErrorMessage.Visible = true;
            }
        }
コード例 #4
0
        public void loadSuppliers(clsProductRecord productRecord)
        {
            clsDBSupplier      dbSupplier = new clsDBSupplier();
            List <clsSupplier> suppliers  = dbSupplier.SupplierList();

            Int32 Index = 0;

            cmbSupplierName.DisplayMember = "Name";
            cmbSupplierName.ValueMember   = "ID";
            cmbSupplierName.Items.Clear();
            while (Index < suppliers.Count)
            {
                clsSupplier supplier = suppliers[Index];
                cmbSupplierName.Items.Add(supplier); //add the supplier to the list
                if (productRecord != null && (productRecord.SupplierId == supplier.ID))
                {
                    cmbSupplierName.SelectedItem = supplier;
                }

                Index++; //move the index to the next record
            }
        }