protected override object ReadRow(IRowReader reader)
{
AssetFilePath assetFilePath = AssetFilePath.New();
// Table Fields
assetFilePath.AssetFilePathId = reader.GetInt32("AssetFilePathId");
assetFilePath.Path = reader.GetString("Path");
assetFilePath.IsDefault = reader.GetBoolean("IsDefault");
assetFilePath.IsDirty = false;
assetFilePath.ChangedProperties.Clear();
return(assetFilePath);
}
public virtual AssetFilePath Update(AssetFilePath assetFilePath)
{
if (!assetFilePath.IsDirty || assetFilePath.IsNull)
{
// Nothing to do - no point hammering the database unnecessarily
return(assetFilePath);
}
IDbCommand command = CreateCommand();
if (assetFilePath.IsNew)
{
// Adding
command.CommandText = "INSERT INTO [AssetFilePath] ([Path], [IsDefault]) VALUES (@path, @isDefault) ; SELECT @@identity AS NewId;";
}
else
{
// Updating
command.CommandText = "UPDATE [AssetFilePath] SET [Path] = @path, [IsDefault] = @isDefault WHERE AssetFilePathId = @assetFilePathId";
}
command.Parameters.Add(CreateParameter("@path", assetFilePath.Path));
command.Parameters.Add(CreateParameter("@isDefault", assetFilePath.IsDefault));
if (assetFilePath.IsNew)
{
assetFilePath.AssetFilePathId = Convert.ToInt32(ExecScalar(command));
}
else
{
command.Parameters.Add(CreateParameter("@assetFilePathId", assetFilePath.AssetFilePathId));
ExecuteCommand(command);
}
assetFilePath.IsDirty = false;
assetFilePath.ChangedProperties.Clear();
return(assetFilePath);
}
public static AssetFilePath Update(AssetFilePath assetFilePath)
{
return(AssetFilePathMapper.Instance.Update(assetFilePath));
}
public static AssetFilePath FindOne(AssetFilePathFinder finder)
{
AssetFilePath AssetFilePath = AssetFilePathMapper.Instance.FindOne(finder);
return(AssetFilePath ?? Empty);
}
public static AssetFilePath Get(Nullable <Int32> AssetFilePathId)
{
AssetFilePath AssetFilePath = AssetFilePathMapper.Instance.Get(AssetFilePathId);
return(AssetFilePath ?? Empty);
}
