public static long?VerifyAnalyzerInstanceID(long analyzerInstanceID, FortuneStreetAppContext fortuneStreetAppContext) { try { CurrentAnalyzerInstancesTVF currentAnalyzerInstancesTVFResult = fortuneStreetAppContext.CurrentAnalyzerInstancesTVF.FromSqlInterpolated($"SELECT * FROM currentanalyzerinstances_tvf() WHERE analyzer_instance_id = {analyzerInstanceID} AND status = 'in_progress'").FirstOrDefault(); string userIPAddress = GetUserIPAddress(); if (currentAnalyzerInstancesTVFResult == null || !HashComparison(userIPAddress, currentAnalyzerInstancesTVFResult.IPAddress)) { AnalyzerInstances analyzerInstanceRecord = new AnalyzerInstances { IPAddress = Hash(userIPAddress), Status = "in_progress" }; fortuneStreetAppContext.AnalyzerInstances.Add(analyzerInstanceRecord); fortuneStreetAppContext.SaveChanges(); analyzerInstanceRecord.AnalyzerInstanceID = analyzerInstanceRecord.ID; fortuneStreetAppContext.SaveChanges(); return(analyzerInstanceRecord.AnalyzerInstanceID); } return(currentAnalyzerInstancesTVFResult.AnalyzerInstanceID); } catch { return(null); } }
public IndexModel(FortuneStreetAppContext fortuneStreetAppContext) { _fortuneStreetAppContext = fortuneStreetAppContext; }