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