public virtual AssetWorkflowCommenter Update(AssetWorkflowCommenter assetWorkflowCommenter)
{
if (!assetWorkflowCommenter.IsDirty || assetWorkflowCommenter.IsNull)
{
// Nothing to do - no point hammering the database unnecessarily
return(assetWorkflowCommenter);
}
IDbCommand command = CreateCommand();
if (assetWorkflowCommenter.IsNew)
{
// Adding
command.CommandText = "INSERT INTO [AssetWorkflowCommenter] ([UserId], [InvitingAssetWorkflowUserId], [InvitingUserMessage], [Comments], [CreateDate], [LastUpdate]) VALUES (@userId, @invitingAssetWorkflowUserId, @invitingUserMessage, @comments, @createDate, @lastUpdate) ; SELECT @@identity AS NewId;";
}
else
{
// Updating
command.CommandText = "UPDATE [AssetWorkflowCommenter] SET [UserId] = @userId, [InvitingAssetWorkflowUserId] = @invitingAssetWorkflowUserId, [InvitingUserMessage] = @invitingUserMessage, [Comments] = @comments, [CreateDate] = @createDate, [LastUpdate] = @lastUpdate WHERE AssetWorkflowCommenterId = @assetWorkflowCommenterId";
}
command.Parameters.Add(CreateParameter("@userId", assetWorkflowCommenter.UserId));
command.Parameters.Add(CreateParameter("@invitingAssetWorkflowUserId", assetWorkflowCommenter.InvitingAssetWorkflowUserId));
command.Parameters.Add(CreateParameter("@invitingUserMessage", assetWorkflowCommenter.InvitingUserMessage));
command.Parameters.Add(CreateParameter("@comments", assetWorkflowCommenter.Comments));
command.Parameters.Add(CreateParameter("@createDate", assetWorkflowCommenter.CreateDate));
command.Parameters.Add(CreateParameter("@lastUpdate", assetWorkflowCommenter.LastUpdate));
if (assetWorkflowCommenter.IsNew)
{
assetWorkflowCommenter.AssetWorkflowCommenterId = Convert.ToInt32(ExecScalar(command));
}
else
{
command.Parameters.Add(CreateParameter("@assetWorkflowCommenterId", assetWorkflowCommenter.AssetWorkflowCommenterId));
ExecuteCommand(command);
}
assetWorkflowCommenter.IsDirty = false;
assetWorkflowCommenter.ChangedProperties.Clear();
return(assetWorkflowCommenter);
}
protected override object ReadRow(IRowReader reader)
{
AssetWorkflowCommenter assetWorkflowCommenter = AssetWorkflowCommenter.New();
// Table Fields
assetWorkflowCommenter.AssetWorkflowCommenterId = reader.GetInt32("AssetWorkflowCommenterId");
assetWorkflowCommenter.UserId = reader.GetInt32("UserId");
assetWorkflowCommenter.InvitingAssetWorkflowUserId = reader.GetInt32("InvitingAssetWorkflowUserId");
assetWorkflowCommenter.InvitingUserMessage = reader.GetString("InvitingUserMessage");
assetWorkflowCommenter.Comments = reader.GetString("Comments");
assetWorkflowCommenter.CreateDate = reader.GetDateTime("CreateDate");
assetWorkflowCommenter.LastUpdate = reader.GetDateTime("LastUpdate");
// View Fields
assetWorkflowCommenter.InvitingUserId = reader.GetInt32("InvitingUserId");
assetWorkflowCommenter.AssetWorkflowId = reader.GetInt32("AssetWorkflowId");
assetWorkflowCommenter.IsDirty = false;
assetWorkflowCommenter.ChangedProperties.Clear();
return(assetWorkflowCommenter);
}
public static AssetWorkflowCommenter Update(AssetWorkflowCommenter assetWorkflowCommenter)
{
return(AssetWorkflowCommenterMapper.Instance.Update(assetWorkflowCommenter));
}
public static AssetWorkflowCommenter FindOne(AssetWorkflowCommenterFinder finder)
{
AssetWorkflowCommenter AssetWorkflowCommenter = AssetWorkflowCommenterMapper.Instance.FindOne(finder);
return(AssetWorkflowCommenter ?? Empty);
}
public static AssetWorkflowCommenter Get(Nullable <Int32> AssetWorkflowCommenterId)
{
AssetWorkflowCommenter AssetWorkflowCommenter = AssetWorkflowCommenterMapper.Instance.Get(AssetWorkflowCommenterId);
return(AssetWorkflowCommenter ?? Empty);
}
