public static MonAnViewModel FindFood(string maMonAn)
{
QUANLYQUANANEntities entities = new QUANLYQUANANEntities();
var res = entities.MONANs.FirstOrDefault(t => t.MAMONAN == maMonAn);
if (res != null)
{
return(new MonAnViewModel()
{
Anh = res.HINHANH,
Ten = res.TENMONAN,
MoTa = res.MOTA,
Ma = res.MAMONAN
});
}
return(null);
}
public static List <BookedFoodViewModel> GetBookedFoods(string idFood)
{
QUANLYQUANANEntities entities = new QUANLYQUANANEntities();
List <BookedFoodViewModel> lst = new List <BookedFoodViewModel>();
var result = entities.InHoaDon(idFood).ToList();
if (result.Count > 0)
{
foreach (var item in result)
{
lst.Add(new BookedFoodViewModel()
{
ID = item.MAMONAN,
Quantity = item.SoLuongDat
});
}
}
return(lst);
}
public static List <string> FindListHoaDon(string idFood)
{
QUANLYQUANANEntities entity = new QUANLYQUANANEntities();
try
{
var result = (from ct in entity.CHITIETHOADONs
where ct.MAMONAN == idFood
group new { ct } by new { ct.MAHD } into grp
select grp.Key.MAHD
);
return(result.ToList());
}
catch (Exception)
{
entity.Dispose();
return(null);
}
}
public static List <BookedFoodViewModel> GetChoosingFoods(CartViewModel cart)
{
QUANLYQUANANEntities entities = new QUANLYQUANANEntities();
var foods = entities.MONANs.Select(t => t.MAMONAN).ToList().OrderBy(t => t);
List <BookedFoodViewModel> res = new List <BookedFoodViewModel>();
BookedFoodViewModel food;
if (cart == null)
{
foreach (var item in foods)
{
food = new BookedFoodViewModel()
{
ID = item, Quantity = 0
};
res.Add(food);
}
}
else
{
foreach (var item in foods)
{
var choosenFood = cart.Foods.FirstOrDefault(t => t.ID == item);
if (choosenFood != null)
{
food = new BookedFoodViewModel()
{
ID = item, Quantity = choosenFood.Quantity
};
}
else
{
food = new BookedFoodViewModel()
{
ID = item, Quantity = 0
};
}
res.Add(food);
}
}
return(res);
}
public static List <MonAnViewModel> LoadMonAn()
{
QUANLYQUANANEntities entities = new QUANLYQUANANEntities();
try
{
var res = (from m in entities.MONANs
select new MonAnViewModel()
{
Ma = m.MAMONAN,
Anh = m.HINHANH,
Ten = m.TENMONAN,
}).ToList();
return(res);
}
catch (Exception)
{
entities.Dispose();
return(null);
}
}
