예제 #1
0
 public void AddRange(MovieSettings_GetRecordCollection val)
 {
     for (int i = 0; i < val.Count; i++)
     {
         this.Add(val[i]);
     }
 }
예제 #2
0
 public MovieSettings_GetRecordCollection(MovieSettings_GetRecordCollection val)
 {
     this.AddRange(val);
 }
예제 #3
0
        private static int MovieSettings_Get(System.Data.IDbTransaction transaction, out MovieSettings_GetRecordCollection returnValue)
        {
            int returnCode = -1;

            returnValue = new MovieSettings_GetRecordCollection();

            System.Data.IDbConnection dbConnection = null;

            try
            {
#if QUERYLOG
                RightPoint.Data.QueryLogItem queryLog = RightPoint.Data.QueryLog.CreateLogItem("Movies.dbo.ap_Movies_MovieSettings_Get");
#endif

                if (transaction != null)
                {
                    dbConnection = transaction.Connection;
                }
                else
                {
                    dbConnection = RightPoint.Data.DbFactory.GetConnection("Movies");
                    dbConnection.Open();
                }

                System.Data.IDbCommand dbCommand = RightPoint.Data.DbUtility.CreateStoredProcedureCommand(dbConnection, "dbo.ap_Movies_MovieSettings_Get");

                if (transaction != null)
                {
                    dbCommand.Transaction = transaction;
                }

                dbCommand.CommandTimeout = 120;

                RightPoint.Data.DbUtility.AddReturnParameter(dbCommand);


                System.Data.IDataReader dbDataReader = null;

#if QUERYLOG
                queryLog.MarkExecutionStart();
#endif

                dbDataReader = dbCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection);

#if QUERYLOG
                queryLog.MarkExecutionEnd();
#endif

                while (dbDataReader.Read())
                {
                    returnValue.Add(new MovieSettings_GetRecord((System.Int32?)(dbDataReader.FieldCount < 1 || dbDataReader[0] == System.DBNull.Value ? null : dbDataReader[0]) /* ID */,
                                                                (System.String)(dbDataReader.FieldCount < 2 || dbDataReader[1] == System.DBNull.Value ? null : dbDataReader[1]) /* Name */,
                                                                (System.String)(dbDataReader.FieldCount < 3 || dbDataReader[2] == System.DBNull.Value ? null : dbDataReader[2]) /* Value */,
                                                                (System.String)(dbDataReader.FieldCount < 4 || dbDataReader[3] == System.DBNull.Value ? null : dbDataReader[3]) /* Description */));
                }

#if QUERYLOG
                queryLog.MarkTransformationEnd();
#endif

                dbDataReader.Close();
                returnCode = RightPoint.Data.DbUtility.GetReturnCode(dbCommand);

                return(returnCode);
            }
            finally
            {
                if (transaction == null && dbConnection != null)
                {
                    if (dbConnection.State != System.Data.ConnectionState.Closed)
                    {
                        dbConnection.Close();
                    }

                    dbConnection.Dispose();
                }
            }
        }
예제 #4
0
            public static bool TryMovieSettings_Get(System.Data.IDbTransaction transaction, out MovieSettings_GetRecordCollection returnValue)
            {
                int returnCode = MovieSettings_Get(transaction, out returnValue);

                return(returnCode == 0);
            }
예제 #5
0
 public static bool TryMovieSettings_Get(out MovieSettings_GetRecordCollection returnValue)
 {
     return(WithTransaction.TryMovieSettings_Get(null, out returnValue));
 }
예제 #6
0
 public MovieSettings_GetRecordEnumerator(MovieSettings_GetRecordCollection mappings)
 {
     _temp           = mappings;
     _baseEnumerator = _temp.GetEnumerator();
 }