public void InsertNCC(NHACUNGCAP NCC)
{
var db = new QLTHONGTINMAYTINHEntities1();
db.NHACUNGCAPs.Add(NCC);
db.SaveChanges();
}
public void insertSP(SANPHAM SP)
{
var db = new QLTHONGTINMAYTINHEntities1();
db.SANPHAMs.Add(SP);
db.SaveChanges();
}
public void InsertNV(NHANVIEN NV)
{
var db = new QLTHONGTINMAYTINHEntities1();
db.NHANVIENs.Add(NV);
db.SaveChanges();
}
public void InsertNhaKho(NHAKHO NK)
{
var db = new QLTHONGTINMAYTINHEntities1();
db.NHAKHOes.Add(NK);
db.SaveChanges();
}
public void soLuongSauKhiBan(string _MaSp, int _SoLuong)
{
var db = new QLTHONGTINMAYTINHEntities1();
db.UpdateSoLuong(_MaSp, amountToDB(_MaSp) - _SoLuong); // Proc SQL
db.SaveChanges();
}
public void removeNK(string _MaNK)
{
var db = new QLTHONGTINMAYTINHEntities1();
NHAKHO NK = db.NHAKHOes.Where(p => p.MANK == _MaNK).SingleOrDefault();
db.NHAKHOes.Remove(NK);
db.SaveChanges();
}
public void removeNCC(string _MaNCC)
{
var db = new QLTHONGTINMAYTINHEntities1();
NHACUNGCAP NCC = db.NHACUNGCAPs.Where(p => p.MANCC == _MaNCC).SingleOrDefault();
db.NHACUNGCAPs.Remove(NCC);
db.SaveChanges();
}
public IEnumerable <KHACHHANG> loadSearch(string _strName)
{
var db = new QLTHONGTINMAYTINHEntities1();
return(db.SeachNameKhachHang(_strName).Select(p => new KHACHHANG()
{
MAKH = p.MAKH, TENKH = p.TENKH, SDT = p.SDT, DIACHI = p.DIACHI, status = p.status
}));
}
public IEnumerable <NHANVIEN> loadSeach(string _strName)
{
var db = new QLTHONGTINMAYTINHEntities1();
return(db.seachName(_strName).Select(p => new NHANVIEN()
{
MANV = p.MANV, TENNV = p.TENNV, SEX = p.SEX, DIACHI = p.DIACHI, SDT = p.SDT, EMAIL = p.EMAIL
}));
}
public IEnumerable <NHACUNGCAP> loadSeach(string _strName)
{
var db = new QLTHONGTINMAYTINHEntities1();
return(db.SeachNameNhaCungCap(_strName).Select(p => new NHACUNGCAP()
{
MANCC = p.MANCC, TENNCC = p.TENNCC, DIACHI = p.DIACHI, SDT = p.SDT, FAX = p.FAX, EMAIL = p.EMAIL
}));
}
public IEnumerable <NHAKHO> loadSeach(string _strName)
{
var db = new QLTHONGTINMAYTINHEntities1();
return(db.SeachNameNhaKHo(_strName).Select(p => new NHAKHO()
{
MANK = p.MANK, TENNK = p.TENNK, DIACHI = p.DIACHI
}));
}
public IEnumerable <SANPHAM> loadSearch(string _strName)
{
var db = new QLTHONGTINMAYTINHEntities1();
return(db.SeachNameSanPham(_strName).Select(p => new SANPHAM()
{
MASP = p.MASP, TENSP = p.TENSP, THUONGHIEU = p.THUONGHIEU, THONGTIN = p.THONGTIN, LOAISP = p.LOAISP, SOLUONG = p.SOLUONG, GIANHAP = p.GIANHAP, GIABAN = p.GIABAN, TIMENHAP = p.TIMENHAP, MANCC = p.MANCC, MANK = p.MANK, IMAGES = p.IMAGES
}));
}
public IEnumerable loadInfo(string _strMADH)
{
var db = new QLTHONGTINMAYTINHEntities1();
return(db.loadINFORDONHANG(_strMADH).Select(p => new cTTDONHANG()
{
StrMASP = p.MASP, StrTENSP = p.TENSP, ISOLUONG = p.SOLUONG, DGIA = p.GIABAN
}).ToList());
}
public IEnumerable loadSP()
{
var db = new QLTHONGTINMAYTINHEntities1();
return(db.Top_5_SP().Select(p => new SANPHAM()
{
TENSP = p.TENSP, IMAGES = p.IMAGES
}).ToList());
}
public void removeSP(string _MaSP)
{
try
{
var db = new QLTHONGTINMAYTINHEntities1();
SANPHAM SP = db.SANPHAMs.Where(p => p.MASP == _MaSP).SingleOrDefault();
db.SANPHAMs.Remove(SP);
db.SaveChanges();
}
catch { }
}
public void insertStatus(string _strMAKH)
{
var db = new QLTHONGTINMAYTINHEntities1();
var result = db.KHACHHANGs.Where(p => p.MAKH == _strMAKH).SingleOrDefault();
if (result != null)
{
result.status = 1;
db.SaveChanges();
}
}
public bool loginSuss(string _ID, string _Pass)
{
var db = new QLTHONGTINMAYTINHEntities1();
var result = db.NHANVIENs.Where(p => p.MANV == _ID && p.PASSWORD == _Pass).SingleOrDefault();
if (result != null)
{
return(true);
}
return(false);
}
public void InsertDonHang(DONHANG DH)
{
try
{
var db = new QLTHONGTINMAYTINHEntities1();
db.DONHANGs.Add(DH);
db.SaveChanges();
}
catch (Exception)
{
MessageBox.Show("Lỗi Khi Thêm Dư Liệu", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
public void removeNV(string _MaNV)
{
try
{
var db = new QLTHONGTINMAYTINHEntities1();
NHANVIEN NV = db.NHANVIENs.Where(p => p.MANV == _MaNV).SingleOrDefault();
db.NHANVIENs.Remove(NV);
db.SaveChanges();
}
catch
{
}
}
public IEnumerable THONGKETHEONTN(DateTime dateTime, string strDate)
{
var db = new QLTHONGTINMAYTINHEntities1();
if (strDate == "Ngày")
{
return(db.THONGKEDONHANGDABANs.Where(p => p.TIMEXUAT.Day == dateTime.Day && p.TIMEXUAT.Month == dateTime.Month && p.TIMEXUAT.Year == dateTime.Year).ToList());
}
if (strDate == "Tháng")
{
return(db.THONGKEDONHANGDABANs.Where(p => p.TIMEXUAT.Month == dateTime.Month && p.TIMEXUAT.Year == dateTime.Year).ToList());
}
if (strDate == "Năm")
{
return(db.THONGKEDONHANGDABANs.Where(p => p.TIMEXUAT.Year == dateTime.Year).ToList());
}
return(db.THONGKEDONHANGDABANs.ToList());
}
public IEnumerable TKQuy(DateTime dateTime, string strDate)
{
var db = new QLTHONGTINMAYTINHEntities1();
if (strDate == "Quý 1")
{
return(db.THONGKEDONHANGDABANs.Where(p => p.TIMEXUAT.Month >= 1 && p.TIMEXUAT.Month <= 3 && dateTime.Year == p.TIMEXUAT.Year).ToList());
}
if (strDate == "Quý 2")
{
return(db.THONGKEDONHANGDABANs.Where(p => p.TIMEXUAT.Month >= 4 && p.TIMEXUAT.Month <= 6 && dateTime.Year == p.TIMEXUAT.Year).ToList());
}
if (strDate == "Quý 3")
{
return(db.THONGKEDONHANGDABANs.Where(p => p.TIMEXUAT.Month >= 7 && p.TIMEXUAT.Month <= 9 && dateTime.Year == p.TIMEXUAT.Year).ToList());
}
return(db.THONGKEDONHANGDABANs.Where(p => p.TIMEXUAT.Month >= 10 && p.TIMEXUAT.Month <= 12 && dateTime.Year == p.TIMEXUAT.Year).ToList());
}
public int loadQuyen(string _MANV)
{
var db = new QLTHONGTINMAYTINHEntities1();
var result = db.NHANVIENs.Where(p => p.MANV == _MANV).SingleOrDefault();
if (result != null)
{
if (result.QUYEN == 1)
{
return(1);
}
else
{
return(0);
}
}
else
{
return(-1);
}
}
public int SoLuong()
{
var db = new QLTHONGTINMAYTINHEntities1();
return(db.THONGTINDONHANGs.Sum(p => p.SOLUONG));
}
public IEnumerable loadInforKhachHang()
{
var db = new QLTHONGTINMAYTINHEntities1();
return(db.KHACHHANGs.ToList());
}
public IEnumerable loadMANK()
{
var db = new QLTHONGTINMAYTINHEntities1();
return(db.NHAKHOes.Select(p => p.MANK).ToList());
}
public IEnumerable loadNCC()
{
var db = new QLTHONGTINMAYTINHEntities1();
return(db.NHACUNGCAPs.ToList());
}
public IEnumerable loadMANCC()
{
var db = new QLTHONGTINMAYTINHEntities1();
return(db.NHACUNGCAPs.Select(p => p.MANCC).ToList());
}
public IEnumerable listStatus(int _limitMoney)
{
var db = new QLTHONGTINMAYTINHEntities1();
return(db.THONGKEDONHANGDABAN_1.Where(p => p.THANHTIEN >= _limitMoney).Select(a => a.MAKH).ToList());
}
public IEnumerable loadInfoNhaKho()
{
var db = new QLTHONGTINMAYTINHEntities1();
return(db.NHAKHOes.ToList());
}
public int SoLuongKH()
{
var db = new QLTHONGTINMAYTINHEntities1();
return(db.KHACHHANGs.Count());
}
