// GET: Home
        public async Task<ActionResult> Index()
        {
            var context = new ApplicationDbContext(); // DefaultConnection
            var store = new UserStore<CustomUser>(context);
            var manager = new UserManager<CustomUser>(store);

            var email = "[email protected]";
            var password = "Passw0rd";
            var user = await manager.FindByEmailAsync(email);

            if (user == null)
            {
                user = new CustomUser
                {
                    UserName = email,
                    Email = email,
                    FirstName = "Super",
                    LastName = "Admin"
                };

                await manager.CreateAsync(user, password);
            }
            else
            {
                user.FirstName = "Super";
                user.LastName = "Admin";

                await manager.UpdateAsync(user);
            }


            return Content("Hello, Index");
        }

        public string AddFollow(string userId, string type)
        {
            using (ApplicationDbContext db = new ApplicationDbContext())
            {
                var manager = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(db));
                var currentUser = manager.FindById(User.Identity.GetUserId());
                var followedUser = manager.FindById(userId);

                if (type.Equals("Follow"))
                {
                    currentUser.followList.Add(followedUser);
                }
                else
                {
                    UnFollow(currentUser, followedUser);
                }

                //manager.UpdateAsync(currentUser);

                var store = new UserStore<ApplicationUser>(new ApplicationDbContext());

                //store.Context.SaveChanges();
                db.SaveChanges();
                return "success";
            }
        }

        public string AddBlock(string userId, string type)
        {
            using (ApplicationDbContext db = new ApplicationDbContext())
            {
                var manager = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(db));
                var currentUser = manager.FindById(User.Identity.GetUserId());
                var blockedUser = manager.FindById(userId);

                if (type.Equals("Block"))
                {
                    currentUser.blockedList.Add(blockedUser);

                    //unfollow each person if there was any following
                    UnFollow(currentUser, blockedUser);
                    UnFollow(blockedUser, currentUser);
                }
                else  //unblock user just remove him from the list
                {
                    var block = currentUser.blockedList.Find(user => user.Id == blockedUser.Id);

                    if (block != null)
                    {
                        currentUser.blockedList.Remove(block);
                    }
                }

              //  manager.UpdateAsync(currentUser);

                var store = new UserStore<ApplicationUser>(new ApplicationDbContext());

               // store.Context.SaveChanges();
                db.SaveChanges();
                return "success";
            }
        }

 protected void grdMessages_RowCommand(object sender, GridViewCommandEventArgs e)
 {
     Control control = null;
     switch (e.CommandName)
     {
         case "AddFromFooter":
             control = grdMessages.FooterRow;
             break;
         default:
             control = grdMessages.Controls[0].Controls[0];
             break;
     }
     if (control != null)
     {
         var textBox = control.FindControl("txtMessage") as TextBox;
         if (textBox != null)
         {
             string message = textBox.Text;
             
             var db = new ApplicationDbContext();
             db.Messages.Add(new MessageModel()
             {
                 Message = message,
                 UserId = User.Identity.GetUserId()
             });
             db.SaveChanges();
             grdMessages.DataBind();
         }
     }
 }

        protected void Page_Load(object sender, EventArgs e)
        {
            //var manager = new AuthenticationIdentityManager(new IdentityStore(new ApplicationDbContext()));
            //manager.Roles.CreateRoleAsync(new Role("Moderator"));
            //manager.Roles.AddUserToRoleAsync("54fbcab5-d65b-47d4-b517-2eba10002e21", "186c2138-de27-42a6-94f0-8b830c2e8b9c");
            var manager = new AuthenticationIdentityManager(new IdentityStore(new ApplicationDbContext()));
            if (!manager.Logins.HasLocalLogin(User.Identity.GetUserId()))
            {
                grdMessages.EmptyDataTemplate = null;
                if (grdMessages.FooterRow != null)
                {
                    grdMessages.FooterRow.Visible = false;
                }
            }
            else
            {
                var userId = User.Identity.GetUserId();

                var db = new ApplicationDbContext();
                var user = db.Users.FirstOrDefault(u => u.Id == userId);
                if (user != null)
                {
                    if (user.Roles.Any(r => r.Role.Name == "Moderator"))
                    {
                        grdMessages.Columns[2].Visible = true;
                    }
                    else if (user.Roles.Any(r => r.Role.Name == "Administrator"))
                    {
                        grdMessages.Columns[2].Visible = true;
                        grdMessages.Columns[3].Visible = true;
                    }
                }
            }
        }

 public static IEnumerable<Language> GetAll()
 {
     using (ApplicationDbContext db = new ApplicationDbContext())
     {
         return db.Languages.OrderBy(h => h.Name).ToList();
     }
 }

        protected void LogIn(object sender, EventArgs e)
        {
            if (IsValid)
            {
                var context = new ApplicationDbContext();
                var signinUser = context.Users.FirstOrDefault(u => u.UserName == UserName.Text);

                if (signinUser!= null && !signinUser.IsDeleted)
                {
                    // Validate the user password
                    IAuthenticationManager manager = new AuthenticationIdentityManager(new IdentityStore(new ApplicationDbContext())).Authentication;
                    IdentityResult result = manager.CheckPasswordAndSignIn(Context.GetOwinContext().Authentication, UserName.Text, Password.Text, RememberMe.Checked);

                    if (result.Success)
                    {
                        OpenAuthProviders.RedirectToReturnUrl(Request.QueryString["ReturnUrl"], Response);
                    }
                    else
                    {
                        FailureText.Text = result.Errors.FirstOrDefault();
                        ErrorMessage.Visible = true;
                    }
                }
                else
                {
                    FailureText.Text = "Please register";
                    ErrorMessage.Visible = true;
                }
            }
        }

 public CourseViewModel Course([FromUri] int ID)
 {
     using (var ctx = new ApplicationDbContext())
     {
         return new CourseViewModel(ctx.Courses.Include(m => m.Prerequisites).Single(m => m.ID == ID));
     }
 }

		public BookRepository(ApplicationDbContext context, ApplicationUser user) {
			if (context == null) throw new ArgumentException(nameof(context));
			if (user == null) throw new ArgumentException(nameof(user));

			_context = context;
			_user = user;
		}

        public JsonResult doesUserNameExist(string UserName)
        {
            var db = new ApplicationDbContext();
            var user = db.Users.Where(c => c.UserName == UserName).FirstOrDefault();

            return Json(user == null);
        }

        protected void ButtonEditAnswer_Click(object sender, EventArgs e)
        {
            var text = this.AnswerText.Text;

            if (string.IsNullOrWhiteSpace(text) || text == "<br>")
            {
                ErrorSuccessNotifier.AddErrorMessage("Answer body can't be empty");
                return;
            }

            var answerId = Convert.ToInt32(Request.Params["id"]);
            var context = new ApplicationDbContext();
            var answer = context.Answers.Find(answerId);

            if (answer.Text != text)
            {
                answer.Text = text;
            }

            context.SaveChanges();

            ErrorSuccessNotifier.ShowAfterRedirect = true;
            ErrorSuccessNotifier.AddSuccessMessage("Answer edited");

            Response.Redirect("~/QuestionForm.aspx?id=" + answer.Question.Id);
        }

        //
        // GET: /Manage/Index
        public async Task<ActionResult> Index(ManageMessageId? message)
        {
            ApplicationDbContext db = new ApplicationDbContext();

            ViewBag.StatusMessage =
                message == ManageMessageId.ChangePasswordSuccess ? "Your password has been changed."
                : message == ManageMessageId.SetPasswordSuccess ? "Your password has been set."
                : message == ManageMessageId.SetTwoFactorSuccess ? "Your two-factor authentication provider has been set."
                : message == ManageMessageId.Error ? "An error has occurred."
                : message == ManageMessageId.AddPhoneSuccess ? "Your phone number was added."
                : message == ManageMessageId.RemovePhoneSuccess ? "Your phone number was removed."
                : "";

            var userId = User.Identity.GetUserId();

            var model = new IndexViewModel
            {
                HasPassword = HasPassword(),
                PhoneNumber = await UserManager.GetPhoneNumberAsync(userId),
                TwoFactor = await UserManager.GetTwoFactorEnabledAsync(userId),
                Logins = await UserManager.GetLoginsAsync(userId),
                BrowserRemembered = await AuthenticationManager.TwoFactorBrowserRememberedAsync(userId),
                MinutesBetweenAlerts = db.Users.Single(m => m.UserName == User.Identity.Name).MinutesBetweenAlerts,
            };

            return View(model);
        }

        public void Init()
        {
            _trans = new TransactionScope();
            // make connection
            db = new ApplicationDbContext();

            //make controller
            controller = new ReviewController { DbContext = db };

            // seed the database if empty
            if (db.Members.Count() == 0)
            {
                new Migrations.Configuration().SeedDebug(db);
                Console.WriteLine("Seeded DB");
            }
            else
            {
                Console.WriteLine("DB Already seeded");
            }

            Review validTestReview = new Review();
            Game game = db.Games.FirstOrDefault();
            Member member = db.Members.FirstOrDefault();
            validTestReview.Game_Id = game.Id;
            validTestReview.Game = game;
            validTestReview.Author = member;
            validTestReview.Rating = 3;
            validTestReview.Body = "Great Game!";
            validTestReview.Subject = "Review Title";
            validTestReview.IsApproved = false;
            validTestReview.Aprover_Id = null;

            db.Reviews.Add(validTestReview);
            db.SaveChanges();
        }

        public void RegisterTest()
        {
            using (var db = new ApplicationDbContext())
            {
                //arrange
                string password = "joshua";
                string email = "[email protected]";
                string role = "admin";
                string firstname = "Mark Joshua";
                string lastname = "Abrenica";
                RegisterViewModel registration = new RegisterViewModel()
                {
                    Password = password,
                    Email = email,
                    ConfirmPassword = password,
                     Role = role,
                      FirstName = firstname,
                      LastName = lastname
                };

                //act
                AccountController controller = new AccountController();

                bool output = controller.RegisterUser(registration);
                //assert
                Assert.IsTrue(output);

            }
        }

 public int ClearStatistics()
 {
     var context = new ApplicationDbContext();
     context.Statistics.RemoveRange(context.Statistics);
     context.SaveChanges();
     return context.Statistics.Count();
 }

 public ActionResult EditUserProfile(string id)
 {
     var context = new ApplicationDbContext();
     var user = context.Users.Include("Profile").FirstOrDefault(u => u.UserName == id);
     this.ViewBag.user = user;
     return this.View();
 }

        public void ConfigureAuth(IAppBuilder app)
        {
            ApplicationDbContext db = new ApplicationDbContext();

            app.SetDefaultSignInAsAuthenticationType(CookieAuthenticationDefaults.AuthenticationType);

            app.UseCookieAuthentication(new CookieAuthenticationOptions());

            app.UseOpenIdConnectAuthentication(
                new OpenIdConnectAuthenticationOptions
                {
                    ClientId = clientId,
                    Authority = Authority,
                    PostLogoutRedirectUri = postLogoutRedirectUri,

                    Notifications = new OpenIdConnectAuthenticationNotifications()
                    {
                        // If there is a code in the OpenID Connect response, redeem it for an access token and refresh token, and store those away.
                       AuthorizationCodeReceived = (context) =>
                       {
                           var code = context.Code;
                           ClientCredential credential = new ClientCredential(clientId, appKey);
                           string signedInUserID = context.AuthenticationTicket.Identity.FindFirst(ClaimTypes.NameIdentifier).Value;
                           AuthenticationContext authContext = new AuthenticationContext(Authority, new ADALTokenCache(signedInUserID));
                           AuthenticationResult result = authContext.AcquireTokenByAuthorizationCode(
                           code, new Uri(HttpContext.Current.Request.Url.GetLeftPart(UriPartial.Path)), credential, graphResourceId);

                           return Task.FromResult(0);
                       }
                    }
                });
        }

 public Prop()
 {
     //TODO: Get date and lookup to see what Football week is being played
     ApplicationDbContext db = new ApplicationDbContext();
     var weekId = db.Week.First().Week_Id;
     this.Week = weekId;
 }

        public void Insert(string username)
        {
            using (var rep = new OrderRepository())
            {
                ApplicationDbContext dbcon = new ApplicationDbContext();

                OrderView model = new OrderView();
                var obj = new PatientBusiness();
                var shop = new ShoppingCartBusiness();

                var person = dbcon.Patients.SingleOrDefault(x => x.UserName.Equals(username));

                var tot = shop.ComputeTotal(username);

                if (tot != 0)
                {

                    if (person != null)
                    {
                        model.FirstName = person.FirstName;
                        model.LastName = person.LastName;

                    }
                    model.TotalCost = shop.ComputeTotal(username);
                    model.Username = username;

                    rep.Insert(ConvertToProduct(model));
                }
                ShoppingCartBusiness biz = new ShoppingCartBusiness();
                biz.UpdateCheck(username);
            }
        }

 public CallForPapersController(IConferenceService conferenceService, IImageUploader imageUploader, ApplicationDbContext dbContext)
 {
     _conferenceService = conferenceService;
     _imageUploader = imageUploader;
     _dbContext = dbContext;
     _cfpSpeakerImageContainerName = ConfigurationManager.AppSettings["Storage.Container.CallForPaper.SpeakerImages"];
 }