protected override object ReadRow(IRowReader reader)
{
AuditAssetSearchKeyword auditAssetSearchKeyword = AuditAssetSearchKeyword.New();
// Table Fields
auditAssetSearchKeyword.AuditAssetSearchKeywordId = reader.GetInt32("AuditAssetSearchKeywordId");
auditAssetSearchKeyword.AuditAssetSearchId = reader.GetInt32("AuditAssetSearchId");
auditAssetSearchKeyword.SearchKeyword = reader.GetString("SearchKeyword");
auditAssetSearchKeyword.IsDirty = false;
auditAssetSearchKeyword.ChangedProperties.Clear();
return(auditAssetSearchKeyword);
}
public virtual AuditAssetSearchKeyword Update(AuditAssetSearchKeyword auditAssetSearchKeyword)
{
if (!auditAssetSearchKeyword.IsDirty || auditAssetSearchKeyword.IsNull)
{
// Nothing to do - no point hammering the database unnecessarily
return(auditAssetSearchKeyword);
}
IDbCommand command = CreateCommand();
if (auditAssetSearchKeyword.IsNew)
{
// Adding
command.CommandText = "INSERT INTO [AuditAssetSearchKeyword] ([AuditAssetSearchId], [SearchKeyword]) VALUES (@auditAssetSearchId, @searchKeyword) ; SELECT @@identity AS NewId;";
}
else
{
// Updating
command.CommandText = "UPDATE [AuditAssetSearchKeyword] SET [AuditAssetSearchId] = @auditAssetSearchId, [SearchKeyword] = @searchKeyword WHERE AuditAssetSearchKeywordId = @auditAssetSearchKeywordId";
}
command.Parameters.Add(CreateParameter("@auditAssetSearchId", auditAssetSearchKeyword.AuditAssetSearchId));
command.Parameters.Add(CreateParameter("@searchKeyword", auditAssetSearchKeyword.SearchKeyword));
if (auditAssetSearchKeyword.IsNew)
{
auditAssetSearchKeyword.AuditAssetSearchKeywordId = Convert.ToInt32(ExecScalar(command));
}
else
{
command.Parameters.Add(CreateParameter("@auditAssetSearchKeywordId", auditAssetSearchKeyword.AuditAssetSearchKeywordId));
ExecuteCommand(command);
}
auditAssetSearchKeyword.IsDirty = false;
auditAssetSearchKeyword.ChangedProperties.Clear();
return(auditAssetSearchKeyword);
}
public static AuditAssetSearchKeyword FindOne(AuditAssetSearchKeywordFinder finder)
{
AuditAssetSearchKeyword AuditAssetSearchKeyword = AuditAssetSearchKeywordMapper.Instance.FindOne(finder);
return(AuditAssetSearchKeyword ?? Empty);
}
public static AuditAssetSearchKeyword Update(AuditAssetSearchKeyword auditAssetSearchSector)
{
return(AuditAssetSearchKeywordMapper.Instance.Update(auditAssetSearchSector));
}
public static AuditAssetSearchKeyword Get(Nullable <Int32> AuditAssetSearchKeywordId)
{
AuditAssetSearchKeyword AuditAssetSearchKeyword = AuditAssetSearchKeywordMapper.Instance.Get(AuditAssetSearchKeywordId);
return(AuditAssetSearchKeyword ?? Empty);
}