public List <string> ListProducts()
{
Console.WriteLine("List function() has been called by a client.");
List <string> productsList = new List <string>();
try
{
using (adventureworksEntities2 database = new adventureworksEntities2())
{
var products = from p in database.products
select p.ProductNumber;
productsList = productsList.ToList();
#region Alternate Solution
foreach (var p in database.products)
{
productsList.Add(p.ProductNumber);
}
#endregion
#region Create Product
/*product pr = new product();
* pr.Name = "asda";
*
* database.products.Add(pr);*/
#endregion
}
}
catch
{
}
return(productsList);
}
public ProductData GetProduct(string productNumber)
{
Console.WriteLine("GetProduct() functiion called by client.");
ProductData pr = null;
try
{
using (adventureworksEntities2 database = new adventureworksEntities2())
{
var products = from p in database.products
where p.ProductNumber == productNumber
select p;
product prod = products.FirstOrDefault();
pr = new ProductData();
pr.Name = prod.Name;
pr.ProductNumber = prod.ProductNumber;
pr.color = prod.Color;
/*Console.WriteLine(pr.Name);
* Console.WriteLine(pr.ProductNumber);
* Console.WriteLine(pr.color);*/
/*var products = from p in database.products
* select p.ProductNumber;
* productsList = productsList.ToList();*/
}
}
catch
{
}
return(pr);
}
