rendered paste body
//========================================================================
// This file was generated using the MyGeneration tool in combination
// with the Gentle.NET Business Entity template, $Rev: 44g JC$
//========================================================================
using System;
using System.Collections;
using Gentle.Framework;
using Gentle.Common.Attributes;
namespace WideSolutions.Data.Restaunet
{
#region Fontes
/// <summary>
/// This object represents the properties and methods of a Employee.
/// </summary>
[Serializable]
[TableName("Fontes")]
public class Fontes : Persistent
{
#region Members
private bool _changed = false;
private static bool invalidatedListAll = true;
private static ArrayList listAllCache = null;
/***PRESERVE_BEGIN MANUAL_CODE_Fonte***//***PRESERVE_END MANUAL_CODE_Fonte***/
[TableColumn("ID", NotNull = false), PrimaryKey(AutoGenerated = false)]
protected int iD;
/***PRESERVE_BEGIN MANUAL_CODE_Nome***//***PRESERVE_END MANUAL_CODE_Nome***/
[TableColumn("Nome", NotNull=false)]
protected string nome;
#endregion
#region Constructors
/// <summary>
/// Create a new object using the minimum required information (all not-null fields except
/// auto-generated primary keys).
/// </summary>
public Fontes(
int ID)
{
_changed = true;
invalidatedListAll = true;
iD = ID;
}
/// <summary>
/// Create an object from an existing row of data. This will be used by Gentle to
/// construct objects from retrieved rows.
/// </summary>
public Fontes(
int ID,
string Nome)
{
iD = ID;
nome = Nome;
}
#endregion
#region Public Properties
public bool Changed
{ get { return _changed; } }
public int ID
{
get{ return iD; }
set{ _changed |= iD != value; iD = value; invalidatedListAll = _changed;}
}
public string Nome
{
get{ return nome; }
set{ _changed |= nome != value; nome = value; invalidatedListAll = _changed;}
}
// generate a static property to retrieve all instances of a class that are stored in the database
static public IList ListAll()
{
if( listAllCache == null || invalidatedListAll )
{
listAllCache = Broker.RetrieveList( typeof(Fontes) ) as ArrayList;
invalidatedListAll = false;
}
return listAllCache;
}
// static property to retrieve all instances of a class that are stored in the database as a TypedArrayList
[Visible(false)]
static public Gentle.Common.TypedArrayList ListAllTyped
{
get
{
Gentle.Common.TypedArrayList tList = new Gentle.Common.TypedArrayList( typeof(Fontes) );
// populate list (note: ObjectFactory.GetCollection supports a similar syntax)
Broker.RetrieveList( typeof(Fontes), tList );
return tList;
}
}
// static property to retrieve all instances of a class that are stored in the database as a DataView
[Visible(false)]
static public System.Data.DataView ViewAll
{
get{
SqlBuilder sb = new SqlBuilder( StatementType.Select, typeof(Fontes) );
SqlResult sr = sb.GetStatement().Execute();
return ObjectView.GetDataView( sr );
}
}
// static method that returns an instance of the object searching for a especif columns
static public SqlResult FindBy(string _propertie,object _prop_value)
{
SqlBuilder sb = new SqlBuilder( StatementType.Select, typeof(Fontes) );
sb.AddConstraint(Operator.Equals,_propertie,_prop_value);
SqlResult sr = sb.GetStatement().Execute();
return sr;
}
// static method that returns an instance of the object searching for a especif columns with a specific operator
static public SqlResult FindBy(Operator _op,string _propertie,object _prop_value)
{
SqlBuilder sb = new SqlBuilder( StatementType.Select, typeof(Fontes) );
sb.AddConstraint(_op ,_propertie,_prop_value);
SqlResult sr = sb.GetStatement().Execute();
return sr;
}
#endregion
#region Debug Properties
/// <summary>
/// Generated only when genDebug flag enabled in MyGeneration template UI
/// Returns number of items in internal cache
/// </summary>
public static int CacheCount
{
get{ return listAllCache == null ? 0 : listAllCache.Count;}
}
#endregion
#region Storage and retrieval
public static Fontes Retrieve(int id )
{
Key key = new Key( typeof(Fontes), true, "ID", id );
return Broker.RetrieveInstance( typeof(Fontes), key ) as Fontes;
}
//Gentle.NET Business Entity script: Generation of complex retrieve function (multiple primary keys) is not implemented yet.
public override void Persist()
{
if( Changed || !IsPersisted )
{
base.Persist();
_changed=false;
}
}
public override void Remove()
{
base.Remove();
invalidatedListAll = true;
}
#endregion
#region Relations
// List of primary keys for this class table
// Key: ID
// List of foreign keys for this class table
// Key: FK_DicasSugestoes_Fontes primary table: Fontes primary column: ID foreign column: Fonte foreign table: DicasSugestoes
// Key: FK_Receita_Fontes primary table: Fontes primary column: ID foreign column: Fonte foreign table: Receita
// Key: FK_Roteiros_Fontes primary table: Fontes primary column: ID foreign column: Fonte foreign table: Roteiros
// List of selected relation tables for this database
// Table: dtproperties
// Table: Alimentos
// Table: CedidoPor
// Table: Classificacoes
// Table: Concelho
// Table: Concorrente
// Table: DDicas_Alimentos
// Table: DDicas_Culinaria
// Table: DicasSugestoes
// Table: Distrito
// Table: DMenuSemana
// Table: DReceitaDia
// Table: DRoteiroMes
// Table: Fontes
// Table: Glossario
// Table: Ingredientes
// Table: LisboaProva
// Table: Login
// Table: MailingList
// Table: MailingList_Clientes
// Table: MailingList_Testes
// Table: MContactos
// Table: MPublicidade
// Table: MyReceitas
// Table: MyRestaurantes
// Table: MyRoteiros
// Table: Pais
// Table: Perguntas
// Table: PicanoChao
// Table: Picanochao_backup
// Table: Portal Jovem
// Table: PrecoMedio
// Table: Principedocalhariz
// Table: Promocoes
// Table: QuestRestaunet
// Table: Quintadosfrades
// Table: Receita
// Table: Regiao
// Table: Registos
// Table: Respostas
// Table: Respostas_Concorrente
// Table: RestauClientes
// Table: RestauClientes_Imagens
// Table: Restaurantes
// Table: Restaurantes_Comentarios
// Table: Restaurantes_Horario
// Table: Restaurantes_Ocasiao
// Table: Restaurantes_TipoCozinha
// Table: Restaurantes_TipoRestaurante
// Table: RM
// Table: Roteiros
// Table: Staff
// Table: Sugestoes
// Table: TipoAlimento
// Table: TipoCozinha
// Table: TipoData
// Table: TipoDicas
// Table: TipoEntidade
// Table: TipoOcasiao
// Table: TipoPacote
// Table: TipoPrato
// Table: TipoPreparacao
// Table: TipoPromocao
// Table: TipoRestaurantes
// Table: TipoUtensilio
// Table: Utensilios
// Table: Varandadomarques
/// <summary>
/// Return list of referenced objects from n:m relation with
/// table "DMenuSemana", using relation table "Receita"
/// </summary>
public IList referencedDMenuSemanaUsingReceita()
{
return new GentleList( typeof(DMenuSemana), this, typeof(Receita));
}
/// <summary>
/// Return list of referenced objects from n:m relation with
/// table "DMenuSemana", using relation table "Receita"
/// </summary>
public IList referencedDMenuSemanaUsingReceita()
{
return new GentleList( typeof(DMenuSemana), this, typeof(Receita));
}
/// <summary>
/// Return list of referenced objects from n:m relation with
/// table "DMenuSemana", using relation table "Receita"
/// </summary>
public IList referencedDMenuSemanaUsingReceita()
{
return new GentleList( typeof(DMenuSemana), this, typeof(Receita));
}
/// <summary>
/// Return list of referenced objects from n:m relation with
/// table "DReceitaDia", using relation table "Receita"
/// </summary>
public IList referencedDReceitaDiaUsingReceita()
{
return new GentleList( typeof(DReceitaDia), this, typeof(Receita));
}
/// <summary>
/// Return list of referenced objects from n:m relation with
/// table "MyReceitas", using relation table "Receita"
/// </summary>
public IList referencedMyReceitasUsingReceita()
{
return new GentleList( typeof(MyReceitas), this, typeof(Receita));
}
/// <summary>
/// Return list of referenced objects from n:m relation with
/// table "CedidoPor", using relation table "Receita"
/// </summary>
public IList referencedCedidoPorUsingReceita()
{
return new GentleList( typeof(CedidoPor), this, typeof(Receita));
}
/// <summary>
/// Return list of referenced objects from n:m relation with
/// table "Ingredientes", using relation table "Receita"
/// </summary>
public IList referencedIngredientesUsingReceita()
{
return new GentleList( typeof(Ingredientes), this, typeof(Receita));
}
/// <summary>
/// Return list of referenced objects from n:m relation with
/// table "Staff", using relation table "Receita"
/// </summary>
public IList referencedStaffUsingReceita()
{
return new GentleList( typeof(Staff), this, typeof(Receita));
}
/// <summary>
/// Return list of referenced objects from n:m relation with
/// table "MyRoteiros", using relation table "Roteiros"
/// </summary>
public IList referencedMyRoteirosUsingRoteiros()
{
return new GentleList( typeof(MyRoteiros), this, typeof(Roteiros));
}
/// <summary>
/// Return list of referenced objects from n:m relation with
/// table "Regiao", using relation table "Roteiros"
/// </summary>
public IList referencedRegiaoUsingRoteiros()
{
return new GentleList( typeof(Regiao), this, typeof(Roteiros));
}
/// <summary>
/// Return list of referenced objects from n:m relation with
/// table "Staff", using relation table "Roteiros"
/// </summary>
public IList referencedStaffUsingRoteiros()
{
return new GentleList( typeof(Staff), this, typeof(Roteiros));
}
#endregion
#region ManualCode
/***PRESERVE_BEGIN MANUAL_CODE***//***PRESERVE_END MANUAL_CODE***/
#endregion
}
#endregion
}