private void ColorizeMenu(DataGridView source)
{
GetMenu_Result item;
IQueryable <GetWishedDish_Result> liked;
IQueryable <GetWishedDish_Result> disliked;
Color color;
using (ProjetSGBDEntities context = new ProjetSGBDEntities()) {
liked = context.GetWishedDish(CurrentClient.Id, FeelingTypeLike);
disliked = context.GetWishedDish(CurrentClient.Id, FeelingTypeDislike);
foreach (DataGridViewRow row in source.Rows)
{
item = (GetMenu_Result)row.DataBoundItem;
if (liked.Where(mainCourse => mainCourse.DishId == item.DishId).Count() > 0)
{
color = Color.Green;
}
else if (disliked.Where(mainCourse => mainCourse.DishId == item.DishId).Count() > 0)
{
color = Color.Red;
}
else
{
color = Color.Black;
}
row.DefaultCellStyle.ForeColor = color;
row.DefaultCellStyle.SelectionBackColor = color;
}
}
}
private void PopulateDishWishes()
{
using (ProjetSGBDEntities context = new ProjetSGBDEntities()) {
IQueryable <GetWishedDish_Result> DishWishs = context.GetWishedDish(CurrentClient.Id, null);
dataGridViewDishWish.DataSource = DishWishs.ToList();
foreach (DataGridViewColumn column in dataGridViewDishWish.Columns)
{
column.Visible = false;
}
dataGridViewDishWish.Columns[0].Visible = true;
dataGridViewDishWish.Columns[1].Visible = true;
dataGridViewDishWish.Columns[2].Visible = true;
}
}
public void LoadDishWish(int dishId)
{
using (ProjetSGBDEntities context = new ProjetSGBDEntities()) {
CurrentDish = context.GetWishedDish(CurrentClient.Id, null).Where(dish => dish.DishId == dishId).First();
}
}