using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace GeoTema
{
    public partial class ChangeDefaultPassword : Form
    {
        public ChangeDefaultPassword()
        {
            InitializeComponent();
        }

        private void btnChange_Click(object sender, EventArgs e)
        {
            string NewPass = txtNewPass.Text;

            if (NewPass == "")
                MessageBox.Show("Please fill in the necessary fields!");
            else if (NewPass == "Passw0rd")
                MessageBox.Show("New password can't be the default one!");
            else
            {
                MainMenu main1 = new MainMenu();
                if (main1.PasswordCheck(NewPass))
                {
                    List<string> param1 = new List<string> { NewPass };
                    string statement1 = "use GeoTema_Users update Users set password = @User where Username = '" + MainMenu.User + "'";
                    Sql.SQLConnect(statement1, param1);
                    List<string> param2 = new List<string> { NewPass };
                    string statement2 = "use master declare @sql nvarchar(max) set @sql = 'alter login " + MainMenu.User + " with password = ' + quotename(@User, '''') + ' old_password = ''Passw0rd''' exec(@sql)";
                    Sql.SQLConnect(statement2, param2);
                    MainMenu.Pass = NewPass;

                    MessageBox.Show("Password changed!");

                    switch (MainMenu.type)
                    {
                        case "administrator":
                            {
                                this.Hide();
                                AdminMenu Admin1 = new AdminMenu();
                                Admin1.ShowDialog();
                                this.Close();
                                break;
                            }
                        case "super user":
                            {
                                this.Hide();
                                SuperMenu Super1 = new SuperMenu();
                                Super1.ShowDialog();
                                this.Close();
                                break;
                            }
                        case "user":
                            {
                                this.Hide();
                                UserMenu User1 = new UserMenu();
                                User1.ShowDialog();
                                this.Close();
                                break;
                            }
                    }
                }
                else
                    MessageBox.Show("Passwords must be a minimum of 8 characters long and contain at least one of each: small letter, big letter and number.");
            }
        }
    }
}