private async Task <int> AddSerials(List <SerialsDB> serials, int id) { int adds = 0; int idSerial = _invoicesService.GetLastIdInvoiceSerials().Result; idSerial++; foreach (var s in serials) { var existingSerial = _serialService.GetSerialBySerial(s.Serial); var aux = existingSerial.Result != null ? existingSerial.Result.Id : 0; if (aux != 0) { var newItem = new InvoiceSerials { Id = idSerial, Serial = s.Serial.ToString(), InvoiceID = id }; idSerial++; var res = await _invoicesService.UpdateInvoiceSerialsTable(newItem); adds += res; } } return(adds); }
public async Task <int> UpdateInvoiceSerialsTable(InvoiceSerials item) { DbConnection connection = GetConnection(); string insertQuery = @"INSERT INTO [dbo].[InvoiceSerials]([Id], [Serial], [InvoiceID]) VALUES (" + item.Id + ", '" + item.Serial + "', " + item.InvoiceID + ")"; var result = connection.Execute(insertQuery); connection.Close(); return(result); }