using Microsoft.AspNetCore.Components;
using Microsoft.JSInterop;
using System.Data.SqlClient;
using System.Data;
using System.ComponentModel.DataAnnotations;
using sirkettodo.Pages.EntityFramework;
using static sirkettodo.Pages.UserData;
namespace sirkettodo.Pages.AdminPage 
{
    /*public class Users{
        [Key]
        public int user_id {get;set;}
        public string name {get;set;}
        public string lastname {get;set;}
        public string email {get;set;}
        public string password {get;set;}
        public string register_date {get;set;}
        public string role_id {get;set;}
        public string team_id {get;set;}
        public bool confirmation_status {get;set;}
    }*/

    /*public class Role{
         [Key]
        public int role_id {get;set;}
        public string role_name {get;set;}
    }*/

    /*public class Team{
         [Key]
        public int team_id {get;set;}
        public string team_name {get;set;}
    }*/

    public class AdminUserConfirm:ComponentBase
    {
        public static string database = @"workstation id=sirkettodo.mssql.somee.com;packet size=4096;user id=Ramiz058_SQLLogin_1;pwd=rs91p7j2w2;data source=sirkettodo.mssql.somee.com;persist security info=False;initial catalog=sirkettodo";    
        public static SqlConnection connection = new SqlConnection(database);
        public static SqlCommand command = connection.CreateCommand();
        
        public string name{get;set;}
        public string lastname{get;set;}
        public string email{get;set;}
        public string password{get;set;}
        public string callback{get;set;}="Default";
        public string team_id{get;set;}
        public string team_name{get;set;}
        //public List<Users> UserTable=new List<Users>();
        public List<Role> RoleTable=new List<Role>();
        public List<Team> TeamTable=new List<Team>();
        public List<UsersData> UserTable { get; set; }
        [Inject]
        public EntitySqlService service{get;set;}
        [Inject]
        public NavigationManager NavigationManager { get; set; }
        [Inject]
        IJSRuntime JSRuntime { get; set; }

   
        protected override async Task OnInitializedAsync() 
        {
            //RoleTable=GetRole();
            //TeamTable=GetTeam();
            //UserTable=GetUser();
            //UserTable = await Task.Run(() =>service.GettAllUsers());
            if(UserData.Data.UserEmailData != "NULL" && UserData.Data.UserPasswordData != "NULL" && UserData.Data.UserRoleData == 0)
            {
                TeamTable = await Task.Run(() =>GetTeam());
                RoleTable = await Task.Run(() =>GetRole());
                UserTable = await Task.Run(() =>GetUser());
                StateHasChanged();
            }
            else
            {
                JSRuntime.InvokeVoidAsync("gologin");
            }
        }

        protected override async Task OnAfterRenderAsync(bool firstRender)
        {
            if (firstRender)
            {
            string useremail=await JSRuntime.InvokeAsync<string>("useremail");
            string userpassword=await JSRuntime.InvokeAsync<string>("userpassword");
            string userrole=await JSRuntime.InvokeAsync<string>("userrole");
            Console.WriteLine(useremail+" "+userpassword+" "+userrole);
            }
        }

        public async Task<List<UsersData>> GetUser(){
            UserTable = await Task.Run(() =>service.GetAllUsers());
            return UserTable;
        }

        public async Task<List<Role>> GetRole(){
            RoleTable = await Task.Run(() =>service.GetAllRoles());
            return RoleTable;
        }

        public async Task<List<Team>> GetTeam(){
            TeamTable = await Task.Run(() =>service.GetAllTeams());
            return TeamTable;
        }

        public void ChangeRole(ChangeEventArgs e,int? user_id,string elementid)
        {
            string role_id = e.Value.ToString();
            command.CommandText ="update users set role_id="+role_id+" where user_id="+user_id+"";
            Console.WriteLine(command.CommandText);
            connection.Open();
            command.ExecuteNonQuery();
            connection.Close();
            JSRuntime.InvokeVoidAsync("ChangeColor",elementid,role_id);
            StateHasChanged();
        }

        public void ChangeTeam(ChangeEventArgs e,int? user_id)
        {
            string team_id = e.Value.ToString();
            command.CommandText ="update users set team_id="+team_id+" where user_id="+user_id+"";
            Console.WriteLine(command.CommandText);
            connection.Open();
            command.ExecuteNonQuery();
            connection.Close();
            StateHasChanged();
            //InvokeAsync(StateHasChanged);
        }  

        public async void ChangeConfirmation(string UserEmail, object checkedValue)
        {
            bool newIsDone=(bool)checkedValue?true:false;  
            Console.WriteLine(newIsDone);
            foreach(UsersData user in UserTable){
            if(user.email == UserEmail){
                if (newIsDone==true)
                {
                    user.confirmation_status = 1;
                }
                else
                {
                    user.confirmation_status = 0;
                }
                    await UpdateUsers(user);
                    break;
            }
        }
        }

        protected  async Task UpdateUsers(UsersData user)  
        {  
            await service.UpdateUsersAsync(user);
        } 

        protected void UpdateUsers1(UsersData user)  
        {  
            service.UpdateUsersAsync1(user);
        } 


        /*public List<Team> GetTeam()
        {
            connection.Open();
            string sql = "select *from team";  
            SqlDataAdapter DataAdapterTeamTable= new SqlDataAdapter (sql, connection);
            SqlCommandBuilder CommandBuilder = new SqlCommandBuilder(DataAdapterTeamTable);
            DataSet DataSetTeamTable = new DataSet();
            try
                {
                    DataAdapterTeamTable.Fill(DataSetTeamTable, "TeamTable");
                    //error+=DataSetTeamTable.Tables[0].Rows.Count.ToString();
                    for (int i = 0; i < DataSetTeamTable.Tables[0].Rows.Count; i++)  
                    {  
                    Team getTeam = new Team(); 
                    getTeam.team_id = Int32.Parse(DataSetTeamTable.Tables[0].Rows[i]["team_id"].ToString());  
                    getTeam.team_name = DataSetTeamTable.Tables[0].Rows[i]["team_name"].ToString();  
                    TeamTable.Add(getTeam);
                    }
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex);
                }
            connection.Close();
            return TeamTable;
        }*/



        /*public List<Role> GetRole()
        {
            connection.Open();
            string sql = "select *from role";  
            SqlDataAdapter DataAdapterRoleTable= new SqlDataAdapter (sql, connection);
            SqlCommandBuilder CommandBuilder = new SqlCommandBuilder(DataAdapterRoleTable);
            DataSet DataSetRoleTable = new DataSet();
            try
                {
                    DataAdapterRoleTable.Fill(DataSetRoleTable, "RoleTable");
                    //error+=DataSetRoleTable.Tables[0].Rows.Count.ToString();
                    for (int i = 0; i < DataSetRoleTable.Tables[0].Rows.Count; i++)  
                    {  
                    Role getRole = new Role(); 
                    getRole.role_id = Int32.Parse(DataSetRoleTable.Tables[0].Rows[i]["role_id"].ToString());  
                    getRole.role_name = DataSetRoleTable.Tables[0].Rows[i]["role_name"].ToString();  
                    RoleTable.Add(getRole);
                    }
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex);
                }
            connection.Close();
            return RoleTable;
        }*/


        /*public List<Users> GetUser()  
        {
            connection.Open();
            string sql = "select *from users";  
            SqlDataAdapter DataAdapterUserTable= new SqlDataAdapter (sql, connection);
            SqlCommandBuilder CommandBuilder = new SqlCommandBuilder(DataAdapterUserTable);
            DataSet DataSetUserTable = new DataSet();
 
            try
                {
                    DataAdapterUserTable.Fill(DataSetUserTable, "UserTable");
                    //error+=DataSetUserTable.Tables[0].Rows.Count.ToString();
                    for (int i = 0; i < DataSetUserTable.Tables[0].Rows.Count; i++)  
                    {  
                    Users getUser = new Users(); 
                    getUser.user_id = Int32.Parse(DataSetUserTable.Tables[0].Rows[i]["user_id"].ToString());
                    getUser.name = DataSetUserTable.Tables[0].Rows[i]["name"].ToString();  
                    getUser.lastname = DataSetUserTable.Tables[0].Rows[i]["lastname"].ToString();  
                    getUser.email = DataSetUserTable.Tables[0].Rows[i]["email"].ToString();  
                    getUser.password = DataSetUserTable.Tables[0].Rows[i]["password"].ToString();  
                    getUser.register_date = DataSetUserTable.Tables[0].Rows[i]["register_date"].ToString(); 
                    getUser.role_id = DataSetUserTable.Tables[0].Rows[i]["role_id"].ToString(); 
                    getUser.team_id = DataSetUserTable.Tables[0].Rows[i]["team_id"].ToString(); 
                    string cstat =DataSetUserTable.Tables[0].Rows[i]["confirmation_status"].ToString();
                    if(cstat=="1")   getUser.confirmation_status = true;
                    else             getUser.confirmation_status = false;
                    UserTable.Add(getUser);
                    }
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex);
                }
            connection.Close();
            return UserTable;
        }*/

    /*public async void ChangeConfirmation(string UserEmail, object checkedValue)
    {
      bool newIsDone=(bool)checkedValue?true:false;  
      Console.WriteLine(newIsDone);
      foreach(UsersData User in UserTable){
          if(User.email == UserEmail){
            if (newIsDone==true)
            {
                User.confirmation_status = 1;
                command.CommandText = "update users set confirmation_status=1 where email='"+UserEmail+"'";  
            }
            else
            {
                User.confirmation_status = 0;
                 command.CommandText = "update users set confirmation_status=0 where email='"+UserEmail+"'"; 
            }
            connection.Open();
            command.ExecuteNonQuery();
            connection.Close();
            break;
          }
      }
    }*/

    /*public void ChangeRole(ChangeEventArgs e,int user_id,string elementid)
    {
        string role_id = e.Value.ToString();
        string selectclass=role_id;
        
        foreach(UsersData user in UserTable){
            if(user.user_id == user_id){
                user.role_id=Int32.Parse(role_id);
                UpdateUsers1(user);
                JSRuntime.InvokeVoidAsync("ChangeColor",elementid,selectclass);
                break;
            }
        }
    }*/   
    }
}