private void btLichSu_Click(object sender, EventArgs e)
{
if (tbThanhTien.Text == "")
{
MessageBox.Show("Bạn Chưa Bấm Tổng Cộng", "Thông Báo", MessageBoxButtons.OK);
}
else
if (tbMaDonHang.Text != "" || tbSoDienThoai.Text != "")
{
DataRow ls = dsLichSu.NewRow();
ls["SoDienThoai"] = tbSoDienThoai.Text;
ls["MaDonHang"] = tbMaDonHang.Text;
ls["NgayMua"] = dtpNgayMua.Text;
ls["NgayGiao"] = dtpNgayGiao.Text;
ls["TongCong"] = tbThanhTien.Text;
ls["MaChiNhanh"] = cbChiNhanh.SelectedValue;
dsLichSu.Rows.Add(ls);
XuLyDuLieu.ghiBang("LichSuMua", dsLichSu);
}
else
{
MessageBox.Show("Bạn Chưa Nhập Đủ Thông Tin", "Thông Báo", MessageBoxButtons.OK);
}
}
private void Lưu_Click(object sender, EventArgs e)
{
if (dgvChiNhanh.SelectedRows.Count > 0)
{
DataRow cn = ((DataRowView)dgvChiNhanh.SelectedRows[0].DataBoundItem).Row;
DataRow k = ((DataRowView)dgvKhach.SelectedRows[0].DataBoundItem).Row;
DataRow donhang = dsdonhang.NewRow();
DataRow ls = dslichsu.NewRow();
donhang["MaDonHang"] = tbMaDonHang.Text;
donhang["MaChiNhanh"] = cn["MaChiNhanh"];
donhang["SoDienThoai"] = k["SoDienThoai"];
donhang["DiaChi"] = k["DiaChi"];
donhang["ThoiDiem"] = dtp1.Text;
donhang["TrangThai"] = cbTrangThai.Text;
donhang["Loai"] = "3";
dsdonhang.Rows.Add(donhang);
ls["SoDienThoai"] = k["SoDienThoai"];
ls["MaDonHang"] = donhang["MaDonHang"];
ls["NgayMua"] = donhang["ThoiDiem"];
ls["NgayGiao"] = dtp2.Text;
ls["TongCong"] = tbThanhTien.Text;
ls["MaChiNhanh"] = donhang["MaChiNhanh"];
dslichsu.Rows.Add(ls);
XuLyDuLieu.ghiBang("DonHang", dsdonhang);
XuLyDuLieu.ghiBang("LichSuMua", dslichsu);
}
else
{
MessageBox.Show("chon Chi Nhanh", "Thong Bao", MessageBoxButtons.OK);
}
}
private void button6_Click(object sender, EventArgs e)
{
if (dgvKhach.SelectedRows.Count > 0)
{
DataRow k = ((DataRowView)dgvKhach.SelectedRows[0].DataBoundItem).Row;
k.Delete();
XuLyDuLieu.ghiBang("Khach", dskhach);
}
}
private void button3_Click_1(object sender, EventArgs e)
{
if (dgvChiNhanh.SelectedRows.Count > 0)
{
DataRow cn = ((DataRowView)dgvChiNhanh.SelectedRows[0].DataBoundItem).Row;
cn.Delete();
XuLyDuLieu.ghiBang("ChiNhanh", dsChiNhanh);
}
}
private void button6_Click(object sender, EventArgs e)
{
if (dgvBan.SelectedRows.Count > 0)
{
DataRow cn = ((DataRowView)dgvBan.SelectedRows[0].DataBoundItem).Row;
cn.Delete();
XuLyDuLieu.ghiBang("Ban", dsBan);
}
}
private void button5_Click(object sender, EventArgs e)
{
if (dgvDonHang.SelectedRows.Count > 0)
{
DataRow dh = ((DataRowView)dgvDonHang.SelectedRows[0].DataBoundItem).Row;
dh.Delete();
XuLyDuLieu.ghiBang("DonHang", dsdonhang);
}
}
private void button13_Click_1(object sender, EventArgs e)
{
if (dgvDanhMuc.SelectedRows.Count > 0)
{
DataRow dm = ((DataRowView)dgvDanhMuc.SelectedRows[0].DataBoundItem).Row;
dm.Delete();
XuLyDuLieu.ghiBang("Ban", dsBan);
}
}
private void button8_Click_2(object sender, EventArgs e)
{
if (dgvMonAn.SelectedRows.Count > 0)
{
DataRow ma = ((DataRowView)dgvMonAn.SelectedRows[0].DataBoundItem).Row;
ma.Delete();
XuLyDuLieu.ghiBang("MonAn", dsMonAn);
}
}
private void button2_Click_1(object sender, EventArgs e)
{
DataRow kh = dskhach.NewRow();
kh["SoDienThoai"] = tbSDT.Text;
kh["DiaChi"] = tbDiaChi.Text;
kh["Loai"] = cbLoai.Text;
dskhach.Rows.Add(kh);
XuLyDuLieu.ghiBang("Khach", dskhach);
}
private void btTao_Click(object sender, EventArgs e)
{
DataRow kh = dskhach.NewRow();
kh["SoDienThoai"] = tbSoDienThoai.Text;
kh["DiaChi"] = tbDiaChi.Text;
kh["Loai"] = "NorMal";
dskhach.Rows.Add(kh);
XuLyDuLieu.ghiBang("Khach", dskhach);
}
private void button1_Click_1(object sender, EventArgs e)
{
DataRow cn = dsChiNhanh.NewRow();
cn["MaChiNhanh"] = tbMaChiNhanh.Text;
cn["TenChiNhanh"] = tbTenChiNhanh.Text;
cn["SDTChiNhanh"] = tbDienThoai.Text;
cn["DiaChiChiNhanh"] = tbDiaChi.Text;
cn["TinhThanh"] = tbTinhThanh.Text;
dsChiNhanh.Rows.Add(cn);
XuLyDuLieu.ghiBang("ChiNhanh", dsChiNhanh);
}
private void btNhap_Click(object sender, EventArgs e)
{
DataRow cp = dsChiPhi.NewRow();
dsChiPhi.Rows.Add(cp);
cp["Ngay"] = tbNgay.Text;
cp["Thang"] = tbThang.Text;
cp["Nam"] = tbNam.Text;
cp["ChiPhiPhatSinh"] = tbChiPhi.Text;
XuLyDuLieu.ghiBang("ChiPhiPhatSinh", dsChiPhi);
MessageBox.Show("Nhập Thành Công");
}
private void button7_Click(object sender, EventArgs e)
{
if (dgvBan.SelectedRows.Count > 0)
{
DataRow ban = ((DataRowView)dgvBan.SelectedRows[0].DataBoundItem).Row;
ban["BMa"] = tbMaBan.Text;
ban["BTen"] = tbTenBan.Text;
XuLyDuLieu.ghiBang("ChiNhanh", dsChiNhanh);
}
else
{
MessageBox.Show("Chua Chon Chi Nhanh", "Thong Bao", MessageBoxButtons.OK);
}
}
private void button9_Click(object sender, EventArgs e)
{
if (dgvMonAn.SelectedRows.Count > 0)
{
DataRow monan = ((DataRowView)dgvMonAn.SelectedRows[0].DataBoundItem).Row;
monan["Mama"] = tbMaMonAn.Text;
monan["Gia"] = tbGia.Text;
monan["GhiChu"] = tbTenMonAn.Text;
XuLyDuLieu.ghiBang("ChiNhanh", dsChiNhanh);
}
else
{
MessageBox.Show("Chua Chon Chi Nhanh", "Thong Bao", MessageBoxButtons.OK);
}
}
private void button12_Click_1(object sender, EventArgs e)
{
if (dgvChiNhanh.SelectedRows.Count > 0)
{
DataRow cn = ((DataRowView)dgvChiNhanh.SelectedRows[0].DataBoundItem).Row;
DataRow dm = dsDanhMuc.NewRow();
dm["MaDanhMuc"] = tbMaDanhMuc.Text;
dm["TenDanhMuc"] = tbTenDanhMuc.Text;
dm["MaChiNhanh"] = cn["MaChiNhanh"];
dsDanhMuc.Rows.Add(dm);
XuLyDuLieu.ghiBang("DanhMuc", dsDanhMuc);
}
else
{
MessageBox.Show("chon Chi Nhanh", "Thong Bao", MessageBoxButtons.OK);
}
}
private void button1_Click(object sender, EventArgs e)
{
if (dgvChiNhanh.SelectedRows.Count > 0)
{
DataRow cn = ((DataRowView)dgvChiNhanh.SelectedRows[0].DataBoundItem).Row;
cn["TenChiNhanh"] = tbTenChiNhanh.Text;
cn["SDTChiNhanh"] = tbDienThoai.Text;
cn["DiaChiChiNhanh"] = tbDiaChi.Text;
cn["MaChiNhanh"] = tbMaChiNhanh.Text;
cn["TinhThanh"] = tbTinhThanh.Text;
XuLyDuLieu.ghiBang("ChiNhanh", dsChiNhanh);
}
else
{
MessageBox.Show("Chua Chon Chi Nhanh", "Thong Bao", MessageBoxButtons.OK);
}
}
private void button5_Click(object sender, EventArgs e)
{
if (dgvChiNhanh.SelectedRows.Count > 0)
{
DataRow cn = ((DataRowView)dgvChiNhanh.SelectedRows[0].DataBoundItem).Row;
DataRow monan = dsMonAn.NewRow();
monan["Mama"] = tbMaMonAn.Text;
monan["Gia"] = tbGia.Text;
monan["GhiChu"] = tbTenMonAn.Text;
monan["MaCN"] = cn["CNMa"];
dsMonAn.Rows.Add(monan);
XuLyDuLieu.ghiBang("MonAn", dsMonAn);
}
else
{
MessageBox.Show("chon Chi Nhanh", "Thong Bao", MessageBoxButtons.OK);
}
}
private void button2_Click(object sender, EventArgs e)
{
if (dgvChiNhanh.SelectedRows.Count > 0)
{
DataRow cn = ((DataRowView)dgvChiNhanh.SelectedRows[0].DataBoundItem).Row;
DataRow ban = dsBan.NewRow();
ban["MaBan"] = tbMaBan.Text;
ban["TenBan"] = tbTenBan.Text;
ban["MaChiNhanh"] = cn["MaChiNhanh"];
ban["TrangThai"] = tbTrangThai.Text;
dsBan.Rows.Add(ban);
XuLyDuLieu.ghiBang("Ban", dsBan);
}
else
{
MessageBox.Show("chon Chi Nhanh", "Thong Bao", MessageBoxButtons.OK);
}
}
private void btDonHang_Click(object sender, EventArgs e)
{
if (tbMaDonHang.Text != "" || tbSoDienThoai.Text != "" || tbDiaChi.Text != "")
{
DataRow donhang = dsDonHang.NewRow();
dsDonHang.Rows.Add(donhang);
donhang["MaDonHang"] = tbMaDonHang.Text;
donhang["MaChiNhanh"] = cbChiNhanh.SelectedValue;
donhang["SoDienThoai"] = tbSoDienThoai.Text;
donhang["DiaChi"] = tbDiaChi.Text;
donhang["ThoiDiem"] = dtpNgayMua.Text;
donhang["TrangThai"] = "Chưa Thanh Toán";
donhang["Loai"] = "1";
XuLyDuLieu.ghiBang("DonHang", dsDonHang);
}
else
{
MessageBox.Show("Bạn Chưa Nhập Đủ Thông Tin", "Thông Báo", MessageBoxButtons.OK);
}
}
