private void btnTimkiemNV_Click(object sender, EventArgs e)
{
using (SHOPHOATHUTRANGEntities1 quanli = new SHOPHOATHUTRANGEntities1())
{
dgvNV.DataSource = quanli.NHANVIEN.Where(p => p.MANV.Contains(txtTKKNV.Text.Trim())).ToList();
MessageBox.Show("Tìm kiếm thành công", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
}
}
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 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 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 dgvKH_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
makh = dgvKH.CurrentRow.Cells[0].Value.ToString();
txtTKH.Text = dgvKH.CurrentRow.Cells[1].Value.ToString();
txtDCKH.Text = dgvKH.CurrentRow.Cells[2].Value.ToString();
txtSDTKH.Text = dgvKH.CurrentRow.Cells[3].Value.ToString();
dtpkNSKH.Value = Convert.ToDateTime(dgvKH.CurrentRow.Cells[4].Value.ToString());
if (e.ColumnIndex == 5)
{
if (MessageBox.Show("Bạn có muốn xóa nhà khách hàng không ?", "xóa", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
using (SHOPHOATHUTRANGEntities1 quanli = new SHOPHOATHUTRANGEntities1())
{
quanli.deleteKH(makh);
MessageBox.Show("đã xóa", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
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);
}
}
private void Hóa_đơn_Load(object sender, EventArgs e)
{
using (SHOPHOATHUTRANGEntities1 quanli = new SHOPHOATHUTRANGEntities1())
{
var result = from hd in quanli.HOADON
join kh in quanli.KHACHHANG on hd.MAKH equals kh.MAKH
join CTHD in quanli.CTHOADON on hd.MAHD equals CTHD.MAHD
join nv in quanli.NHANVIEN on hd.MANV equals nv.MANV
select new
{
kh.MAKH,
kh.TENKH,
kh.DIACHI,
kh.SDT,
hd.NGAYLAPHD,
nv.TENNV,
CTHD.GIABAN,
CTHD.SOLUONGBAN,
hd.TONGTIEN,
};
dgvHD.DataSource = result.ToList();
}
}
