public DishDetail GetDishById(int id)
{
using (var ctx = new ApplicationDbContext())
{
var entity =
ctx
.Dishes
.Single(e => e.DishID == id);
List <IngredientListItem> ingredientListItems = new List <IngredientListItem>();
foreach (var ingredient in entity.IngredientsInDish)
{
var potato = new IngredientListItem()
{
IngredientID = ingredient.IngredientID,
Name = ingredient.Ingredient.Name,
Type = ingredient.Ingredient.Type,
Price = ingredient.Ingredient.Price
};
ingredientListItems.Add(potato);
}
var total = PriceCalc(entity.DishID);
var dish = new DishDetail
{
DishID = entity.DishID,
Name = entity.Name,
IngredientsInDish = ingredientListItems,
TotalPrice = total
};
return(dish);
}
}
private void butAddDetail_Click(object sender, EventArgs e)
{
DishDetail dishDetail = null;
if (!textBoxPrice.Text.Equals("") || !textBoxTax.Text.Equals(""))
{
dishDetail = new DishDetail
{
availability = checkBox1.Checked,
idSize = Convert.ToByte(comboBoxSize.SelectedValue),
idKind = Convert.ToByte(comboBoxKind.SelectedValue),
price = Convert.ToDecimal(textBoxPrice.Text),
tax = Convert.ToInt32(textBoxTax.Text),
idDish = getSelectedIdx(dataGridView1, "Id")
};
data.DishDetails.InsertOnSubmit(dishDetail);
try{ data.SubmitChanges(); }catch (Exception ex) { Console.WriteLine(ex); }
loadDishDetail();
errorHide();
}
else
{
errorShow("Need PRICE and TAX!");
}
}
private void button3_Click(object sender, EventArgs e)
{
Description description;
if (!textBox1.Text.Equals(""))
{
if (textBox2.Text.Equals(""))
{
description = new Description
{
decription = "Null"
};
}
else
{
description = new Description
{
decription = textBox2.Text
};
}
data.Descriptions.InsertOnSubmit(description);
try{ data.SubmitChanges(); }catch (Exception ex) { Console.WriteLine(ex); }
Dish dish = new Dish
{
name = textBox1.Text,
idDescription = description.Id
};
data.Dishes.InsertOnSubmit(dish);
try{ data.SubmitChanges(); }catch (System.Data.SqlClient.SqlException ex) { Console.WriteLine(ex); }
DishDetail dishDetail = new DishDetail
{
availability = false,
idSize = 1,
idKind = 1,
price = 0,
tax = 0,
Dish = dish
};
data.DishDetails.InsertOnSubmit(dishDetail);
try{ data.SubmitChanges(); }catch (System.Data.SqlClient.SqlException ex) { Console.WriteLine(ex); }
loadDish();
errorHide();
}
else
{
errorShow("Dish name isEmpty!");
}
}
private void butEditDetail_Click(object sender, EventArgs e)
{
int selected = getSelectedIdx(dataGridView2, "Id");
toUpdateDetail = data.DishDetails.SingleOrDefault(x => x.Id == selected);
checkBox1.Checked = Convert.ToBoolean(toUpdateDetail.availability);
comboBoxSize.SelectedValue = toUpdateDetail.idSize;
comboBoxKind.SelectedValue = toUpdateDetail.idKind;
textBoxPrice.Text = toUpdateDetail.price.ToString();
textBoxTax.Text = toUpdateDetail.tax.ToString();
}
public int Insert(DishDetail entity, int dishID)
{
DishDetail dishDetail = new DishDetail();
dishDetail.DishID = dishID;
dishDetail.IngredientID = entity.IngredientID;
dishDetail.QuantiyOfUnit = entity.QuantiyOfUnit;
dishDetail.Status = entity.Status;
dishDetails.InsertOnSubmit(dishDetail);
db.SubmitChanges();
return(dishDetail.DishDetailID);
}
private void btnAdd_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
frmChangeQuantity frmCQ = new frmChangeQuantity();
var rowHandle = gridView1.FocusedRowHandle;
try
{
frmCQ.setIngredient(Convert.ToInt32(gridView1.GetRowCellValue(rowHandle, "IngredientID").ToString()));
}
catch
{
}
frmCQ.setTitle("Thêm Thực Phẩm");
frmCQ.ShowDialog();
if (frmCQ.DialogResult == DialogResult.OK)
{
DataConnect.DishDetail entity = new DishDetail();
entity.DishID = 0;
entity.IngredientID = frmCQ.getIngredient().IngredientID;
entity.Status = true;
entity.QuantiyOfUnit = frmCQ.getQuantity();
if (dishDetails.FindAll(x => x.IngredientID.Equals(entity.IngredientID)).Count > 0)
{
dishDetails.FindLast(x => x.IngredientID.Equals(entity.IngredientID)).QuantiyOfUnit += entity.QuantiyOfUnit;
}
else
{
dishDetails.Add(entity);
}
DishDetailViewModel entity2 = new DishDetailViewModel();
entity2.DishID = 0;
entity2.IngredientID = frmCQ.getIngredient().IngredientID;
entity2.IngredientName = frmCQ.getIngredient().Name;
entity2.Status = true;
entity2.QuantityOfUnit = frmCQ.getQuantity();
if (dishDetailViewModels.FindAll(x => x.IngredientID.Equals(entity2.IngredientID)).Count > 0)
{
dishDetailViewModels.FindLast(x => x.IngredientID.Equals(entity2.IngredientID)).QuantityOfUnit += entity2.QuantityOfUnit;
}
else
{
dishDetailViewModels.Add(entity2);
}
gcRight.DataSource = null;
gcRight.DataSource = dishDetailViewModels;
}
frmCQ.Dispose();
}
public int Insert(DishDetail entity)
{
try
{
dishDetails.InsertOnSubmit(entity);
db.SubmitChanges();
return(entity.DishDetailID);
}
catch
{
return(0);
}
}
public bool Delete(int dishDetailID)
{
try
{
DishDetail obj = dishDetails.Single(x => x.DishDetailID.Equals(dishDetailID));
dishDetails.DeleteOnSubmit(obj);
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool Update(DishDetail entity)
{
try
{
DishDetail obj = dishDetails.Single(x => x.DishDetailID.Equals(entity.DishDetailID));
obj.QuantiyOfUnit = entity.QuantiyOfUnit;
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public DishDetailBean CreateDishDetailBean(DishDetail bean)
{
this.DishDetailId = bean.DishDetailId;
this.DishId = bean.DishId;
this.DishDaoId = bean.DishDaoId;
this.Num = bean.Num;
this.IsMain = bean.IsMain;
this.Type = bean.Type;
this.CreateDatetime = bean.CreateDatetime;
this.CreateBy = bean.CreateBy;
this.Deleted = bean.Deleted;
this.Status = bean.Status;
this.UpdateDatetime = bean.UpdateDatetime;
this.UpdateBy = bean.UpdateBy;
return(this);
}
private void button2_Click(object sender, EventArgs e)
{
try
{
int selected = getSelectedIdx(dataGridView2, "Id");
DishDetail result = data.DishDetails.SingleOrDefault(x => x.Id == selected);
data.DishDetails.DeleteOnSubmit(result);
try{ data.SubmitChanges(); }catch (System.Data.SqlClient.SqlException ex) { Console.WriteLine(ex); }
}catch (Exception ex)
{
Console.WriteLine(ex);
}
loadDishDetail();
}
public DishDetail CreateDishDetail(DishDetailBean bean)
{
DishDetail beanBack = new DishDetail();
beanBack.DishDetailId = bean.DishDetailId;
beanBack.DishId = bean.DishId;
beanBack.DishDaoId = bean.DishDaoId;
beanBack.Num = bean.Num;
beanBack.IsMain = bean.IsMain;
beanBack.Type = bean.Type;
beanBack.CreateDatetime = bean.CreateDatetime;
beanBack.CreateBy = bean.CreateBy;
beanBack.Deleted = bean.Deleted;
beanBack.Status = bean.Status;
beanBack.UpdateDatetime = bean.UpdateDatetime;
beanBack.UpdateBy = bean.UpdateBy;
return(beanBack);
}
