private void btnOpenStudent_Click(object sender, RoutedEventArgs e)
{
StudentView studentView = new StudentView();
//this.Close();
studentView.ShowDialog();
}
private void btnUpdate_Click(object sender, RoutedEventArgs e)
{
student = (Student)dataGridStudent.SelectedItem;
try
{
sqlConn.Open();
string query = string.Format("update tblStudent set StudentName='{0}', SurName='{1}' where StudentID='{2}';", txtName.Text, txtSurname.Text, student.StudentID);
SqlCommand comm = new SqlCommand(query, sqlConn);
if (student.StudentID != 0)
{
comm.ExecuteNonQuery();
MessageBox.Show("Student succesfully updated!");
}
else
{
MessageBox.Show("Please select Student for updating!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
finally
{
sqlConn.Close();
StudentView studentView = new StudentView();
this.Close();
studentView.ShowDialog();
}
}
private void btnAdd_Click(object sender, RoutedEventArgs e)
{
if (txtName.Text != "" && txtSurname.Text != "")
{
string query1 = string.Format("select * from tblStudent where StudentName='{0}' and SurName='{1}';", txtName.Text, txtSurname.Text);
sqlConn.Open();
SqlCommand comm1 = new SqlCommand(query1, sqlConn);
SqlDataReader sqlReader = comm1.ExecuteReader();
if (!sqlReader.HasRows)
{
string query = string.Format("insert into tblStudent values ('{0}','{1}')", txtName.Text, txtSurname.Text);
try
{
sqlReader.Close();
SqlCommand comm = new SqlCommand(query, sqlConn);
comm.ExecuteNonQuery();
MessageBox.Show("Student succesfully added!");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
finally
{
sqlConn.Close();
StudentView studentView = new StudentView();
this.Close();
studentView.ShowDialog();
}
}
else
{
MessageBox.Show("Particular Student already exist!");
sqlReader.Close();
sqlConn.Close();
txtName.Text = "";
txtSurname.Text = "";
}
}
else
{
MessageBox.Show("Please write name and surname of Student before add to database!");
}
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
student = (Student)dataGridStudent.SelectedItem;
try
{
if (student != null)
{
sqlConn.Open();
string query = string.Format("delete from tblStudent where StudentID='{0}';", student.StudentID);
SqlCommand comm = new SqlCommand(query, sqlConn);
if (student.StudentID != 0)
{
comm.ExecuteNonQuery();
MessageBox.Show("Student deleted succesfully!");
}
else
{
MessageBox.Show("Please select Student for deleting!");
}
}
else
{
MessageBox.Show("Please select Student for delete!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
finally
{
sqlConn.Close();
StudentView studentView = new StudentView();
this.Close();
studentView.ShowDialog();
}
}