async Task ProcessRecords(Tuple <long, string> record)
{
var Data = record.Item2;
var TrimmedData = Data.Trim();
CurrentInstanceId = record.Item1;
if (!(TrimmedData.Length % 4 == 0 && Regex.IsMatch(TrimmedData, @"^[a-zA-Z0-9\+/]*={0,3}$", RegexOptions.None)))
{
var CompressedData = StringCompressor.Compress(Data);
try
{
using (var Connection = new SqlConnection(ConnectionString))
using (var Command = new SqlCommand($"UPDATE UserAssignments SET {newColumnName} = '{CompressedData}' WHERE InstanceId = {record.Item1}", Connection))
{
if (Connection.State == ConnectionState.Closed)
{
Connection.Open();
}
await Command.ExecuteNonQueryAsync();
LastProcessedInstanceID = record.Item1;
logger.Log(LogLevel.Trace, "Processed InstanceId : " + record.Item1);
}
}
catch (Exception ex)
{
FailedInstanceIDs.Add(CurrentInstanceId.ToString());
logger.Log(LogLevel.Error, ex.Message);
}
}
}
async Task ProcessRecordsLast10Records(Tuple <long, string> record)
{
Console.WriteLine("Processing InstanceId : " + record.Item1);
logger.Log(LogLevel.Trace, "Processing InstanceId : " + record.Item1);
var Data = record.Item2;
var TrimmedData = Data.Trim();
CurrentInstanceId = record.Item1;
//if (!(TrimmedData.Length % 4 == 0 && Regex.IsMatch(TrimmedData, @"^[a-zA-Z0-9\+/]*={0,3}$", RegexOptions.None)))
{
var DeCompressedData = StringCompressor.Decompress(Data);
try
{
using (var Connection = new SqlConnection(ConnectionString))
using (var Command = new SqlCommand($"UPDATE UserAssignments SET SimulationRecordsStoreDocument = '{DeCompressedData}' WHERE InstanceId = {record.Item1}", Connection))
{
if (Connection.State == ConnectionState.Closed)
{
Connection.Open();
}
await Command.ExecuteNonQueryAsync();
LastProcessedInstanceID = record.Item1;
Console.WriteLine("Finished processing InstanceId : " + record.Item1);
logger.Log(LogLevel.Trace, "Finished processing InstanceId : " + record.Item1);
}
}
catch (Exception ex)
{
// store the instanceID into list
FailedInstanceIDs.Add(CurrentInstanceId.ToString());
logger.Log(LogLevel.Error, ex.Message);
Console.WriteLine(ex.Message);
Console.WriteLine(ex.StackTrace);
}
}
}
