/// <summary> /// maj article /// </summary></returns> /// <returns>indique si l action a reussi public static bool UpdateArticle(Article ArticleToUpdate) { bool ok; using (BDDRestaurantEntities bdd = new BDDRestaurantEntities()) { try { //maj de l'atrticle ds l entitee Article unArticle = bdd.Article.Where(x => x.idArticle == ArticleToUpdate.idArticle).FirstOrDefault(); unArticle.designationArticle = ArticleToUpdate.designationArticle; unArticle.prixArticle = ArticleToUpdate.prixArticle; unArticle.photoArticle = ArticleToUpdate.photoArticle; unArticle.idCatArticle = ArticleToUpdate.idCatArticle; //save les modifs dans la base bdd.SaveChanges(); ok = true; } catch (Exception) { ok = false; } } return(ok); }
/// <summary> /// maj CategorieArticle /// </summary></returns> /// <returns>indique si l action a reussi public static bool UpdateCategorieArticle(CategorieArticle CategorieArticleToUpdate) { bool ok; using (BDDRestaurantEntities Bdd = new BDDRestaurantEntities()) { try { //maj du user ds l entitee CategorieArticle unArticle = Bdd.CategorieArticle.Where(x => x.idCatArticle == CategorieArticleToUpdate.idCatArticle).FirstOrDefault(); unArticle.idCatArticle = CategorieArticleToUpdate.idCatArticle; unArticle.libelleCatArticle = CategorieArticleToUpdate.libelleCatArticle; //save les modifs dans la base Bdd.SaveChanges(); ok = true; } catch (Exception) { ok = false; } } return(ok); }
/// <summary> /// maj Table /// </summary> /// <returns>indique si l action a reussi</returns> public static bool UpdateTablee(Tablee TableeToUpdate) { bool ok; using (BDDRestaurantEntities bdd = new BDDRestaurantEntities()) { try { //maj de l'atrticle ds l entitee Tablee unTablee = bdd.Tablee.Where(x => x.numTablee == TableeToUpdate.numTablee).FirstOrDefault(); unTablee.numTablee = TableeToUpdate.numTablee; unTablee.nbPlaceTablee = TableeToUpdate.nbPlaceTablee; //save les modifs dans la base bdd.SaveChanges(); ok = true; } catch (Exception) { ok = false; } } return(ok); }
/// <summary> /// maj Table /// </summary> /// <returns>indique si l action a reussi</returns> public static bool UpdateCommande(Commande CommandeToUpdate) { bool ok; using (BDDRestaurantEntities bdd = new BDDRestaurantEntities()) { try { //maj de l'atrticle ds l entitee Commande unCommande = bdd.Commande.Where(x => x.numCommande == CommandeToUpdate.numCommande).FirstOrDefault(); unCommande.dateHeureCommance = CommandeToUpdate.dateHeureCommance; unCommande.numTablee = CommandeToUpdate.numTablee; unCommande.idServeur = CommandeToUpdate.idServeur; unCommande.termine = CommandeToUpdate.termine; //save les modifs dans la base bdd.SaveChanges(); ok = true; } catch (Exception) { ok = false; } } return(ok); }
public static List <CategorieArticle> GetCategoriePlats() { List <CategorieArticle> DesCategorieArticles; using (BDDRestaurantEntities Bdd = new BDDRestaurantEntities()) try { DesCategorieArticles = Bdd.CategorieArticle.Where(x => x.idCatArticle != 0).ToList(); } catch (Exception) { DesCategorieArticles = new List <CategorieArticle>(); } return(DesCategorieArticles); }
internal static List <Article> GetArticleByCateg(int idCat) { List <Article> DesArticles; using (BDDRestaurantEntities bdd = new BDDRestaurantEntities()) { try { DesArticles = bdd.Article.Where(x => x.idCatArticle == idCat).ToList(); } catch (Exception) { DesArticles = new List <Article>(); } } return(DesArticles); }
/// <summary> /// recup un Table a partir de son numéro /// </summary> /// <param name="unIDTablee">id de la Table recherché</param> /// <returns></returns> public static Tablee GetInstance(int unIdTablee) { Tablee unTablee; using (BDDRestaurantEntities bdd = new BDDRestaurantEntities()) { try { unTablee = bdd.Tablee.Where(x => x.numTablee == unIdTablee).FirstOrDefault(); } catch (Exception) { unTablee = new Tablee(); } } return(unTablee); }
/// <summary> /// recup un Table a partir de son numéro /// </summary> /// <param name="unIDCommande">id de la Table recherché</param> /// <returns></returns> public static Commande GetInstance(int unIdCommande) { Commande unCommande; using (BDDRestaurantEntities bdd = new BDDRestaurantEntities()) { try { unCommande = bdd.Commande.Where(x => x.numCommande == unIdCommande).FirstOrDefault(); } catch (Exception) { unCommande = new Commande(); } } return(unCommande); }
/// <summary> /// recup la liste des Commande /// </summary> /// <returns>la liste des Table qu on recherche et si il existe pas une liste vide</returns> public static List <Commande> GetCommande() { List <Commande> DesCommandes; using (BDDRestaurantEntities bdd = new BDDRestaurantEntities()) { try { DesCommandes = bdd.Commande.ToList(); } catch (Exception) { DesCommandes = new List <Commande>(); } } return(DesCommandes); }
/// <summary> /// recup la liste des article /// </summary> /// <returns>la liste des articles qu on recherche et si il existe pas une liste vide</returns> public static List <Article> GetArticle() { List <Article> DesArticles; using (BDDRestaurantEntities bdd = new BDDRestaurantEntities()) { try { DesArticles = bdd.Article.ToList(); } catch (Exception) { DesArticles = new List <Article>(); } } return(DesArticles); }
/// <summary> /// recup un article a partir de son identifiant /// </summary> /// <param name="unIDarticle">id de l'article recherché</param> /// <returns>user qu on recherche et si il existe pas un nouveau article</returns> public static Article GetInstance(int unIdArticle) { Article unArticle; using (BDDRestaurantEntities bdd = new BDDRestaurantEntities()) { try { unArticle = bdd.Article.Where(x => x.idArticle == unIdArticle).FirstOrDefault(); } catch (Exception) { unArticle = new Article(); } } return(unArticle); }
/// <summary> /// recup la liste des Tablee /// </summary> /// <returns>la liste des Table qu on recherche et si il existe pas une liste vide</returns> public static List <Tablee> GetTablee() { List <Tablee> DesTablees; using (BDDRestaurantEntities bdd = new BDDRestaurantEntities()) { try { DesTablees = bdd.Tablee.ToList(); } catch (Exception) { DesTablees = new List <Tablee>(); } } return(DesTablees); }
/// <summary> /// recup une catarticle a partir de son id /// </summary> /// <returns>catArticle qu on recherche et si il existe pas un nv catarticle0</returns> public static CategorieArticle GetInstance(int unIdCatArticle) { CategorieArticle uneCategorieArticle; using (BDDRestaurantEntities Bdd = new BDDRestaurantEntities()) { try { //select * from daluser where daluserid=iduser; uneCategorieArticle = Bdd.CategorieArticle.Where(x => x.idCatArticle == unIdCatArticle).FirstOrDefault(); } catch (Exception) { uneCategorieArticle = new CategorieArticle(); } } return(uneCategorieArticle); }
/// <summary> /// recup la liste des CategorieArticle /// </summary> /// <returns>la liste des CategorieArticle qu on recherche et si il existe pas une liste vide</returns> public static List <CategorieArticle> GetCategorieArticle() { List <CategorieArticle> DesCategorieArticles; using (BDDRestaurantEntities Bdd = new BDDRestaurantEntities()) { try { //select * from daluser where Article=iduser; DesCategorieArticles = Bdd.CategorieArticle.ToList(); } catch (Exception) { DesCategorieArticles = new List <CategorieArticle>(); } } return(DesCategorieArticles); }
/// <summary> /// ajoute une Table /// </summary> /// <param name="user"></param> /// <returns></returns> public static bool AddCommande(Commande Commande) { bool ok; using (BDDRestaurantEntities bdd = new BDDRestaurantEntities()) { try { //ajoute le user a l entitee bdd.Commande.Add(Commande); //save les modifs dans la base bdd.SaveChanges(); ok = true; } catch (Exception) { ok = false; } } return(ok); }
/// <summary> /// supp l Table /// </summary> /// <returns>indique si l action a reussi</returns> public static bool TermineCommande(Commande CommandeToTermine) { bool ok; using (BDDRestaurantEntities bdd = new BDDRestaurantEntities()) { try { //maj de l'Commande ds l entitee Commande unCommande = bdd.Commande.Where(x => x.numCommande == CommandeToTermine.numCommande).FirstOrDefault(); unCommande.termine = CommandeToTermine.termine; //save les modifs dans la base bdd.SaveChanges(); ok = true; } catch (Exception) { ok = false; } } return(ok); }
/// <summary> /// ajoute un CategorieArticle /// </summary> public static bool AddCategorieArticle(CategorieArticle categorieArticle) { bool ok; using (BDDRestaurantEntities Bdd = new BDDRestaurantEntities()) { try { //ajoute le categorieArticle a l entitee Bdd.CategorieArticle.Add(categorieArticle); //.AddObject(categorieArticle); //save les modifs dans la base Bdd.SaveChanges(); ok = true; } catch (Exception) { ok = false; } } return(ok); }
/// <summary> /// supp l article /// </summary></returns> /// <returns>indique si l action a reussi public static bool DeleteArticle(Article ArticleToDelete) { bool ok; using (BDDRestaurantEntities bdd = new BDDRestaurantEntities()) { try { //maj de l'article ds l entitee Article unArticle = bdd.Article.Where(x => x.idArticle == ArticleToDelete.idArticle).FirstOrDefault(); bdd.Article.Remove(unArticle); //save les modifs dans la base bdd.SaveChanges(); ok = true; } catch (Exception) { ok = false; } } return(ok); }