/// <summary>
/// Criar a tabela no banco de dados
/// </summary>
/// <returns>true se criar</returns>
public virtual void Create()
{
try
{
using (var trans = TransManager.GetTrans())
{
var eventArgs = new TableAdapterEventArgs();
if (OnBeforeCreate != null)
{
OnBeforeCreate(this, eventArgs);
}
var command = GetCreateCommand();
Connection.SqlServerExecute(command.Item1, command.Item2);
eventArgs = new TableAdapterEventArgs();
if (OnAfterCreate != null)
{
OnAfterCreate(this, eventArgs);
}
trans.Complete();
}
}
catch (Exception ex)
{
var message = string.Format("Erro ao criar a tabela [{0}..{1}]", DBName, TableName);
throw new Exception(message, ex);
}
}
/// <summary>
/// Atualiza o registro no banco de dados
/// </summary>
/// <returns>True se atualizar</returns>
public virtual void Update()
{
using (var trans = TransManager.GetTrans())
{
var eventArgs = new TableAdapterEventArgs();
if (OnBeforeUpdate != null)
{
OnBeforeUpdate(this, eventArgs);
}
var command = GetUpdateCommand();
Connection.SqlServerExecute(command.Item1, command.Item2);
eventArgs = new TableAdapterEventArgs();
if (OnAfterUpdate != null)
{
eventArgs.Keys = KeyFields;
OnAfterUpdate(this, eventArgs);
}
trans.Complete();
}
}
/// <summary>
/// Adiciona um registro no banco de dados
/// </summary>
/// <returns>true se adicionar</returns>
public virtual void Add()
{
using (var trans = TransManager.GetTrans())
{
var eventArgs = new TableAdapterEventArgs();
if (OnBeforeAdd != null)
{
OnBeforeAdd(this, eventArgs);
}
var inserdCommand = GetInsertCommand();
var lastInsertedId = Connection.SqlServerExecuteAndGetLastInsertId(inserdCommand.Item1, inserdCommand.Item2);
SetIdentityValue(lastInsertedId);
eventArgs.Keys = KeyFields;
eventArgs = new TableAdapterEventArgs();
if (OnAfterAdd != null)
{
OnAfterAdd(this, eventArgs);
}
trans.Complete();
}
}
/// <summary>
/// Pega o registro pelas chaves
/// </summary>
/// <returns>True se encontrar</returns>
public virtual bool GetByKey()
{
using (var trans = TransManager.GetTrans())
{
var eventArgs = new TableAdapterEventArgs();
if (OnBeforeSelect != null)
{
OnBeforeSelect(this, eventArgs);
}
var command = GetSelectCommand();
var data = Connection.SqlServerQuery(command.Item1, command.Item2);
var foundRecord = data.Rows.Count > 0;
if (foundRecord)
{
eventArgs = new TableAdapterEventArgs
{
Keys = KeyFields
};
FillFields(data.Rows[0], true);
StateRecord = eState.eDatabase;
if (OnAfterSelect != null)
{
OnAfterSelect(this, eventArgs);
}
}
trans.Complete();
return(foundRecord);
}
}
