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); }