public void searchDataGrid(object sender, EventArgs e)
{
clearDataGrid();
updateResultsNumber();
if (!this.txtVendorSearch.Text.ToString().Equals(""))
{
if (this.comboVendorSearchTypes.SelectedItem.ToString().Equals("ID"))
{
int temp;
if (!Int32.TryParse(txtVendorSearch.Text.ToString(), out temp))
{
MessageBox.Show("You must enter a number");
}
else
{
VendorDB.PullVendorByID(Int32.Parse(txtVendorSearch.Text));
populateDateGrid();
}
}
else
{
clearDataGrid();
VendorDB.PullVendorByName(txtVendorSearch.Text.ToString());
populateDateGrid();
}
}
}
public void TestRefresh(frmVendors theForm)
{
this.clearDataGrid();
VendorDB.PullVendorsFromDB();
populateDateGrid();
}
public frmVendors()
{
InitializeComponent();
clearDataGrid();
VendorDB.PullVendorsFromDB();
InitTimer();
populateDateGrid();
comboVendorSearchTypes.Items.Clear();
comboVendorSearchTypes.Items.Add("ID");
comboVendorSearchTypes.Items.Add("Name");
}
private void btnVendorAdd_Click(object sender, EventArgs e)
{
if (!txtVendorName.Text.ToString().Equals(""))
{
if (VendorDB.AddVendor(txtVendorName.Text, txtVendorDescription.Text, txtVendorPhone.Text, txtVendorWebsite.Text, txtVendorNotes.Text))
{
frmVendors.updated = true;
MessageBox.Show("Success!");
clearTextBoxes(sender, e);
this.Close();
}
else
{
MessageBox.Show("Error?");
}
}
else
{
MessageBox.Show("You must enter at least a name!");
}
}
private void btnVendorDelete_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Are you sure you want to delete this record?", "ATTENTION: PERMANENT CHANGE", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
Console.WriteLine("Yes");
VendorIDSelected = Int32.Parse(dataGridVendors.CurrentRow.Cells[0].Value.ToString());
string deleteStatement = "delete from Vendors where VendorID='" + VendorIDSelected + "'";
SqlConnection connection = new SqlConnection(VendorDB.connectionString);
SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection);
try
{
connection.Open();
deleteCommand.ExecuteNonQuery();
MessageBox.Show("Record deleted. ");
clearDataGrid();
VendorDB.PullVendorsFromDB();
populateDateGrid();
}
catch (SqlException ex)
{
throw ex;
}
finally
{
connection.Close();
}
}
else if (dialogResult == DialogResult.No)
{
//
}
}
public void reloadDefaultData()
{
clearDataGrid();
VendorDB.PullVendorsFromDB();
populateDateGrid();
}
