public async Task AddAsync(ProducType entity, string userId)
{
var db = _databaseLocator.GetProductCenterManagementDatabase();
var tran = _databaseLocator.GetDbTransaction(db);
StringBuilder sql = new StringBuilder();
sql.Append($" INSERT INTO {_TABLE} ");
sql.Append(" (Id, ParentId, LevelCode, TypeName, TypeCode, SortOrder, CreatedById, CreatedAt) ");
sql.Append($" VALUES ");
sql.Append(" (nextval('PT'), @ParentId, @LevelCode, @TypeName, @TypeCode, @SortOrder, @CreatedById, NOW()) ");
await db.ExecuteAsync(sql.ToString(), new { entity.ParentId, entity.LevelCode, entity.TypeCode, entity.TypeName, entity.SortOrder, CreatedById = userId }, tran);
}
public async Task UpdateAsync(ProducType entity, string userId)
{
var db = _databaseLocator.GetProductCenterManagementDatabase();
var tran = _databaseLocator.GetDbTransaction(db);
StringBuilder updatedParams = new StringBuilder();
if (!string.IsNullOrWhiteSpace(entity.TypeName))
{
updatedParams.Append("TypeName = @TypeName,");
}
if (entity.Deleted.HasValue)
{
updatedParams.Append("Deleted = @Deleted,");
updatedParams.Append("DeletedAt = NOW(),");
}
if (!string.IsNullOrWhiteSpace(userId))
{
updatedParams.Append("DeletedById = @DeletedById,");
}
if (!string.IsNullOrWhiteSpace(userId))
{
updatedParams.Append("UpdatedById = @UpdatedById,");
}
if (!string.IsNullOrWhiteSpace(updatedParams.ToString()))
{
updatedParams.Append("UpdatedAt = NOW()");
await db.ExecuteAsync(
$"UPDATE {_TABLE} SET {updatedParams.ToString()} WHERE Id=@Id ",
new
{
entity.Id,
entity.TypeName,
entity.Deleted,
DeletedById = userId,
UpdatedById = userId,
}, tran);
}
}
