public static void Insert(Hoadonbanhang hd) { if (conn.State == ConnectionState.Open) conn.Close(); conn.Open(); SqlCommand sc = new SqlCommand("Hoadonbanhang_ProcInsert", conn); sc.CommandType = CommandType.StoredProcedure; sc.Parameters.Add(new SqlParameter("@Ngayviet", hd.Ngayviet)); sc.Parameters.Add(new SqlParameter("@KhachhangID", hd.KhachhangID)); sc.Parameters.Add(new SqlParameter("@NhanvienID", hd.NhanvienID)); sc.ExecuteNonQuery(); conn.Close(); }
public static int GetHoadonID(Hoadonbanhang hd) { if (conn.State == ConnectionState.Open) conn.Close(); conn.Open(); SqlCommand sc = new SqlCommand("Hoadonbanhang_ProcGetHoadonID", conn); sc.CommandType = CommandType.StoredProcedure; sc.Parameters.Add(new SqlParameter("@Ngayviet", hd.Ngayviet)); sc.Parameters.Add(new SqlParameter("@KhachhangID", hd.KhachhangID)); sc.Parameters.Add(new SqlParameter("@NhanvienID", hd.NhanvienID)); int ID = 0; SqlDataReader reader = sc.ExecuteReader(); while (reader.Read()) { ID = int.Parse(reader["HoadonbanhangID"].ToString()); } reader.Close(); conn.Close(); return ID; }
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!"); } }