public string InsertList(List <PreOrderItem> items)
{
int result = 0;
try
{
using (var context = new ProyectoMaestriaEntities())
{
foreach (PreOrderItem poi in items)
{
var std = new PreOrderItem
{
// ID=poi.ID,
IDProduct = poi.IDProduct,
IDPreOrder = poi.IDPreOrder,
Quantity = poi.Quantity
};
context.PreOrderItem.Add(std);
result = context.SaveChanges();
if (result == 0)
{
return("no se ha podido ingresar el registro");
}
else
{
result = int.Parse(std.ID.ToString());
}
}
return(result.ToString());
}
}
catch (Exception e)
{
return(e.Message);
}
}
public List <PreOrderItem> GetByOrder(long Preorder)
{
List <PreOrderItem> ingredients = new List <PreOrderItem>();
using (var context = new ProyectoMaestriaEntities())
{
// Query for all blogs with names starting with B
//var ComedorExtracted = from b in context.Comedor
// where b.ID.Equals(id)
// select b;
var repetido = context.PreOrderItem.Where(x => x.IDPreOrder == Preorder);
foreach (PreOrderItem ing in repetido)
{
PreOrderItem ingr = new PreOrderItem();
ingr.ID = ing.ID;
ingr.IDPreOrder = ing.IDPreOrder;
ingr.IDProduct = ing.IDProduct;
ingr.Quantity = ing.Quantity;
ingredients.Add(ingr);
}
return(ingredients);
}
}
