public void PhanChiSP(string idMa, string idNhap, string idPP, int SL)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
db.USP_PhanChiaSP(idMa, idNhap, idPP, SL);
}
}
public List <ChiTietHDNhapHang> GetChiTietHDNH(string id)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
return(dbs.ChiTietHDNhapHangs.Where(p => p.MaHoaDonNH == id).ToList());
}
}
public List <KhachHang> GetAllKH()
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
return(dbs.spGetKH().ToList());
}
}
public List <NhanVien> TimKiemNV(string id)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
return(db.NhanViens.Where(p => p.MaNV.Contains(id) || p.TenNV.Contains(id) || p.SDT.Contains(id) || p.DiaChi.Contains(id)).ToList());
}
}
public List <NhanVien> GetNVShiper()
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
return(dbs.NhanViens.Where(p => p.MaLoaiNV == "shiper").ToList());
}
}
public List <SanPham> GetSPByMaDSP(string id)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
return(db.SanPhams.Where(p => p.MaDSP == id).ToList());
}
}
public List <NhanVien> GetallNV()
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
return(dbs.NhanViens.ToList());
}
}
public USP_GETAllInfoSPNew_Result GetMaSPByMaKieuSP(string id)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
return(db.USP_GETAllInfoSPNew(id).Single());
}
}
public void XoaKieuSp(string id)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
db.USP_DeleteCTSP(id);
}
}
public ChiTietSP Get1ChiTietSPByIDKieuSP(string id)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
return(db.ChiTietSPs.Where(p => p.MaKieu == id).SingleOrDefault());
}
}
public ChiTietSP GetChiTietSPOderByMaCHByIDKieuSP(string idch, string id)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
return(db.USP_GetCTSPOderByMaCHByMaKieu(idch, id).SingleOrDefault());
}
}
public List <ChiTietSP> GetChiTietSPOderByMaCHByIDSP(string idch, string id)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
return(db.USP_GetCTSPOderByMaCHByMaSP(idch, id).ToList());
}
}
public List <ChiTietSP> GetChiTietSPByIDSP(string id)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
return(db.ChiTietSPs.Where(p => p.MaSP == id).ToList());
}
}
public void Them_SLCTSP_Into_KhoHang_(string idMa, string ch, int sl)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
db.USP_ThemSL_KhoHangByMaKieuByMaCH(idMa, ch, sl);
}
}
public List <SanPham> GetAllSanPham()
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
return(db.SanPhams.ToList());
}
}
public void ThayDoiGiaSP(string id, decimal gia)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
db.USP_ThayDoiGiaChiTietSP(id, gia);
}
}
public SanPham GetSanPhamByID(string id)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
return(db.SanPhams.Where(p => p.MaSP == id).Single());
}
}
public int matruycap(string name, string pass)
{
TaiKhoan a = new TaiKhoan();
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
string loaitk = dbs.TaiKhoans.SingleOrDefault(p => p.UserName == name && p.Password == pass).MaLoaiTK;
if (loaitk == "admin")
{
return(0);
}
else
if (loaitk == "qlk")
{
return(1);
}
else
if (loaitk == "qlns")
{
return(2);
}
if (loaitk == "qlch")
{
return(3);
}
return(4);
}
}
public List <LoaiSP> GetLoaiSP()
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
return(dbs.LoaiSPs.ToList());
}
}
public List <TaiKhoan> GetAllTK()
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
return(dbs.TaiKhoans.ToList());
}
}
public List <NhanVien> GetallNV(string ch)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
return(dbs.NhanViens.Where(p => p.MaCuaHang == ch).ToList());
}
}
public HoaDonNhapHang GetHoaDonNhap(string id)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
return(db.HoaDonNhapHangs.Where(p => p.MaHoaDonNH == id).Single());
}
}
public List <NhanVien> GetallNVWithoutAdmin()
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
return(dbs.NhanViens.Where(p => p.MaLoaiNV != "admin").ToList());
}
}
public List <HoaDonNhapHang> GetAllHoaDonNhap()
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
return(db.HoaDonNhapHangs.ToList());
}
}
public NhanVien Get1NV(string id)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
return(dbs.NhanViens.Where(p => p.MaNV == id).SingleOrDefault());
}
}
public List <KhoHang> GetAllKhoHang()
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
return(db.USP_GetAllKhoHang().ToList());
}
}
public ChiTietHDNhapHang KiemTRaTonTaiSPinCTNH(string id, string idsp)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
return(dbs.ChiTietHDNhapHangs.Where(p => p.MaHoaDonNH == id && p.MaKieu == idsp).SingleOrDefault());
}
}
public List <KhoHang> GetAllKhoHangByMaKieu(string id)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
return(db.KhoHangs.Where(p => p.MaKieu == id).ToList());
}
}
public void UpdateKH(string ma, string tenkh, string diachi, string sdt)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
dbs.spUpdateKH(ma, tenkh, diachi, sdt);
}
}
public List <MauSP> GetAllMauSP()
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
return(db.MauSPs.ToList());
}
}
