public static bool AddComment(Tblcomment model) { QLNHangData.QLNhaHangContext _db = new QLNHangData.QLNhaHangContext(); try { _db.Add(model); _db.SaveChanges(); } catch (Exception ex) { return(false); } return(true); }
public static List <Tblfood> GetOrderedPriceListByTypeId(int typeId, bool isAsc) { QLNHangData.QLNhaHangContext _db = new QLNHangData.QLNhaHangContext(); if (isAsc) { return(_db.Tblfood.Where(x => x.FodcaId == typeId && x.Del == false).OrderBy(x => x.Price).ToList()); } else { return(_db.Tblfood.Where(x => x.FodcaId == typeId && x.Del == false).OrderByDescending(x => x.Price).ToList()); } }
public static List <Tblcomment> GetListByFoodId(int foodId) { QLNHangData.QLNhaHangContext _db = new QLNHangData.QLNhaHangContext(); return(_db.Tblcomment.Where(x => x.FodId == foodId).ToList()); }
public static List <Tbltablecategory> GetAllFoodType() { QLNHangData.QLNhaHangContext _db = new QLNHangData.QLNhaHangContext(); return(_db.Tbltablecategory.ToList()); }
public static List <Tblfood> GetListByName(string name) { QLNHangData.QLNhaHangContext _db = new QLNHangData.QLNhaHangContext(); return(_db.Tblfood.Where(x => x.FodName.Contains(name) && x.Del == false).ToList()); }
public static List <Tblfood> GetListByTypeId(int typeId) { QLNHangData.QLNhaHangContext _db = new QLNHangData.QLNhaHangContext(); return(_db.Tblfood.Where(x => x.FodcaId == typeId && x.Del == false).ToList()); }
public static Tblfood FindById(int id) { QLNHangData.QLNhaHangContext _db = new QLNHangData.QLNhaHangContext(); return(_db.Tblfood.FirstOrDefault(x => x.FodId == id && x.Del == false)); }