private int?AddCounterpart(string name)
{
var newObj = new Counterpart()
{
Name = name
};
string sql =
$"INSERT INTO Counterpart (Name,IdSource) VALUES (@name,@_sourceClipper); SELECT CAST(SCOPE_IDENTITY() as int)";
using (var connection = ConnectionFactory.GetOpenConnection())
{
newObj.Id = connection.Query <int>(sql, new { newObj.Name, _sourceClipper }).Single();
CounterpartsList.Add(newObj);
}
return(newObj.Id);
}
public int?GetCounterpartId(ClipperData clipperData)
{
if (string.IsNullOrWhiteSpace(clipperData.LoadOwner) || clipperData.LoadOwner == "UNKNOWN")
{
return(null);
}
var name = clipperData.LoadOwner;
var result = CounterpartsList.Any(x => x.Name.ToLower() == name.ToLower())
? CounterpartsList.FirstOrDefault(x => x.Name.ToLower() == name.ToLower())?.Id
: AddCounterpart(name);
if (result == 0)
{
return(null);
}
return(result);
}