private void GetVendor(int vendorID)
{
try
{
vendor = VendorDB.GetVendor(vendorID);
if (vendor != null)
{
vendorBindingSource.Clear();
vendorBindingSource.Add(vendor);
btnModifyVendor.Enabled = true;
}
else
{
MessageBox.Show("No vendor found with this ID. " +
"Please try again.", "Vendor Not Found");
vendorBindingSource.Clear();
btnModifyVendor.Enabled = false;
}
vendorBindingSource.Clear();
vendorBindingSource.Add(vendor);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
/// <summary>
/// Saves the data
/// </summary>
private void SaveData()
{
vendor = VendorChange(); //sets vendor values to current vendor values
vendors[intCount] = vendor;
VendorDB.SaveVendors(vendors);
boolNextVendor = true; //eligible to view a different vendor
}
private void btnSearch_Click(object sender, EventArgs e)
{
vendorList = VendorDB.GetSelectedVendors(txtLastName.Text,
txtState.Text);
singleLineAddressListBox.DataSource = vendorList;
switch (vendorList.Count)
{
case 0:
lblMessage.Text = "No vendors found with that name "
+ "and state.";
break;
case 1:
lblMessage.Text = "One vendor found with that name "
+ "and state.";
break;
default:
lblMessage.Text = singleLineAddressListBox.Items.Count +
" vendors found with that name and state.";
break;
}
singleLineAddressListBox.SelectedIndex = -1;
btnOK.Enabled = false;
}
protected void loadVendors()
{
List <Vendor> vendorList = new List <Vendor>();
vendorList = VendorDB.getVendors();
this.vendorsDropDownList.DataSource = vendorList;
this.vendorsDropDownList.DataTextField = "ShortString";
this.vendorsDropDownList.DataValueField = "BusinessEntityID";
this.vendorsDropDownList.DataBind();
if (vendorList.Count > 0)
{
if (this.selectedVendor == null)
{
this.vendorsDropDownList.SelectedIndex = 0;
this.selectedVendor = vendorList.ElementAt(0);
}
else
{
this.vendorsDropDownList.SelectedValue =
this.selectedVendor.BusinessEntityID.ToString();
}
this.displaySelectedVendor();
}
}
private void frmListVendors_Load(object sender, EventArgs e)
{
List <Vendor> vendors = VendorDB.GetAllVendors();
vendorBindingSource.DataSource = vendors;
_cm = (CurrencyManager)
vendorDataGridView.BindingContext[vendors];
}
/// <summary>
/// Loads vendor info into the form
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void FrmVendor_Load(object sender, EventArgs e)
{
foreach (string defaultDiscount in strDiscount)
{
cboDiscount.Items.Add(defaultDiscount); //loads combo box values from string array strDiscount
}
vendors = VendorDB.GetVendors();
FillVendorTextBox();
boolNextVendor = true; //user can go to next vendor
}
private void mnuAddNewVendor_Click(object sender, EventArgs e)
{
frmAddModifyVendor frmChild = new frmAddModifyVendor();
this.AddOwnedForm(frmChild);
if (frmChild.ShowDialog() == DialogResult.OK)
{
vendorBindingSource.DataSource = VendorDB.GetAllVendors();
}
}
private void mnuModifyVendor_Click(object sender, EventArgs e)
{
// retrieve the current Vendor
Vendor vendor = (Vendor)vendorBindingSource.Current;
// display vendor form
frmAddModifyVendor frmChild = new frmAddModifyVendor();
frmChild.vendor = vendor;
this.AddOwnedForm(frmChild);
if (frmChild.ShowDialog() == DialogResult.OK)
{
vendorBindingSource.DataSource = VendorDB.GetAllVendors();
}
}
private void btnAccept_Click(object sender, EventArgs e)
{
if (IsValidData())
{
if (vendor == null)
{
try
{
newVendor.VendorID = VendorDB.AddVendor(newVendor);
vendor = newVendor;
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
else
{
try
{
if (!VendorDB.UpdateVendor(vendor, newVendor))
{
MessageBox.Show("Another user has updated or " +
"deleted that vendor.", "Database Error");
this.DialogResult = DialogResult.Retry;
}
else
{
vendor = newVendor;
this.DialogResult = DialogResult.OK;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
}
static void Main(string[] args)
{
ICRUDAble iCRUDAble;
iCRUDAble = new CustomerDB();
iCRUDAble.Create();
iCRUDAble.Update();
iCRUDAble.Read();
iCRUDAble.Delete();
iCRUDAble = new VendorDB();
iCRUDAble.Create();
iCRUDAble.Update();
iCRUDAble.Read();
iCRUDAble.Delete();
iCRUDAble = new InvoiceDB();
iCRUDAble.Create();
iCRUDAble.Update();
iCRUDAble.Read();
iCRUDAble.Delete();
}
protected void updateButton_Click(object sender, EventArgs e)
{
Address address = new Address(
Int32.Parse(this.addressIDLabel.Text),
this.addressLine1TextBox.Text.Trim(),
this.addressLine2TextBox.Text.Trim(),
this.cityTextBox.Text.Trim(),
Int32.Parse(this.stateTextBox.Text.Trim()),
this.zipTextBox.Text.Trim(),
DateTime.Now);
Vendor vendor = new Vendor(
Int32.Parse(this.vendorsDropDownList.SelectedValue),
this.accountNumberTextBox.Text.Trim(),
this.nameTextBox.Text.Trim(),
Int16.Parse(this.creditRatingDropDownList.SelectedValue),
this.preferredVendorCheckBox.Checked, this.activeCheckBox.Checked,
this.webServiceTextBox.Text.Trim(),
this.modifiedDateCalendar.SelectedDate, address);
selectedVendor = VendorDB.updateVendor(vendor);
this.displaySelectedVendor();
}
protected void vendorsDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
this.selectedVendor = VendorDB.getVendor(Int32.Parse(vendorsDropDownList.SelectedValue));
this.displaySelectedVendor();
}
protected void newVendorButton_Click(object sender, EventArgs e)
{
VendorDB.insertEmptyVendor();
loadVendors();
}
public VendorBiz() : base()
{
m_db = new VendorDB();
}
