private void btchuyen_Click(object sender, EventArgs e)
{
if (cbbanconguoi.Text == "")
{
MessageBox.Show("Không có bàn nào để chuyển.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
HOADON_PUBLIC hd_public = new HOADON_PUBLIC();
BAN_PUBLIC ban_public = new BAN_PUBLIC();
hd_public.IDBAN = int.Parse(cbmabanconguoi.Text);
int mahoadon_banconguoi = hd_bul.load_IDHD_WITH_IDBAN(hd_public);
hd_public.IDHOADON = mahoadon_banconguoi;
hd_public.IDBAN = int.Parse(cbmabantrong.Text); // mã bàn mới
hd_bul.update_hoadon_doiban(hd_public);
ban_public.IDBAN = int.Parse(cbmabanconguoi.Text); //update thành Trống
ban_public.TRANGTHAI = "Trống";
ban_bul.update_trangthaiban(ban_public);
ban_public.IDBAN = int.Parse(cbmabantrong.Text);//update thành Có người
ban_public.TRANGTHAI = "Có người";
ban_bul.update_trangthaiban(ban_public);
CHUYENBAN_Load(sender, e);
this.Close();
}
}
private void delete()
{
BAN_PUBLIC ban_public = new BAN_PUBLIC();
HOADON_PUBLIC hd_public = new HOADON_PUBLIC();
hd_public.IDBAN = int.Parse(txtmaban.Text);
ban_public.IDBAN = int.Parse(txtmaban.Text);
hd_bul.delete_hoadon_with_idban(hd_public);
ban_bul.delete_ban(ban_public);
}
private void ThanhToan_Load(object sender, EventArgs e)
{
txttongtien.ReadOnly = true;
groupBoxhd.Text = "Hóa đơn " + Tenban;
HOADON_PUBLIC hd_public = new HOADON_PUBLIC();
hd_public.IDBAN = Idban;
idhoadon = hd_bul.load_IDHD_WITH_IDBAN(hd_public);
Load_CTHD(idhoadon);
tinhtongtien();
}
public int load_IDHD_WITH_IDBAN(HOADON_PUBLIC hd_public)
{
int parameter = 1;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@IDBAN";
values[0] = hd_public.IDBAN;
string sql = "LOAD_HOADON_WITH_IDBAN";
return(ketnoi.ReturnValueIntWithParameter(sql, name, values, parameter));
}
public int delete_hoadon_with_idban(HOADON_PUBLIC hoadon_public)
{
int parameter = 1;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@IDBAN";
values[0] = hoadon_public.IDBAN;
string sql = "DELETE_HOADON_with_IDBAN";
return(ketnoi.Excute_Data(sql, name, values, parameter));
}
public int count_hoadon_ban(HOADON_PUBLIC hoadon_public)
{
int parameter = 1;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@IDBAN";
values[0] = hoadon_public.IDBAN;
string sql = "DEMSOHD_OFBAN";
return(ketnoi.ReturnValueIntWithParameter(sql, name, values, parameter));
}
public int update_hoadon_doiban(HOADON_PUBLIC hoadon_public)
{
int parameter = 2;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@IDHOADON";
name[1] = "@IDBAN";
values[0] = hoadon_public.IDHOADON;
values[1] = hoadon_public.IDBAN;
string sql = "UPDATE_HOADON_doiban";
return(ketnoi.Excute_Data(sql, name, values, parameter));
}
public int insert_hoadon(HOADON_PUBLIC hoadon_public)
{
int parameter = 4;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@IDBAN";
name[1] = "@IDNV";
name[2] = "@NGAYLAP";
name[3] = "@TRANGTHAI";
values[0] = hoadon_public.IDBAN;
values[1] = hoadon_public.IDNV;
values[2] = hoadon_public.NGAYLAP;
values[3] = hoadon_public.TRANGTHAI;
string sql = "INSERT_HOADON";
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();
}
private void btgop_Click(object sender, EventArgs e)
{
if (cbbanconguoi.Text == cbbanconguoi1.Text)
{
MessageBox.Show("Không thể gộp 2 bàn giống nhau.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
HOADON_PUBLIC hd_public = new HOADON_PUBLIC();
hd_public.IDBAN = int.Parse(cbmabanconguoi.Text);
int idhoadon = hd_bul.load_IDHD_WITH_IDBAN(hd_public);
CTHD_PUBLIC cthd_public = new CTHD_PUBLIC();
cthd_public.IDHOADON = idhoadon;
dg_cthd.DataSource = cthd_bul.load_cthd(cthd_public);
hd_public.IDBAN = int.Parse(cbmabanconguoi1.Text);
int idhoadon1 = hd_bul.load_IDHD_WITH_IDBAN(hd_public);
cthd_public.IDHOADON = idhoadon1;
for (int i = 0; i < dg_cthd.Rows.Count - 1; i++)
{
cthd_public.IDDOUONG = int.Parse(dg_cthd["IDDOUONG", i].Value.ToString());
cthd_public.SOLUONG = int.Parse(dg_cthd["SOLUONG", i].Value.ToString());
cthd_bul.insert_cthd(cthd_public); // insert cthd vào bạn nhận
}
cthd_public.IDHOADON = idhoadon; // set lại mã hóa đơn cũ
for (int j = 0; j < dg_cthd.Rows.Count - 1; j++)
{
cthd_public.IDDOUONG = int.Parse(dg_cthd["IDDOUONG", j].Value.ToString());
cthd_bul.delete_cthd(cthd_public);
}
hd_public.IDBAN = int.Parse(cbmabanconguoi.Text);
hd_bul.delete_hoadon_with_idban(hd_public);
BAN_PUBLIC ban_public = new BAN_PUBLIC();
ban_public.IDBAN = int.Parse(cbmabanconguoi.Text);
ban_public.TRANGTHAI = "Trống";
ban_bul.update_trangthaiban(ban_public);
this.Close();
}
}
void bt_click(object sender, EventArgs e)
{
idban = ((sender as Button).Tag as BAN_PUBLIC).IDBAN;
tenban = ((sender as Button).Tag as BAN_PUBLIC).TEN;
trangthaiban = ((sender as Button).Tag as BAN_PUBLIC).TRANGTHAI;
DSMON.Text = "Danh sách món ăn của " + tenban;
HOADON_PUBLIC hd_public = new HOADON_PUBLIC();
hd_public.IDBAN = idban;
int sohoadonban = hd_bul.count_hoadon_ban(hd_public);
if (sohoadonban == 0)
{
hd_public.IDNV = Idnv;// lấy từ mã từ tài khoản nhân viên đăng nhập vào
hd_public.NGAYLAP = DateTime.Now;
hd_public.TRANGTHAI = "Chưa";
hd_bul.insert_hoadon(hd_public);
taobanan();
}
idhd = hd_bul.load_IDHD_WITH_IDBAN(hd_public);
Load_CTHD(idhd);
numericsoluongdoan.Value = 1;
}
public int update_hoadon_doiban(HOADON_PUBLIC hoadon_public)
{
return(hoadon_dal.update_hoadon_doiban(hoadon_public));
}
public int load_IDHD_WITH_IDBAN(HOADON_PUBLIC hd_public)
{
return(hoadon_dal.load_IDHD_WITH_IDBAN(hd_public));
}
public int delete_hoadon_with_idban(HOADON_PUBLIC hoadon_public)
{
return(hoadon_dal.delete_hoadon_with_idban(hoadon_public));
}
public int count_hoadon_ban(HOADON_PUBLIC hoadon_public)
{
return(hoadon_dal.count_hoadon_ban(hoadon_public));
}
public int insert_hoadon(HOADON_PUBLIC hoadon_public)
{
return(hoadon_dal.insert_hoadon(hoadon_public));
}
