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

namespace SUveTUPtakip
{
    public partial class Form3 : Form
    {
        public Form3()
        {
            InitializeComponent();

        }
        public  Form2 frm2;


        MySqlCommand cmd;
        MySqlDataReader dr;
        MySqlConnection con = new MySqlConnection("Server=localhost; Database=su_tup; Uid=root; Pwd=1234");
        public DataSet dtst = new DataSet();
        private void Form3_Load(object sender, EventArgs e)
        {
            dateTimePicker1.Enabled = false;
            string formateddate = dateTimePicker1.Value.ToString("yyyy-MM-dd");
            textBox5.Text = formateddate;
            
        }
        private void button1_Click(object sender, EventArgs e)
        {

            cmd.Connection = con;
            cmd.CommandText = "INSERT INTO musteribilgi (musteriNo, musteriAdi, musteriSoyadi, musteriTel, musteriKayitTarihi, musteriAdres) VALUES (@musteriNo, @musteriAdi, @musteriSoyadi, @musteriTel, @musteriKayitTarihi, @musteriAdres)";

            cmd.Parameters.AddWithValue("@musteriNo", textBox1.Text);
            cmd.Parameters.AddWithValue("@musteriAdi", textBox2.Text);
            cmd.Parameters.AddWithValue("@musteriSoyadi", textBox3.Text);
            cmd.Parameters.AddWithValue("@musteriTel", textBox4.Text);
            cmd.Parameters.AddWithValue("@musteriKayitTarihi", textBox5.Text);
            cmd.Parameters.AddWithValue("@musteriAdres", textBox6.Text);

            cmd.ExecuteNonQuery();

            textBox1.Clear();
            textBox2.Clear();
            textBox3.Clear();
            textBox4.Clear();
            textBox5.Clear();
            textBox6.Clear();

            frm2.dtst.Tables["musteribilgi"].Clear();
            frm2.mustlistele();

            MessageBox.Show("Kayıt işlemi tamamlandı!");
        }
    }
}