private void addmisionDepart_Load(object sender, EventArgs e)
{
textBox1.Enabled = false;
textBox3.Enabled = false;
qc = new QueriesClass();
textBox1.Text = qc.returnRollNumber().ToString();
rad = new radioLoad();
aq = new AdmissionQueries();
textBox3.Text = aq.limitSeats();
comboBox1.DataSource = rad.mydt("select * from categoriesFields");
comboBox1.DisplayMember = "title";
comboBox1.ValueMember = "ID";
comboBox4.DataSource = rad.mydt("select * from bloodGroups");
comboBox4.DisplayMember = "title";
comboBox4.ValueMember = "ID";
}
private void button1_Click(object sender, EventArgs e)
{
aq = new AdmissionQueries();
AdmissionQueries ad = new AdmissionQueries();
qc = new QueriesClass();
if (radioButton1.Checked)
{
myGender = "Male";
}
else if (radioButton2.Checked)
{
myGender = "Female";
}
try
{
if (aq.limitSeats() != "Admission Closed")
{
ad.Rno = Convert.ToInt32(textBox1.Text);
ad.admissionDate = dateTimePicker1.Value;
ad.firstName = textBox4.Text;
ad.lastName = textBox5.Text;
ad.dateBirth = dateTimePicker2.Value;
ad.gender = myGender;
ad.fatherName = textBox6.Text;
ad.status = comboBox3.Text;
ad.fatheOccupation = textBox7.Text;
ad.income = Convert.ToInt32(textBox8.Text);
ad.nationality = textBox9.Text;
ad.blood = comboBox4.Text;
ad.religion = comboBox5.Text;
ad.field = comboBox1.Text;
ad.year = comboBox2.Text;
ad.section = textBox3.Text;
ad.phoneNumber = textBox2.Text;
ad.address = richTextBox1.Text;
ad.parcentage = Convert.ToInt32(textBox10.Text);
ad.insertStudent();
ad.insertRollSection();
qc.returnRollNumber();
textBox3.Text = aq.limitSeats();
textBox1.Text = qc.returnRollNumber().ToString();
}
else
{
MessageBox.Show("Registration Closed!!", "Admission Alert!!");
}
}
catch (FormatException)
{
MessageBox.Show("Enter All values!!");
}
textBox2.Clear();
textBox4.Clear();
textBox5.Clear();
textBox6.Clear();
textBox7.Clear();
textBox8.Clear();
textBox9.Clear();
textBox10.Clear();
}