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 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();
}
