public static void Insert(ChitietHDBH ct)
{
if (conn.State == ConnectionState.Open) conn.Close();
conn.Open();
SqlCommand sc = new SqlCommand("CTHoadonbanhang_ProcInsert", conn);
sc.CommandType = CommandType.StoredProcedure;
sc.Parameters.Add(new SqlParameter("@HoadonbanhangID", ct.HoadonbanhangID));
sc.Parameters.Add(new SqlParameter("@SanphamID", ct.SanphamID));
sc.Parameters.Add(new SqlParameter("@Soluong", ct.Soluong));
sc.Parameters.Add(new SqlParameter("@Dongia", ct.Dongia));
sc.ExecuteNonQuery();
conn.Close();
}
private void button1_Click(object sender, EventArgs e)
{
DialogResult dialog = MessageBox.Show("Bạn muốn thanh toán?","Thông báo",MessageBoxButtons.OKCancel,MessageBoxIcon.Question);
if (dialog == DialogResult.OK)
{
Hoadonbanhang hd = new Hoadonbanhang();
//hd.NhanvienID = Global.MaNV;
hd.Ngayviet = DateTime.Now;
hd.KhachhangID = (textBox1.Text==null||textBox1.Text==""?1:int.Parse(textBox1.Text));
HoadonbanhangController.Insert(hd);
int HoadonID = HoadonbanhangController.GetHoadonID(hd);
foreach (ListViewItem item in listView1.Items)
{
ChitietHDBH ct = new ChitietHDBH();
ct.HoadonbanhangID = HoadonID;
ct.SanphamID = int.Parse(item.Text);
ct.Soluong = int.Parse(item.SubItems[2].Text);
ct.Dongia = double.Parse(item.SubItems[3].Text);
ChitietHDBHController.Insert(ct);
}
MessageBox.Show("Thanh toán thành công!");
}
}
