public string ErrorMessageSavingDataToDb(string raceResultsArchiveId, string raceResultsArchiveTitle, DataTable grandPrixResults) { var errorMessage = string.Empty; try { using (var context = new GrandPrixResultsContext(ConnectionString)) { context.GrandPrix.Add (new GrandPrix { GrandPrixId = raceResultsArchiveId, GrandPrixResultsTitle = raceResultsArchiveTitle }); foreach (DataRow dataRow in grandPrixResults.Rows) { context.GrandPrixResults.Add(new GrandPrixResults(raceResultsArchiveId, dataRow)); } context.SaveChanges(); } } catch (Exception exception) { errorMessage = exception.Message; } return(errorMessage); }
public bool IsRaceResultsExistsInDbByIdCheck(string raceResultsArchiveId) { using (var context = new GrandPrixResultsContext(ConnectionString)) return(context.GrandPrix.Any(grandPrix => grandPrix.GrandPrixId == raceResultsArchiveId)); }