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