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); }