public bool checkExisted(string masp)
        {
            Tbl_SanPham sp = db.Tbl_SanPhams.Where(x => x.maSP == masp).FirstOrDefault();

            if (sp == null)
            {
                return(true);
            }
            return(false);
        }
        public int ThemSanPham(eSanPham newsp)
        {
            var masanpham = db.Tbl_SanPhams.Where(x => x.maSP == newsp.maSP).FirstOrDefault();

            if (masanpham != null)
            {
                return(0);
            }
            Tbl_SanPham spTmp = new Tbl_SanPham();

            spTmp.maSP      = newsp.maSP;
            spTmp.tenSP     = newsp.tenSP;
            spTmp.tenNhaPP  = newsp.tenNhaPP;
            spTmp.tenNhaSX  = newsp.tenNhaSX;
            spTmp.trangThai = newsp.trangthai;
            spTmp.ngaySX    = newsp.ngaySX;
            spTmp.moTa      = newsp.moTa;
            spTmp.hanSD     = newsp.hanSD;
            db.Tbl_SanPhams.InsertOnSubmit(spTmp);
            db.SubmitChanges();
            return(1);
        }