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); } }