public bool Add(ComboDetail comboDetail) { string sql = @"insert into ComboDetail (ComboID, ProductID, Quantity) values (@comboid, @productid, @quantity)"; SqlCommand command = new SqlCommand { Connection = connection, CommandType = CommandType.Text, CommandText = sql }; command.Parameters.Add("@comboid", SqlDbType.NVarChar).Value = comboDetail.Combo.ID; command.Parameters.Add("@productid", SqlDbType.NVarChar).Value = comboDetail.Product.ID; command.Parameters.Add("@quantity", SqlDbType.Int).Value = comboDetail.Quantity; try { command.ExecuteNonQuery(); return(true); } catch (SqlException) { return(false); } }
public void CreateComboDetail(int comboCount) { // コンボ数表示を生成(ComboDetail クラスの持つメソッドを実行したいので、ComboDetail クラスで生成しておくことで GetComponent を実行しなくて済むようにする) ComboDetail comboDetail = Instantiate(comboDetailPrefab, comboObjTran, false); // コンボ数表示を設定したり、アニメ演出したりする処理を実行 comboDetail.SetUpComboDetail(comboCount); }
public async Task RemoveProductToComboAsync(string comboId, string productId) { ComboDetail comboDetail = new ComboDetail { ComboId = comboId, ProductId = productId, }; await _comboDetailRepository.DeleteAsync(comboDetail); }
public async Task AddProductToComboAsync(string comboId, string productId, int quantity) { ComboDetail comboDetail = new ComboDetail { ComboId = comboId, ProductId = productId, Quantity = quantity, }; await _comboDetailRepository.AddAsync(comboDetail); }
public async Task <IActionResult> UpdateComboDetail([FromBody] ComboDetail comboDetail) { try { _unitOfWork.ComboDetailRepository.Update(comboDetail); await _unitOfWork.Commit(); return(Ok(comboDetail)); } catch (Exception e) { return(BadRequest(e.Message)); } }
private void btnComboDetailAdd_Click(object sender, EventArgs e) { if (lvCombo.SelectedItems.Count == 0) { MessageBox.Show("Vui lòng chọn một trường combo"); return; } string comboid = (lvCombo.SelectedItems[0].Tag as Combo).ID; string productid = txtComboDetailProductID.Text; int quantity = (int)nmrComboDetailQuantity.Value; if (String.IsNullOrWhiteSpace(productid)) { MessageBox.Show("Mã sản phẩm không được bỏ trống"); return; } ComboDetail comboDetail = new ComboDetail { Combo = new Combo { ID = comboid }, Product = new Product { ID = productid }, Quantity = quantity }; bool result = comboDetailBUS.Add(comboDetail); if (result) { MessageBox.Show("Thêm thành công"); ShowComboDetailByComboID(comboid); txtComboDetailProductID.Text = ""; nmrComboDetailQuantity.Value = 0; } else { MessageBox.Show("Thêm thất bại: \n - Đã có mã sản phẩm trong combo\n - Mã sản phẩm không tồn tại"); } }
public ActionResult ComboDetail_Create(string CBMRowid, ViewModel_ComboDetails combodetail) { if (combodetail != null && ModelState.IsValid) { var target = new ComboDetail(); target.CBDRowid = Guid.NewGuid().ToString(); target.CBMRowid = CBMRowid; target.CBDCode = combodetail.CBDCode; target.CBDDescription = combodetail.CBDDescription; target.CBDDisplayFlag = combodetail.CBDDisplayFlag; target.CBDDisplayOrder = combodetail.CBDDisplayOrder; target.CBDLastModifiedDateTime = combodetail.CBDLastModifiedDateTime; target.CBDModifiedUserRowid = combodetail.CBDModifiedUserRowid; db.ComboDetail.Add(target); db.SaveChanges(); } return(Json(new[] { combodetail }.ToDataSourceResult(new DataSourceRequest(), ModelState))); }
private void btnComboDetailDelete_Click(object sender, EventArgs e) { if (lvComboDetail.SelectedItems.Count == 0) { MessageBox.Show("Vui lòng chọn một trường để xóa"); return; } ComboDetail comboDetail = lvComboDetail.SelectedItems[0].Tag as ComboDetail; bool result = comboDetailBUS.Delete(comboDetail.Combo.ID, comboDetail.Product.ID); if (result) { MessageBox.Show("Xóa thành công"); ShowComboDetailByComboID(comboDetail.Combo.ID); } else { MessageBox.Show("Xóa thất bại"); } }
public List <ComboDetail> GetByComboID(string comboid) { List <ComboDetail> comboDetails = new List <ComboDetail>(); string sql = @"select cd.ComboID, cd.ProductID, p.Name, cd.Quantity from ComboDetail cd, Product p where cd.ProductID = p.ID and cd.ComboID = @comboid"; SqlCommand command = new SqlCommand { Connection = connection, CommandType = CommandType.Text, CommandText = sql }; command.Parameters.Add("@comboid", SqlDbType.NVarChar).Value = comboid; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { ComboDetail comboDetail = new ComboDetail { Combo = new Combo { ID = reader.GetString(0) }, Product = new Product { ID = reader.GetString(1), Name = reader.GetString(2) }, Quantity = reader.GetInt32(3) }; comboDetails.Add(comboDetail); } reader.Close(); return(comboDetails); }
public async Task <ActionResult <ComboDetail> > CreateComboDetail(ComboDetail detail) { try { // var cmbo = new ComboDetail() // { // ComboId = detail.ComboId, // DishId = detail.DishId, // Price = detail.Price, // Qty = detail.Qty // }; await _unitOfWork.ComboDetailRepository.InsertTask(detail); await _unitOfWork.Commit(); return(detail); } catch (Exception e) { return(BadRequest(e.Message)); } }
public ActionResult ComboDetail_Destroy([DataSourceRequest] DataSourceRequest request, ComboDetail combodetail) { if (ModelState.IsValid) { var entity = new ComboDetail { CBDRowid = combodetail.CBDRowid, CBMRowid = combodetail.CBMRowid, CBDCode = combodetail.CBDCode, CBDDescription = combodetail.CBDDescription, CBDDisplayFlag = combodetail.CBDDisplayFlag, CBDDisplayOrder = combodetail.CBDDisplayOrder, CBDLastModifiedDateTime = combodetail.CBDLastModifiedDateTime, CBDModifiedUserRowid = combodetail.CBDModifiedUserRowid }; db.ComboDetail.Attach(entity); db.ComboDetail.Remove(entity); db.SaveChanges(); } return(Json(new[] { combodetail }.ToDataSourceResult(request, ModelState))); }
public bool Add(ComboDetail comboDetail) { return(dao.Add(comboDetail)); }
public void create(ComboDetail comboDetail) { sellingComponentsDBContext.Add(comboDetail); sellingComponentsDBContext.SaveChanges(); }