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();
}
