using System.Collections.Generic;
using System.Text.RegularExpressions;
using Microsoft.AspNet.Identity;
using Microsoft.AspNet.Identity.EntityFramework;
using SnippyApp.Models;

namespace SnippyApp.Data.Migrations
{
    using System;
    using System.Data.Entity;
    using System.Data.Entity.Migrations;
    using System.Linq;

    internal sealed class Configuration : DbMigrationsConfiguration<SnippyApp.Data.SnippyDbContext>
    {
        public Configuration()
        {
            AutomaticMigrationsEnabled = true;
        }

        protected override void Seed(SnippyApp.Data.SnippyDbContext context)
        {
            if (!context.Users.Any())
            {
                SeedUsers(context);
            }
            if (!context.Labels.Any())
            {
                SeedLabels(context);
            }
            if (!context.Languages.Any())
            {
                SeedLanguages(context);
            }

            if (!context.Snippets.Any())
            {
                SeedSnippets(context);
            }

            if (!context.Comments.Any())
            {
                SeedComments(context);
            }
        }

        private void SeedComments(SnippyDbContext context)
        {
            context.Comments.Add(new Comment()
            {
                Content = "Now that's really funny! I like it!",
                Author = context.Users.FirstOrDefault(u=>u.UserName=="admin"),
                CreatedOn = DateTime.Parse("30.10.2015 11:50:38"),
                Snippet = context.Snippets.FirstOrDefault(s=>s.Title== "Ternary Operator Madness")
            });
            context.SaveChanges();

            context.Comments.Add(new Comment()
            {
                Content = "Here, have my comment!",
                Author = context.Users.FirstOrDefault(u => u.UserName == "newUser"),
                CreatedOn = DateTime.Parse("01.11.2015 15:52:42"),
                Snippet = context.Snippets.FirstOrDefault(s => s.Title == "Ternary Operator Madness")
            });
            context.SaveChanges();

            context.Comments.Add(new Comment()
            {
                Content = "I didn't manage to comment first :(",
                Author = context.Users.FirstOrDefault(u => u.UserName == "someUser"),
                CreatedOn = DateTime.Parse("02.11.2015 05:30:20"),
                Snippet = context.Snippets.FirstOrDefault(s => s.Title == "Ternary Operator Madness")
            });
            context.SaveChanges();

            context.Comments.Add(new Comment()
            {
                Content = "That's why I love Python - everything is so simple!",
                Author = context.Users.FirstOrDefault(u => u.UserName == "newUser"),
                CreatedOn = DateTime.Parse("27.10.2015 15:28:14"),
                Snippet = context.Snippets.FirstOrDefault(s => s.Title == "Reverse a String")
            });
            context.SaveChanges();

            context.Comments.Add(new Comment()
            {
                Content = "I have always had problems with Geometry in school. Thanks to you I can now do this without ever having to learn this damn subject",
                Author = context.Users.FirstOrDefault(u => u.UserName == "someUser"),
                CreatedOn = DateTime.Parse("29.10.2015 15:08:42"),
                Snippet = context.Snippets.FirstOrDefault(s => s.Title == "Points Around A Circle For GameObject Placement")
            });
            context.SaveChanges();

            context.Comments.Add(new Comment()
            {
                Content = "Thank you. However, I think there must be a simpler way to do this. I can't figure it out now, but I'll post it when I'm ready.",
                Author = context.Users.FirstOrDefault(u => u.UserName == "admin"),
                CreatedOn = DateTime.Parse("03.11.2015 12:56:20"),
                Snippet = context.Snippets.FirstOrDefault(s => s.Title == "Numbers only in an input field")
            });
            context.SaveChanges();
        }

        private void SeedSnippets(SnippyDbContext context)
        {
            context.Snippets.Add(new Snippet()
            {
                Title = "Ternary Operator Madness",
                Description = "This is how you DO NOT user ternary operators in C#!",
                Author = context.Users.FirstOrDefault(u=>u.UserName=="admin"),
                Code = "bool X = Glob.UserIsAdmin ? true : false;",
                CreatedOn = DateTime.Parse("26.10.2015 17:20:33"),
                Language = context.Languages.FirstOrDefault(l=>l.Name== "C#"),
                Labels = new List<Label>()
                {
                    context.Labels.FirstOrDefault(l=>l.Text=="funny")
                }
            });
            context.SaveChanges();

            context.Snippets.Add(new Snippet()
            {
                Title = "Points Around A Circle For GameObject Placement",
                Description = "Determine points around a circle which can be used to place elements around a central point",
                Author = context.Users.FirstOrDefault(u => u.UserName == "admin"),
                Code = @"private Vector3 DrawCircle(float centerX, float centerY, float radius, float totalPoints, float currentPoint)
                {
                float ptRatio = currentPoint / totalPoints;
                float pointX = centerX + (Mathf.Cos(ptRatio * 2 * Mathf.PI)) * radius;
                float pointY = centerY + (Mathf.Sin(ptRatio * 2 * Mathf.PI)) * radius;

                Vector3 panelCenter = new Vector3(pointX, pointY, 0.0f);

                return panelCenter;
                }
                ",
                CreatedOn = DateTime.Parse("26.10.2015 20:15:30"),
                Language = context.Languages.FirstOrDefault(l => l.Name == "C#"),
                Labels = new List<Label>()
                {
                     context.Labels.FirstOrDefault(l=>l.Text=="geometry"),
                     context.Labels.FirstOrDefault(l=>l.Text=="games"),
                }
            });
            context.SaveChanges();

            context.Snippets.Add(new Snippet()
            {
                Title = "forEach. How to break?",
                Description = "Array.prototype.forEach You can't break forEach. So use \"some\" or \"every\". Array.prototype.some some is pretty much the same as forEach but it break when the callback returns true. Array.prototype.every every is almost identical to some except it's expecting false to break the loop.",
                Author = context.Users.FirstOrDefault(u => u.UserName == "newUser"),
                Code = "var ary = [\"JavaScript\", \"Java\", \"CoffeeScript\", \"TypeScript\"]; "
+ "                                                                       "
+ "ary.some(function (value, index, _ary) {                               "
+ " console.log(index + \": \" + value);                                 "
+ " return value === \"CoffeeScript\";                                   "
+ "});                                                                    "
+ "// output:                                                             "
+ "// 0: JavaScript                                                       "
+ "// 1: Java                                                             "
+ "// 2: CoffeeScript                                                     "
+ "                                                                       "
+ "ary.every(function(value, index, _ary) {                               "
+ " console.log(index + \": \" + value);                                 "
+ " return value.indexOf(\"Script\") > -1;                               "
+ "});                                                                    "
+ "// output:                                                             "
+ "// 0: JavaScript                                                       "
+ "// 1: Java                                                             "
,
                CreatedOn = DateTime.Parse("27.10.2015 10:53:20"),
                Language = context.Languages.FirstOrDefault(l => l.Name == "JavaScript"),
                Labels = new List<Label>()
                {
                    context.Labels.FirstOrDefault(l=>l.Text=="jquery"),
                    context.Labels.FirstOrDefault(l=>l.Text=="useful"),
                    context.Labels.FirstOrDefault(l=>l.Text=="web"),
                    context.Labels.FirstOrDefault(l=>l.Text=="front-end")
                }
            });
            context.SaveChanges();



            context.Snippets.Add(new Snippet()
            {
                Title = "Numbers only in an input field",
                Description = "Method allowing only numbers (positive / negative / with commas or decimal points) in a field",
                Author = context.Users.FirstOrDefault(u => u.UserName == "someUser"),
                Code = "$(\"#input\").keypress(function(event){        "
+ " var charCode = (event.which) ? event.which : window.event.keyCode; "
+ " if (charCode <= 13) { return true; }                               "
+ " else {                                                             "
+ "     var keyChar = String.fromCharCode(charCode);                   "
+ "     var regex = new RegExp(\"[0-9,.-]\");                          "
+ "     return regex.test(keyChar);                                    "
+ " }                                                                  "
+ "});                                                                 "
                ,
                CreatedOn = DateTime.Parse("28.10.2015 09:00:56"),
                Language = context.Languages.FirstOrDefault(l => l.Name == "JavaScript"),
                Labels = new List<Label>()
                {
                    context.Labels.FirstOrDefault(l=>l.Text=="web"),
                     context.Labels.FirstOrDefault(l=>l.Text=="front-end"),
                }
            });
            context.SaveChanges();

            context.Snippets.Add(new Snippet()
            {
                Title = "Create a link directly in an SQL query",
                Description = "That's how you create links - directly in the SQL!",
                Author = context.Users.FirstOrDefault(u => u.UserName == "admin"),
                Code = "Code:                                                                                                                                        "
+ "SELECT DISTINCT                                                                                                                              "
+ "              b.Id,                                                                                                                          "
+ "              concat('<button type=\"\"button\"\" onclick=\"\"DeleteContact(', cast(b.Id as char), ')\"\">Delete...</button>') as lnkDelete  "
+ "FROM tblContact   b                                                                                                                          "
+ "WHERE ....                                                                                                                                   "

               ,
                CreatedOn = DateTime.Parse("30.10.2015 11:20:00"),
                Language = context.Languages.FirstOrDefault(l => l.Name == "SQL"),
                Labels = new List<Label>()
                {
                     context.Labels.FirstOrDefault(l=>l.Text=="bug"),
                     context.Labels.FirstOrDefault(l=>l.Text=="funny"),
                     context.Labels.FirstOrDefault(l=>l.Text=="mysql"),
                }
            });
            context.SaveChanges();

            context.Snippets.Add(new Snippet()
            {
                Title = "Reverse a String",
                Description = "Almost not worth having a function for...",
                Author = context.Users.FirstOrDefault(u => u.UserName == "admin"),
                Code = "def reverseString(s):                        "
+ " \"\"\"Reverses a string given to it.\"\"\" "
+ " return s[::-1]                             ",
                CreatedOn = DateTime.Parse("26.10.2015 09:35:13"),
                Language = context.Languages.FirstOrDefault(l => l.Name == "Python"),
                Labels = new List<Label>()
                {
                     context.Labels.FirstOrDefault(l=>l.Text=="useful"),

                }
            });
            context.SaveChanges();

            context.Snippets.Add(new Snippet()
            {
                Title = "Pure CSS Text Gradients",
                Description = "code describes how to create text gradients using only pure CSS",
                Author = context.Users.FirstOrDefault(u => u.UserName == "someUser"),
                Code = "/* CSS text gradients */                                                                                                                         "
+ "h2[data-text] {                                                                                                                                 "
+ " position: relative;                                                                                                                           "
+ "}                                                                                                                                               "
+ "h2[data-text]::after {                                                                                                                          "
+ " content: attr(data-text);                                                                                                                     "
+ " z-index: 10;                                                                                                                                  "
+ " color: #e3e3e3;                                                                                                                               "
+ " position: absolute;                                                                                                                           "
+ " top: 0;                                                                                                                                       "
+ " left: 0;                                                                                                                                      "
+ " -webkit-mask-image: -webkit-gradient(linear, left top, left bottom, from(rgba(0,0,0,0)), color-stop(50%, rgba(0,0,0,1)), to(rgba(0,0,0,0)));  "
,
                CreatedOn = DateTime.Parse("22.10.2015 19:26:42"),
                Language = context.Languages.FirstOrDefault(l => l.Name == "CSS"),
                Labels = new List<Label>()
                {
                     context.Labels.FirstOrDefault(l=>l.Text=="web"),
                     context.Labels.FirstOrDefault(l=>l.Text=="front-end"),
                }
            });
            context.SaveChanges();

            context.Snippets.Add(new Snippet()
            {
                Title = "Check for a Boolean value in JS",
                Description = "How to check a Boolean value - the wrong but funny way :D",
                Author = context.Users.FirstOrDefault(u => u.UserName == "admin"),
                Code = "var b = true;                     "
+ "                                  "
+ "if (b.toString().length < 5) {    "
+ "  //...                           "
+ "}                                 "

,
                CreatedOn = DateTime.Parse("22.10.2015 05:30:04"),
                Language = context.Languages.FirstOrDefault(l => l.Name == "JavaScript"),
                Labels = new List<Label>()
                {
                     context.Labels.FirstOrDefault(l=>l.Text=="funny"),
                }
            });
            context.SaveChanges();

        }

        private void SeedLanguages(SnippyDbContext context)
        {
            var languagesString = "C#, JavaScript, Python, CSS, SQL, PHP";
            string[] languages = Regex.Split(languagesString, @",");

            foreach (var language in languages)
            {
                context.Languages.Add(new Language()
                {
                    Name = language.Trim()
                });
                context.SaveChanges();
            }
        }

        private void SeedUsers(SnippyDbContext context)
        {
            var userStore = new UserStore<User>(context);
            var userManager = new UserManager<User>(userStore);
            var userToInsert = new User { UserName = "admin", Email = "admin@snippy.softuni.com" };
            userManager.Create(userToInsert, "adminPass123");

            userStore = new UserStore<User>(context);
            userManager = new UserManager<User>(userStore);
            userToInsert = new User { UserName = "someUser", Email = "someUser@example.com" };
            userManager.Create(userToInsert, "someUserPass123");

            userStore = new UserStore<User>(context);
            userManager = new UserManager<User>(userStore);
            userToInsert = new User { UserName = "newUser", Email = "new_user@gmail.com" };
            userManager.Create(userToInsert, "userPass123");
        }

        private void SeedLabels(SnippyDbContext context)
        {
            var labelsString = "bug, funny, jquery, mysql, useful, web, geometry, back-end, front-end, games";
            string[] labels = Regex.Split(labelsString, @", ");

            foreach (var label in labels)
            {
                context.Labels.Add(new Label()
                {
                    Text = label,
                });
                context.SaveChanges();
            }

        }
    }
}