public static List <Piece> getPieces()
{
using (var db = new CommandeContext())
{
return(db.Pieces.ToList());
}
}
public static Piece getPieceByName(string name)
{
using (var db = new CommandeContext())
{
return(db.Pieces
.Where(p => p.Nom == name)
.FirstOrDefault());
}
}
public static List <Commande> getCommandes()
{
using (var db = new CommandeContext())
{
return(db.Commandes
.Include(c => c.LignesCommande.Select(lc => lc.Piece))
.ToList());
}
}
//public static List<LigneCommande> getLignesCommandeByCommande(Commande c)
//{
// using (var db = new CommandeContext())
// {
// return db.LignesCommande
// .Where(lc => lc.Commande == c)
// .Include("Piece")
// .ToList();
// }
//}
public static Commande getCommande(int id)
{
using (var db = new CommandeContext())
{
return(db.Commandes
.Where(c => c.Id == id)
.Include(c => c.LignesCommande.Select(lc => lc.Piece))
.SingleOrDefault());
}
}
public static T insertObject <T>(T obj) where T : Model
{
using (var db = new CommandeContext())
{
var table = db.Set(obj.GetType());
//if(obj.GetType() == typeof(LigneCommande) )
//{
// // use the following statement so that City won't be inserted
// db.Entry(obj.Commande).State = EntityState.Unchanged;
//}
table.Add(obj);
db.SaveChanges();
return(obj);
}
}
public static LigneCommande insertLigneCommande(LigneCommande obj)
{
using (var db = new CommandeContext())
{
var table = db.Set(typeof(LigneCommande));
try
{
db.Entry(obj.Commande).State = EntityState.Unchanged;
db.Entry(obj.Piece).State = EntityState.Unchanged;
} catch (Exception e)
{
}
table.Add(obj);
db.SaveChanges();
return(obj);
}
}
public static T updateObject <T>(T obj) where T : Model
{
using (var db = new CommandeContext())
{
var table = db.Set(obj.GetType());
var original = table.Find(obj.Id);
if (original != null)
{
db.Entry(original).CurrentValues.SetValues(obj);
db.SaveChanges();
return(obj);
}
return(null);
}
}
