private void btnPN_ThemMoiHang_Click(object sender, EventArgs e)
{
int id = ctPhieuNhap.id_phieunhap;
int masp = Convert.ToInt32(txtPN_MaHang.Text);
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
CT_PHIEUNHAP ctphieunhap = db.CT_PHIEUNHAPs.Where(n => n.id_phieunhap == id && n.id_hanghoa == masp).SingleOrDefault();
if (ctphieunhap != null)
{
MessageBox.Show("Sản phẩm đã tồn tại trong đơn . Vui lòng chỉnh lại số lượng .");
}
else
{
ctPhieuNhap.id_hanghoa = masp;
int sl = txtPN_SoLuongNhap.Text == null ? 0 : Convert.ToInt32(txtPN_SoLuongNhap.Text);
ctPhieuNhap.soluongnhap = sl;
ctPhieuNhap.gianhap = txtPN_GiaNhap.Text == null ? 500000 : Convert.ToInt32(txtPN_GiaNhap.Text);
HANGHOA sp = db.HANGHOAs.Where(n => n.id_hanghoa == masp).SingleOrDefault();
sp.soluongton += sl;
db.CT_PHIEUNHAPs.InsertOnSubmit(ctPhieuNhap);
db.SubmitChanges();
MessageBox.Show("Thêm thành công");
}
}
}
private void btnSuaHang_Click(object sender, EventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
int idPX = (int)grvXuatHang.SelectedCells[0].OwningRow.Cells["IDDONHANG"].Value;
int idSP = (int)grvCTXuatHang.SelectedCells[0].OwningRow.Cells["IDSANPHAM"].Value;
CT_PHIEUXUAT ct = (from ctpx in db.CT_PHIEUXUATs where ctpx.id_hanghoa == idSP && ctpx.id_phieuxuat == idPX select ctpx).SingleOrDefault();
HANGHOA sp = db.HANGHOAs.Single(n => n.id_hanghoa == idSP);
if (txtSoLuongMua.Text == "")
{
ct.soluongxuat = 1;
}
else
{
string a = txtSoLuongMua.Text;
int sl = Convert.ToInt32(a);
if (sl > sp.soluongton)
{
MessageBox.Show("Số lượng quá lớn so với lượng hàng còn");
}
else
{
ct.soluongxuat = sl;
sp.soluongton -= sl;
db.SubmitChanges();
MessageBox.Show("Sửa Thành Công .");
}
}
}
LoadXuatHang();
}
private void btnTimKiemNCC_Click(object sender, EventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
grvNhaCC.DataSource = from ncc in db.NHACUNGCAPs where ncc.tennhacungcap.Contains(txtTimKiemNCC.Text) select ncc;
}
}
//Nhà cung cấp
public void LoadNhaCungCap()
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
grvNhaCC.DataSource = from ncc in db.NHACUNGCAPs select ncc;
}
}
private void grvXuatHang_CellClick(object sender, DataGridViewCellEventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
cbbPX_NHANVIEN.DataSource = db.NHANVIENs;
cbbPX_NHANVIEN.DisplayMember = "tennhanvien";
cbbPX_NHANVIEN.ValueMember = "id_nhanvien";
txtIDHoaDon.Text = grvXuatHang.SelectedCells[0].OwningRow.Cells["IDDONHANG"].Value.ToString();
txtTenKH.Text = grvXuatHang.SelectedCells[0].OwningRow.Cells["TENKH"].Value.ToString();
txtSoDT.Text = grvXuatHang.SelectedCells[0].OwningRow.Cells["SODT"].Value.ToString();
txtDiaChi.Text = grvXuatHang.SelectedCells[0].OwningRow.Cells["DIACHIKH"].Value.ToString();
DateTime dt = (DateTime)grvXuatHang.SelectedCells[0].OwningRow.Cells["NGAYXUATHANG"].Value;
cbbPX_NHANVIEN.Text = grvXuatHang.SelectedCells[0].OwningRow.Cells["TENNV"].Value.ToString();
dtpNgayXuat.Value = dt;
int id = (int)grvXuatHang.SelectedCells[0].OwningRow.Cells["IDDONHANG"].Value;
grvCTXuatHang.DataSource = from xh in db.PHIEUXUATs
from sp in db.HANGHOAs
from ctpx in db.CT_PHIEUXUATs
where xh.id_phieuxuat == ctpx.id_phieuxuat && ctpx.id_hanghoa == sp.id_hanghoa && xh.id_phieuxuat == id
select new
{
IDSANPHAM = sp.id_hanghoa,
TENSANPHAM = sp.tenhanghoa,
SOLUONG = ctpx.soluongxuat,
DGIA = sp.giaban,
DVTINH = sp.donvitinh,
THANHTIEN = Convert.ToInt32(sp.giaban) * ctpx.soluongxuat
};
}
}
private void grvNhapHang_CellClick(object sender, DataGridViewCellEventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
cbbNhapHangNCC.DataSource = db.NHACUNGCAPs;
cbbNhapHangNCC.DisplayMember = "tennhacungcap";
cbbNhapHangNCC.ValueMember = "id_nhacungcap";
cbbNhapHangNV.DataSource = db.NHANVIENs;
cbbNhapHangNV.DisplayMember = "tennhanvien";
cbbNhapHangNV.ValueMember = "id_nhanvien";
txtIDHDNHAP.Text = grvNhapHang.SelectedCells[0].OwningRow.Cells["idPhieuNhap"].Value.ToString();
cbbNhapHangNCC.Text = grvNhapHang.SelectedCells[0].OwningRow.Cells["PN_NCC"].Value.ToString();
DateTime dt = (DateTime)grvNhapHang.SelectedCells[0].OwningRow.Cells["PN_NgayNhap"].Value;
dtpNhapHangNgayNhap.Value = dt;
cbbNhapHangNV.Text = grvNhapHang.SelectedCells[0].OwningRow.Cells["PN_NhanVien"].Value.ToString();
int id = (int)grvNhapHang.SelectedCells[0].OwningRow.Cells["idPhieuNhap"].Value;
grvCHITIETNHAPHANG.DataSource = from ctnh in db.CT_PHIEUNHAPs
from sp in db.HANGHOAs
where ctnh.id_phieunhap == id && ctnh.id_hanghoa == sp.id_hanghoa
select new
{
id_SanPham = sp.id_hanghoa,
CTPN_TenSP = sp.tenhanghoa,
CTPN_SoLuong = ctnh.soluongnhap,
CTPN_GiaNhap = ctnh.gianhap
};
}
}
private void grvPN_KQTimKiem_CellClick(object sender, DataGridViewCellEventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
txtPN_MaHang.Text = grvPN_KQTimKiem.SelectedCells[0].OwningRow.Cells["ID"].Value.ToString();
txtPN_TenHang.Text = grvPN_KQTimKiem.SelectedCells[0].OwningRow.Cells["TenSanPham"].Value.ToString();
}
}
private void grvNhanVien_CellClick(object sender, DataGridViewCellEventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
txtTenNhanVien.Text = grvNhanVien.SelectedCells[0].OwningRow.Cells["tennhanvien"].Value.ToString();
txtDiaChiNV.Text = grvNhanVien.SelectedCells[0].OwningRow.Cells["diachinhanvien"].Value.ToString();
txtTaiKhoan.Text = grvNhanVien.SelectedCells[0].OwningRow.Cells["taikhoan"].Value.ToString();
txtMatKhau.Text = grvNhanVien.SelectedCells[0].OwningRow.Cells["matkhau"].Value.ToString();
}
}
private void btnXoaNCC_Click(object sender, EventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
int id = (int)grvNhaCC.SelectedCells[0].OwningRow.Cells["id_nhacungcap"].Value;
NHACUNGCAP nhacc = db.NHACUNGCAPs.Where(n => n.id_nhacungcap == id).SingleOrDefault();
db.NHACUNGCAPs.DeleteOnSubmit(nhacc);
db.SubmitChanges();
}
LoadNhaCungCap();
}
private void btnPN_TimKiem_Click(object sender, EventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
grvPN_KQTimKiem.DataSource = from sp in db.HANGHOAs select new {
ID = sp.id_hanghoa,
TenSanPham = sp.tenhanghoa,
SoLuongTon = sp.soluongton
};
}
}
public void LoadSanPham()
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
grvPN_KQTimKiem.DataSource = from sp in db.HANGHOAs where sp.id_nhacungcap == idNCC
select new {
ID = sp.id_hanghoa,
TenSanPham = sp.tenhanghoa,
SoLuongTon = sp.soluongton
};
}
}
private void btnXoaNV_Click(object sender, EventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
int id = (int)grvNhanVien.SelectedCells[0].OwningRow.Cells["id_nhanvien"].Value;
NHANVIEN nv = db.NHANVIENs.Where(n => n.id_nhanvien == id).SingleOrDefault();
db.NHANVIENs.DeleteOnSubmit(nv);
db.SubmitChanges();
MessageBox.Show("Xóa Thành Công");
}
LoadNhanVien();
}
//Chi Tiết Phiếu Xuất Hàng
private void btnThemHang_Click(object sender, EventArgs e)
{
int idDH;
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
idDH = (int)grvXuatHang.SelectedCells[0].OwningRow.Cells["IDDONHANG"].Value;
}
frmXuatHang xuathang = new frmXuatHang(idDH);
xuathang.ShowDialog();
}
private void btnXoa_Click(object sender, EventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
string id = grvSanPham.SelectedCells[0].OwningRow.Cells["id_sp"].Value.ToString();
int idSP = Convert.ToInt32(id);
HANGHOA sp = db.HANGHOAs.Where(n => n.id_hanghoa == idSP).SingleOrDefault();
db.HANGHOAs.DeleteOnSubmit(sp);
db.SubmitChanges();
}
LoadSanPham();
}
private void btnSuaNCC_Click(object sender, EventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
int id = (int)grvNhaCC.SelectedCells[0].OwningRow.Cells["id_nhacungcap"].Value;
NHACUNGCAP nhacc = db.NHACUNGCAPs.Where(n => n.id_nhacungcap == id).SingleOrDefault();
nhacc.tennhacungcap = txtTenNCC.Text;
nhacc.diachi = txtDiaChiNCC.Text;
db.SubmitChanges();
MessageBox.Show("Thành Công");
}
LoadNhaCungCap();
}
private void btnThemNCC_Click(object sender, EventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
NHACUNGCAP nhacc = new NHACUNGCAP();
nhacc.tennhacungcap = txtTenNCC.Text;
nhacc.diachi = txtDiaChiNCC.Text;
db.NHACUNGCAPs.InsertOnSubmit(nhacc);
db.SubmitChanges();
MessageBox.Show("Thành Công");
}
LoadNhaCungCap();
}
//CT_Phiếu nhập :
private void btnCTPN_ThemHang_Click(object sender, EventArgs e)
{
int idDH, idNCC;
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
idDH = (int)grvNhapHang.SelectedCells[0].OwningRow.Cells["idPhieuNhap"].Value;
idNCC = (int)cbbNhapHangNCC.SelectedValue;
}
frmPN_ThemHang themhang = new frmPN_ThemHang(idDH, idNCC);
themhang.ShowDialog();
}
private void btnXoaHang_Click(object sender, EventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
int idPX = (int)grvXuatHang.SelectedCells[0].OwningRow.Cells["IDDONHANG"].Value;
int idSP = (int)grvCTXuatHang.SelectedCells[0].OwningRow.Cells["IDSANPHAM"].Value;
CT_PHIEUXUAT ct = (from ctpx in db.CT_PHIEUXUATs where ctpx.id_hanghoa == idSP && ctpx.id_phieuxuat == idPX select ctpx).SingleOrDefault();
db.CT_PHIEUXUATs.DeleteOnSubmit(ct);
db.SubmitChanges();
MessageBox.Show("Xóa Thành Công");
}
LoadXuatHang();
}
private void btnXoaHD_Click(object sender, EventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
int idPX = (int)grvXuatHang.SelectedCells[0].OwningRow.Cells["IDDONHANG"].Value;
PHIEUXUAT px = db.PHIEUXUATs.Where(n => n.id_phieuxuat == idPX).SingleOrDefault();
var delete = db.CT_PHIEUXUATs.Where(n => n.id_phieuxuat == idPX);
db.CT_PHIEUXUATs.DeleteAllOnSubmit(delete);
db.SubmitChanges();
db.PHIEUXUATs.DeleteOnSubmit(px);
db.SubmitChanges();
}
LoadXuatHang();
}
private void btnPN_SuaHD_Click(object sender, EventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
int id = (int)grvNhapHang.SelectedCells[0].OwningRow.Cells["idPhieuNhap"].Value;
PHIEUNHAP _pn = db.PHIEUNHAPs.Where(n => n.id_phieunhap == id).SingleOrDefault();
_pn.id_nhacungcap = (int)cbbNhapHangNCC.SelectedValue;
_pn.id_nhanvien = (int)cbbNhapHangNV.SelectedValue;
_pn.ngaynhap = dtpNhapHangNgayNhap.Value;
db.SubmitChanges();
MessageBox.Show("Thành Công");
}
LoadNhapHang();
}
//Phiếuu nhập :
private void btnPN_ThemHD_Click(object sender, EventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
PHIEUNHAP phieuNhap = new PHIEUNHAP();
phieuNhap.ngaynhap = dtpNhapHangNgayNhap.Value;
phieuNhap.id_nhacungcap = (int)cbbNhapHangNCC.SelectedValue;
phieuNhap.id_nhanvien = (int)cbbNhapHangNV.SelectedValue;
db.PHIEUNHAPs.InsertOnSubmit(phieuNhap);
db.SubmitChanges();
MessageBox.Show("Thành Công");
}
LoadNhapHang();
}
private void btnThemMoiHang_Click(object sender, EventArgs e)
{
int id = ctphieuxuat.id_phieuxuat;
int idhh = Convert.ToInt32(txtMaHang.Text);
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
CT_PHIEUXUAT ctpx1 = db.CT_PHIEUXUATs.Where(n => n.id_phieuxuat == id && n.id_hanghoa == idhh).SingleOrDefault();
HANGHOA sp = db.HANGHOAs.Where(n => n.id_hanghoa == idhh).SingleOrDefault();
if (ctpx1 != null)
{
MessageBox.Show("Sản phẩm đã tồn tại trong đơn . Vui lòng chỉnh lại số lượng .");
}
else
{
// ctphieuxuat.id_hanghoa = Convert.ToInt32(txtMaHang.Text);
string a = txtSoLuongMua.Text;
if (a == "")
{
ctphieuxuat.id_hanghoa = idhh;
ctphieuxuat.soluongxuat = 1;
sp.soluongton -= 1;
db.CT_PHIEUXUATs.InsertOnSubmit(ctphieuxuat);
db.SubmitChanges();
MessageBox.Show("Thêm thành công");
}
else
{
int sl = Convert.ToInt32(a);
if (sl > sp.soluongton)
{
MessageBox.Show("Số lượng quá lớn so với lượng hàng còn");
}
else
{
ctphieuxuat.id_hanghoa = idhh;
ctphieuxuat.soluongxuat = sl;
sp.soluongton -= sl;
db.CT_PHIEUXUATs.InsertOnSubmit(ctphieuxuat);
db.SubmitChanges();
MessageBox.Show("Thêm thành công");
}
}
}
}
//this.Close();
//frmHome f = new frmHome();
//f.Show();
}
private void btnSuaHD_Click(object sender, EventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
int idPX = (int)grvXuatHang.SelectedCells[0].OwningRow.Cells["IDDONHANG"].Value;
PHIEUXUAT px = db.PHIEUXUATs.Where(n => n.id_phieuxuat == idPX).SingleOrDefault();
px.TenKH = txtTenKH.Text;
px.SoDT = txtSoDT.Text;
px.DiaChiKH = txtDiaChi.Text;
px.ngayxuat = dtpNgayXuat.Value;
px.id_nhanvien = (int)cbbPX_NHANVIEN.SelectedValue;
db.SubmitChanges();
}
LoadXuatHang();
}
private void btnSuaNV_Click(object sender, EventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
int id = (int)grvNhanVien.SelectedCells[0].OwningRow.Cells["id_nhanvien"].Value;
NHANVIEN nv = db.NHANVIENs.Where(n => n.id_nhanvien == id).SingleOrDefault();
nv.tennhanvien = txtTenNhanVien.Text;
nv.diachi = txtDiaChiNV.Text;
nv.taikhoan = txtTaiKhoan.Text;
nv.matkhau = txtMatKhau.Text;
db.SubmitChanges();
MessageBox.Show("Thành công");
}
LoadNhanVien();
}
private void grvSanPham_CellClick(object sender, DataGridViewCellEventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
cbnNhaCC.DataSource = db.NHACUNGCAPs;
cbnNhaCC.DisplayMember = "tennhacungcap";
cbnNhaCC.ValueMember = "id_nhacungcap";
txtTenSP.Text = grvSanPham.SelectedCells[0].OwningRow.Cells["tensp"].Value.ToString();
cbnNhaCC.Text = grvSanPham.SelectedCells[0].OwningRow.Cells["tenncc"].Value.ToString();
txtMota.Text = grvSanPham.SelectedCells[0].OwningRow.Cells["Mota"].Value == null ? null : grvSanPham.SelectedCells[0].OwningRow.Cells["Mota"].Value.ToString();
txtSoLuong.Text = grvSanPham.SelectedCells[0].OwningRow.Cells["sluong"].Value == null ? null : grvSanPham.SelectedCells[0].OwningRow.Cells["sluong"].Value.ToString();
txtGiaBan.Text = grvSanPham.SelectedCells[0].OwningRow.Cells["Dongia"].Value == null ? null : grvSanPham.SelectedCells[0].OwningRow.Cells["Dongia"].Value.ToString();
txtDonVT.Text = grvSanPham.SelectedCells[0].OwningRow.Cells["donvt"].Value == null ? null : grvSanPham.SelectedCells[0].OwningRow.Cells["donvt"].Value.ToString();
}
}
private void btnCTPN_XoaHang_Click(object sender, EventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
int idPN = (int)grvNhapHang.SelectedCells[0].OwningRow.Cells["idPhieuNhap"].Value;
int idSP = (int)grvCHITIETNHAPHANG.SelectedCells[0].OwningRow.Cells["id_SanPham"].Value;
CT_PHIEUNHAP ctpn = db.CT_PHIEUNHAPs.Where(n => n.id_phieunhap == idPN && n.id_hanghoa == idSP).SingleOrDefault();
int sl = Convert.ToInt32(txtCTNH_SoLuong.Text);
HANGHOA sp = db.HANGHOAs.Single(n => n.id_hanghoa == idSP);
sp.soluongton -= sl;
db.CT_PHIEUNHAPs.DeleteOnSubmit(ctpn);
db.SubmitChanges();
MessageBox.Show("Xóa Thành Công ");
}
}
private void btnPN_XoaHD_Click(object sender, EventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
int id = (int)grvNhapHang.SelectedCells[0].OwningRow.Cells["idPhieuNhap"].Value;
PHIEUNHAP _pn = db.PHIEUNHAPs.Where(n => n.id_phieunhap == id).SingleOrDefault();
var delete = from ctpn in db.CT_PHIEUNHAPs where ctpn.id_phieunhap == id select ctpn;
db.CT_PHIEUNHAPs.DeleteAllOnSubmit(delete);
db.SubmitChanges();
db.PHIEUNHAPs.DeleteOnSubmit(_pn);
db.SubmitChanges();
MessageBox.Show("Thành Công");
}
LoadNhapHang();
}
private void btnTimKiemNV_Click(object sender, EventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
grvNhanVien.DataSource = from nv in db.NHANVIENs
where nv.tennhanvien.Contains(txtTimKiemNV.Text)
select new
{
id_nhanvien = nv.id_nhanvien,
tennhanvien = nv.tennhanvien,
diachi = nv.diachi,
taikhoan = nv.taikhoan,
matkhau = nv.matkhau
};
}
}
private void btnThemNV_Click(object sender, EventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
NHANVIEN nv = new NHANVIEN();
nv.tennhanvien = txtTenNhanVien.Text;
nv.diachi = txtDiaChiNV.Text;
nv.taikhoan = txtTaiKhoan.Text;
nv.matkhau = txtMatKhau.Text;
nv.id_loainv = 2;
db.NHANVIENs.InsertOnSubmit(nv);
db.SubmitChanges();
MessageBox.Show("Thành Công");
}
LoadNhanVien();
}
//Phiếu Xuất Hàng
private void btnThemHD_Click(object sender, EventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
PHIEUXUAT px = new PHIEUXUAT();
px.ngayxuat = dtpNgayXuat.Value;
px.TenKH = txtTenKH.Text;
px.DiaChiKH = txtDiaChi.Text;
px.SoDT = txtSoDT.Text;
px.id_nhanvien = (int)cbbPX_NHANVIEN.SelectedValue;
db.PHIEUXUATs.InsertOnSubmit(px);
db.SubmitChanges();
MessageBox.Show("Thêm Thành Công ");
}
LoadXuatHang();
}
