private void btSua_Click(object sender, EventArgs e)
{
if (dgvKhachHang.SelectedRows.Count > 0)
{
DataRow cn = ((DataRowView)dgvKhachHang.SelectedRows[0].DataBoundItem).Row;
XuLyDuLieu.ghiDuLieu("KHACH_HANG", dt);
}
Form_Load();
}
private void dgvBan_SelectionChanged(object sender, EventArgs e)
{
if (dgvBan.SelectedRows.Count > 0)
{
DataRow dr = ((DataRowView)dgvBan.SelectedRows[0].DataBoundItem).Row;
this.txtTenBan.Text = dr[1].ToString();
this.cbTrangThai.Text = dr[3].ToString();
XuLyDuLieu.ghiDuLieu("CHI_NHANH", dsBan);
}
}
private void btSuaBan_Click_1(object sender, EventArgs e)
{
if (dgvBan.SelectedRows.Count > 0)
{
DataRow dr = ((DataRowView)dgvBan.SelectedRows[0].DataBoundItem).Row;
dr[1] = this.txtTenBan.Text;
dr[3] = this.cbTrangThai.Text;
XuLyDuLieu.ghiDuLieu("BAN", dsBan);
}
Form_Load();
}
private void btThemBan_Click(object sender, EventArgs e)
{
DataRow cn = ((DataRowView)dgvChiNhanh.SelectedRows[0].DataBoundItem).Row;
DataRow dr = dsBan.NewRow();
dr[1] = this.txtTenBan.Text;
dr[2] = cn[0].ToString();
dr[3] = this.cbTrangThai.Text;
dsBan.Rows.Add(dr);
XuLyDuLieu.ghiDuLieu("BAN", dsBan);
Form_Load();
}
private void N_Click(object sender, EventArgs e)
{
dtDonHang = XuLyDuLieu.docDuLieu("Select * From DON_HANG");
DataRow dr = dtDonHang.NewRow();
dr[1] = Ma;
dr[2] = ((Button)sender).Tag;
dr[3] = 1;
dtDonHang.Rows.Add(dr);
XuLyDuLieu.ghiDuLieu("DON_HANG", dtDonHang);
Form_Load();
}
private void btSua_Click(object sender, EventArgs e)
{
if (dgvNuoc.SelectedRows.Count > 0)
{
DataRow cn = ((DataRowView)dgvNuoc.SelectedRows[0].DataBoundItem).Row;
cn[1] = txtTen.Text;
cn[2] = txtDonGia.Text;
cn[3] = txtThongTin.Text;
XuLyDuLieu.ghiDuLieu("MON_AN", dsMM);
}
}
private void btInHoaDon_Click(object sender, EventArgs e)
{
dt = XuLyDuLieu.docDuLieu("Select * From HOA_DON");
DataRow dr = dt.NewRow();
dr[0] = Ma + 1;
dr[1] = UDQL.Ma;
dr[2] = TongTien;
dt.Rows.Add(dr);
XuLyDuLieu.ghiDuLieu("HOA_DON", dt);
this.Hide();
}
private void btXacNhan_Click(object sender, EventArgs e)
{
dt = XuLyDuLieu.docDuLieu("Select * From KHACH_HANG");
DataRow dr = dt.NewRow();
dr[2] = txtTenKH.Text;
dr[1] = txtSDTKH.Text;
dr[3] = txtDiaChiKH.Text;
dt.Rows.Add(dr);
XuLyDuLieu.ghiDuLieu("KHACH_HANG", dt);
this.Hide();
}
private void btThemCN_Click(object sender, EventArgs e)
{
DataRow dr = dsChiNhanh.NewRow();
dr[0] = this.txtMaCN.Text;
dr[1] = this.txtTenCN.Text;
dr[2] = this.txtSoLuongBanCN.Text;
dr[3] = this.txtDiaChiCN.Text;
dr[4] = this.txtSDTCN.Text;
dr[5] = this.txtQuanLyCN.Text;
dsChiNhanh.Rows.Add(dr);
XuLyDuLieu.ghiDuLieu("CHI_NHANH", dsChiNhanh);
Form_Load();
}
private void btXoa_Click(object sender, EventArgs e)
{
if (dgvNuoc.SelectedRows.Count > 0)
{
DataRow cn = ((DataRowView)dgvNuoc.SelectedRows[0].DataBoundItem).Row;
String noidung = String.Format("Anh/chi co muon xoa món '{0}' khong?", cn[1]);
DialogResult dr = MessageBox.Show(noidung, "Thong bao", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.Yes)
{
cn.Delete();
XuLyDuLieu.ghiDuLieu("MON_AN", dsMM);
}
}
}
private void btGuiDonHang_Click(object sender, EventArgs e)
{
DataTable dt = XuLyDuLieu.docDuLieu("Select * From GIAO_HANG");
DataRow dr = dt.NewRow();
dr[1] = DateTime.Now;
dr[2] = MaDH;
dt.Rows.Add(dr);
XuLyDuLieu.ghiDuLieu("GIAO_HANG", dt);
MaKH = string.Empty;
Form_Load();
btnThemMon.Enabled = false;
btTaoMoi.Enabled = false;
}
private void btSuaCN_Click(object sender, EventArgs e)
{
if (dgvChiNhanh.SelectedRows.Count > 0)
{
DataRow dr = ((DataRowView)dgvChiNhanh.SelectedRows[0].DataBoundItem).Row;
dr[0] = this.txtMaCN.Text;
dr[1] = this.txtTenCN.Text;
dr[2] = this.txtSoLuongBanCN.Text;
dr[3] = this.txtDiaChiCN.Text;
dr[4] = this.txtSDTCN.Text;
dr[5] = this.txtQuanLyCN.Text;
XuLyDuLieu.ghiDuLieu("CHI_NHANH", dsChiNhanh);
}
Load_Ban();
}
private void btMoi_Click(object sender, EventArgs e)
{
dt = XuLyDuLieu.docDuLieu("Select * From DAT_HANG");
DataRow dr = dt.NewRow();
dr[1] = MaNV;
dr[2] = DBNull.Value;
dr[3] = MaCN;
dr[4] = MaBan;
dr[5] = DateTime.Now;
dr[6] = DBNull.Value;
dt.Rows.Add(dr);
XuLyDuLieu.ghiDuLieu("DAT_HANG", dt);
Form_Load();
pnMonAn.Enabled = true;
}
private void btTaoMoi_Click(object sender, EventArgs e)
{
DataTable dt = XuLyDuLieu.docDuLieu("Select * From DAT_HANG");
DataRow dr = dt.NewRow();
dr[1] = UDQL.MaNV;
dr[2] = dsKhachHang.MaKH;
dr[3] = DBNull.Value;
dr[4] = DBNull.Value;
dr[5] = DateTime.Now;
dr[6] = DBNull.Value;
dt.Rows.Add(dr);
XuLyDuLieu.ghiDuLieu("DAT_HANG", dt);
DataTable db = XuLyDuLieu.docDuLieu("Select * From DAT_HANG Where MaKH = '" + dsKhachHang.MaKH + "'");
foreach (DataRow r in db.Rows)
{
MaDH = r[0].ToString();
}
Form_Load();
}
private void btThem_Click(object sender, EventArgs e)
{
string MaMA = "MA0001";
while (XuLyDuLieu.kiemtratontai(MaMA))
{
if (dem < 10)
{
MaMA = "MA000" + dem.ToString();
}
else if (dem < 100)
{
MaMA = "MA00" + dem.ToString();
}
else if (dem < 1000)
{
MaMA = "MA0" + dem.ToString();
}
else
{
MaMA = "MA" + dem.ToString();
}
dem++;
}
DataRow cn = dsMM.NewRow();
cn[0] = MaMA;
cn[1] = txtTen.Text;
cn[2] = txtDonGia.Text;
cn[3] = txtThongTin.Text;
cn[4] = "Dessert";
cn[5] = cbbChiNhanh.SelectedValue;
dsMM.Rows.Add(cn);
XuLyDuLieu.ghiDuLieu("MON_AN", dsMM);
loadDSMM();
}
private void btnThemMon_Click(object sender, EventArgs e)
{
DataTable db = XuLyDuLieu.docDuLieu("Select * From DAT_HANG Where MaKH = '" + dsKhachHang.MaKH + "'");
foreach (DataRow r in db.Rows)
{
MaDH = r[0].ToString();
}
DataTable dm = XuLyDuLieu.docDuLieu("Select * From MON_AN Where TenMA like N'" + cbMonAn.Text + "'");
foreach (DataRow d in dm.Rows)
{
Ma = d[0].ToString();
}
DataTable dt = XuLyDuLieu.docDuLieu("Select * From DON_HANG");
DataRow dr = dt.NewRow();
dr[1] = MaDH;
dr[2] = Ma;
dr[3] = nbudSoLuong.Value;
dt.Rows.Add(dr);
XuLyDuLieu.ghiDuLieu("DON_HANG", dt);
Form_Load();
}
