public static List <LU_Material> GetAllMaterials(int MaterialTypeID)
{
using (var context = new SpectrumDBContext())
{
return((from m in context.LU_Material where m.MaterialTypeID == MaterialTypeID select m).ToList());
}
}
public static List <LU_MaterialType> GetAllMaterialTypes()
{
using (var context = new SpectrumDBContext())
{
return(context.LU_MaterialType.ToList());
}
}
public static LU_Material GetAllMaterialProperies(int MaterialID)
{
using (var context = new SpectrumDBContext())
{
return((from m in context.LU_Material where m.MaterialID == MaterialID select m).SingleOrDefault());
}
}