private bool checkDuesPending()
    {
        bool          result        = false;
        string        TenantsMobile = Session["TenantMobile"].ToString();
        SqlDataReader sdr           = uc.GetPendingDues(TenantsMobile);

        if (sdr.HasRows)
        {
            if (sdr.Read())
            {
                string tenantName     = sdr["d_PayeeText"].ToString();
                string d_RoomNo       = sdr["d_RoomNo"].ToString();
                string d_t_Mobile     = sdr["d_t_Mobile"].ToString();
                string d_DuesTypeText = sdr["d_DuesTypeText"].ToString();
                string d_DuesAmount   = sdr["d_DuesAmount"].ToString();
                string text           = "The due of " + tenantName + "(" + d_t_Mobile + ") Room no " + d_RoomNo + " Due type " + d_DuesTypeText + " of Rs." + d_DuesAmount + " is pending you can not delete it";
                ScriptManager.RegisterStartupScript(this, typeof(Page), "Warning", "<script>showpoperror('" + text + "')</script>", false);
                result = true;
            }
            sdr.Close();
        }
        else
        {
            result = false;
        }
        return(result);
    }