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