public static CrmAddress GetByCrmReplicationUniqueID( Guid crmReplicationUniqueID ) { DataRow row = AdoNetSqlHelper.ExecuteRow( "GetCrmAddressByCrmReplicationUniqueID", new AdoNetSqlParamCollection( AdoNetSqlParamCollection.CreateParameter( "@CrmReplicationUniqueID", crmReplicationUniqueID ) ) ); if ( row == null ) { return null; } else { CrmAddress o = new CrmAddress(); o.Load( row ); if ( o.IsEmpty ) { return null; } else { return o; } } }
/// <summary> /// Load all for the given parent. /// </summary> public static CrmPerson[] GetForAddress( CrmAddress parentObject ) { DataTable table = AdoNetSqlHelper.ExecuteTable( "GetCrmPersonByCrmAddressID", new AdoNetSqlParamCollection( AdoNetSqlParamCollection.CreateParameter( "@ID", parentObject.ID ) ) ); if ( table == null ) { return null; } else { ArrayList result = new ArrayList(); foreach ( DataRow row in table.Rows ) { CrmPerson o = new CrmPerson(); o.Load( row ); if ( !o.IsEmpty ) { result.Add( o ); } } if ( result.Count <= 0 ) { return null; } else { return (CrmPerson[])result.ToArray( typeof( CrmPerson ) ); } } }
/// <summary> /// Load an object by a given ID. /// </summary> public static CrmAddress GetByID( int id ) { DataRow row = AdoNetSqlHelper.ExecuteRow( "GetCrmAddressByID", new AdoNetSqlParamCollection( AdoNetSqlParamCollection.CreateParameter( "@ID", id ) ) ); if ( row == null ) { return null; } else { CrmAddress o = new CrmAddress(); o.Load( row ); if ( o.IsEmpty ) { return null; } else { return o; } } }
/// <summary> /// Load all. /// </summary> public static CrmAddress[] GetAll() { DataTable table = AdoNetSqlHelper.ExecuteTable( "GetAllCrmAddresses", new AdoNetSqlParamCollection( ) ); if ( table == null ) { return null; } else { ArrayList result = new ArrayList(); foreach ( DataRow row in table.Rows ) { CrmAddress o = new CrmAddress(); o.Load( row ); if ( !o.IsEmpty ) { result.Add( o ); } } if ( result.Count <= 0 ) { return null; } else { return (CrmAddress[])result.ToArray( typeof( CrmAddress ) ); } } }