using System;
using System.Collections.Generic;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Http;
using DbConnection;
using loginReg.Models;

namespace loginReg.Controllers
{
    public class HomeController : Controller
    {
        [HttpGet]
        [Route("")]
        public IActionResult Index()
        {
            return View();
        }

        [HttpGet]
        [Route("/logout")]
        public IActionResult LogOut()
        {
            HttpContext.Session.Clear();
            return RedirectToAction("Index");
        }

        [HttpGet]
        [Route("/loggedIn")]
        public IActionResult Logged()
        {
            List<Dictionary<string, object>> UsertoMessages = DbConnector.Query("SELECT users.id, first_name, message, messageposted_at FROM users JOIN messages ON users.id = messages.user_id");
            List<Dictionary<string, object>> UsertoComments = DbConnector.Query("SELECT users.id, first_name, comment, commentposted_at  FROM users JOIN comments ON users.id = comments.user_id");
            List<Dictionary<string, object>> MessagestoComments = DbConnector.Query("SELECT message, comment, commentposted_at FROM messages JOIN comments ON messages.messages_id = comments.message_id");
            ViewBag.messages = UsertoMessages;
            ViewBag.comments = UsertoComments;
            ViewBag.messcomms = MessagestoComments;
            return View();
        }

        [HttpPost]
        [Route("/loggingIn")]
        public IActionResult Logging(string useremail, string userpassword)
        {
            List<Dictionary<string, object>> Userid = DbConnector.Query($"SELECT * from users where email = '{useremail}'");
            int id = (int)Userid[0]["id"];
            HttpContext.Session.SetInt32("UserId", id);
            User NewUser = new User
            {
                Email = useremail,
                Password = userpassword,
            };
            TryValidateModel(NewUser);
            ViewBag.errors = ModelState.Values;
            int? v = HttpContext.Session.GetInt32("UserId");
            List<Dictionary<string, object>> userVIAemail = DbConnector.Query($"SELECT * FROM users where id = '{v}'");
            if ((string)userVIAemail[0]["email"] != useremail || (string)userVIAemail[0]["password"] != userpassword)
            {
                return RedirectToAction("Index");
            }
            else
            {
                return RedirectToAction("Logged");
            }
        }

        [HttpPost]
        [Route("/register")]
        public IActionResult Registrate(string fname, string lname, string useremail, string userpassword)
        {
            User NewUser = new User
            {
                First_Name = fname,
                Last_Name = lname,
                Email = useremail,
                Password = userpassword,
            };
            TryValidateModel(NewUser);
            ViewBag.errors = ModelState.Values;
            string firstname = fname;
            string lastname = fname;
            string email = useremail;
            string password = userpassword;
            if (firstname == null && lastname == null && email == null && password == null)
            {
                return RedirectToAction("Index");
            }
            else
            {
                List<Dictionary<string, object>> Users = DbConnector.Query($"INSERT INTO users (first_name, last_name, email, password) VALUES ('{firstname}', '{lastname}', '{email}', '{password}')");
                return RedirectToAction("Index");
            }
        }


        [HttpPost]
        [Route("/comment")]
        public IActionResult Comment(string content)
        {
            Comment NewComment = new Comment
            {
                PostComment = content,
            };
            TryValidateModel(NewComment);
            ViewBag.errors = ModelState.Values;
            string comment = content;
            if (comment == null)
            {
                return RedirectToAction("Logged");
            }
            else
            {
                int? x = HttpContext.Session.GetInt32("UserId");
                int? y = HttpContext.Session.GetInt32("MsgId");
                Console.WriteLine(x);
                Console.WriteLine(y);
                // List<Dictionary<string, object>> MessageTObe = DbConnector.Query($"SELECT * FROM messages WHERE messages_id = '{y}'");
                // List<Dictionary<string, object>> Comment = DbConnector.Query($"INSERT INTO comments (comment, commentposted_at, user_id, message_id) VALUES ('{content}', NOW(), '{x}', '{y}')");
                return RedirectToAction("Logged");
            }
        }

        [HttpPost]
        [Route("/postmessage")]
        public IActionResult MessagePosting(string message)
        {
            Message NewMessage = new Message
            {
                MessagePost = message,
            };
            TryValidateModel(NewMessage);
            ViewBag.errors = ModelState.Values;
            string msg = message;
            if (msg == null)
            {
                return RedirectToAction("Logged");
            }
            else
            {
                int? x = HttpContext.Session.GetInt32("UserId");
                List<Dictionary<string, object>> PostMessage = DbConnector.Query($"INSERT INTO messages (message, user_id, messageposted_at) VALUES ('{message}', '{x}', NOW())");
                List<Dictionary<string, object>> Messages = DbConnector.Query($"SELECT * FROM messages");
                Dictionary<string,object> unique = new Dictionary<string, object>();
                foreach(var n in Messages){
                    unique.Add((string) n["messages_id"], n);
                }
                HttpContext.Session.SetInt32("MsgId", n);
                return RedirectToAction("Logged");
            }
        }
    }
}