public async Task CreateRequest(string userId) { List<Language> languages = new List<Language>() { new EnglishLanguage(), new SpanishLanguage(), new PortugalLanguage(), new RussianLanguage(), new BulgarianLanguage() }; JavaScriptSerializer serializer = new JavaScriptSerializer(); LangDetector detector = new LangDetector(); var gridModel = new List<ComparableGridModel>(); _builder.Clear(); string queryString = string.Format(@"Update RequestsInfo Set amountOfQueries = amountOfQueries+1, lastLoginDateTime='{0}' Where id='{1}';", DateTime.Now, userId); await _context.ExecuteQueryAsync(queryString); for (int z = 0; z < 10; z++) { _builder.Append((char)_random.Next(0x041, 0x015A)); } foreach (Language language in languages) { gridModel.Add(detector.Detect(_builder.ToString(), language)); } string JSonString = serializer.Serialize(gridModel); queryString = string.Format(@"INSERT INTO Requests(UserId, QueryString, QueryResult) VALUES ('{0}', '{1}', '{2}');" , userId, _builder, JSonString); //context.ExecuteQuery(queryString); await _context.ExecuteQueryAsync(queryString); _builder.Clear(); }
public async Task CreateRequest(string userId) { List <Language> languages = new List <Language>() { new EnglishLanguage(), new SpanishLanguage(), new PortugalLanguage(), new RussianLanguage(), new BulgarianLanguage() }; JavaScriptSerializer serializer = new JavaScriptSerializer(); LangDetector detector = new LangDetector(); var gridModel = new List <ComparableGridModel>(); _builder.Clear(); string queryString = string.Format(@"Update RequestsInfo Set amountOfQueries = amountOfQueries+1, lastLoginDateTime='{0}' Where id='{1}';", DateTime.Now, userId); await _context.ExecuteQueryAsync(queryString); for (int z = 0; z < 10; z++) { _builder.Append((char)_random.Next(0x041, 0x015A)); } foreach (Language language in languages) { gridModel.Add(detector.Detect(_builder.ToString(), language)); } string JSonString = serializer.Serialize(gridModel); queryString = string.Format(@"INSERT INTO Requests(UserId, QueryString, QueryResult) VALUES ('{0}', '{1}', '{2}');" , userId, _builder, JSonString); //context.ExecuteQuery(queryString); await _context.ExecuteQueryAsync(queryString); _builder.Clear(); }