private void guna2Button1_Click(object sender, EventArgs e)
{
string idImport = txtIdImportDetail.Text;
string idUser = txtIdUserImportDetail.Text.Substring(0, 10);
string idOrder = txtIdOrderinImportDetail.Text;
string idPackage = txtIdPackage.Text;
string totalPrice = txtTotalPriceImport.Text;
var rowCount = dataGridImportDetail.RowCount;
if (rowCount > 0)
{
ImportDTO import = new ImportDTO(idImport, idOrder, idPackage, totalPrice, idUser);
var i = Ibus.AddImport(import);
List <ImportDetailDTO> listImport = new List <ImportDetailDTO>();
for (int index = 0; index < dataGridImportDetail.RowCount; index++)
{
DataGridViewRow row = this.dataGridImportDetail.Rows[index];
ImportDetailDTO importDetailDTO = new ImportDetailDTO();
importDetailDTO.IdImport = idImport;
importDetailDTO.IdProduct = row.Cells[0].Value.ToString();
importDetailDTO.amount = row.Cells[1].Value.ToString();
importDetailDTO.idUnit = row.Cells[2].Value.ToString();
importDetailDTO.idSuplier = row.Cells[3].Value.ToString();
importDetailDTO.price = row.Cells[4].Value.ToString();
importDetailDTO.intoPrice = row.Cells[5].Value.ToString();
DateTime oDate = Convert.ToDateTime(row.Cells[6].Value.ToString());
importDetailDTO.expired = oDate;
listImport.Add(importDetailDTO);
}
var result = Ibus.AddImportDetail(listImport);
if (result == 1 && i == 1)
{
var confimrOrder = Obus.ComfirmOrder(idOrder);
MessageBox.Show("Tạo chi tiết nhập hàng thành công", "Kho", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Tạo chi tiết nhập hàng thất bại", "Kho", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
public int AddImportDetail(List <ImportDetailDTO> listImportDetailDTO)
{
int result = 1;
SqlCommand cmd;
for (int index = 0; index < listImportDetailDTO.Count; index++)
{
ImportDetailDTO importDetail = new ImportDetailDTO();
importDetail.IdImport = listImportDetailDTO[index].IdImport;
importDetail.IdProduct = listImportDetailDTO[index].IdProduct;
importDetail.amount = listImportDetailDTO[index].amount;
importDetail.idUnit = listImportDetailDTO[index].idUnit;
importDetail.idSuplier = listImportDetailDTO[index].idSuplier;
importDetail.price = listImportDetailDTO[index].price;
importDetail.intoPrice = listImportDetailDTO[index].intoPrice;
importDetail.expired = listImportDetailDTO[index].expired;
cmd = new SqlCommand("USP_INSERT_IMPORTDETAIL", _conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@nvcIdImportProduct", importDetail.IdImport);
cmd.Parameters.AddWithValue("@nvcIdProduct", importDetail.IdProduct);
cmd.Parameters.AddWithValue("@nvcAmount", importDetail.amount);
cmd.Parameters.AddWithValue("@nvcUnitPrice", importDetail.price);
cmd.Parameters.AddWithValue("@nvcIntoPrice", importDetail.intoPrice);
cmd.Parameters.AddWithValue("@nvcExpDate", importDetail.expired);
cmd.Parameters.AddWithValue("@nvcIdUnit", importDetail.idUnit);
cmd.Parameters.AddWithValue("@nvcIdSuplier", importDetail.idSuplier);
_conn.Open();
int check = cmd.ExecuteNonQuery();
if (check != 1)
{
result = check;
break;
}
_conn.Close();
}
return(result);
}
