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 System.Data.SqlClient;

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

        private void label9_Click(object sender, EventArgs e)
        {

        }

        private void label10_Click(object sender, EventArgs e)
        {

        }

        private void textBox3_Leave(object sender, EventArgs e)
        {
            verificCNP(textBox3.Text);
        }
        public static bool verificCNP(string cnp)
        {
            int s, a1, a2, l1, l2, z1, z2, j1, j2, n1, n2, n3, cifc, u;
            if (cnp.Trim().Length != 13)
                return false;
            else
            {
                s = Convert.ToInt16(cnp.Substring(0, 1));
                a1 = Convert.ToInt16(cnp.Substring(1, 1));
                a2 = Convert.ToInt16(cnp.Substring(2, 1));
                l1 = Convert.ToInt16(cnp.Substring(3, 1));
                l2 = Convert.ToInt16(cnp.Substring(4, 1));
                z1 = Convert.ToInt16(cnp.Substring(5, 1));
                z2 = Convert.ToInt16(cnp.Substring(6, 1));
                j1 = Convert.ToInt16(cnp.Substring(7, 1));
                j2 = Convert.ToInt16(cnp.Substring(8, 1));
                n1 = Convert.ToInt16(cnp.Substring(9, 1));
                n2 = Convert.ToInt16(cnp.Substring(10, 1));
                n3 = Convert.ToInt16(cnp.Substring(11, 1));
                cifc = Convert.ToInt16(((s * 2 + a1 * 7 + a2 * 9 + l1 * 1 + l2 * 4 + z1 * 6 +
                z2 * 3 + j1 * 5 + j2 * 8 + n1 * 2 + n2 * 7 + n3 * 9) % 11));
                if (cifc == 10)
                {
                    cifc = 1;
                }
                u = Convert.ToInt16(cnp.Substring(12, 1));
                if (cifc == u)
                    return true;
                else
                    return false;
            }

        }

        private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
        {

        }

        private void textBox3_TextChanged(object sender, EventArgs e)
        {
            if (verificCNP(textBox3.Text) == true)
                dataa();
        }
        public void dataa()
        {
            if (verificCNP(textBox3.Text) == true)
            {
                string cnp = textBox3.Text;
                int a1, a2, l1, l2, z1, z2;
                a1 = Convert.ToInt16(cnp.Substring(1, 1));
                a2 = Convert.ToInt16(cnp.Substring(2, 1));
                l1 = Convert.ToInt16(cnp.Substring(3, 1));
                l2 = Convert.ToInt16(cnp.Substring(4, 1));
                z1 = Convert.ToInt16(cnp.Substring(5, 1));
                z2 = Convert.ToInt16(cnp.Substring(6, 1));
                int year = 1900 + (a1 * 10) + a2;
                int month = (l1 * 10) + l2;
                int day = (z1 * 10) + z2;
                dateTimePicker1.Value = new DateTime(year, month, day);
                int varsta1 = DateTime.Today.Year - year;
                string vs = Convert.ToString(varsta1);
                textBox6.Text = vs;
            }
        }

        private void textBox6_TextChanged(object sender, EventArgs e)
        {

        }

        private void button1_Click(object sender, EventArgs e)
        {
            string connetionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Student\source\repos\WindowsFormsApp6\WindowsFormsApp6\PacientiSpital.mdf;Integrated Security=True";
            SqlConnection cnn = new SqlConnection(connetionString);
            cnn.Open();
            string tabel_date = "insert into Pacienti ([Nume], [Prenume],[CNP],[Sex],[NumeMama],[NumeTata],[DataNasterii],[Varsta],[LoculNasterii],[APGAR],[MedicFam],[Antecendente])values(@nume, @prenume, @cnp,@sex,@numemama,@numetata,@datanasterii,@varsta,@loculnasterii,@apgar,@medicfam,@antecedente)";
            SqlCommand sc = new SqlCommand(tabel_date, cnn);
            sc.Parameters.AddWithValue("@nume", textBox1.Text);
            sc.Parameters.AddWithValue("@prenume", textBox2.Text);
            sc.Parameters.AddWithValue("@cnp", textBox3.Text);
            sc.Parameters.AddWithValue("@sex", comboBox1.Text);
            sc.Parameters.AddWithValue("@numemama", textBox4.Text);
            sc.Parameters.AddWithValue("@numetata", textBox5.Text);
            sc.Parameters.AddWithValue("@datanasterii", dateTimePicker1.Value);
            sc.Parameters.AddWithValue("@varsta", textBox6.Text);
            sc.Parameters.AddWithValue("@loculnasterii", textBox7.Text);
            sc.Parameters.AddWithValue("@apgar", textBox8.Text);
            sc.Parameters.AddWithValue("@medicfam", textBox9.Text);
            sc.Parameters.AddWithValue("@antecedente", textBox10.Text);
            sc.ExecuteNonQuery();
            cnn.Close();
            MessageBox.Show("Date salvate!");
            DialogResult = DialogResult.OK;
        }

        private void textBox10_TextChanged(object sender, EventArgs e)
        {

        }
    }
}