public bool Them(int maKH, string tenKH, DateTime ngaySinhKH, string gioiTinh,
string email, string diaChi, string soDT, string loaiKH, string chuThich)
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
int maloaiKH = GetLoaiKH(loaiKH);
var kiemTraKH = db.KhachHangs.Where(p => p.Email.Equals(email) || p.SDT.Equals(soDT));
if (kiemTraKH.Count() <= 0)
{
KhachHang KhachHangNew = new KhachHang();
KhachHangNew.MaKhachHang = maKH;
KhachHangNew.TenKhachHang = tenKH;
KhachHangNew.Ngaysinh = ngaySinhKH;
KhachHangNew.GioiTinh = gioiTinh;
KhachHangNew.Email = email;
KhachHangNew.DiaChi = diaChi;
KhachHangNew.SDT = soDT;
KhachHangNew.LoaiKhachHang = maloaiKH;
KhachHangNew.GhiChu = chuThich;
db.KhachHangs.InsertOnSubmit(KhachHangNew);
db.SubmitChanges();
return(true);
}
else
{
return(false);
}
}
}
public void Them(int maHSX, string tenHSX)
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
HangSanXuat hangSX = new HangSanXuat();
hangSX.MaHangSanXuat = maHSX;
hangSX.TenHangSanXuat = tenHSX;
db.HangSanXuats.InsertOnSubmit(hangSX);
db.SubmitChanges();
}
}
public void Them(int maLSP, string tenLSP)
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
LoaiSanPham loaiSP = new LoaiSanPham();
//loaiSP.MaLoaiSanPham = maLSP;
loaiSP.TenLoaiSanPham = tenLSP;
db.LoaiSanPhams.InsertOnSubmit(loaiSP);
db.SubmitChanges();
//MessageBox.Show( loaiSP.MaLoaiSanPham.ToString());
}
}
public void Sua(int maLSP, string tenLSP)
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
LoaiSanPham loaiSP = db.LoaiSanPhams.Where(p => p.MaLoaiSanPham == maLSP).SingleOrDefault();
if (loaiSP != null)
{
loaiSP.TenLoaiSanPham = tenLSP;
db.SubmitChanges();
}
}
}
public void Sua(int ma, string ten)
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
HangSanXuat hangSX = db.HangSanXuats.Where(p => p.MaHangSanXuat == ma).SingleOrDefault();
if (hangSX != null)
{
hangSX.TenHangSanXuat = ten;
db.SubmitChanges();
}
}
}
public void TaoTaiKhoan(int maNV, string taiKhoan, string matKhau, string quyen)
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
int maQuyen = GetQuyen(quyen);
User newUser = new User();
newUser.MaNhanVien = maNV;
newUser.TenDangNhap = taiKhoan;
newUser.Password = matKhau;
newUser.Quyen = maQuyen;
db.Users.InsertOnSubmit(newUser);
db.SubmitChanges();
}
}
public void DoiAnh(int MaHH, Image image)
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
HangHoa hangHoa = db.HangHoas.Where(p => p.MaHangHoa == MaHH).SingleOrDefault();
byte[] fileAnh = ImageToByteArray(image);
if (hangHoa != null)
{
hangHoa.Image = fileAnh;
db.SubmitChanges();
}
}
}
public void LapChiTietHoaDon(int maHD, int maHangHoa, int soLuongMua, int tTien, string ghiChu)
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
ChiTietHoaDon chiTietNew = new ChiTietHoaDon();
chiTietNew.MaHoaDon = maHD;
chiTietNew.MaHangHoa = maHangHoa;
chiTietNew.SoLuong = soLuongMua;
chiTietNew.TongTien = tTien;
chiTietNew.GhiChu = ghiChu;
db.ChiTietHoaDons.InsertOnSubmit(chiTietNew);
db.SubmitChanges();
}
}
public void DoiAnh(int MaNV, Image image)
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
NhanVien nhanVien = db.NhanViens.Where(p => p.MaNhanVien == MaNV).SingleOrDefault();
byte[] fileAnh = ImageToByteArray(image);
if (nhanVien != null)
{
nhanVien.Anh = fileAnh;
db.SubmitChanges();
}
}
}
public void CapNhatTongTienPN(int maPN, int ttMoi, string ghiChu)
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
// MessageBox.Show(maNV + "");
PhieuNhap phieuNhap = db.PhieuNhaps.Where(p => p.ID == maPN).SingleOrDefault();
if (phieuNhap != null)
{
// MessageBox.Show(ghiChu + "");
phieuNhap.TongTien = ttMoi;
phieuNhap.GhiChu = ghiChu;
db.SubmitChanges();
}
}
}
public int LapPhieu(int maNV, int TongTien, DateTime ngayLapPhieu)
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
PhieuNhap phieuNhapNew = new PhieuNhap();
phieuNhapNew.NVTao = maNV;
phieuNhapNew.NgayTao = ngayLapPhieu;
phieuNhapNew.TinhTrang = true;
phieuNhapNew.TongTien = TongTien;
db.PhieuNhaps.InsertOnSubmit(phieuNhapNew);
db.SubmitChanges();
return(phieuNhapNew.ID);
}
}
public int LapHoaDon(int maKH, int maNV, int TongTien, DateTime ngayLapHD, string ghiChuHD)
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
HoaDon hoaDonNew = new HoaDon();
hoaDonNew.MaKhachHang = maKH;
hoaDonNew.MaNhanVien = maNV;
hoaDonNew.TongTien = TongTien;
hoaDonNew.NgayLapHoaDon = ngayLapHD;
hoaDonNew.GhiChu = ghiChuHD;
db.HoaDons.InsertOnSubmit(hoaDonNew);
db.SubmitChanges();
return(hoaDonNew.MaHoaDon);
}
}
public bool XoaTaiKhoan(int m_ID)
{
try
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
User taiKhoan = db.Users.Where(p => p.ID == m_ID).SingleOrDefault();
db.Users.DeleteOnSubmit(taiKhoan);
db.SubmitChanges();
return(true);
}
}
catch
{
return(false);
}
}
public bool Xoa(int maLSP)
{
try
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
LoaiSanPham loaiSP = db.LoaiSanPhams.Where(p => p.MaLoaiSanPham == maLSP).SingleOrDefault();
db.LoaiSanPhams.DeleteOnSubmit(loaiSP);
db.SubmitChanges();
return(true);
}
}
catch
{
return(false);
}
}
public void CapNhatSoLuong(int maHH, int tong, int giaMoi)
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
// MessageBox.Show(maNV + "");
HangHoa hangHoa = db.HangHoas.Where(p => p.MaHangHoa == maHH).SingleOrDefault();
if (hangHoa != null)
{
// MessageBox.Show(ghiChu + "");
hangHoa.SoLuongCon = tong;
hangHoa.GiaNhap = giaMoi;
hangHoa.GiaBan = giaMoi + 50000;
db.SubmitChanges();
}
}
}
public void LapChiTietPhieuNhap(int MaPN, int maHangHoa, int soLuongCon, int soLuongNhap, int giaCapNhat, int tTien, string ghiChu, bool tinhTrang)
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
ChiTietPhieuNhap chiTietNew = new ChiTietPhieuNhap();
chiTietNew.MaPhieuNhap = MaPN;
chiTietNew.MaHH = maHangHoa;
chiTietNew.SoLuongCon = soLuongCon;
chiTietNew.SoLuongNhap = soLuongNhap;
chiTietNew.GiaCapNhat = giaCapNhat;
chiTietNew.TongTien = tTien;
chiTietNew.GhiChu = ghiChu;
chiTietNew.TinhTrang = tinhTrang;
db.ChiTietPhieuNhaps.InsertOnSubmit(chiTietNew);
db.SubmitChanges();
}
}
public bool Xoa(int ma)
{
try
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
HangSanXuat hangSX = db.HangSanXuats.Where(p => p.MaHangSanXuat == ma).SingleOrDefault();
db.HangSanXuats.DeleteOnSubmit(hangSX);
db.SubmitChanges();
return(true);
}
}
catch
{
return(false);
}
}
public void LapChiTietHoaDon(int maHD, int maHangHoa, int soLuongMua, int tTien, string ghiChu)
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
int giaNhap = db.HangHoas.Where(p => p.MaHangHoa == maHangHoa).SingleOrDefault().GiaBan;
ChiTietHoaDon chiTietNew = new ChiTietHoaDon();
chiTietNew.MaHoaDon = maHD;
chiTietNew.MaHangHoa = maHangHoa;
chiTietNew.GiaNhap = giaNhap;
chiTietNew.SoLuong = soLuongMua;
chiTietNew.TongTien = tTien;
chiTietNew.GhiChu = ghiChu;
db.ChiTietHoaDons.InsertOnSubmit(chiTietNew);
db.SubmitChanges();
}
}
public bool Xoa(int maHH)
{
try
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
HangHoa delHH = db.HangHoas.Where(p => p.MaHangHoa == maHH).SingleOrDefault();
db.HangHoas.DeleteOnSubmit(delHH);
db.SubmitChanges();
return(true);
}
}
catch
{
return(false);
}
}
public bool Sua(int maNV, string tenNV, string chucVu, DateTime ngaySinh, string gioiTinh, int cmnd,
string email, DateTime ngayVaoLam, DateTime?ngayNghiLam, string diaChi, string soDT, Boolean tinhTrang, string chuThich)
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
// MessageBox.Show(maNV + "");
NhanVien nhanVien = db.NhanViens.Where(p => p.MaNhanVien == maNV).SingleOrDefault();
var kiemTraNV = db.NhanViens.Where(p => p.CMND.Equals(cmnd) || p.Email.Equals(email) || p.SoDT.Equals(soDT));
if (kiemTraNV.Count() <= 1)
{
int maChucVu = GetChucVu(chucVu);
//int maHangSX = GetMaHangSanXuat(hangSanXuat);
if (nhanVien != null)
{
nhanVien.MaNhanVien = maNV;
nhanVien.TenNhanVien = tenNV;
nhanVien.CMND = cmnd;
nhanVien.NgaySinh = ngaySinh;
nhanVien.GioiTinh = gioiTinh;
nhanVien.Email = email;
nhanVien.NgayVaoLam = ngayVaoLam;
nhanVien.NgayNghiLam = ngayNghiLam;
nhanVien.ChucVu = maChucVu;
nhanVien.DiaChi = diaChi;
nhanVien.SoDT = soDT;
nhanVien.TinhTrang = tinhTrang;
nhanVien.GhiChu = chuThich;
nhanVien.Anh = null;;
db.SubmitChanges();
return(true);
}
else
{
MessageBox.Show("null");
return(false);
}
}
else
{
return(false);
}
}
}
public bool Xoa(int maNV)
{
try
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
//MessageBox.Show( "thuc hien xoa");
NhanVien delNV = db.NhanViens.Where(p => p.MaNhanVien == maNV).SingleOrDefault();
db.NhanViens.DeleteOnSubmit(delNV);
db.SubmitChanges();
return(true);
}
}
catch
{
//MessageBox.Show("thuc hien xoa"+ex);
return(false);
}
}
public void SuaTK(int m_ID, int maNV, string tenDN, string m_MK, string quyen, string chuThich, bool tinhTrang)
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
int quyenUS = GetQuyen(quyen);
User editUser = db.Users.Where(p => p.ID.Equals(m_ID)).SingleOrDefault();
if (editUser != null)
{
editUser.ID = m_ID;
editUser.MaNhanVien = maNV;
editUser.TenDangNhap = tenDN;
editUser.Password = m_MK;
editUser.Quyen = quyenUS;
editUser.ChuThich = chuThich;
editUser.TinhTrang = tinhTrang;
db.SubmitChanges();
}
}
}
public void Hien(int maHH)
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
HangHoa editHH = db.HangHoas.Where(p => p.MaHangHoa == maHH).SingleOrDefault();
try
{
if (editHH != null)
{
editHH.TrangThai = true;
db.SubmitChanges();
}
}
catch
{
}
}
}
public bool Xoa(int maKH)
{
try
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
//MessageBox.Show( "thuc hien xoa");
KhachHang delKH = db.KhachHangs.Where(p => p.MaKhachHang == maKH).SingleOrDefault();
db.KhachHangs.DeleteOnSubmit(delKH);
db.SubmitChanges();
return(true);
}
}
catch
{
//MessageBox.Show("thuc hien xoa"+ex);
return(false);
}
}
public bool SuaPhieu(int maPN, int maHH, int giaMoi, string chuThich)
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
// MessageBox.Show(maNV + "");
ChiTietPhieuNhap ctPhieuNhap = db.ChiTietPhieuNhaps.Where(p => p.MaPhieuNhap == maPN && p.MaHH == maHH).SingleOrDefault();
if (ctPhieuNhap != null)
{
ctPhieuNhap.GiaCapNhat = giaMoi;
ctPhieuNhap.GhiChu = chuThich;
db.SubmitChanges();
return(true);
}
else
{
return(false);
}
}
}
public void Them(int maHangHoa, string tenHangHoa, string loaiHangHoa, string hangSanXuat, int giaNhap, int giaBan, int soLuongCon, bool trangThai, string chuThich)
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
int maLoaiHH = GetMaLoaiHH(loaiHangHoa);
int maHangSX = GetMaHangSanXuat(hangSanXuat);
HangHoa hangHoaNew = new HangHoa();
hangHoaNew.MaHangHoa = maHangHoa;
hangHoaNew.TenHangHoa = tenHangHoa;
hangHoaNew.MaLoaiHangHoa = maLoaiHH;
hangHoaNew.MaHangSanXuat = maHangSX;
hangHoaNew.GiaNhap = giaNhap;
hangHoaNew.GiaBan = giaBan;
hangHoaNew.SoLuongCon = soLuongCon;
hangHoaNew.TrangThai = trangThai;
hangHoaNew.ChuThich = chuThich;
hangHoaNew.Image = null;
db.HangHoas.InsertOnSubmit(hangHoaNew);
db.SubmitChanges();
}
}
public bool DoiMatKhau(string tenTK, string nMKCu, string nMKMoi)
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
User editUser = db.Users.Where(p => p.TenDangNhap.Equals(tenTK) &&
p.Password.Equals(nMKCu) &&
p.Quyen != 1).SingleOrDefault();
try
{ if (editUser != null)
{
editUser.Password = nMKMoi;
db.SubmitChanges();
return(true);
}
return(false); }
catch
{
return(false);
}
}
}
public bool Sua(int maKH, string tenKH, DateTime ngaySinhKH, string gioiTinh,
string email, string diaChi, string soDT, string loaiKH, string chuThich)
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
// MessageBox.Show(maNV + "");
KhachHang khachHang = db.KhachHangs.Where(p => p.MaKhachHang == maKH).SingleOrDefault();
var kiemTraNV = db.NhanViens.Where(p => p.Email.Equals(email) || p.SoDT.Equals(soDT));
if (kiemTraNV.Count() <= 1)
{
int maloaiKH = GetLoaiKH(loaiKH);
//int maHangSX = GetMaHangSanXuat(hangSanXuat);
if (khachHang != null)
{
khachHang.MaKhachHang = maKH;
khachHang.TenKhachHang = tenKH;
khachHang.Ngaysinh = ngaySinhKH;
khachHang.GioiTinh = gioiTinh;
khachHang.Email = email;
khachHang.DiaChi = diaChi;
khachHang.SDT = soDT;
khachHang.LoaiKhachHang = maloaiKH;
khachHang.GhiChu = chuThich;
db.SubmitChanges();
return(true);
}
else
{
MessageBox.Show("null");
return(false);
}
}
else
{
return(false);
}
}
}
public bool HuyPhieu(int maPN)
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
// MessageBox.Show(maNV + "");
PhieuNhap phieuNhap = db.PhieuNhaps.Where(p => p.ID == maPN).SingleOrDefault();
if (phieuNhap != null)
{
// MessageBox.Show(ghiChu + "");
phieuNhap.TinhTrang = null;
phieuNhap.GhiChu = "Phiếu đã hủy";
db.SubmitChanges();
return(true);
}
else
{
return(false);
}
}
}
public bool XacNhanPhieu(int maPN, int maNV, DateTime ngayXacNhan)
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
// MessageBox.Show(maNV + "");
PhieuNhap phieuNhap = db.PhieuNhaps.Where(p => p.ID == maPN).SingleOrDefault();
if (phieuNhap != null)
{
// MessageBox.Show(ghiChu + "");
phieuNhap.NVXacNhan = maNV;
phieuNhap.NgayXacNhan = ngayXacNhan;
phieuNhap.TinhTrang = false;
db.SubmitChanges();
return(true);
}
else
{
return(false);
}
}
}