public bool XoaChiTietThietBi(string matb, string mathietbi)
        {
            CHITIETTRANGBI ct = (from cttb in db.CHITIETTRANGBIs
                                 where (cttb.MATB == matb && cttb.MATHIETBI == mathietbi)
                                 select cttb).First();

            db.CHITIETTRANGBIs.DeleteOnSubmit(ct);
            db.SubmitChanges();

            return(true);
        }
        public bool themChiTietThietBi(string matb, string mathietbi, int soluongtb)
        {
            CHITIETTRANGBI cttb = new CHITIETTRANGBI();

            cttb.MATB           = matb;
            cttb.MATHIETBI      = mathietbi;
            cttb.SOLUONGTRANGBI = soluongtb;
            db.CHITIETTRANGBIs.InsertOnSubmit(cttb);
            db.SubmitChanges();

            return(true);
        }
        public bool updatethemTrangBiThietBi(string matb, string mathietbi, int soluongtb)
        {
            CHITIETTRANGBI ct = (from cttb in db.CHITIETTRANGBIs
                                 where (cttb.MATB == matb && cttb.MATHIETBI == mathietbi)
                                 select cttb).First();

            ct.MATB            = matb;
            ct.MATHIETBI       = mathietbi;
            ct.SOLUONGTRANGBI += soluongtb;
            db.SubmitChanges();

            return(true);
        }