private void label3_Click(object sender, EventArgs e)
{
StudenHome Peron = new StudenHome();
this.Hide();
Peron.Show();
}
private void cmdInfo_Click(object sender, EventArgs e)
{
try
{
String str = "Data Source=HAIER-PC\\NIMRASQLSERVER;Initial Catalog=ProjectA;Integrated Security=True";
String query = "INSERT INTO Student (Id,RegistrationNo)VALUES((select MAX(Id) FROM Person),('" + (txtRegno.Text).ToString() + "'));";
SqlConnection con = new SqlConnection(str);
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("Data insert");
StudenHome Info = new StudenHome();
this.Hide();
Info.Show();
con.Close();
}
catch (Exception es)
{
MessageBox.Show(es.Message);
}
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
try
{
//label1.Show();
//label2.Show();
//label3.Show();
//textBox1.Show();
//textBox2.Show();
//comboBox1.Show();
String str = "Data Source=HAIER-PC\\NIMRASQLSERVER;Initial Catalog=ProjectA;Integrated Security=True";
SqlConnection con = new SqlConnection(str);
con.Open();
if (e.RowIndex >= 0 && e.ColumnIndex == 9)
{
DataGridViewRow row = this.dataGridView1.Rows[e.RowIndex];
String query = "Delete from Student where Id = '" + row.Cells[0].Value + "';";
String query1 = "Delete from Person where Id = '" + row.Cells[0].Value + "';";
String query2 = "Delete from GroupStudent where StudentId = '" + row.Cells[0].Value + "';";
SqlCommand cmd = new SqlCommand(query2, con);
cmd.ExecuteNonQuery();
SqlCommand cmd1 = new SqlCommand(query, con);
cmd1.ExecuteNonQuery();
SqlCommand cmd2 = new SqlCommand(query1, con);
cmd2.ExecuteNonQuery();
MessageBox.Show("Student is deleted");
StudenHome ne = new StudenHome();
this.Hide();
ne.Show();
}
if (e.RowIndex >= 0 && e.ColumnIndex == 8)
{
//Editstudent edit = new Editstudent();
panel1.Show();
textBox5.Text = this.dataGridView1.CurrentRow.Cells[0].Value.ToString();
textBox1.Text = this.dataGridView1.CurrentRow.Cells[2].Value.ToString();
textBox2.Text = this.dataGridView1.CurrentRow.Cells[3].Value.ToString();
textBox3.Text = this.dataGridView1.CurrentRow.Cells[4].Value.ToString();
textBox4.Text = this.dataGridView1.CurrentRow.Cells[6].Value.ToString();
dateTimePicker1.Text = this.dataGridView1.CurrentRow.Cells[5].Value.ToString();
comboBox1.Text = this.dataGridView1.CurrentRow.Cells[7].Value.ToString();
//edit.Show();
}
}
catch (Exception es)
{
MessageBox.Show(es.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
int key = Convert.ToInt32(textBox5.Text);
String str = "Data Source=HAIER-PC\\NIMRASQLSERVER;Initial Catalog=ProjectA;Integrated Security=True";
String query = "Update Person Set FirstName=('" + textBox1.Text.ToString() + "'),LastName=('" + textBox2.Text.ToString() + "'),Contact=('" + textBox3.Text.ToString() + "'),Email=('" + textBox4.Text.ToString() + "'),DateOfBirth=('" + Convert.ToDateTime(dateTimePicker1.Text) + "'),Gender=(select Id from Lookup where Lookup.Value ='" + comboBox1.Text + "') where Id = '" + Convert.ToInt32(textBox5.Text) + "';";
SqlConnection con = new SqlConnection(str);
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("Data Updated");
con.Close();
panel1.Hide();
StudenHome ne = new StudenHome();
this.Hide();
ne.Show();
}
catch (Exception es)
{
MessageBox.Show(es.Message);
}
}