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();
}
private void bbtDanhsachhdb_ItemClick(object sender, ItemClickEventArgs e)
{
Form frm = this.Kiemtratontai(typeof(Hoadonbanhang));
if (frm != null)
{
frm.Activate();
}
else
{
Hoadonbanhang hdb = new Hoadonbanhang();
hdb.MdiParent = this;
//dmk.StartPosition = FormStartPosition.CenterParent;
hdb.WindowState = FormWindowState.Maximized;
hdb.Show();
}
}
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!");
}
}
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);
}
