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));
}
