//public int ID { get; set; }
//public string Name { get; set; }
public static List <ComboCategory> GetCategories()
{
using (NorthwindDataContext db = new NorthwindDataContext())
{
var query = from c in db.Categories
select new ComboCategory()
{
ID = c.CategoryID, Name = c.CategoryName
};
return(query.ToList());
}
//NorthwindDataContext db = new NorthwindDataContext();
//var data = from c in db.Categories
// select c;
//List<Category> retval = new List<Category>();
//foreach (var item in data)
//{
// Category newItem = new Category
// {
// ID = item.CategoryID,
// Name = item.CategoryName
// };
// retval.Add(newItem);
//}
//return retval;
//return data.ToList();
}
public static List <Supplier> GetSuppliers()
{
using (NorthwindDataContext db = new NorthwindDataContext())
{
var data = from s in db.Suppliers
select s;
List <Supplier> retval = new List <Supplier>();
foreach (var item in data)
{
Supplier newItem = new Supplier
{
ID = item.SupplierID,
Name = item.CompanyName
};
retval.Add(newItem);
}
return(retval);
}
}
public static List <Product> GetProducts()
{
NorthwindDataContext db = new NorthwindDataContext();
var data = from p in db.Products
select p;
List <Product> retval = new List <Product>();
foreach (var item in data)
{
Product newItem = new Product
{
ID = item.ProductID,
Name = item.ProductName,
Price = item.UnitPrice ?? 0,
SupplierID = item.SupplierID
};
retval.Add(newItem);
}
return(retval);
}