public void LoadBanAn()
{
BanHang.Model.Load load = new Model.Load();
DataTable dt = load.LoadBanAn();
comboTree1.DataSource = dt;
comboTree1.ValueMember = "MaBan";
}
private void SuaBan_Load(object sender, EventArgs e)
{
BanHang.Model.Load load = new Model.Load();
DataTable dt = load.LoadKhuVucTheoMaKhuVuc(MaKhuVuc);
lblKhuVuc.Text = dt.Rows[0][1].ToString();
DataTable dt1 = load.LoadBanAnTheoMaBan(MaBan);
textBoxX1.Text = dt1.Rows[0][1].ToString();
}
private void SuaKhuVuc_Load(object sender, EventArgs e)
{
BanHang.Model.Load load = new Model.Load();
DataTable dt = load.LoadKhuVuc();
comboTree1.DataSource = dt;
comboTree1.DisplayMembers = "TenKhuVuc";
comboTree1.ValueMember = "MaKhuVuc";
}
private void buttonX1_Click(object sender, EventArgs e)
{
int MaBanTiep = Convert.ToInt32(comboTree1.SelectedValue.ToString());
HoaDon.model.Load load1 = new HoaDon.model.Load();
DataTable dt1 = load1.LoadHoaDonChuaThanhToanCanChon(MaBanTiep);
if (dt1.Rows.Count == 0)
{
BanHang.Model.Load load = new Model.Load();
DataTable dt = load.LoadBanAnTheoMaBan(MaBanTiep);
string Ten = dt.Rows[0][1].ToString();
BanHang.Model.Update update = new Model.Update();
update.UpdateChuyenBanAn(MaBanAn, MaBanTiep, Ten);
this.Close();
}
else
{
MessageBox.Show("Bàn đã có người ngồi");
}
}
private void btnTKTT_Click(object sender, EventArgs e)
{
BanHang.Model.Load load = new BanHang.Model.Load();
DataTable dt = new DataTable();
dt = load.LoadHoaDonBanHangThongKe(dateTimeInputThongKeTuNgay.Value, dateTimeInputThongKeDenNgay.Value);
CrystalReportThongKeDoanhThuTheoThang cry = new CrystalReportThongKeDoanhThuTheoThang();
cry.SetDataSource(dt);
crystalReportViewer1.ReportSource = cry;
crystalReportViewer1.Refresh();
}
public DataTable LoadListBanAnTheoKhuVuc(int MaKhuVuc)
{
BanHang.Model.Load load = new BanHang.Model.Load();
return load.LoadBanAn(MaKhuVuc);
}
public void LoadHoaDonBanHang()
{
BanHang.Model.Load load = new BanHang.Model.Load();
DataTable dt = new DataTable(); ;
KiemTraHoaDon = 1;
if (!checkBoxX2.Checked)
{
dt = load.LoadHoaDonBanHang(dateTimeInput1.Value, dateTimeInput2.Value);
}
else
{
dt = load.LoadHoaDonBanHangNo(dateTimeInput1.Value, dateTimeInput2.Value);
}
loadDataHoaDon(dt);
lblHoaDon.Text = dt.Rows.Count.ToString();
int Tong = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
Tong = Convert.ToInt32(dt.Rows[i][7].ToString()) + Tong;
}
txtTongTien.Text = Tong.ToString();
}
private void toolStripMenuItemThemBan_Click(object sender, EventArgs e)
{
try
{
//check khu vuc
int MaBanAn = Convert.ToInt32(listViewExKhuVuc.SelectedItems[0].Name.ToString());
BanHang.Model.Load load = new BanHang.Model.Load();
DataTable dt = load.LoadKhuVucTheoMaBanAn(MaBanAn);
int MaKhuVuc = Convert.ToInt32(dt.Rows[0][2].ToString());
BanHang.ThemBan them = new BanHang.ThemBan(MaKhuVuc);
them.ShowDialog();
LoadKhuVuc();
}
catch (Exception)
{
}
}
private DataTable LoadListKhuVuc()
{
BanHang.Model.Load load = new BanHang.Model.Load();
return load.LoadKhuVuc();
}
private void ThemBan_Load(object sender, EventArgs e)
{
BanHang.Model.Load load = new Model.Load();
DataTable dt = load.LoadKhuVucTheoMaKhuVuc(MaKhuVuc);
lblKhuVuc.Text = dt.Rows[0][1].ToString();
}
