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;
using MySql.Data.MySqlClient;



namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();

            String dbconnect = "Server=129.241.151.172;Database=IT1901;User=root;Password=herp";
            MySqlConnection dbconn = new MySqlConnection(dbconnect);

            MySqlCommand cmdepost = dbconn.CreateCommand();
            MySqlDataReader Readerepost;
            cmdepost.CommandText = "select epost from login where bondeID = 8"; // må endres så: bondeID = current user id
            dbconn.Open();
            Readerepost = cmdepost.ExecuteReader();
            Readerepost.Read();
            textBoxEpost.Text = Readerepost.GetValue(0).ToString();
            dbconn.Close();

            MySqlCommand cmdpw = dbconn.CreateCommand();
            MySqlDataReader Readerpw;
            cmdpw.CommandText = "select passord from login where bondeID = 8";
            dbconn.Open();
            Readerpw = cmdpw.ExecuteReader();
            Readerpw.Read();
            textBoxGammelPassord.Text = Readerpw.GetValue(0).ToString();
            dbconn.Close();

            MySqlCommand cmdtlf = dbconn.CreateCommand();
            MySqlDataReader Readertlf;
            cmdtlf.CommandText = "select telefonnr from Kontakt where bondeID = 8";
            dbconn.Open();
            Readertlf = cmdtlf.ExecuteReader();
            Readertlf.Read();
            textBoxTelefon.Text = Readertlf.GetValue(0).ToString();
            dbconn.Close();

            MySqlCommand cmdadresse = dbconn.CreateCommand();
            MySqlDataReader Readeradresse;
            cmdadresse.CommandText = "select adresse from Kontakt where bondeID = 8";
            dbconn.Open();
            Readeradresse = cmdadresse.ExecuteReader();
            Readeradresse.Read();
            textBoxAdresse.Text = Readeradresse.GetValue(0).ToString();
            dbconn.Close();

            MySqlCommand cmdID = dbconn.CreateCommand();
            MySqlDataReader ReaderID;
            cmdID.CommandText = "select bondeID from login where bondeID = 8";
            dbconn.Open();
            ReaderID = cmdID.ExecuteReader();
            ReaderID.Read();
            textBoxID.Text = ReaderID.GetValue(0).ToString();
            dbconn.Close();
        }

        private void Form1_Load(object sender, EventArgs e)
        {

        }

        private void label1_Click(object sender, EventArgs e)
        {

        }

        private void tabPage3_Click(object sender, EventArgs e)
        {

        }

        private void label2_Click(object sender, EventArgs e)
        {

        }

        private void label11_Click(object sender, EventArgs e)
        {

        }

        private void dataGridView2_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }

        private void labelNyPassord_Click(object sender, EventArgs e)
        {

        }

        private void textEpost_TextChanged(object sender, EventArgs e)
        {

        }

        private void buttonLagreEndringer_Click(object sender, EventArgs e)
        {



            String dbconnect = "Server=129.241.151.172;Database=IT1901;User=root;Password=herp";
            MySqlConnection dbconn = new MySqlConnection(dbconnect);


            MySqlCommand cmd = dbconn.CreateCommand();
            cmd.CommandText = "UPDATE login SET epost=@NyEpost, passord=@NyPassord WHERE bondeID=@bondeID";
            cmd.Parameters.AddWithValue("@bondeID", 8);                     // må endres så: bondeID = current user id
            cmd.Parameters.AddWithValue("@NyEpost", textBoxEpost.Text);
            cmd.Parameters.AddWithValue("@NyPassord", textBoxNyPassord.Text);
            dbconn.Open();
            cmd.ExecuteNonQuery();
            dbconn.Close();

            MySqlCommand cmd2 = dbconn.CreateCommand();
            cmd2.CommandText = "UPDATE Kontakt SET adresse=@NyAdresse, telefonnr=@NyTelefon WHERE bondeID=@bondeID";
            cmd2.Parameters.AddWithValue("@bondeID", 8);                    // må endres så: bondeID = current user id
            cmd2.Parameters.AddWithValue("@NyAdresse", textBoxAdresse.Text);
            cmd2.Parameters.AddWithValue("@NyTelefon", textBoxTelefon.Text);
            dbconn.Open();
            cmd2.ExecuteNonQuery();
            dbconn.Close();


            MessageBox.Show("Lagret");

        }
    }
}