private void btnFindCommodity_Click(object sender, RoutedEventArgs e)
{
// Initialize the context and the binding collection
context = new TopCarrotEntities(topCarrotDataUri);
context.SendingRequest += new EventHandler<SendingRequestEventArgs>(context_SendingRequest);
commodityPluCodes = new DataServiceCollection<CommodityPluCode>(context);
//Show the progress bar
pageIndicators.ShowProgress(this);
if (UserInputUtilities.IsPluCode(txtCommodityToFind.Text))
{
txtblkInstructions.Text = "By PLU code entered";
SearchQuery = from CommodityPluCode PluData in context.CommodityPluCodes
where PluData.PLU == txtCommodityToFind.Text.ToString()
select PluData;
}
if (UserInputUtilities.IsCropNumber(txtCommodityToFind.Text))
{
txtblkInstructions.Text = "By crop ID entered";
SearchQuery = from CommodityPluCode PluData in context.CommodityPluCodes
where PluData.Commodity == txtCommodityToFind.Text.ToUpper()
select PluData;
}
else
{
txtblkInstructions.Text = "By commondity name entered";
SearchQuery = from CommodityPluCode PluData in context.CommodityPluCodes
where PluData.Commodity == txtCommodityToFind.Text.ToUpper()
select PluData;
}
// Register for the LoadCompleted event.
commodityPluCodes.LoadCompleted
+= new EventHandler<LoadCompletedEventArgs>(commodityPluCodes_LoadCompleted);
// Load the customers feed by executing the LINQ query.
commodityPluCodes.LoadAsync(SearchQuery);
}
/// <summary>
/// Gets the details of the PLU or commodity that was selected on the Search By page
/// </summary>
/// <param name="PluId">The PLUID from the SQL table which is the same as the table ID</param>
private void GetDetailInformation(int PluId)
{
// Initialize the context and the binding collection
context = new TopCarrotEntities(topCarrotDataUri);
commodityPluCodes = new DataServiceCollection<CommodityPluCode>(context);
// Define a LINQ query that returns all customers.
var query = from CommodityPluCode PluData in context.CommodityPluCodes
where PluData.PLUId == PluId
select PluData;
// Register for the LoadCompleted event.
commodityPluCodes.LoadCompleted
+= new EventHandler<LoadCompletedEventArgs>(commodityPluCodes_LoadCompleted);
// Load the customers feed by executing the LINQ query.
commodityPluCodes.LoadAsync(query);
}
