public int SoSVToiDaTrongPhong(string MAPHG)
        {
            ChuyenPhongData data  = new ChuyenPhongData();
            DataTable       table = data.SoSVToiDaTrongPhong(MAPHG);
            int             i     = 0;

            if (table.Columns.Count > 0 && table.Rows.Count > 0)
            {
                if (table.Rows[0]["SOLUONGTOIDA"].ToString() != "")
                {
                    i = Convert.ToInt32(table.Rows[0]["SOLUONGTOIDA"].ToString());
                }
                else
                {
                    i = 0;
                }
            }
            return(i);
        }