public async Task <IActionResult> GetItem(int?id) { var response = await _getItem.GetItems(id); //var service = new InvoiceService(); //service.Get(response.Items); return(Ok(response)); }
public async Task <JsonResult> GetItems([FromQuery] int?id, string replydatetime) { Item item = new Item(); item.Id = id.Value; item.ReplyDateTime = replydatetime; var jsonResult = await _getItem.GetItems <Item>(item, Item.nomeTabela); return(Json(jsonResult)); }
public async Task <JsonResult> GetItems([FromQuery] int?codigo, string uf) { Item item = new Item(); item.Codigo = codigo.Value; item.UF = uf; var jsonResult = await _getItem.GetItems <Item>(item, Item.nomeTabela); return(Json(jsonResult)); }
public async Task <UpdateItemResponse> UpdateItems <T>(T tabelaInterna, string nomeTabela) { tableUpdate = Table.LoadTable(_dynamoDbClient, nomeTabela); DynamoDBContext db = new DynamoDBContext(_dynamoDbClient); var respostaGet = await _getItem.GetItems(tabelaInterna, nomeTabela); Document documentResponseGet = Document.FromJson(respostaGet); Document documentRequestUpdate = db.ToDocument(tabelaInterna); //Variaveis internas List <String> keyUpdate = new List <string>(); Dictionary <string, AttributeValueUpdate> valoresUpdate = new Dictionary <string, AttributeValueUpdate>(); //Veriricar quais elementos deverão ser modificados para o update foreach (var i in documentResponseGet) { foreach (var j in documentRequestUpdate) { if (i.Key == j.Key) { if (i.Value.ToString() != j.Value.ToString()) { var valor = j.Value; //valor keyUpdate.Add(j.Key.ToString()); } } } } chaveUpdate = tableUpdate.ToAttributeMap(documentRequestUpdate); foreach (var item in keyUpdate) { foreach (var chave in chaveUpdate) { if (item == chave.Key) { AttributeValueUpdate valorUpdate = new AttributeValueUpdate(chave.Value, "PUT"); valoresUpdate.Add(chave.Key, valorUpdate); } } } chaveUpdate = Utils.VerificarChaves(chaveUpdate, tableUpdate); var response = await _dynamoDbClient.UpdateItemAsync(nomeTabela, chaveUpdate, valoresUpdate, cancellationToken); db.Dispose(); return(response); }
public async Task <Item> DeleteItems(int id) { var deleteItem = _getItem.GetItems(id); var registerDateTime = deleteItem.Result.Items.Select(x => x.RegisterDateTime).FirstOrDefault(); var deleteItemRequest = DeleteItemRequest(id, registerDateTime); var response = await _amazonDynamoDB.DeleteItemAsync(deleteItemRequest); return(new Item { Id = Convert.ToInt32(response.Attributes["Id"].N), Price = Convert.ToDouble(response.Attributes["Price"].N), RegisterDateTime = response.Attributes["RegisterDateTime"].N }); }
public async Task <Item> Update(int id, double price) { var response = await _getItem.GetItems(id); var currentPrice = response.Items.Select(p => p.Price).FirstOrDefault(); var replyDateTime = response.Items.Select(p => p.ReplyDateTime).FirstOrDefault(); var request = RequestBuilder(id, price, currentPrice, replyDateTime); var result = await UpdateItemAsync(request); return(new Item { Id = Convert.ToInt32(result.Attributes["Id"].N), ReplyDateTime = result.Attributes["ReplyDateTime"].N, Price = Convert.ToDouble(result.Attributes["Price"].N) }); }
public async Task <Item> UpdateItems(int id, double price) { var response = _getItem.GetItems(id); var currentPrice = response.Result.Items.Select(z => z.Price).FirstOrDefault(); var registerDateTime = response.Result.Items.Select(z => z.RegisterDateTime).FirstOrDefault(); var request = GetUpdateItemRequest(id, currentPrice, registerDateTime, price); var client = new AmazonDynamoDBClient(); var result = await UpdateItemAsyns(request); return(new Item { Id = Convert.ToInt32(result.Attributes["Id"].N), Price = Convert.ToDouble(result.Attributes["Price"].N), RegisterDateTime = result.Attributes["RegisterDateTime"].N.ToString() }); }
public async Task <IActionResult> GetItems([FromQuery] int?id) { var response = await _getItem.GetItems(id); return(Ok(response)); }