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