public int AddDeliveryBillDetail(DtoDeliveryBillDetail data)
{
SqlParameter[] para =
{
new SqlParameter("@MaChiTietPhieuXuatKho", data.MaChiTietPhieuXuatKho),
new SqlParameter("@MaPhieuXuatKho", data.MaPhieuXuatKho),
new SqlParameter("@MaSanPham", data.MaSanPham),
new SqlParameter("@SoLuong", data.SoLuong),
new SqlParameter("@GhiChu", data.GhiChu),
};
try
{
return SqlHelper.ExecuteNonQuery(Constants.ConnectionString, CommandType.StoredProcedure,
"AddDeliveryBillDetail",
para);
}
catch (SqlException)
{
throw new ArgumentException(Constants.MsgExceptionSql);
}
catch (Exception)
{
throw new AggregateException(Constants.MsgExceptionError);
}
}
private void btnThem_Click(object sender, EventArgs e)
{
List<DtoDeliveryBillDetail> list = new List<DtoDeliveryBillDetail>();
DtoDeliveryBill DeliveryBill = new DtoDeliveryBill();
DeliveryBill.MaPhieuXuatKho = txtMaPhieuXuatKho.Text;
DeliveryBill.NgayLapPhieu = DateTime.Now;
DeliveryBill.MaNguoiNhan = maNguoiNhanComboBox.SelectedValue.ToString();
DeliveryBill.MaNguoiLapPhieu = nguoiLapPhieuComboBox.SelectedValue.ToString();
DeliveryBill.GhiChu = txtGhiChu.Text;
for (int i = 0; i < dgvDetailDeliveryBill.Rows.Count - 1; i++)
{
DtoDeliveryBillDetail detail = new DtoDeliveryBillDetail();
detail.MaChiTietPhieuXuatKho = dgvDetailDeliveryBill.Rows[i].Cells[0].Value.ToString();
detail.MaPhieuXuatKho = DeliveryBill.MaPhieuXuatKho;
detail.MaSanPham = dgvDetailDeliveryBill.Rows[i].Cells[1].Value.ToString();
detail.SoLuong = int.Parse(dgvDetailDeliveryBill.Rows[i].Cells[3].Value.ToString());
detail.GhiChu = dgvDetailDeliveryBill.Rows[i].Cells[4].Value.ToString();
list.Add(detail);
}
if (_bllDeliveryBill.AddDeliveryBillTran(DeliveryBill, list))
{
MessageBox.Show(Constants.MsgNotificationSuccessfuly);
btnThoat.PerformClick();
}
else
{
MessageBox.Show(Constants.MsgExceptionError);
}
}