private void QuanLyBan_Load(object sender, EventArgs e)
{
using (HangHoaBUS bus = new HangHoaBUS())
dataGridView2.DataSource = bus.ListHangHoa2();
using (KhuVucBUS bus = new KhuVucBUS())
{
foreach (DataRow row in bus.ListKhuVuc().Rows)
{
var group = new ListViewGroup(row["TenKhuVuc"].ToString());
listView1.Groups.Add(group);
foreach (DataRow r in bus.ListBan(row["TenKhuVuc"].ToString()).Rows)
{
listView1.Items.Add(new ListViewItem(r["TenBan"].ToString(),
bus.IsAvailable(r["MaSoBan"].ToString()) ? 0 : 1, group)).Tag = r["MaSoBan"];
}
listView1.Items[0].Selected = true;
}
}
using (QuanLyBanBUS bus = new QuanLyBanBUS())
txtSoHoaDon.Text = bus.GetSoHoaDon().ToString();
}
private void btnLuu_Click(object sender, EventArgs e)
{
KhuVucDTO kv = new KhuVucDTO();
kv.TenKhuVuc = txtTen.Text;
kv.GhiChu = txtGhiChu.Text;
if (chxConQuanLy.Checked == true)
{
kv.ConQuanLy = true;
}
else
{
kv.ConQuanLy = false;
}
bool check = KhuVucBUS.KiemTraThem(kv);
if (check)
{
if (eventThemXong != null)
{
eventThemXong();
}
Interaction.MsgBox("Thêm thành công!");
Log_BUS.ThemNhatKy("Khu vực", "Thêm khu vực");
}
else
{
Interaction.MsgBox("Thêm thất bại!");
}
}
private void simpleButton3_Click(object sender, EventArgs e)
{
int vitri = gridView1.GetFocusedDataSourceRowIndex();
KhuVucBUS.Xoa(gridView1.GetRowCellValue(vitri, "MaKhuVuc").ToString());
gridControl1.DataSource = LayDanhSach();
}
private void btnLuu_Click(object sender, EventArgs e)
{
KhuVucDTO kv = new KhuVucDTO();
kv.MaKhuVuc = txtMaKhuVuc.Text.Trim();
kv.TenKhuVuc = txtTen.Text.Trim();
kv.GhiChu = txtGhiChu.Text.Trim();
if (chxConQuanLy.Checked == true)
{
kv.ConQuanLy = true;
}
else
{
kv.ConQuanLy = false;
}
bool check = KhuVucBUS.KiemTraSua(kv);
if (check)
{
if (eventSuaXong != null)
{
eventSuaXong();
}
Log_BUS.ThemNhatKy("Khu vực", "Sửa thông tin khu vực");
Interaction.MsgBox("Sửa thành công!");
}
else
{
Interaction.MsgBox("Sửa thất bại!");
}
}
public BanHangReport(BanHangDTO info)
{
Thread.CurrentThread.CurrentCulture = new CultureInfo("vi-VN");
InitializeComponent();
var materialSkinManager = MaterialSkinManager.Instance;
materialSkinManager.AddFormToManage(this);
materialSkinManager.Theme = MaterialSkinManager.Themes.LIGHT;
materialSkinManager.ColorScheme = new ColorScheme(Primary.Teal500, Primary.Teal700, Primary.Teal500,
Accent.Red700, TextShade.WHITE);
using (KhuVucBUS bus = new KhuVucBUS())
{
HoaDonBanHang hdbh = new HoaDonBanHang();
var lblSoPhieu = hdbh.ReportDefinition.ReportObjects["lblSoPhieu"] as TextObject;
lblSoPhieu.Text = "Số phiếu: " + info.SoHoaDon;
var lblKhu = hdbh.ReportDefinition.ReportObjects["lblKhu"] as TextObject;
lblKhu.Text = "Khu: " + bus.GetChiTiet(info.MaSoBan).Rows[0].Field <string>("TenKhuVuc");
var lblBan = hdbh.ReportDefinition.ReportObjects["lblBan"] as TextObject;
lblBan.Text = "Bàn: " + bus.GetChiTiet(info.MaSoBan).Rows[0].Field <string>("TenBan");
var lblGioRa = hdbh.ReportDefinition.ReportObjects["lblGioRa"] as TextObject;
lblGioRa.Text = "Giờ ra: " + info.GioRa.ToString("dd/MM/yyyy H:mm");
var lblTongCong = hdbh.ReportDefinition.ReportObjects["lblTongCong"] as TextObject;
lblTongCong.Text = info.ChuaThue.ToString("N0");
var lblKhuyenMai = hdbh.ReportDefinition.ReportObjects["lblKhuyenMai"] as TextObject;
lblKhuyenMai.Text = info.KhuyenMai + " %";
var lblThanhToan = hdbh.ReportDefinition.ReportObjects["lblThanhToan"] as TextObject;
lblThanhToan.Text = info.TongTien.ToString("N0");
hdbh.SetDataSource(info.ChiTiet);
crystalReportViewer1.ReportSource = hdbh;
crystalReportViewer1.Refresh();
}
}
private void btnThemKV_Click(object sender, System.EventArgs e)
{
if (string.IsNullOrWhiteSpace(txtTenKhuVuc.Text))
{
errorProvider1.SetError(txtTenKhuVuc, "Vui lòng điền tên khu vực muốn thêm");
return;
}
errorProvider1.SetError(txtTenKhuVuc, string.Empty);
try
{
using (KhuVucBUS bus = new KhuVucBUS())
bus.InsertKhuVuc(txtTenKhuVuc.Text);
}
catch (SqlException ex)
{
if (ex.Number == DbConnection.MssqlEng002627)
{
errorProvider1.SetError(txtTenKhuVuc, "Khu vực đã tồn tại");
}
else
{
throw;
}
}
RefreshKhuVuc();
}
private void btnThemBan_Click(object sender, System.EventArgs e)
{
if (string.IsNullOrWhiteSpace(txtTenBan.Text))
{
errorProvider1.SetError(txtTenBan, "Vui lòng điền tên bàn muốn thêm");
return;
}
errorProvider1.SetError(txtTenBan, string.Empty);
try
{
using (KhuVucBUS bus = new KhuVucBUS())
bus.InsertBan(treeView1.SelectedNode.Text, txtTenBan.Text);
}
catch (SqlException ex)
{
if (ex.Number == DbConnection.MssqlEng002627)
{
errorProvider1.SetError(txtTenBan, "Bàn đã tồn tại trong khu vực");
}
else
{
throw;
}
}
RefreshBan();
}
public frmSuaKhachHang()
{
InitializeComponent();
gridLookupKhuVuc.Properties.DataSource = KhuVucBUS.DanhSach();
gridLookupKhuVuc.Properties.DisplayMember = "TenKhuVuc";
gridLookupKhuVuc.Properties.ValueMember = "MaKhuVuc";
}
public void LoadBanTrongKhuVuc()
{
m_tabCtrKhuVuc.Tabs.Clear();
int maNhaHang = m_cBoxNhaHang.SelectedIndex == 0 ? 0 : ((NhaHangDTO)m_cBoxNhaHang.SelectedItem).MaNhaHang;
List <KhuVucDTO> dsKhuVuc = KhuVucBUS.LayDanhSachKhuVuc(maNhaHang);
foreach (KhuVucDTO kv in dsKhuVuc)
{
if (KiemTraKhuVuc(kv.MaKhuVuc))
{
TabItem tabI = new TabItem();
TabControlPanel tabCtrP = new TabControlPanel();
tabI.Name = "m_tabIKhuVuc" + kv.MaKhuVuc;
tabI.Text = kv.TenKhuVuc;
tabCtrP.Name = "m_tabCtrP" + kv.MaKhuVuc;
tabCtrP.AutoScroll = true;
tabCtrP.AutoSize = true;
tabCtrP.Dock = System.Windows.Forms.DockStyle.Fill;
tabCtrP.TabItem = tabI;// chỗ này là gán
tabI.AttachedControl = tabCtrP;
uCtr_KhuVuc khuvuc = new uCtr_KhuVuc(this, kv.MaKhuVuc);
khuvuc.MaximumSize = new Size(m_tabCtrKhuVuc.Width, 0);
tabCtrP.Controls.Add(khuvuc);
m_tabCtrKhuVuc.Controls.Add(tabCtrP); // chỗ này là add
m_tabCtrKhuVuc.Tabs.Add(tabI);
}
}
}
public void btnLuu_Click(object sender, EventArgs e)
{
KhuVucDTO kv = new KhuVucDTO();
kv.MaKhuVuc = int.Parse(txtMaKhuVuc.Text.Trim());
kv.TenKhuVuc = txtTen.Text.Trim();
kv.GhiChu = txtGhiChu.Text.Trim();
if (chxConQuanLy.Checked == true)
{
kv.ConQuanLy = true;
}
else
{
kv.ConQuanLy = false;
}
bool check = KhuVucBUS.KiemTraSua(kv);
if (check)
{
if (eventSuaXongEvent != null)
{
eventSuaXongEvent();
}
Log_BUS.ThemNhatKy("Khu vực", "Sửa thông tin khu vực");
MessageBox.Show("Sửa thành công!");
}
else
{
MessageBox.Show("Sửa thất bại!");
}
}
public FormKhuVuc(int themOrSua, KhuVucO kv)
{
this.themOrSua = themOrSua;
khuVucBUS = new KhuVucBUS();
//KV = new KhuVucO();
KV = kv;
InitializeComponent();
}
public void LoadKhuVuc()
{
List <KhuVucDTO> lKV = KhuVucBUS.LayToanBoKhuVuc();
lkpKhuVuc.Properties.DataSource = lKV;
lkpKhuVuc.Properties.DisplayMember = "TenKhuVuc";
lkpKhuVuc.Properties.ValueMember = "MaKhuVuc";
}
public frmThemNCC()
{
InitializeComponent();
txtMaNCC.Text = NhaCungCapBUS.LayMaNCC();
gridlookupKhuVuc.Properties.DataSource = KhuVucBUS.DanhSach();
gridlookupKhuVuc.Properties.DisplayMember = "TenKhuVuc";
gridlookupKhuVuc.Properties.ValueMember = "MaKhuVuc";
}
public FormKhachHang()
{
InitializeComponent();
themOrSua = 1;
khuVucBUS = new KhuVucBUS();
// load lookupEdit khu vuc
lueKhuVuc.Properties.DataSource = khuVucBUS.getAllKhuVuc();
lueKhuVuc.Properties.DisplayMember = "TenKhuVuc";
lueKhuVuc.Properties.ValueMember = "MaKhuVuc";
}
private void RefreshBan()
{
listView1.Items.Clear();
using (KhuVucBUS bus = new KhuVucBUS())
{
foreach (DataRow row in bus.ListBan(treeView1.SelectedNode.Text).Rows)
{
listView1.Items.Add(row[1].ToString(), 1).Tag = row[0];
}
}
}
public FormNhaCungCap()
{
InitializeComponent();
themOrSua = 1;
nhaCungCapBUS = new NhaCungCapBUS();
NCC = new NhaCungCapO();
khuVucBUS = new KhuVucBUS();
// load lookupEdit khu vuc
lueKhuVuc.Properties.DataSource = khuVucBUS.getAllKhuVuc();
lueKhuVuc.Properties.DisplayMember = "TenKhuVuc";
lueKhuVuc.Properties.ValueMember = "MaKhuVuc";
}
private void btnXoaKV_Click(object sender, System.EventArgs e)
{
using (KhuVucBUS bus = new KhuVucBUS())
{
if (new XacNhan {
Text = @"Bạn có chắc chắn muốn xóa khu vực " + treeView1.SelectedNode.Text
}.ShowDialog() == DialogResult.Yes)
{
bus.DeleteKhuVuc(treeView1.SelectedNode.Text);
}
}
RefreshKhuVuc();
}
private void RefreshKhuVuc()
{
treeView1.Nodes.Clear();
using (KhuVucBUS bus = new KhuVucBUS())
{
foreach (DataRow row in bus.ListKhuVuc().Rows)
{
treeView1.Nodes.Add(row[0].ToString());
}
}
treeView1.SelectedNode = treeView1.TopNode;
}
private void LoadKhuVuc(int maNhaHang)
{
m_cBoxKhuVuc.Items.Clear();
m_cBoxKhuVuc.Items.Add("Chọn khu vực");
List <KhuVucDTO> khuVuc = KhuVucBUS.LayDanhSachKhuVuc(maNhaHang);
foreach (KhuVucDTO oKhuVuc in khuVuc)
{
m_cBoxKhuVuc.Items.Add(oKhuVuc);
}
m_cBoxKhuVuc.SelectedIndex = 0;
m_cBoxKhuVuc.ValueMember = "MaKhuVuc";
m_cBoxKhuVuc.DisplayMember = "TenKhuVuc";
}
private void simpleButton1_Click(object sender, EventArgs e)
{
bool ConQuanLy;
if (checkBox1.Checked)
{
ConQuanLy = true;
}
else
{
ConQuanLy = false;
}
KhuVucBUS.Sua(txtMaKhuVuc.Text, txtTen.Text, txtGhiChu.Text, ConQuanLy);
this.Close();
}
private void BarButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
int[] i = GridView1.GetSelectedRows();
int makv = Convert.ToInt32(GridView1.GetRowCellValue(i[0], "MaKhuVuc"));
bool check = KhuVucBUS.KiemTraXoa(makv);
if (check)
{
LoadTatCaKhuVuc();
Interaction.MsgBox("Xóa thành công!");
Log_BUS.ThemNhatKy("Khu vực", "Xóa khu vực");
}
else
{
Interaction.MsgBox("Xóa thất bại!");
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
bool ConQuanLy;
if (checkBox1.Checked == true)
{
ConQuanLy = true;
}
else
{
ConQuanLy = false;
}
KhuVucBUS.Them(txtMaKhuVuc.Text, txtTen.Text, txtGhiChu.Text, ConQuanLy);
txtMaKhuVuc.Text = KhuVucBUS.MaKhuVuc();
txtTen.Text = null;
txtGhiChu.Text = null;
checkBox1.Checked = true;
}
private void btnXoaBan_Click(object sender, System.EventArgs e)
{
if (listView1.SelectedItems.Count == 0)
{
return;
}
using (KhuVucBUS bus = new KhuVucBUS())
{
if (new XacNhan {
Text = @"Bạn có chắc chắn muốn xóa bàn " + listView1.SelectedItems[0].Text
}.ShowDialog() == DialogResult.Yes)
{
bus.DeleteBan(listView1.SelectedItems[0].Tag.ToString());
}
}
RefreshBan();
}
private void frmThemKhuVuccs_Load(object sender, EventArgs e)
{
txtMaKhuVuc.Text = KhuVucBUS.MaKhuVuc();
}
public void LoadCotKhuVuc()
{
RepositoryItemCheckedComboBoxEdit1.DataSource = KhuVucBUS.LayToanBoKhuVuc();
RepositoryItemCheckedComboBoxEdit1.DisplayMember = "TenKhuVuc";
RepositoryItemCheckedComboBoxEdit1.ValueMember = "MaKhuVuc";
}
void Tao_Ban()
{
flowLayoutBan.Controls.Clear();
DataTable dt = KhuVucBUS.KhuVuc_LoadTheoTrangThai("Đang sử dụng");
GroupBox grkhuvucCu = new GroupBox()
{
Width = 0, Location = new Point(0, 0)
}; // lưu vị trí của groupbox cũ
for (int i = 0; i < dt.Rows.Count; i++)
{
int makv = int.Parse(dt.Rows[i]["kv_id"].ToString());
string tenkv = dt.Rows[i]["kv_ten"].ToString();
GroupBox grkhuvuc = new GroupBox() // tạo groupbox(khu vực) chứa các button(bàn)
{
Width = 450,
Height = 300,
Location = new Point(grkhuvucCu.Location.X + grkhuvucCu.Width, grkhuvucCu.Location.Y),
Text = tenkv,
Tag = makv,
};
FlowLayoutPanel flowKhuVuc = new FlowLayoutPanel(); // tạo FlowLayoutPanel add vào grKhuVuc
flowKhuVuc.Dock = DockStyle.Fill;
flowKhuVuc.AutoScroll = true;
grkhuvuc.Controls.Add(flowKhuVuc); // add button vao flow
// tao danh sach ban theo khu vuc
List <BanDTO> ban = new List <BanDTO>();
ban = BanBUS.Ban_List_KhuVuc(makv);
Button oldbtn = new Button()
{
Width = 0, Location = new Point(0, 0)
};
foreach (BanDTO item in ban)
{
Button btn = new Button()
{
Width = 80,
Height = 80,
Location = new Point(oldbtn.Location.X + oldbtn.Width, oldbtn.Location.Y),
Text = item.Ban_ten,
Tag = item.Ban_id
};
// gán màu cho bàn theo trạng thái Trống - xanh, Có khách - Đỏ, Đặt trước - Hồng
if (item.Ban_trangthai == "Trống")
{
btn.BackColor = Color.Blue;
}
else if (item.Ban_trangthai == "Có khách")
{
btn.BackColor = Color.Red;
}
else
{
btn.BackColor = Color.Pink;
}
flowKhuVuc.Controls.Add(btn);
btn.MouseDown += new MouseEventHandler(bt_MouseDown); // tạo sự kiện click cho các button
}
flowLayoutBan.Controls.Add(grkhuvuc);
}
}
public void LoadTatCaKhuVuc()
{
GridControl1.DataSource = KhuVucBUS.KiemTraLoad();
}
private void LoadCotKhuVuc()
{
RepositoryItemCheckedComboBoxEdit_2.DataSource = KhuVucBUS.KiemTraLoad();
RepositoryItemCheckedComboBoxEdit_2.ValueMember = "MaKhuVuc";
RepositoryItemCheckedComboBoxEdit_2.DisplayMember = "TenKhuVuc";
}
public UCKhuVuc()
{
InitializeComponent();
khuVucBUS = new KhuVucBUS();
kv = new KhuVucO();
}
private List <KhuVucDTO> LayDanhSach()
{
return(KhuVucBUS.DanhSach());
}
