ono1
            End Get
            Set(ByVal Value As String)
                n_ISTT_Telefono1 = Value
            End Set
        End Property
        Public Property Telefono2() As String
            Get
                Telefono2 = n_ISTT_Telefono2
            End Get
            Set(ByVal Value As String)
                n_ISTT_Telefono2 = Value
            End Set
        End Property
        Public Property Fax() As String
            Get
                Fax = n_ISTT_Fax
            End Get
            Set(ByVal Value As String)
                n_ISTT_Fax = Value
            End Set
        End Property
        Public Property HomePage() As String
            Get
                HomePage = n_ISTT_HomePage
            End Get
            Set(ByVal Value As String)
                n_ISTT_HomePage = Value
            End Set
        End Property
        Public Property IsUniversita() As Boolean
            Get
                IsUniversita = n_ISTT_IsUniversita
            End Get
            Set(ByVal Value As Boolean)
                n_ISTT_IsUniversita = Value
            End Set
        End Property
        Public ReadOnly Property Errore() As Errori_Db
            Get
                Errore = n_errore
            End Get
        End Property
        Public Property Logo() As String
            Get
                Logo = n_ISTT_Logo
            End Get
            Set(ByVal Value As String)
                n_ISTT_Logo = Value
            End Set
        End Property
#End Region

#Region "Metodi New"
        Sub New()
            Me.n_errore = Errori_Db.None
        End Sub
#End Region

#Region "Metodi"
        Public Function Elenca() As DataSet
            Dim oRequest As New COL_Request
            Dim oParam As New COL_Request.Parameter
            Dim dsTable As New DataSet
            Dim objAccesso As New COL_DataAccess

            With oRequest
               .Command = "sp_Istituzione_Elenca"
               .CommandType = CommandType.StoredProcedure
               .Role = COL_Request.UserRole.Admin
               .transactional = False
            End With
            Try
                dsTable = objAccesso.GetdataSet(oRequest)
                Me.n_errore = Errori_Db.None
            Catch ex As Exception
                Me.n_errore = Errori_Db.DBError
            End Try
            Return dsTable
        End Function
        Public Sub Modifica()
            Dim oRequest As New COL_Request
            Dim oParam As New COL_Request.Parameter
            Dim objAccesso As New COL_DataAccess
            With oRequest
               .Command = "sp_Istituzione_Modifica"
               .CommandType = CommandType.StoredProcedure
                oParam = objAccesso.GetParameter("@ISTT_Id", Me.n_ISTT_id, ParameterDirection.Input, DbType.Int32)
               .Parameters.Add(oParam)
                oParam = objAccesso.GetParameter("@ISTT_RagioneSociale", n_ISTT_RagioneSociale, ParameterDirection.Input, DbType.String,, 100)
               .Parameters.Add(oParam)
                oParam = objAccesso.GetParameter("@ISTT_Indirizzo", n_ISTT_Indirizzo, ParameterDirection.Input, DbType.String,, 100)
               .Parameters.Add(oParam)
                oParam = objAccesso.GetParameter("@ISTT_Cap", n_ISTT_Cap, ParameterDirection.Input, DbType.Int32)
               .Parameters.Add(oParam)
                oParam = objAccesso.GetParameter("@ISTT_Citta", n_ISTT_Citta, ParameterDirection.Input, DbType.String,, 50)
               .Parameters.Add(oParam)
                oParam = objAccesso.GetParameter("@ISTT_PRVN_ID", n_ISTT_PRVN.ID,, DbType.Int32)
               .Parameters.Add(oParam)
                oParam = objAccesso.GetParameter("@ISTT_STTO_ID", n_ISTT_STTO.ID,, DbType.Int32)
               .Parameters.Add(oParam)
                oParam = objAccesso.GetParameter("@ISTT_Telefono1", n_ISTT_Telefono1, ParameterDirection.Input, DbType.String,, 25)
               .Parameters.Add(oParam)
                oParam = objAccesso.GetParameter("@ISTT_Telefono2", n_ISTT_Telefono2, ParameterDirection.Input, DbType.String,, 25)
               .Parameters.Add(oParam)
                oParam = objAccesso.GetParameter("@ISTT_Fax", n_ISTT_Fax, ParameterDirection.Input, DbType.String,, 25)
               .Parameters.Add(oParam)
                oParam = objAccesso.GetParameter("@ISTT_HomePage", n_ISTT_HomePage, ParameterDirection.Input, DbType.String,, 250)
               .Parameters.Add(oParam)
                oParam = objAccesso.GetParameter("@ISTT_IsUniversita", n_ISTT_IsUniversita,, DbType.Boolean)
               .Parameters.Add(oParam)
                oParam = objAccesso.GetParameter("@ISTT_Logo", n_ISTT_Logo,, DbType.String,, 300)
               .Parameters.Add(oParam)
               .Role = COL_Request.UserRole.Admin
               .transactional = False
            End With
            Try
                objAccesso.GetExecuteNotQuery(oRequest)
                Me.n_errore = Errori_Db.None
            Catch ex As Exception
                Me.n_errore = Errori_Db.DBChange
            End Try
        End Sub
        Public Sub Aggiungi()
            Dim oRequest As New COL_Request
            Dim oParam As New COL_Request.Parameter
            Dim objAccesso As New COL_DataAccess
            With oRequest
               .Command = "sp_Istituzione_Aggiungi"
               .CommandType = CommandType.StoredProcedure
                oParam = objAccesso.GetParameter("@ISTT_Id", "", ParameterDirection.Output, DbType.Int32)
               .Parameters.Add(oParam)
                oParam = objAccesso.GetParameter("@ISTT_RagioneSociale", n_ISTT_RagioneSociale, ParameterDirection.Input, DbType.String,, 100)
               .Parameters.Add(oParam)
                oParam = objAccesso.GetParameter("@ISTT_Indirizzo", n_ISTT_Indirizzo, ParameterDirection.Input, DbType.String,, 100)
               .Parameters.Add(oParam)
                oParam = objAccesso.GetParameter("@ISTT_Cap", n_ISTT_Cap, ParameterDirection.Input, DbType.Int32)
               .Parameters.Add(oParam)
                oParam = objAccesso.GetParameter("@ISTT_Citta", n_ISTT_Citta, ParameterDirection.Input, DbType.String,, 50)
               .Parameters.Add(oParam)
                oParam = objAccesso.GetParameter("@ISTT_PRVN_ID", n_ISTT_PRVN.ID,, DbType.Int32)
               .Parameters.Add(oParam)
                oParam = objAccesso.GetParameter("@ISTT_STTO_ID", n_ISTT_STTO.ID,, DbType.Int32)
               .Parameters.Add(oParam)
                oParam = objAccesso.GetParameter("@ISTT_Telefono1", n_ISTT_Telefono1, ParameterDirection.Input, DbType.String,, 25)
               .Parameters.Add(oParam)
                oParam = objAccesso.GetParameter("@ISTT_Telefono2", n_ISTT_Telefono2, ParameterDirection.Input, DbType.String,, 25)
               .Parameters.Add(oParam)
                oParam = objAccesso.GetParameter("@ISTT_Fax", n_ISTT_Fax, ParameterDirection.Input, DbType.String,, 25)
               .Parameters.Add(oParam)
                oParam = objAccesso.GetParameter("@ISTT_HomePage", n_ISTT_HomePage, ParameterDirection.Input, DbType.String,, 250)
               .Parameters.