add using linq c#

Question

#####Presentation

private void Grid_Loaded_1(object sender, RoutedEventArgs e) // load list box with a value or name of sorts

{

var getResults = data.LoadShip();

lsShipper.ItemsSource = getResults;

lsShipper.DisplayMemberPath = "CompanyName";

lsShipper.SelectedValuePath = "ShipperID";

txtShip.IsEnabled = false;

txtCompanyName.IsEnabled = false;

txtPhone.IsEnabled = false;

}

private void lsShipper_SelectionChanged(object sender, SelectionChangedEventArgs e)

{

var getResults = data.ReturnString(Convert.ToInt32(lsShipper.SelectedValue));

foreach (var item in getResults) //binding to textbox

{

txtShip.Text = item.ShipperID.ToString();

txtCompanyName.Text = item.CompanyName;

txtPhone.Text = item.Phone;

}

###DataTier

public DataTable ExcelCustomer() //SELECT USING A JOINT STATEMENT

{

var query = from qry in data.Territories

join qrys in data.Regions

on qry.RegionID equals qrys.RegionID

orderby qry.RegionID

select new

{

qry.Employees,

qry.RegionID,

qry.Region,

qrys.Territories,

qrys.RegionDescription

};

DataTable dt = new DataTable();

dt.Columns.Add("Employees");

dt.Columns.Add("RegionID");

dt.Columns.Add("Region");

dt.Columns.Add("Territories");

dt.Columns.Add("RegionDescription");

foreach (var qry in query)

{

dt.NewRow();

dt.Rows.Add(qry.Employees, qry.RegionID, qry.Region, qry.Territories, qry.RegionDescription);

}

return dt;

}

public IEnumerable<NorthClass.Shipper> ReportShip() //LOADING A LISTBOX

{

var query = from qry in data.Shippers

select qry;

return query.ToList();

}

public IEnumerable<object> strString(int Ship) //RECIEVE AND LOAD TEXTBOX

{

var query = from qry in data.Suppliers

where qry.SupplierID.Equals(Ship)

select qry;

return query.ToList();

}

}