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