private void BillOfLading_Load(object sender, EventArgs e)
{
this.WindowState = FormWindowState.Maximized;
dGridPackages.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dc = new CIS260_recycleDataContext();
dGridPackages.DataSource = dc.AllDatas;
}
private void VendorsPage_Load(object sender, EventArgs e)
{
this.WindowState = FormWindowState.Maximized;
dc = new CIS260_recycleDataContext();
dGridVendors.DataSource = dc.Vendors;
dGridVendors.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
}
/// <summary>
/// Runs select statement in ComputerRecyclingLocation table
/// to get info at ID 1.
/// </summary>
/// <returns></returns>
public static IQueryable <ComputerRecyclingLocation> GetLocation(int id)
{
CIS260_recycleDataContext dc = new CIS260_recycleDataContext();
IQueryable <ComputerRecyclingLocation> query =
from loc in dc.ComputerRecyclingLocations
where loc.LocationID == 1
select loc;
return(query);
}
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 AdminLogin_Load(object sender, EventArgs e)
{
dc = new CIS260_recycleDataContext();
admin = dc.Administrators.ToList();
}
private void LoadData()
{
dc = new CIS260_recycleDataContext();
dGridVendors.DataSource = dc.Vendors;
}
