private int?AddCharterer(string name)
{
var newObj = new Charterer()
{
Name = name
};
string sql =
$"INSERT INTO Charterer (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();
CharterersList.Add(newObj);
}
return(newObj.Id);
}
public int?GetChartererIdFromName(string name)
{
if (string.IsNullOrWhiteSpace(name))
{
return(null);
}
var charterer = GetTargoValue("Charterer", name);
var result = CharterersList.Any(x => x.Name.ToLower() == charterer.ToLower())
? CharterersList.FirstOrDefault(x => x.Name.ToLower() == charterer.ToLower())?.Id
: AddCharterer(charterer);
if (result == 0)
{
return(null);
}
return(result);
}