Example #1
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                POCS.Ds.POCSTableAdapters.VendorTableAdapter tAdapter = new POCS.Ds.POCSTableAdapters.VendorTableAdapter();
                if (!IsEditMode)
                {
                    if (IsValidEntry(this.Frame1))
                    {
                        tAdapter.Insert(txtVendorFirmName.Text, txtVendorCnctPerson.Text, txtVendorAdd.Text, txtVendorPh.Text, txtVendorMob.Text, txtVendorZip.Text, txtVendorFax.Text, txtVendorEmail.Text, "1", txtVendorCity.Text, "-", txtVendorCountry.Text, TxtRegNo.Text, dtpRegDate.Value, txtVendorCode.Text, chkAVL.Checked, 45);
                    }
                    else
                    {
                        MessageBox.Show("Please Enter all Required Vendor Detail Entries", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    }
                }
                else
                {
                    tAdapter.UpdateVendorDetails(txtVendorFirmName.Text, txtVendorCnctPerson.Text, txtVendorAdd.Text, txtVendorPh.Text, txtVendorMob.Text, txtVendorZip.Text, txtVendorFax.Text, txtVendorEmail.Text, "1", txtVendorCity.Text, "-", txtVendorCountry.Text, TxtRegNo.Text, dtpRegDate.Value, txtVendorCode.Text, chkAVL.Checked, 45, VendorID);
                    vendorTableAdapter.Update(this.pOCS.Vendor);

                    dgvVendors.Refresh();
                    MessageBox.Show("Vendor Information Updated Succesfully", Application.ProductName, MessageBoxButtons.OK);
                }
            }
            catch { }
        }
Example #2
0
 private void txtVendorId_TextChanged(object sender, EventArgs e)
 {
     POCS.Ds.POCSTableAdapters.VendorTableAdapter dAdapter = new POCS.Ds.POCSTableAdapters.VendorTableAdapter();
     txtVendorFirmName.Text = dAdapter.GetDataByVendorID(Decimal.Parse(txtVendorId.Text)).v_nameColumn.Table.Columns[0].ToString();
 }