public int FshiCmimiDhoma(int idDhoma, int idCmimi)
        {
            int          p = 0;
            int          z = 2; int r = 1;
            DataSet      ds          = null;
            DataSet      ds1         = null;
            DbController db          = new DbController();
            Dhoma        dhomaObject = new Dhoma();

            ds = dhomaObject.NxirrDhome(idDhoma);
            DataRow dr      = ds.Tables[0].Rows[0];
            string  gjendja = Convert.ToString(dr[2]);

            ds1 = this.KontrolloDhomaRezervuarData(idDhoma, this.dtFillimi, this.dtMbarimi);
            DataRow dr1 = ds1.Tables[0].Rows[0];

            if (Convert.ToInt32(dr1[0]) == 0)
            {
                ds = db.Read("dbShfaqKlientPerDhomeDataTeDhenaKntCmime", idDhoma, this.dtFillimi, this.dtMbarimi);
                if (Convert.ToInt32(ds.Tables[0].Rows.Count) == 0)
                {
                    p = db.Delete("dbFshiCmimiDhoma", idDhoma, idCmimi);
                }
                else
                {
                    return(p = z);
                }
            }
            else
            {
                p = r;
            }
            return(p);
        }
        public int FshiKategori(int idKategoria)
        {
            int          p           = 0;
            DataSet      ds          = null;
            DbController db          = new DbController();
            Dhoma        dhomaObject = new Dhoma();

            ds = db.Read("dbKontrolloKategoriDhome", idKategoria);
            DataRow dr = ds.Tables[0].Rows[0];

            if (Convert.ToInt32(dr[0]) == 0)
            {
                p = db.Delete("dbFshiKategori", idKategoria);
            }
            else
            {
                p = 1;                 //per kete kategori ka dhoma te konfiguruara	,fshirja lejohet kur nuk ka dhoma
            }
            return(p);
        }