private void load_dshd_nam()
{
HOADON_OLD_PUBLIC hd_old_public = new HOADON_OLD_PUBLIC();
hd_old_public.NAM = Nam;
dg_dshd.DataSource = hd_old_bul.load_hd_year(hd_old_public);
}
private void load_dshd_ngay()
{
HOADON_OLD_PUBLIC hd_old_public = new HOADON_OLD_PUBLIC();
hd_old_public.NGAY = Ngay;
dg_dshd.DataSource = hd_old_bul.load_hd_day(hd_old_public);
}
private void load_dshd_thang()
{
HOADON_OLD_PUBLIC hd_old_public = new HOADON_OLD_PUBLIC();
hd_old_public.THANG = Thang;
dg_dshd.DataSource = hd_old_bul.load_hd_month(hd_old_public);
}
private void TONGDOANHTHU_Load(object sender, EventArgs e)
{
txttongtien.ReadOnly = true;
groupBox2.Text = "Tổng doanh thu(VNĐ)";
if (Bngay == true)
{
trangthai = "Ngày";
load_dshd_ngay();
dinhdangluoi();
groupBoxTONGDOANHTHU.Text = "Danh sách hóa đơn theo Ngày: " + Ngay.ToString();
tinhtongtien(5);
}
else if (Bthang == true)
{
trangthai = "Tháng";
load_dshd_thang();
dinhdangluoi();
groupBoxTONGDOANHTHU.Text = "Danh sách hóa đơn theo Tháng: " + Thang.ToString();
tinhtongtien(5);
}
else if (Bnam == true)
{
trangthai = "Năm";
load_dshd_nam();
dinhdangluoi();
groupBoxTONGDOANHTHU.Text = "Danh sách hóa đơn theo Năm: " + Nam.ToString();
tinhtongtien(5);
}
else if (Timcheck == true)
{
trangthai = Tenban;
HOADON_OLD_PUBLIC hd_old_public = new HOADON_OLD_PUBLIC();
hd_old_public.Soban = Tenban;
dg_dshd.DataSource = hd_old_bul.load_timhd_old(hd_old_public);
dinhdangluoi_hd_ban();
groupBoxTONGDOANHTHU.Text = "Danh sách hóa đơn theo " + Tenban;
tinhtongtien(5);
}
else if (Checkten == true)
{
trangthai = Tenban;
HOADON_OLD_PUBLIC hd_old_public = new HOADON_OLD_PUBLIC();
hd_old_public.TENNV = Tenban;
dg_dshd.DataSource = hd_old_bul.load_timhd_old_TENNV(hd_old_public);
dinhdangluoi_hd_ban();
groupBoxTONGDOANHTHU.Text = "Danh sách hóa đơn của nhân viên: " + Tenban;
tinhtongtien(5);
}
else
{
trangthai = "Tất cả các hóa đơn";
dg_dshd.DataSource = hd_old_bul.load_hoadon_old_NOTID();
dinhdangluoi();
groupBoxTONGDOANHTHU.Text = "Danh sách tất cả các hóa đơn";
tinhtongtien(5);
}
}
public DataTable load_hd_day(HOADON_OLD_PUBLIC hd_old)
{
int parameter = 1;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@NGAY";
values[0] = hd_old.NGAY;
string sql = "LOAD_HD_DAY";
return(ketnoi.LoadDataWithParameter(sql, name, values, parameter));
}
public DataTable load_timhd_old_TENNV(HOADON_OLD_PUBLIC hd_old)
{
int paramater = 1;
string[] name = new string[paramater];
object[] values = new object[paramater];
name[0] = "@TENNV";
values[0] = hd_old.TENNV;
string sql = "TIM_HOADON_OLD_tennv";
return(ketnoi.LoadDataWithParameter(sql, name, values, paramater));
}
public int delete_hoadon_old(HOADON_OLD_PUBLIC hd_old)
{
int parameter = 1;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@IDHD_OLD";
values[0] = hd_old.IDHOADON;
string sql = "DELETE_HOADON_OLD";
return(ketnoi.Excute_Data(sql, name, values, parameter));
}
public DataTable load_hd_month(HOADON_OLD_PUBLIC hd_old)
{
int parameter = 1;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@THANG";
values[0] = hd_old.THANG;
string sql = "LOAD_HD_MONTH";
return(ketnoi.LoadDataWithParameter(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 bttimnhanvien_Click(object sender, EventArgs e)
{
checktimtennv = true;
HOADON_OLD_PUBLIC hd_old_publuc = new HOADON_OLD_PUBLIC();
hd_old_publuc.TENNV = txttennhanvien.Text;
dg_hoadon.DataSource = hoadon_old_bul.load_timhd_old_TENNV(hd_old_publuc);
cbngay.DropDownStyle = ComboBoxStyle.DropDownList;
cbngay.Enabled = false;
cbthang.DropDownStyle = ComboBoxStyle.DropDownList;
cbthang.Enabled = false;
cbnam.DropDownStyle = ComboBoxStyle.DropDownList;
cbnam.Enabled = false;
rdNgay.Checked = false;
rdThang.Checked = false;
rdNam.Checked = false;
cbngay.SelectedIndex = -1;
cbthang.SelectedIndex = -1;
cbnam.SelectedIndex = -1;
}
private void bttim_Click(object sender, EventArgs e)
{
checktim = true;
HOADON_OLD_PUBLIC hd_old_publuc = new HOADON_OLD_PUBLIC();
hd_old_publuc.Soban = "Bàn số: " + Soban.Value.ToString();
dg_hoadon.DataSource = hoadon_old_bul.load_timhd_old(hd_old_publuc);
cbngay.DropDownStyle = ComboBoxStyle.DropDownList;
cbngay.Enabled = false;
cbthang.DropDownStyle = ComboBoxStyle.DropDownList;
cbthang.Enabled = false;
cbnam.DropDownStyle = ComboBoxStyle.DropDownList;
cbnam.Enabled = false;
rdNgay.Checked = false;
rdThang.Checked = false;
rdNam.Checked = false;
cbngay.SelectedIndex = -1;
cbthang.SelectedIndex = -1;
cbnam.SelectedIndex = -1;
}
public int insert_hoadon_old(HOADON_OLD_PUBLIC hd_old)
{
int parameter = 6;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@IDHOADON";
name[1] = "@IDBAN";
name[2] = "@IDNV";
name[3] = "@NGAYLAP";
name[4] = "@TRANGTHAI";
name[5] = "@TONGTIEN";
values[0] = hd_old.IDHOADON;
values[1] = hd_old.IDBAN;
values[2] = hd_old.IDNV;
values[3] = hd_old.NGAYLAP;
values[4] = hd_old.TRANGTHAI;
values[5] = hd_old.TONGTIEN;
string sql = "INSERT_HOADON_OLD";
return(ketnoi.Excute_Data(sql, name, values, parameter));
}
public DataTable load_timhd_old_TENNV(HOADON_OLD_PUBLIC hd_old)
{
return(hd_dal_old.load_timhd_old_TENNV(hd_old));
}
public DataTable load_hd_year(HOADON_OLD_PUBLIC hd_old)
{
return(hd_dal_old.load_hd_year(hd_old));
}
public int delete_hoadon_old(HOADON_OLD_PUBLIC hd_old)
{
return(hd_dal_old.delete_hoadon_old(hd_old));
}
public int insert_hoadon_old(HOADON_OLD_PUBLIC hd_old)
{
return(hd_dal_old.insert_hoadon_old(hd_old));
}
