private void CTHD_OLD_Load(object sender, EventArgs e)
{
groupBox1.Text = "Chi tiết của mã hóa đơn: " + mahoadon_old.ToString();
CTHD_OLD_PUBLIC cthd_old_public = new CTHD_OLD_PUBLIC();
cthd_old_public.IDHOADON_OLD = mahoadon_old;
dg_chtd_old.DataSource = cthd_old_bul.load_cthd_old_printer(cthd_old_public);
dinhdangluoi();
rttongtien.ReadOnly = true;
tinhtongtien();
}
public int delete_cthd_old(CTHD_OLD_PUBLIC cthd_old)
{
int parameter = 2;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@IDHD_OLD";
values[0] = cthd_old.IDHOADON_OLD;
string sql = "DELETE_CTHD_OLD";
return(ketnoi.Excute_Data(sql, name, values, parameter));
}
public DataTable load_cthd_old_printer(CTHD_OLD_PUBLIC cthd_old)
{
int parameter = 1;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@IDHD_OLD";
values[0] = cthd_old.IDHOADON_OLD;
string sql = "LOAD_CTHD_OLD_PRINTER";
return(ketnoi.LoadDataWithParameter(sql, name, values, parameter));
}
public int insert_cthd_old(CTHD_OLD_PUBLIC cthd_old)
{
int parameter = 3;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@IDHD_OLD";
name[1] = "@IDDOUONG";
name[2] = "@SOLUONG";
values[0] = cthd_old.IDHOADON_OLD;
values[1] = cthd_old.IDDOUONG;
values[2] = cthd_old.SOLUONG;
string sql = "INSERT_CTHD_OLD";
return(ketnoi.Excute_Data(sql, name, values, parameter));
}
private void btthanhtoan_Click(object sender, EventArgs e)
{
HOADON_OLD_PUBLIC hd_old_public = new HOADON_OLD_PUBLIC();
hd_old_public.IDHOADON = idhoadon;
hd_old_public.IDBAN = Idban;
hd_old_public.IDNV = Idnv;
hd_old_public.NGAYLAP = DateTime.Now;
hd_old_public.TRANGTHAI = "Rồi";
hd_old_public.TONGTIEN = double.Parse(txttongtien.Text);
hd_old_bul.insert_hoadon_old(hd_old_public);
CTHD_OLD_PUBLIC cthd_old_public = new CTHD_OLD_PUBLIC();
for (int i = 0; i < dg_monan_ofban.Rows.Count - 1; i++)
{
cthd_old_public.IDHOADON_OLD = idhoadon;
cthd_old_public.IDDOUONG = int.Parse(dg_monan_ofban[0, i].Value.ToString());
cthd_old_public.SOLUONG = int.Parse(dg_monan_ofban[2, i].Value.ToString());
cthd_old_bul.insert_cthd_old(cthd_old_public);
}
// delete CTHD
CTHD_PUBLIC cthd_public = new CTHD_PUBLIC();
for (int j = 0; j < dg_monan_ofban.Rows.Count - 1; j++)
{
cthd_public.IDHOADON = idhoadon;
cthd_public.IDDOUONG = int.Parse(dg_monan_ofban[0, j].Value.ToString());
cthd_bul.delete_cthd(cthd_public);
}
HOADON_PUBLIC hd_public = new HOADON_PUBLIC();
hd_public.IDHOADON = idhoadon;
hd_bul.delete_hoadon(hd_public);
// update trạng thái bàn
BAN_PUBLIC ban_public = new BAN_PUBLIC();
ban_public.IDBAN = idban;
ban_public.TRANGTHAI = "Trống";
ban_bul.update_trangthaiban(ban_public);
inhoadon();
this.Close();
}
public int delete_cthd_old(CTHD_OLD_PUBLIC cthd_old)
{
return(cthd_old_dal.delete_cthd_old(cthd_old));
}
public int insert_cthd_old(CTHD_OLD_PUBLIC cthd_old)
{
return(cthd_old_dal.insert_cthd_old(cthd_old));
}
public DataTable load_cthd_old_printer(CTHD_OLD_PUBLIC cthd_old)
{
return(cthd_old_dal.load_cthd_old_printer(cthd_old));
}
