public static List <CUSTOMER> selectAllCustomers()
{
List <CUSTOMER> lista = new List <CUSTOMER>();
using (var testEntities = new TestEntities())
{
var customers = from c in testEntities.CUSTOMER select c;
foreach (var cu in customers)
{
lista.Add(cu);
}
}
return(lista);
}
public static List <ORDER> selectOrdersC(Int16 cId)
{
List <ORDER> lista = new List <ORDER>();
using (var testEntities = new TestEntities())
{
var orders = from o in testEntities.ORDER where o.CUSTOMERID == cId select o;
foreach (var or in orders)
{
lista.Add(or);
}
}
return(lista);
}
public static CUSTOMER selectCUSTOMER(Int16 id)
{
using (var testEntities = new TestEntities())
{
var cost = from c in testEntities.CUSTOMER where c.CUSTOMERID == id select c;
if (cost.Count() > 0)
{
return(cost.First());
}
else
{
return(null);
}
}
}
