public bool ValidateRegex(Puzzle[] puzzles, Answer[] answers) { Debug.Assert(answers.Length == puzzles.Length); for(int i = 0; i < answers.Length; ++i) { var regX = new Regex(answers[i].Regex); if (regX.Replace(puzzles[i].Problem, answers[i].Substitute) != puzzles[i].Goal) return false; } return true; }
public async Task<IHttpActionResult> GetAnswer(int id, Answer answer) { var selectedOption = await this.db.Options.FirstOrDefaultAsync(o => o.ID == answer.OptionId && o.QuestionId == answer.OptionId); var correctAnswer = await this.db.Options.Where(a => a.QuestionId == id && a.IsCorrect == true).FirstOrDefaultAsync(); if (correctAnswer == null) { return NotFound(); } //if (!selectedOption.IsCorrect) //{ // return Ok(correctAnswer); //} return Ok(correctAnswer); }
public void Seed(EstateSocialSystemDbContext context) { ////Seed User Roles var RoleManager = new RoleManager<IdentityRole>(new RoleStore<IdentityRole>(context)); for (int i = 0; i < roles.Count; i++) { if (RoleManager.RoleExists(roles[i]) == false) { RoleManager.Create(new IdentityRole(roles[i])); } } //// FORUM SEEDING if (!context.Answers.Any()) { for (int i = 1; i <= 18; i++) { var Answer = new Answer() { Title = string.Format("Answer {0}", i), Content = string.Format("Answer <b>content></b> {0}", i) }; context.Answers.Add(Answer); } context.SaveChanges(); } if (!context.Tags.Any()) { var tagList = new List<Tag>(); for (int i = 1; i <= 20; i++) { var tag = new Tag() { Name = string.Format("Tag {0}", i) }; context.Tags.Add(tag); tagList.Add(tag); } var tagIndex = 0; for (int i = 1; i <= 20; i++) { var post = new Post() { Content = string.Format("Post content {0}", i), Title = string.Format("Post Title {0}", i) }; for (int j = 0; j < 5; j++) { post.Tags.Add(tagList[tagIndex % tagList.Count]); tagIndex++; } context.Posts.Add(post); } context.SaveChanges(); } ////END ////Blog Seed if (context.Settings.Any()) { return; } context.Settings.Add(new Setting { Name = "Logo URL", Value = "/img/header-logo.png" }); context.Settings.Add(new Setting { Name = "Home Title", Value = "Home Title" }); context.Settings.Add(new Setting { Name = "Blog Name", Value = "Blog Name" }); context.Settings.Add(new Setting { Name = "Blog Url", Value = "Blog Url" }); context.Settings.Add(new Setting { Name = "Keywords", Value = "Keywords" }); context.Settings.Add(new Setting { Name = "Author", Value = "Author" }); context.Settings.Add(new Setting { Name = "GitHub Profile", Value = "GitHub Profile" }); context.Settings.Add(new Setting { Name = "GitHub Badge HTML Code", Value = "GitHub Badge HTML Code" }); context.Settings.Add(new Setting { Name = "StackOverflow Badge HTML Code", Value = "StackOverflow Badge HTML Code" }); context.Settings.Add(new Setting { Name = "Stack Overflow Profile", Value = "Stack Overflow Profile" }); context.Settings.Add(new Setting { Name = "Linked In Profile", Value = "Linked In Profile" }); context.Settings.Add(new Setting { Name = "Contact Email", Value = "Contact Email" }); context.Settings.Add(new Setting { Name = "Facebook Profile", Value = "Facebook Profile" }); context.Settings.Add(new Setting { Name = "Foursquare Profile", Value = "Foursquare Profile" }); context.Settings.Add(new Setting { Name = "Google Profile", Value = "Google+ Profile" }); context.Settings.Add(new Setting { Name = "RSS Url", Value = "RSS Url" }); ////END }
protected override void Seed(SBDforum.Models.MyDbContext context) { // This method will be called after migrating to the latest version. // You can use the DbSet<T>.AddOrUpdate() helper extension method // to avoid creating duplicate seed data. E.g. // // context.People.AddOrUpdate( // p => p.FullName, // new Person { FullName = "Andrew Peters" }, // new Person { FullName = "Brice Lambson" }, // new Person { FullName = "Rowan Miller" } // ); // context.Database.ExecuteSqlCommand("Delete from comments"); context.Database.ExecuteSqlCommand("Delete from answers"); context.Database.ExecuteSqlCommand("Delete from threads"); context.Database.ExecuteSqlCommand("Delete from categories"); context.Database.ExecuteSqlCommand("Delete from messages"); context.Database.ExecuteSqlCommand("Delete from users"); context.Database.ExecuteSqlCommand("Delete from rules"); context.Database.ExecuteSqlCommand("Delete from bannedwordsdictionaries"); context.Database.ExecuteSqlCommand("Delete from intervalpoints"); context.SaveChanges(); User u = new Models.User(); // u.UserID = 1; u.Nick = "Witek15"; u.Email = "*****@*****.**"; u.Password = "******"; u.Role = false; u.Avatar = "http://i.wp.pl/a/f/jpeg/20901/walesa_wp_04_550.jpeg"; u.Active = true; context.Users.Add(u); context.SaveChanges(); u = new Models.User(); // u.UserID = 2; u.Nick = "Jola17"; u.Email = "*****@*****.**"; u.Password = "******"; u.Role = false; u.Avatar = "http://images.hellokids.com/_uploads/_tiny_galerie/20131043/vign-pikachu-by5_bb9.jpg"; u.Active = true; context.Users.Add(u); context.SaveChanges(); u = new Models.User(); // u.UserID = 3; u.Nick = "drobiowy07"; u.Email = "*****@*****.**"; u.Password = "******"; u.Role = false; u.Avatar = "http://megaicons.net/static/img/icons_sizes/84/445/256/blue-user-icon.png"; u.Active = true; context.Users.Add(u); context.SaveChanges(); u = new Models.User(); // u.UserID = 4; u.Nick = "wiktor500"; u.Email = "*****@*****.**"; u.Password = "******"; u.Role = false; u.Avatar = "http://www.rmf.fm/_files/Short_foto/625/0e4fb6e75a40f3ac328f8fe2e841898e.jpg"; u.Active = true; context.Users.Add(u); context.SaveChanges(); u = new Models.User(); // u.UserID = 5; u.Nick = "marysia94"; u.Email = "*****@*****.**"; u.Password = "******"; u.Role = false; u.Avatar = "http://www.tapetus.pl/obrazki/n/111055_kotek-apka-klopot.jpg"; u.Active = true; context.Users.Add(u); context.SaveChanges(); u = new Models.User(); // u.UserID = 6; u.Nick = "admin"; u.Email = "*****@*****.**"; u.Password = "******"; u.Role = true; u.Avatar = "http://megaicons.net/static/img/icons_sizes/84/445/256/blue-user-icon.png"; u.Active = true; context.Users.Add(u); context.SaveChanges(); u = new Models.User(); // u.UserID = 7; u.Nick = "u"; u.Email = "u"; u.Password = "******"; u.Role = false; u.Avatar = "http://megaicons.net/static/img/icons_sizes/84/445/256/blue-user-icon.png"; u.Active = true; context.Users.Add(u); context.SaveChanges(); BannedWordsDictionary b = new BannedWordsDictionary(); b.Name = "krucafuks"; context.BannedWordsDictionaries.AddOrUpdate(b); context.SaveChanges(); b = new BannedWordsDictionary(); b.Name = "psia koœæ".ToString(); context.BannedWordsDictionaries.AddOrUpdate(b); context.SaveChanges(); b = new BannedWordsDictionary(); b.Name = "kurka wodna".ToString(); context.BannedWordsDictionaries.AddOrUpdate(b); context.SaveChanges(); b = new BannedWordsDictionary(); b.Name = "pata³ach".ToString(); context.BannedWordsDictionaries.AddOrUpdate(b); context.SaveChanges(); b = new BannedWordsDictionary(); b.Name = "motyla noga".ToString(); context.BannedWordsDictionaries.AddOrUpdate(b); context.SaveChanges(); b = new BannedWordsDictionary(); b.Name = "cholercia".ToString(); context.BannedWordsDictionaries.AddOrUpdate(b); context.SaveChanges(); IntervalPoint i = new IntervalPoint(); i.LowerRange = 0; i.UpperRange = 5; i.Name = "nowicjusz".ToString(); context.IntervalPoints.AddOrUpdate(i); context.SaveChanges(); i = new IntervalPoint(); i.LowerRange = 6; i.UpperRange = 500; i.Name = "pocz¹tkuj¹cy".ToString(); context.IntervalPoints.AddOrUpdate(i); context.SaveChanges(); i = new IntervalPoint(); i.LowerRange = 501; i.UpperRange = 10000; i.Name = "œredniozaawansowany".ToString(); context.IntervalPoints.AddOrUpdate(i); context.SaveChanges(); i = new IntervalPoint(); i.LowerRange = 10001; i.UpperRange = 100000; i.Name = "zaawansowany"; context.IntervalPoints.AddOrUpdate(i); context.SaveChanges(); i = new IntervalPoint(); i.LowerRange = 100001; i.UpperRange = 2147483647; i.Name = "super nerd"; context.IntervalPoints.AddOrUpdate(i); context.SaveChanges(); Rule r = new Rule(); r.Name = "Nie bluzgaj"; r.Text = "Nie u¿ywaj brzydkich s³ów"; context.Rules.AddOrUpdate(r); context.SaveChanges(); r = new Rule(); r.Name = "Pisz poprawnie"; r.Text = "Nie pope³niaj ortografów"; context.Rules.AddOrUpdate(r); context.SaveChanges(); r = new Rule(); r.Name = "Zbieraj punkty"; r.Text = "Zbieraj¹c punkty zdobywasz wy¿szy level"; context.Rules.AddOrUpdate(r); context.SaveChanges(); r = new Rule(); r.Name = "Myj rêce"; r.Text = "Myj d³onie przed posi³kiem"; context.Rules.AddOrUpdate(r); context.SaveChanges(); r = new Rule(); r.Name = "Szanuj rodziców"; r.Text = "Zadzwoñ do mamy"; context.Rules.AddOrUpdate(r); context.SaveChanges(); int ids, idr; ids = context.Users.Where(n => n.Nick == "Witek15").Select(n => n.UserID).FirstOrDefault(); idr = context.Users.Where(n => n.Nick == "Jola17").Select(n => n.UserID).FirstOrDefault(); Message m = new Message(); m.SenderID = ids; m.ReceiverID = idr; m.Text = "czeœæ"; m.Date = new DateTime(2016, 11, 20, 10, 10, 10); m.Read = true; context.Messages.AddOrUpdate(m); context.SaveChanges(); ids = context.Users.Where(n => n.Nick == "Jola17").Select(n => n.UserID).FirstOrDefault(); idr = context.Users.Where(n => n.Nick == "Witek15").Select(n => n.UserID).FirstOrDefault(); m = new Message(); m.SenderID = ids; m.ReceiverID = idr; m.Text = "no czeœæ"; m.Read = true; m.Date = new DateTime(2016, 11, 20, 10, 10, 15); context.Messages.AddOrUpdate(m); context.SaveChanges(); ids = context.Users.Where(n => n.Nick == "Witek15").Select(n => n.UserID).FirstOrDefault(); idr = context.Users.Where(n => n.Nick == "Jola17").Select(n => n.UserID).FirstOrDefault(); m = new Message(); m.SenderID = ids; m.ReceiverID = idr; m.Text = "idziemy na piwo?"; m.Read = true; m.Date = new DateTime(2016, 11, 20, 10, 11, 5); context.Messages.AddOrUpdate(m); context.SaveChanges(); ids = context.Users.Where(n => n.Nick == "Jola17").Select(n => n.UserID).FirstOrDefault(); idr = context.Users.Where(n => n.Nick == "Witek15").Select(n => n.UserID).FirstOrDefault(); m = new Message(); m.SenderID = ids; m.ReceiverID = idr; m.Text = "za 15 minut na murkach"; m.Read = true; m.Date = new DateTime(2016, 11, 20, 10, 11, 17); context.Messages.AddOrUpdate(m); context.SaveChanges(); ids = context.Users.Where(n => n.Nick == "Witek15").Select(n => n.UserID).FirstOrDefault(); idr = context.Users.Where(n => n.Nick == "Jola17").Select(n => n.UserID).FirstOrDefault(); m = new Message(); m.SenderID = ids; m.ReceiverID = idr; m.Text = "elo"; m.Read = true; m.Date = new DateTime(2016, 11, 20, 10, 11, 29); context.Messages.AddOrUpdate(m); context.SaveChanges(); Category c = new Category(); // c.CategoryID = 1; c.Name = "Linux"; c.Description = "W¹tki o Linuxie"; context.Categories.AddOrUpdate(c); context.SaveChanges(); c = new Category(); // c.CategoryID = 2; c.Name = "Monitory"; c.Description = "W¹tki o Monitorach"; context.Categories.AddOrUpdate(c); context.SaveChanges(); c = new Category(); // c.CategoryID = 3; c.Name = "Myszki"; c.Description = "W¹tki o Myszach"; context.Categories.AddOrUpdate(c); context.SaveChanges(); c = new Category(); // c.CategoryID = 4; c.Name = "Laptopy"; c.Description = "W¹tki o Laptopach"; context.Categories.AddOrUpdate(c); context.SaveChanges(); c = new Category(); //c.CategoryID = 5; c.Name = "MVC"; c.Description = "W¹tki o MVC"; context.Categories.AddOrUpdate(c); context.SaveChanges(); c = new Category(); // c.CategoryID = 6; c.Name = "Programowanie"; c.Description = "W¹tki o Programowaniu"; context.Categories.AddOrUpdate(c); context.SaveChanges(); int ui, ci, ai, ti; ui = context.Users.Where(n => n.Nick == "Witek15").Select(n => n.UserID).FirstOrDefault(); ci = context.Categories.Where(n => n.Name == "Linux").Select(n => n.CategoryID).FirstOrDefault(); Thread t = new Thread(); t.CategoryID = ci; t.UserID = ui; t.Title = "Co to jest grep?"; t.Date = new DateTime(2016, 11, 20, 07, 50, 37); context.Threads.AddOrUpdate(t); context.SaveChanges(); ui = context.Users.Where(n => n.Nick == "wiktor500").Select(n => n.UserID).FirstOrDefault(); ci = context.Categories.Where(n => n.Name == "Myszki").Select(n => n.CategoryID).FirstOrDefault(); t = new Thread(); t.CategoryID = ci; t.UserID = ui; t.Title = "Jaka najlepsza myszka do grania?"; t.Date = new DateTime(2016, 11, 20, 07, 52, 37); context.Threads.AddOrUpdate(t); context.SaveChanges(); ui = context.Users.Where(n => n.Nick == "wiktor500").Select(n => n.UserID).FirstOrDefault(); ci = context.Categories.Where(n => n.Name == "Myszki").Select(n => n.CategoryID).FirstOrDefault(); t = new Thread(); t.CategoryID = ci; t.UserID = ui; t.Title = "Myszka przewodowa czy bezprzewodowa?"; t.Date = new DateTime(2016, 11, 20, 07, 54, 37); context.Threads.AddOrUpdate(t); context.SaveChanges(); ui = context.Users.Where(n => n.Nick == "marysia94").Select(n => n.UserID).FirstOrDefault(); ci = context.Categories.Where(n => n.Name == "MVC").Select(n => n.CategoryID).FirstOrDefault(); t = new Thread(); t.CategoryID = ci; t.UserID = ui; t.Title = "Areas in MVC?"; t.Date = new DateTime(2016, 11, 20, 07, 56, 37); context.Threads.AddOrUpdate(t); context.SaveChanges(); ui = context.Users.Where(n => n.Nick == "wiktor500").Select(n => n.UserID).FirstOrDefault(); ci = context.Categories.Where(n => n.Name == "Laptopy").Select(n => n.CategoryID).FirstOrDefault(); t = new Thread(); t.CategoryID = ci; t.UserID = ui; t.Title = "Jaki laptop do gier do 3000z³?"; t.Date = new DateTime(2016, 11, 20, 07, 58, 37); context.Threads.AddOrUpdate(t); context.SaveChanges(); ui = context.Users.Where(n => n.Nick == "wiktor500").Select(n => n.UserID).FirstOrDefault(); ti = context.Threads.Where(n => n.Title == "Co to jest grep?").Select(n => n.ThreadID).FirstOrDefault(); Answer a = new Models.Answer(); a.ThreadID = ti; a.UserID = ui; a.Text = "To wyszukiwanie"; a.Points = 2; a.Date = new DateTime(2016, 11, 20, 08, 50, 37); context.Answers.AddOrUpdate(a); context.SaveChanges(); ui = context.Users.Where(n => n.Nick == "Jola17").Select(n => n.UserID).FirstOrDefault(); ti = context.Threads.Where(n => n.Title == "Myszka przewodowa czy bezprzewodowa?").Select(n => n.ThreadID).FirstOrDefault(); a = new Models.Answer(); a.ThreadID = ti; a.UserID = ui; a.Text = "Zdecydowanie bezprzewodowa"; a.Points = 3; a.Date = new DateTime(2016, 11, 20, 09, 52, 37); context.Answers.AddOrUpdate(a); context.SaveChanges(); ui = context.Users.Where(n => n.Nick == "drobiowy07").Select(n => n.UserID).FirstOrDefault(); ti = context.Threads.Where(n => n.Title == "Myszka przewodowa czy bezprzewodowa?").Select(n => n.ThreadID).FirstOrDefault(); a = new Models.Answer(); a.ThreadID = ti; a.UserID = ui; a.Text = "Polecam przewodow¹"; a.Points = 1; a.Date = new DateTime(2016, 11, 20, 09, 50, 37); context.Answers.AddOrUpdate(a); context.SaveChanges(); ui = context.Users.Where(n => n.Nick == "wiktor500").Select(n => n.UserID).FirstOrDefault(); ti = context.Threads.Where(n => n.Title == "Myszka przewodowa czy bezprzewodowa?").Select(n => n.ThreadID).FirstOrDefault(); a = new Models.Answer(); a.ThreadID = ti; a.UserID = ui; a.Text = "Bezprzewodowe lepsze. W przewodowych kable denerwuj¹ce"; a.Points = 0; a.Date = new DateTime(2016, 11, 20, 09, 54, 37); context.Answers.AddOrUpdate(a); context.SaveChanges(); ui = context.Users.Where(n => n.Nick == "Witek15").Select(n => n.UserID).FirstOrDefault(); ti = context.Threads.Where(n => n.Title == "Myszka przewodowa czy bezprzewodowa?").Select(n => n.ThreadID).FirstOrDefault(); a = new Models.Answer(); a.ThreadID = ti; a.UserID = ui; a.Text = "Je¿eli do stacjonarnego, to przewodowa. Do laptopa bezprzewodowa."; a.Points = 2; a.Date = new DateTime(2016, 11, 20, 09, 51, 37); context.Answers.AddOrUpdate(a); context.SaveChanges(); ui = context.Users.Where(n => n.Nick == "Witek15").Select(n => n.UserID).FirstOrDefault(); ai = context.Answers.Where(n => n.Text == "Zdecydowanie bezprzewodowa").Select(n => n.AnswerID).FirstOrDefault(); Comment cm = new Comment(); cm.AnswerID = ai; cm.UserID = ui; cm.Text = "Popieram! Jedyne s³uszne rozwi¹zanie!"; cm.Date = new DateTime(2016, 11, 20, 09, 53, 37); context.Comments.AddOrUpdate(cm); context.SaveChanges(); ui = context.Users.Where(n => n.Nick == "drobiowy07").Select(n => n.UserID).FirstOrDefault(); ai = context.Answers.Where(n => n.Text == "Zdecydowanie bezprzewodowa").Select(n => n.AnswerID).FirstOrDefault(); cm = new Comment(); cm.AnswerID = ai; cm.UserID = ui; cm.Text = "Dok³adnie, nie trzeba sie mêczyc z kabelkiem"; cm.Date = new DateTime(2016, 11, 20, 09, 54, 37); context.Comments.AddOrUpdate(cm); context.SaveChanges(); ui = context.Users.Where(n => n.Nick == "Jola17").Select(n => n.UserID).FirstOrDefault(); ai = context.Answers.Where(n => n.Text == "Bezprzewodowe lepsze. W przewodowych kable denerwuj¹ce").Select(n => n.AnswerID).FirstOrDefault(); cm = new Comment(); cm.AnswerID = ai; cm.UserID = ui; cm.Text = "W jakim sensie denerwuj¹ce?"; cm.Date = new DateTime(2016, 11, 20, 11, 50, 37); context.Comments.AddOrUpdate(cm); context.SaveChanges(); ui = context.Users.Where(n => n.Nick == "drobiowy07").Select(n => n.UserID).FirstOrDefault(); ai = context.Answers.Where(n => n.Text == "Bezprzewodowe lepsze. W przewodowych kable denerwuj¹ce").Select(n => n.AnswerID).FirstOrDefault(); cm = new Comment(); cm.AnswerID = ai; cm.UserID = ui; cm.Text = "¯e trzeba je zwijaæ i rozwijaæ i siê pl¹cz¹."; cm.Date = new DateTime(2016, 11, 20, 12, 50, 37); context.Comments.AddOrUpdate(cm); context.SaveChanges(); ui = context.Users.Where(n => n.Nick == "drobiowy07").Select(n => n.UserID).FirstOrDefault(); ai = context.Answers.Where(n => n.Text == "Je¿eli do stacjonarnego, to przewodowa. Do laptopa bezprzewodowa.").Select(n => n.AnswerID).FirstOrDefault(); cm = new Comment(); cm.AnswerID = ai; cm.UserID = ui; cm.Text = "Przy stacjonarnym kabel nie przeszkadza. A jak do laptopa to szybciej bez kabla."; cm.Date = new DateTime(2016, 11, 20, 15, 50, 37); context.Comments.AddOrUpdate(cm); context.SaveChanges(); }