public static void Main() { var db = new ApplicationDbContext(); var repo = new DbRepository<JokeCategory>(db); var categoriesService = new CategoriesService(repo); var configuration = Configuration.Default.WithDefaultLoader(); var browsingContext = BrowsingContext.New(configuration); for (int i = 1; i <= 10000; i++) { var url = $"http://vicove.com/vic-{i}"; var document = browsingContext.OpenAsync(url).Result; var jokeContent = document.QuerySelector("#content_box .post-content").TextContent.Trim(); if (!string.IsNullOrWhiteSpace(jokeContent)) { var categoryName = document.QuerySelector("#content_box .thecategory a").TextContent.Trim(); var category = categoriesService.EnsureCategory(categoryName); var joke = new Joke { Category = category, Content = jokeContent }; db.Jokes.Add(joke); db.SaveChanges(); Console.WriteLine(i); } } }
//[Test] public void ConsultaTodosOsProdutos() { Joke<ProdutoTeste> targetTeste = new Joke<ProdutoTeste>(); List<ProdutoTeste> produtos = targetTeste.GetAll(); Assert.That(produtos.Count, Is.EqualTo(11088)); }
//[Test] public void ConsultaTodasAsCategoriasPrincipais() { Joke<CategoriaTeste> targetTeste = new Joke<CategoriaTeste>(); List<CategoriaTeste> produtos = targetTeste.Query() .Where("id_categoria_teste = 0").Execute(); Assert.That(produtos.Count, Is.EqualTo(27)); }
internal void CarregaSubCategorias() { var sql = new Joke<CategoriaTeste>().Query() .Where("categoriaTeste.IdCategoriaTeste = " + Id); var lis = sql.Execute(); subCategorias = lis; }
public int AddJoke(string mText, int mMemberID) { NokatEntities entities = new NokatEntities(); Joke _Jok = new Joke { JokeText = mText, MemberID = mMemberID,TimeAdded=DateTime.Now.ToUniversalTime() , Rank = 0 , Good= 0 , Bad = 0 }; entities.Jokes.AddObject(_Jok); entities.SaveChanges(); return _Jok.ID; }
//[Test] public void ConsultaCategoriaPorNome() { Joke<CategoriaTeste> targetTeste = new Joke<CategoriaTeste>(); List<CategoriaTeste> produtos = targetTeste.Query() .Where("categoriaTeste.Nome = 'Arroz, Massas e Pratos Prontos'") .Execute(); Assert.That(produtos.Count, Is.EqualTo(1)); }
static DemoServiceImpl() { m_dict = new Dictionary<string, State?>(); m_jokes = new List<Joke>(); m_jokes.Add(new Joke() { Question = "Why did the chicken code in VBScript?", Answer = "His head was cut off.", DateAdded = DateTime.Now }); m_jokes.Add(new Joke() { Question = "How many VBScript programmers does it take to screw in a light bulb?", Answer = "Three. One IsObject, one IsArray, and one to figure out the difference.", DateAdded = DateTime.Now }); m_jokes.Add(new Joke() { Question = "What is the keyword \"set\" for?", Answer = "The code wasn't unreliable enough without the extra keyword.", DateAdded = DateTime.Now }); s_status = new Joke() { Question = "Status?", Answer = "Foo: RequestId: ", DateAdded = DateTime.Now }; m_jokes.Add(s_status); }
//[Test] public void ConsultaProdutosPorId() { Joke<ProdutoTeste> targetTeste = new Joke<ProdutoTeste>(); List<ProdutoTeste> produtos = targetTeste.Query() .Where("produtoTeste.Id <= 10") .Execute(); Assert.That(produtos.Count, Is.EqualTo(10)); }
public void SetUp() { DictionaryEntitiesMap.INSTANCE.TryAddEntity(typeof(CategoriaTeste)); DictionaryEntitiesMap.INSTANCE.TryAddEntity(typeof(Ags)); target = new Joke<CategoriaTeste>(); JokeConfigurationBuilder.NewConfigurationToPostgreSQL() .Host(LOCAL_HOST) .Port(PORTA_5432) .Username(USER) .Password(SENHA) .DataBase(JOKE_BD) .BuildConfiguration(); }
public bool delJoke(string usuw) { if (usuw == null) { return(false); } else { int usuwID = int.Parse(usuw); Joke usuwany = this.x.GetByID(usuwID); this.x.Delete(usuwany); x.Commit(); return(true); } }
public async Task <ActionResult> Post([FromBody] Joke joke) { if (AuthorizationUtils.Authorized(Request, _config) == false) { return(Unauthorized()); } if (joke == null || String.IsNullOrEmpty(joke.JokeText)) { return(BadRequest()); } var j = await _data.Add(joke); return(Ok()); }
private Joke SetValue(Joke x) { int CatId = Convert.ToInt32(ddlCat.SelectedValue); x.id = Convert.ToInt32(hdnID.Value); x.title = txtJokeTitle.Text; x.category_id = CatId; x.teaser = txtTeaser.Text; x.joke_text = txtJoke.Text; x.featured = chkFeatured.Checked; x.created_at = Convert.ToDateTime(hdnCreatedAt.Value); x.user_id = Convert.ToInt32(hdnUID.Value); return(x); }
public override async void Execute(Message message, TelegramBotClient client) { var chatId = message.Chat.Id; var MessageId = message.MessageId; var Restclient = new RestClient("https://joke3.p.rapidapi.com/v1/joke?nsfw=false"); var request = new RestRequest(Method.GET); request.AddHeader("x-rapidapi-key", "6b0338b559msh0f5b4fae99c205cp1b304cjsn93f7f906d12b"); request.AddHeader("x-rapidapi-host", "joke3.p.rapidapi.com"); IRestResponse response = Restclient.Execute(request); Joke joke = JsonConvert.DeserializeObject <Joke>(response.Content); await client.SendTextMessageAsync(chatId, joke.Content, replyToMessageId : MessageId); }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } Joke = await _context.Joke.FirstOrDefaultAsync(m => m.ID == id); if (Joke == null) { return(NotFound()); } return(Page()); }
public ServiceResponse AddJoke(JokeFromApiModel model) { var count = jokesCollection.CountDocuments(new BsonDocument()); var joke = new Joke() { JokeId = count + 1, AddedDate = DateTime.Now, Description = model.Description, Content = model.Content }; redisDb.SortedSetAdd(keys, joke.JokeId.ToString(), 0); jokesCollection.InsertOne(joke); return(new ServiceResponse()); }
/// <summary> /// Code here /// </summary> /// <param name="serviceProvider"></param> private static void SandboxCode(IServiceProvider serviceProvider) { //var db = serviceProvider.GetService<FunAppContext>(); //Console.WriteLine(db.Users.Count()); var context = serviceProvider.GetService <FunAppContext>(); Encoding.RegisterProvider(CodePagesEncodingProvider.Instance); var parser = new HtmlParser(); var webClient = new WebClient { Encoding = Encoding.GetEncoding("windows-1251"), }; for (var i = 201; i < 3287; i++) { var url = "http://fun.dir.bg/vic_open.php?id=" + i; var html = webClient.DownloadString(url); var document = parser.Parse(html); var jokeContent = document.QuerySelector("#newsbody")?.TextContent?.Trim(); var categoryName = document.QuerySelector(".tag-links-left a")?.TextContent?.Trim(); if (!string.IsNullOrWhiteSpace(jokeContent) && !string.IsNullOrWhiteSpace(categoryName)) { var category = context.Categories.FirstOrDefault(x => x.Name == categoryName); if (category == null) { category = new Category { Name = categoryName, }; } var joke = new Joke() { Category = category, Content = jokeContent, }; context.Jokes.Add(joke); context.SaveChanges(); } Console.WriteLine($"{i} => {categoryName}"); } }
async void DelayForFive() { Joke j = new Joke(); Joke j2 = new Joke(); string path = "https://jokesapi.gottacatchemall.repl.co/jokes"; HttpClient client = new HttpClient(); HttpResponseMessage response = await client.GetAsync(path); if (response.IsSuccessStatusCode) { dynamic jsonJoke = await response.Content.ReadAsStringAsync(); j = JsonConvert.DeserializeObject <Joke>(jsonJoke); } HttpResponseMessage response2 = await client.GetAsync(path); if (response.IsSuccessStatusCode) { dynamic jsonJoke = await response2.Content.ReadAsStringAsync(); j2 = JsonConvert.DeserializeObject <Joke>(jsonJoke); } await Task.Delay(new TimeSpan(0, 30, 30)).ContinueWith(o => { TextNotification n = new TextNotification(); n.Show(); }); await Task.Delay(new TimeSpan(3, 0, 160)).ContinueWith(o => { Notification n = new Notification(); n.Show(); }); await Task.Delay(new TimeSpan(6, 30, 160)).ContinueWith(o => { TextNotification n = new TextNotification(); n.Show(); }); await Task.Delay(new TimeSpan(8, 30, 160)).ContinueWith(o => { Notification n = new Notification(); n.Show(); }); }
public void AddJoke(Guid gameId, UpsertJokeDTO dto) { var game = this.gameRepository.GetById(gameId); var joke = new Joke() { Author = dto.Author, Content = dto.Content, Created = DateTime.Now, Number = dto.Number }; game.Jokes ??= new List <Joke>(); game.Jokes.Add(joke); this.gameRepository.Update(game); }
public async Task <Joke> GetDadJoke() { Joke joke = new Joke(); HttpClient client = new HttpClient(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); var content = await client.GetStringAsync("https://icanhazdadjoke.com/"); JObject jsonContent = JObject.Parse(content); joke.ID = jsonContent["id"].ToString(); joke.JokeContent = jsonContent["joke"].ToString(); joke.Votes = 0; joke.Type = true; return(joke); }
public async Task <Joke> GetCNJoke() { Joke joke = new Joke(); HttpClient client = new HttpClient(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); var content = await client.GetStringAsync("https://api.chucknorris.io/jokes/random"); JObject jsonContent = JObject.Parse(content); joke.ID = jsonContent["id"].ToString(); joke.JokeContent = jsonContent["value"].ToString(); joke.Votes = 0; joke.Type = false; return(joke); }
/// <summary> /// Sets te joke linked to this card /// </summary> /// <param name="joke">The joke object linked to the card</param> /// <param name="punchline">Is this card showing the punchline? (If false, it shows the setup)</param> internal void SetJoke(Joke joke, bool punchline) { _joke = joke; _isPunchline = punchline; // set display text - punchline or setup? var stringToUse = punchline ? joke.Punchline : joke.Setup; JokeText.text = TextFormatter.GetCardJokeString(stringToUse); // set the images var imageIndex = IsPunchline() ? 1 : 0; CardBack.GetComponent <SpriteRenderer>().sprite = PunchlineBlingController.Instance.CardBacks[imageIndex]; CardFront.GetComponent <SpriteRenderer>().sprite = PunchlineBlingController.Instance.CardFronts[imageIndex]; }
public ActionResult Put(int id, [FromBody] Joke joke) { try { RestDatabaseContext db = new RestDatabaseContext(); Joke findJoke = db.Jokes.First(item => item.Id == id); findJoke.Rating = joke.Rating; findJoke.Text = joke.Text; db.SaveChanges(); return(Ok(findJoke)); } catch (Exception e) { return(StatusCode(StatusCodes.Status500InternalServerError, e.Message)); } }
public static async Task SayJoke() { Joke joke = DataAccess.DeserializeModuleData(typeof(Joke), await DataAccess.GetModuleData(Modules.JOKE)); StringBuilder jokeString = new StringBuilder(); jokeString.Append("Lückenfüller Lückenfüller <break time='300ms'/>"); jokeString.AppendLine($"Einen {joke.Title.Remove(joke.Title.Length - 1)} gefällig: <break time='300ms'/><prosody rate=\"-15%\">{joke.Description}</prosody>"); await sayAsync(jokeString.ToString()); // Neuen Joke laden #pragma warning disable 4014 DataAccess.AddOrReplaceModuleData(Modules.JOKE, await JokeHelper.GetJoke()); #pragma warning restore 4014 }
public ActionResult Delete(int id) { try { RestDatabaseContext db = new RestDatabaseContext(); Joke findJoke = db.Jokes.First(item => item.Id == id); db.Jokes.Remove(findJoke); db.SaveChanges(); return(Ok(id)); } catch (Exception e) { return(StatusCode(StatusCodes.Status500InternalServerError, e.Message)); } }
public async Task PutAsync(Guid id, [FromBody] Joke joke) { try { //there are several approaches here //one would be to eliminate the id and use the one on the joke //another would be to query the database for the expected joke confirm there are changes //I've chosen to simply update the joke for brevity process the update Validate(joke); await this.JokeService.UpdateAsync(joke); } catch (Exception ex) { this._logger.LogError(ex.StackTrace); throw new Exception(ex.Message); } }
public Joke GetRandomJoke() { Joke result = null; var unused = Jokes.Where(j => !j.Found).ToList(); var randomIndex = Random.Range(0, unused.Count); result = unused[randomIndex]; result.Found = true; FlowchartScript.ExecuteBlock(result.Name); print(result.Name); return(result); }
static async Task Main(string[] args) { ChuckNorrisApi api = new ChuckNorrisApi(); try { Console.WriteLine("Getting random joke:"); Joke joke = await api.GetRandomJoke(); PrintProperties <Joke>(joke); Console.WriteLine("Getting random joke from a set of categories:"); Joke jokeFromCategory = await api.GetRandomJoke(new string[] { "dev", "music" }); PrintProperties <Joke>(jokeFromCategory); Console.WriteLine("Getting random personalized joke:"); Joke personalizedJoke = await api.GetRandomJoke("Peter"); PrintProperties <Joke>(personalizedJoke); Console.WriteLine("Getting random personalized joke from a set of categories:"); Joke personalizedJokeFromCategory = await api.GetRandomJoke("Peter", new string[] { "dev", "music" }); PrintProperties <Joke>(personalizedJokeFromCategory); Console.WriteLine("Getting categories:"); string[] categories = await api.GetCategories(); Console.WriteLine(string.Join(",", categories)); Console.WriteLine("Getting all jokes containing a particular word or phrase:"); List <Joke> searchResults = await api.SearchForText("films"); foreach (Joke result in searchResults) { PrintProperties <Joke>(result); } } catch (Exception ex) { Console.WriteLine(ex); } api.Dispose(); }
public void httpRequest(string URL) { WebRequest request = WebRequest.Create(URL); WebResponse response = request.GetResponse(); Joke joke = new Joke(); // Convert the stream to a string using (Stream dataStream = response.GetResponseStream()) using (StreamReader sr = new StreamReader(dataStream)) using (JsonReader reader = new JsonTextReader(sr)) { // Deserialize the string into an object of the Joke class JsonSerializer ser = new JsonSerializer(); while (reader.Read()) { if (reader.TokenType == JsonToken.StartObject) { joke = ser.Deserialize <Joke>(reader); } } if (joke.type == "single") { // If type == "single", the joke only has the "joke" property if (joke.joke == string.Empty) { output.Text = "No jokes found"; } output.Text = joke.joke; } else { // If type == "twopart", the joke has the "setup" and "delivery" properties if (joke.setup == string.Empty && joke.delivery == string.Empty) { output.Text = "No jokes found"; } output.Text = joke.setup; output.Text += "\n" + joke.delivery; } } // Close the request response.Close(); }
public async Task <RuntimeResult> AddJokeAsync([Remainder] string jokeText) { if (jokeText is null) { return(new ErrorResult("Joke is empty")); } Joke joke = new Joke { Text = jokeText, User = User }; await Database.Jokes.AddAsync(joke); return(new SuccessResult()); }
//[Test] public void TestB() { GgsTeste cat = new GgsTeste(); cat.Nome = "Teste Insert 4"; var insert = new CommandInsertGenerator(cat).GetCommand(); NonQueryCommandsExecutor executor = new NonQueryCommandsExecutor(cat); executor.Execute(); var novaCategoria = new Joke<GgsTeste>().Query() .Where("nome ILIKE 'Teste%4'") .Execute()[0]; Assert.That(novaCategoria.Id, Is.EqualTo(23)); Assert.That(novaCategoria.Nome, Is.EqualTo("Teste Insert 4")); }
static void Main() { // TODO: Add DI container an AutoMapper var db = new ApplicationDbContext(); var dbRopository = new DbRepository <JokeCategory>(db); var categoryesService = new CategoriesService(dbRopository); // AngleSharp configurations IConfiguration configuration = Configuration.Default.WithDefaultLoader(); IBrowsingContext browsingContex = BrowsingContext.New(configuration); long countOfAddedJokes = 0; for (int i = 1; i < 65000; i++) { string url = $"http://vicove.com/vic-{i}"; IDocument document = browsingContex.OpenAsync(url).Result; string jokeContent = document.QuerySelector("#content_box .post-content p").TextContent.Trim(); string categoryName = document.QuerySelector("#content_box .thecategory a").TextContent.Trim(); bool isValidJoke = !string.IsNullOrWhiteSpace(jokeContent); bool isValidCategory = !string.IsNullOrWhiteSpace(categoryName); if (isValidJoke && isValidCategory) { countOfAddedJokes++; JokeCategory category = categoryesService.EnsureCategory(categoryName); Joke joke = new Joke { Content = jokeContent, Category = category }; db.Jokes.Add(joke); db.SaveChanges(); if (countOfAddedJokes % 100 == 0) { Console.WriteLine($"Added {countOfAddedJokes} jokes"); } } } Console.WriteLine(); Console.WriteLine($"--- DONE => {countOfAddedJokes} joke added"); }
/// <summary> /// Pulls a random joke from the database and returns it /// </summary> /// <returns></returns> public static Joke QueryRandomJoke() { Joke joke = null; using (SqliteConnection connection = OpenDatabase()) { using (SqliteCommand command = connection.CreateCommand()) { command.CommandText = "SELECT * FROM TJokes WHERE jokeID IN (SELECT jokeID FROM TJokes ORDER BY RANDOM() LIMIT 1)"; SqliteDataReader reader = command.ExecuteReader(); reader.Read(); joke = Joke.FromDataRow(reader); reader.Close(); } } return(joke); }
public void ReplaceWith_DoesNotMatch_DoesNotReplace() { // Setup Fake Data var joke = new Joke { Value = "Some joke" }; var userName = new UserName { Name = "John", Surname = "Doe" }; // Execute Test var result = joke.ReplaceWith(userName); // Verify mocks and assertions Assert.IsNotNull(result); Assert.AreEqual(joke.Value, result.Value); }
public NewItemPage() { InitializeComponent(); //Item = new Item //{ // Text = "Item name", // Description = "This is a nice description" //}; Joke = new Joke { Text = "" }; BindingContext = this; }
/// <summary>Replaces the with.</summary> /// <param name="joke">The joke.</param> /// <param name="userName">Name of the user.</param> /// <returns>The joke with replaced name and surname.</returns> /// <exception cref="ArgumentNullException">joke /// or /// userName</exception> public static Joke ReplaceWith(this Joke joke, UserName userName) { if (joke == null) { throw new ArgumentNullException(nameof(joke)); } if (userName == null) { throw new ArgumentNullException(nameof(userName)); } joke.Value = joke.Value.Replace(Chuck, userName.Name); joke.Value = joke.Value.Replace(Norris, userName.Surname); return(joke); }
public RedirectToActionResult JokeForm(string name, string keyword, string jokeline) { if (ModelState.IsValid) { Joke joke = new Joke { KeyWord = keyword }; joke.Name = name; joke.JokeLine = jokeline; /*joke.Joke.Add(new Joke() { Name = name }); * joke.PubDate = DateTime.Parse(pubDate);*/ repo.AddJoke(joke); // this is temporary, in the future the data will go in a database } return(RedirectToAction("Jokespage")); }
// Get random joke from a specific Chuck Norris API public static string GetJokeFromCategory(string category) { Joke joke = new Joke(); string Url = "https://api.chucknorris.io/jokes/random?category=" + category; try { string stringResult = HttpWebRequest("GET", Url); joke = JsonConvert.DeserializeObject <Joke>(stringResult); return(joke.Value); } catch (Exception ex) { return(null); } }
public IActionResult Get() { var jokes = new Joke[] { new Joke() { Question = "What do you call a boomerang that won't come back?", Answer = "A stick" }, new Joke() { Question = "What horse never comes out in the daytime?", Answer = "A night mare" } }; return(Ok(jokes)); }
public async Task <Joke> GetJokeAsync() { Joke joke = null; client.BaseAddress = new Uri(url); client.DefaultRequestHeaders.Accept.Add( new MediaTypeWithQualityHeaderValue("application/json")); HttpResponseMessage response = await client.GetAsync(url); if (response.IsSuccessStatusCode) { joke = await response.Content.ReadAsAsync <Joke>(); } return(joke); }
protected void btnAdd_Click(object sender, EventArgs e) { try { Joke jokeOBJ = Factory.CreateJoke(); CUD.AddJoke(AssignValues(jokeOBJ)); alertexit1.Checked = false; alertexit2.Checked = true; SysMessage.InnerText = "Joke creation successful!"; } catch (Exception ex) { alertexit1.Checked = true; alertexit2.Checked = false; SysMessageErr.InnerText = "Joke creation failed"; SysDetails.InnerText = ex.Message; } }
//[Test] public void TodosProdutosMySQL() { JokeConfigurationBuilder.NewConfigurationToMySQL() .Host("mysql01.ggs5.hospedagemdesites.ws") .Username("ggs5") .Password("desenv_1") .DataBase("ggs5") .BuildConfiguration(); Joke<ProdutoTeste> targetTeste = new Joke<ProdutoTeste>(); List<ProdutoTeste> produtos = targetTeste.GetAll(); Assert.That(produtos.Count, Is.EqualTo(3)); }
//[Test] public void TestC() { GgsTeste cat = new GgsTeste(); cat.Nome = "Gui"; Ags ags = new Ags(); ags.Nome = "Alana"; ags.Ggs = cat; NonQueryCommandsExecutor executor = new NonQueryCommandsExecutor(ags); executor.Execute(); var novaCategoria = new Joke<Ags>().Query() .Where("ags.Ggs.Nome ILIKE 'Gui'") .Execute()[0]; Assert.That(novaCategoria.Id, Is.EqualTo(14)); Assert.That(novaCategoria.Nome, Is.EqualTo("Gui")); }
public Task AddJokeAsync(Joke joke) { return Task.Run(() => {m_jokes.Add(joke); }); }
public void SetUp() { new Joke<Ags>(); target = new Joke<Produto>(); JokeConfigurationBuilder.NewConfigurationToPostgreSQL() .Host(LOCAL_HOST) .Port(PORTA_5432) .Username(USER) .Password(SENHA) .DataBase(JOKE_BD) .BuildConfiguration(); }
/// <summary> /// Add a joke /// </summary> /// <param name="joke"> A nice work-friendly joke</param> public Task AddJokeAsync(Joke joke) { return SendAsync("AddJoke", new Dictionary<string, object>() { {"joke", joke } }); }
/// <summary> /// Add a joke /// </summary> /// <param name="joke"> A nice work-friendly joke</param> public void AddJoke(Joke joke) { Send("AddJoke", new Dictionary<string, object>() { {"joke", joke } }); }