public void LoadDonVi()
{
ThucDon.ModuleThucDon thucdon = new ThucDon.ModuleThucDon();
//load Donvi
DataTable dtDonVi = thucdon.LoadDonVi();
comboTreeDonVi.DataSource = dtDonVi;
comboTreeDonVi.ValueMember = "TenDonVi";
comboTreeDonVi.DisplayMembers = "TenDonVi";
}
public void LoadDataGridViewThucDon1()
{
string s = "";
try
{
s = advTreeThucDon1.SelectedNode.Name;
int MaDanhMuc = Convert.ToInt32(s);
MaDanhMucThucDon = MaDanhMuc;
ThucDon.ModuleThucDon thudon = new ThucDon.ModuleThucDon();
DataTable dt = thudon.LoadThucDonTheoDanhMuc(MaDanhMuc);
LoadThucDonTheoAdvTree(dt);
}
catch (Exception)
{
try
{
int NhomDanhMuc = Convert.ToInt32(s.Substring(1));
ThucDon.ModuleThucDon thudon = new ThucDon.ModuleThucDon();
DataTable dt = thudon.LoadThucDonTheoNhomDanhMuc(NhomDanhMuc);
LoadThucDonTheoAdvTree(dt);
}
catch
{
ThucDon.ModuleThucDon thudon = new ThucDon.ModuleThucDon();
DataTable dt = thudon.LoadToanBoThucDon();
dataGridViewXThucDon.DataSource = dt;
LoadThucDonTheoAdvTree(dt);
}
}
}
public void LoadDataGridViewThucDon()
{
string s="";
try
{
s = advTreeThucDon.SelectedNode.Name;
int MaDanhMuc = Convert.ToInt32(s);
MaDanhMucThucDon = MaDanhMuc;
ThucDon.ModuleThucDon thudon = new ThucDon.ModuleThucDon();
DataTable dt = thudon.LoadThucDonTheoDanhMuc(MaDanhMuc);
loadData(dt);
toolStripMenuItemThemMon.Enabled = true;
ToolStripMenuItemThemDanhMuc.Enabled = true;
ToolStripMenuItemSuaDanhMuc.Enabled = true;
}
catch
{
try
{
int NhomDanhMuc = Convert.ToInt32(s.Substring(1));
ThucDon.ModuleThucDon thudon = new ThucDon.ModuleThucDon();
DataTable dt = thudon.LoadThucDonTheoNhomDanhMuc(NhomDanhMuc);
loadData(dt);
ToolStripMenuItemThemDanhMuc.Enabled = true;
toolStripMenuItemThemMon.Enabled = false;
ToolStripMenuItemSuaDanhMuc.Enabled = true;
}
catch
{
ThucDon.ModuleThucDon thudon = new ThucDon.ModuleThucDon();
DataTable dt = thudon.LoadToanBoThucDon();
dataGridViewXThucDon.DataSource = dt;
loadData(dt);
ToolStripMenuItemThemDanhMuc.Enabled = false;
toolStripMenuItemThemMon.Enabled = false;
ToolStripMenuItemSuaDanhMuc.Enabled = false;
}
}
}
private void ToolStripMenuItemXoaDanhMuc_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Bạn có chắc chắn muốn xóa", "Xóa", MessageBoxButtons.YesNo);
if(dialogResult == DialogResult.Yes)
{
string s = "";
try
{
s = advTreeThucDon.SelectedNode.Name;
int NhomDanhMuc = Convert.ToInt32(s);
ThucDon.ModuleThucDon thucdon = new ThucDon.ModuleThucDon();
thucdon.DeleteDanhMuc(NhomDanhMuc);
LoadTreeViewThucDon();
LoadDataGridViewThucDon();
}
catch (Exception)
{
try
{
int NhomDanhMuc = Convert.ToInt32(s.Substring(1));
ThucDon.ModuleThucDon thucdon = new ThucDon.ModuleThucDon();
thucdon.DeleteNhomDanhMuc(NhomDanhMuc);
LoadTreeViewThucDon();
LoadDataGridViewThucDon();
}
catch (Exception)
{
MessageBox.Show("Bạn chưa chọn mục");
}
}
}
}
private void ToolStripMenuItemThemDanhMuc_Click(object sender, EventArgs e)
{
string s = advTreeThucDon.SelectedNode.Name;
try
{
int DanhMuc = Convert.ToInt32(s);
// load Nhom danh muc
ThucDon.ModuleThucDon load = new ThucDon.ModuleThucDon();
DataTable dt = load.LoadDanhMucTheoMaDanhMuc(DanhMuc);
int NhomDanhMuc = Convert.ToInt32(dt.Rows[0][2].ToString());
ThemDanhMuc them = new ThemDanhMuc(NhomDanhMuc);
them.ShowDialog();
LoadTreeViewThucDon();
}
catch
{
int NhomDanhMuc = Convert.ToInt32(s.Substring(1));
ThemDanhMuc them = new ThemDanhMuc(NhomDanhMuc);
them.ShowDialog();
LoadTreeViewThucDon();
}
}
private void LoadTreeViewThucDon1()
{
advTreeThucDon1.Nodes.Clear();
DevComponents.AdvTree.Node node2 = new DevComponents.AdvTree.Node();
node2.Text = "Tất cả";
DevComponents.AdvTree.Node node3 = new DevComponents.AdvTree.Node();
node3.Text = "Tất cả thực đơn";
node2.Nodes.AddRange(new DevComponents.AdvTree.Node[] { node3 });
// node3.Image = global::VietRestaurant2._0.Properties.Resources.folder_48;
advTreeThucDon1.Nodes.AddRange(new DevComponents.AdvTree.Node[] { node2 });
ThucDon.ModuleThucDon thucdon = new ThucDon.ModuleThucDon();
DataTable dtNhom = thucdon.LoadNhomDanhMucThucDon();
int a = dtNhom.Rows.Count;
for (int i = 0; i < a; i++)
{
DevComponents.AdvTree.Node node = new DevComponents.AdvTree.Node();
node.Text = dtNhom.Rows[i]["TenDanhMuc"].ToString();
node.Name = "a" + dtNhom.Rows[i]["MaDanhMuc"].ToString();
DataTable dt = thucdon.LoadDanhMucTheoNhomDanhMuc(Convert.ToInt32(dtNhom.Rows[i]["MaDanhMuc"].ToString()));
int b = dt.Rows.Count;
for (int j = 0; j < b; j++)
{
DevComponents.AdvTree.Node node1 = new DevComponents.AdvTree.Node();
node1.Text = dt.Rows[j]["TenDanhMuc"].ToString();
node1.Name = dt.Rows[j]["MaDanhMuc"].ToString();
// node1.Image = global::VietRestaurant2._0.Properties.Resources.folder_48;
node.Nodes.AddRange(new DevComponents.AdvTree.Node[] { node1 });
}
advTreeThucDon1.Nodes.AddRange(new DevComponents.AdvTree.Node[] { node });
}
advTreeThucDon1.ExpandAll();
}
private void loadThucDon()
{
ThucDon.ModuleThucDon thudon = new ThucDon.ModuleThucDon();
DataTable dt = thudon.LoadToanBoThucDon();
LoadThucDonTheoAdvTree(dt);
LoadSoLuongSanPham();
}
private void SuaMon_Load(object sender, EventArgs e)
{
ThucDon.ModuleThucDon thucDon = new ThucDon.ModuleThucDon();
DataTable dt = thucDon.LoadThucDonTheoMaMonAn(MaMonAn);
ThucDon.ModuleThucDon thucdon = new ThucDon.ModuleThucDon();
pictureBox1.Image = global::VietRestaurant2._0.Properties.Resources._5564116;
//load danh muc da chon
DataTable dtDanhMuc = thucdon.LoadDanhMucNhomDanhMucThucDon();
comboTreeDanhMuc.DataSource = dtDanhMuc;
comboTreeDanhMuc.ValueMember = "MaDanhMuc";
int MaDanhMuc = Convert.ToInt32(dt.Rows[0][5].ToString());
comboTreeDanhMuc.SelectedValue = MaDanhMuc;
txtThucDon.Text = dt.Rows[0][1].ToString();
txtGiaBan.Text = dt.Rows[0][3].ToString();
try
{
pictureBox1.Image = byeArrayToImage((byte[])dt.Rows[0][4]);
}
catch (Exception)
{
}
LoadDonVi();
comboTreeDonVi.SelectedValue = dt.Rows[0][2].ToString();
}
private void SuaNhomDanhMuc_Load(object sender, EventArgs e)
{
ThucDon.ModuleThucDon thucdon = new ThucDon.ModuleThucDon();
DataTable dt = thucdon.LoadNhomDanhMucTheoMaNhomDanhMuc(Nhom);
textBoxX1.Text = dt.Rows[0][1].ToString();
}
private void ThemMon_Load(object sender, EventArgs e)
{
try
{
ThucDon.ModuleThucDon thucdon = new ThucDon.ModuleThucDon();
//load danh muc da chon
DataTable dtDanhMuc = thucdon.LoadDanhMucNhomDanhMucThucDon();
comboTreeDanhMuc.DataSource = dtDanhMuc;
comboTreeDanhMuc.ValueMember = "MaDanhMuc";
comboTreeDanhMuc.SelectedValue = MaDanhMuc;
pictureBox1.Image = global::VietRestaurant2._0.Properties.Resources._5564116;
LoadDonVi();
panelEx1.Visible = false;
}
catch (Exception)
{
}
}