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