private async Task <int> AddSerials(List <SerialsDB> serials, int id)
{
int adds = 0;
int idSerial = _dispatchesService.GetLastIdDispatchSerials().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 DispatchSerials
{
Id = idSerial,
Serial = s.Serial.ToString(),
DispatchID = id
};
idSerial++;
var res = await _dispatchesService.UpdateDispatchSerialsTable(newItem);
adds += res;
}
}
return(adds);
}
public async Task <int> UpdateDispatchSerialsTable(DispatchSerials item)
{
DbConnection connection = GetConnection();
string insertQuery = @"INSERT INTO [dbo].[DispatchSerials]([Id], [Serial], [DispatchID]) VALUES (" +
item.Id + ", '" + item.Serial + "', " + item.DispatchID + ")";
var result = connection.Execute(insertQuery);
connection.Close();
return(result);
}
