public async Task UpOrDownAsync(string id, int sortValue, string userId)
{
PropertiesOption up = new PropertiesOption()
{
Id = id, SortOrder = sortValue
};
await UpdateAsync(up, userId);
}
public async Task DisableAsync(string id, string userId)
{
PropertiesOption option = new PropertiesOption()
{
Id = id, IsDisable = true
};
await UpdateAsync(option, userId);
}
public async Task UpdateAsync(PropertiesOption entity, string userId)
{
var db = _databaseLocator.GetProductCenterManagementDatabase();
var tran = _databaseLocator.GetDbTransaction(db);
StringBuilder updatedParams = new StringBuilder();
if (!string.IsNullOrWhiteSpace(entity.OptionName))
{
updatedParams.Append("OptionName = @OptionName,");
}
if (entity.IsDisable.HasValue)
{
updatedParams.Append("IsDisable = @IsDisable,");
}
if (entity.SortOrder.HasValue)
{
updatedParams.Append("SortOrder = @SortOrder,");
}
if (!string.IsNullOrWhiteSpace(userId))
{
updatedParams.Append("UpdatedById = @UpdatedById,");
}
if (!string.IsNullOrWhiteSpace(updatedParams.ToString()))
{
updatedParams.Append("UpdatedAt=NOW()");
var result = await db.ExecuteAsync(
$"UPDATE {_TABLE} SET {updatedParams.ToString()} WHERE Id=@Id",
new
{
entity.Id,
entity.OptionName,
entity.IsDisable,
entity.SortOrder,
UpdatedById = userId,
},
tran);
}
}
public async Task AddAsync(PropertiesOption entity, string userId)
{
var db = _databaseLocator.GetProductCenterManagementDatabase();
var tran = _databaseLocator.GetDbTransaction(db);
StringBuilder sql = new StringBuilder();
sql.Append($" INSERT INTO {_TABLE} ");
sql.Append(" (Id,PropId,OptionName,IsDisable,SortOrder, CreatedAt,CreatedById) ");
sql.Append($" VALUES ");
sql.Append(" (nextval('PO'),@PropId,@OptionName,@IsDisable,@SortOrder,NOW(),@CreatedById) ");
await db.ExecuteAsync(
sql.ToString(),
new
{
entity.PropId,
entity.OptionName,
entity.IsDisable,
entity.SortOrder,
CreatedById = userId,
},
tran);
}
