public void AddAnalysisInfo(AnalysisDto analysis) { string sqlInsert = "INSERT INTO fx." + AnalysisInfoTable + "(AnalysisName, Symbol, FirstAnalysedItemDate, LastAnalysedItemDate, AnalysedUnits, " + "AnalysisStart, AnalysisEnd, AnalysisTotalTime) " + "VALUES ('" + analysis.Type + "'" + ", '" + analysis.Symbol + "'" + ", '" + analysis.FirstItemDate + "'" + ", '" + analysis.LastItemDate + "'" + ", " + analysis.AnalyzedItems + ", '" + analysis.AnalysisStart + "'" + ", '" + analysis.AnalysisEnd + "'" + ", " + analysis.AnalysisTotalTime.ToDbString() + ");"; using (var context = new EFDbContext()) { context.Database.ExecuteSqlCommand(sqlInsert); context.SaveChanges(); } }
public AnalysisDto ToDto() { var dto = new AnalysisDto { Type = Type.TableName(), Symbol = Symbol, FirstItemDate = FirstItemDate, LastItemDate = LastItemDate, AnalyzedItems = AnalyzedItems, AnalysisStart = AnalysisStart, AnalysisEnd = AnalysisEnd, AnalysisTotalTime = TotalTime() }; return dto; }