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