private void btnSave_Click(object sender, EventArgs e)
{
dc = new CIS260_recycleDataContext();
if (isEdited == false)
{
Vendor obj = new Vendor();
//Adds values from form
obj.VendorName = txtName.Text;
obj.StreetAddress1 = txtStreet.Text;
obj.StreetAddress2 = txtStreet2.Text;
obj.City = txtCity.Text;
obj.State = txtState.Text;
obj.Country = txtCountry.Text;
obj.Zip = txtZip.Text;
if (obj.StreetAddress2 == "")
{
obj.StreetAddress2 = null;
}
dc.Vendors.InsertOnSubmit(obj);
dc.SubmitChanges();
MessageBox.Show("Inserted into the table");
}
else
{
//Code runs when entry is being updated
Vendor obj = dc.Vendors.SingleOrDefault(E => E.VendorID == vendorID);
obj.VendorName = txtName.Text;
obj.StreetAddress1 = txtStreet.Text;
obj.StreetAddress2 = txtStreet2.Text;
obj.City = txtCity.Text;
obj.State = txtState.Text;
obj.Country = txtCountry.Text;
obj.Zip = txtZip.Text;
obj.Company = txtCompany.Text;
dc.SubmitChanges();
MessageBox.Show("Record updated");
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (dGridVendors.SelectedRows.Count > 0)
{
if (MessageBox.Show("Are you sure you wish to delete this record?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
int vendorID = Convert.ToInt32(dGridVendors.SelectedRows[0].Cells[0].Value);
Vendor obj = dc.Vendors.SingleOrDefault(E => E.VendorID == vendorID);
dc.Vendors.DeleteOnSubmit(obj);
dc.SubmitChanges();
LoadData();
}
}
else
{
MessageBox.Show("Please select entire row to delete record.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
