private void btnXoaNV_Click(object sender, EventArgs e)
{
using (SHOPHOATHUTRANGEntities1 quanli = new SHOPHOATHUTRANGEntities1())
{
quanli.deleteNV(manv);
quanli.SaveChanges();
MessageBox.Show("Da xoa");
Nhân_viên_Load(sender, e);
}
}
private void guna2Button6_Click(object sender, EventArgs e)
{
using (SHOPHOATHUTRANGEntities1 quanli = new SHOPHOATHUTRANGEntities1())
{
quanli.deleteNCC(mancc);
quanli.SaveChanges();
MessageBox.Show("Da xoa");
Nhà_cung_cấp_Load(sender, e);
}
}
private void guna2Button4_Click(object sender, EventArgs e)
{
if (!kiemtra())
{
return;
}
using (SHOPHOATHUTRANGEntities1 quanli = new SHOPHOATHUTRANGEntities1())
{
quanli.insertNHACUNGCAP(txtTNCC.Text, txtDCNCC.Text, txtSDTNCC.Text, int.Parse(txtGN.Text), int.Parse(txtSLN.Text), dtpkNNNCC.Value, int.Parse(txtTT.Text));
quanli.SaveChanges();
MessageBox.Show("Thêm thành công!", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
Nhà_cung_cấp_Load(sender, e);
}
}
private void bntTemKH_Click(object sender, EventArgs e)
{
if (!kiemtra())
{
return;
}
using (SHOPHOATHUTRANGEntities1 quanli = new SHOPHOATHUTRANGEntities1())
{
quanli.insertKhachHang(txtTKH.Text, txtDCKH.Text, txtSDTKH.Text, dtpkNSKH.Value);
quanli.SaveChanges();
MessageBox.Show("Thêm thành công!", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
Form2_Load(sender, e);
}
}
private void btnThemNV_Click(object sender, EventArgs e)
{
if (!kiemtra())
{
return;
}
using (SHOPHOATHUTRANGEntities1 quanli = new SHOPHOATHUTRANGEntities1())
{
quanli.insertNhanvien(txtTNV.Text, int.Parse(txtSGL.Text), txtDCNV.Text, int.Parse(txtLuong.Text), txtSDTNV.Text, cbGTNV.Text);
quanli.SaveChanges();
MessageBox.Show("Thêm!");
Nhân_viên_Load(sender, e);
}
}
private void bntSuaKH_Click(object sender, EventArgs e)
{
if (makh == "")
{
MessageBox.Show("Hãy chọn khách hàng cần sửa!", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
return;
}
using (SHOPHOATHUTRANGEntities1 quanli = new SHOPHOATHUTRANGEntities1())
{
KHACHHANG kh = quanli.KHACHHANG.FirstOrDefault(p => p.MAKH == makh);
kh.TENKH = txtTKH.Text;
kh.DIACHI = txtDCKH.Text;
kh.SDT = txtSDTKH.Text;
kh.NGAYSINH = dtpkNSKH.Value;
quanli.SaveChanges();
MessageBox.Show("Sửa thành công", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
Form2_Load(sender, e);
}
}
private void btnSuaNV_Click(object sender, EventArgs e)
{
if (manv == "")
{
MessageBox.Show("Hãy chọn nhân viên cần sửa!");
return;
}
using (SHOPHOATHUTRANGEntities1 quanli = new SHOPHOATHUTRANGEntities1())
{
NHANVIEN nv = quanli.NHANVIEN.FirstOrDefault(p => p.MANV == manv);
nv.TENNV = txtTNV.Text;
nv.DIACHI = txtDCNV.Text;
nv.GIOITINH = cbGTNV.Text;
nv.LUONG = int.Parse(txtLuong.Text);
nv.SOGIOLAM = int.Parse(txtSGL.Text);
nv.SDT = txtSDTNV.Text;
quanli.SaveChanges();
MessageBox.Show("Sua thanh cong!");
Nhân_viên_Load(sender, e);
}
}
private void btnSua_Click(object sender, EventArgs e)
{
if (mancc == "")
{
MessageBox.Show("Hãy chọn nhà cung cấp cần sửa!");
return;
}
using (SHOPHOATHUTRANGEntities1 quanli = new SHOPHOATHUTRANGEntities1())
{
NHACUNGCAP ncc = quanli.NHACUNGCAP.FirstOrDefault(p => p.MANCC == mancc);
ncc.TENNCC = txtTNCC.Text;
ncc.DIACHI = txtDCNCC.Text;
ncc.SDT = txtSDTNCC.Text;
ncc.GIANHAP = int.Parse(txtGN.Text);
ncc.SOLUONGNHAP = int.Parse(txtSLN.Text);
ncc.TONGTIEN = int.Parse(txtTT.Text);
ncc.NGAYNHAP = dtpkNNNCC.Value;
quanli.SaveChanges();
MessageBox.Show("Sửa thành công", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
Nhà_cung_cấp_Load(sender, e);
}
}