public async Task DeleteAsync(string id, string userId) { ProductVehicle productVehicle = new ProductVehicle() { Id = id, Deleted = true, DeletedAt = DateTime.Now, }; await UpdateAsync(productVehicle, userId); }
public async Task UpdateAsync(ProductVehicle entity, string userId) { var db = _databaseLocator.GetProductCenterManagementDatabase(); var tran = _databaseLocator.GetDbTransaction(db); StringBuilder updated_params = new StringBuilder(); if (entity.DeletedAt.HasValue) { updated_params.Append(" Deleted=@Deleted, "); } if (!string.IsNullOrEmpty(userId)) { updated_params.Append(" DeletedById=@DeletedById, "); } if (entity.DeletedAt.HasValue) { updated_params.Append(" DeletedAt=@DeletedAt, "); } if (!string.IsNullOrWhiteSpace(updated_params.ToString())) { updated_params.Append(" UpdatedAt=NOW(), "); updated_params.Append(" UpdatedById=@UpdatedById "); await db.ExecuteAsync( $" UPDATE {_TABLE} SET {updated_params.ToString()} WHERE Id=@Id ", new { entity.Id, entity.Deleted, entity.DeletedAt, DeletedById = userId, UpdatedById = userId, }); } }