using System;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace Final_Project
{
    public partial class insertStudentForm : Form
    {
        SqlConnection myCon = new SqlConnection(@"Data Source=AHMED-B29748D45\SQLEXPRESS;Initial Catalog= Final DB ;Integrated Security=True");
        SqlCommand insertCmd;

        public insertStudentForm()
        {
            InitializeComponent();
        }

        private void nameTextBox_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (e.KeyChar >= '0' && e.KeyChar <= '9')
                e.Handled = true;
            else
                e.Handled = false;
        }

        private void nameTextBox_TextChanged(object sender, EventArgs e)
        {
            if (nameTextBox.Text == "")
                saveBtn.Enabled = false;
            else
                saveBtn.Enabled = true;
        }

        private void closeBtn_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void cancelBtn_Click(object sender, EventArgs e)
        {
            nameTextBox.Text = "";
            maleRadioBtn.Checked = true;
            gradeComboBox.SelectedIndex = 0;
            departmentComboBox.SelectedIndex=0;
            dateTimePicker1.Value =DateTime.Parse( "1/1/1980");
        }

        private void insertStudentForm_Load(object sender, EventArgs e)
        {

            
            gradeComboBox.SelectedIndex = 0;
            departmentComboBox.SelectedIndex = 0;
             
            nameTextBox.Text = "";
            dateTimePicker1.Value = DateTime.Parse("1/1/1980");
            maleRadioBtn.Checked = true;
        }

        private void saveBtn_Click(object sender, EventArgs e)
        {
            myCon.Open();
            insertCmd = new SqlCommand("insert into students values('"+nameTextBox.Text+"','"+dateTimePicker1.Value+"',"+(maleRadioBtn.Checked?1:0)+","+(departmentComboBox.SelectedIndex+1 ) +"," +  (gradeComboBox.SelectedIndex+1) +")",myCon);
           
            insertCmd.ExecuteNonQuery();
            myCon.Close();
            
            gradeComboBox.SelectedIndex = 0;
            departmentComboBox.SelectedIndex = 0;
            nameTextBox.Text = "";
            dateTimePicker1.Value = DateTime.Parse("1/1/1980");
            maleRadioBtn.Checked = true;

            MessageBox.Show("Insertion has completed...", "insertion....", MessageBoxButtons.YesNo);
        }
    }
}