private void btnOpenMark_Click(object sender, RoutedEventArgs e) { MarkView markView = new MarkView(); //this.Close(); markView.ShowDialog(); }
private void btnAddMark_Click(object sender, RoutedEventArgs e) { //mark = (Mark)dataGridMark.SelectedItem; Mark objMark = new Mark(); if (txtStudentName.Text != "" && txtStudentSurname.Text != "" && txtMarkEvaluation.Text != "" && txtSubjectName.Text != "") { // find StudentID from StudentName and StudentSurname string query1 = string.Format("select StudentID from tblStudent where StudentName='{0}' and SurName='{1}';", txtStudentName.Text, txtStudentSurname.Text); try { sqlConn.Open(); SqlCommand sqlComm = new SqlCommand(query1, sqlConn); SqlDataReader sqlDR = sqlComm.ExecuteReader(); if (sqlDR.Read()) { objMark.StudentID = Convert.ToInt32(sqlDR["StudentID"]); } else { MessageBox.Show("This Student not exist! Please repeat operation!"); } sqlDR.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlConn.Close(); } // Find SubjectID from Subject Name string query2 = string.Format("select SubjectID from tblSubject where SubjectName='{0}';", txtSubjectName.Text); try { sqlConn.Open(); SqlCommand sqlComm = new SqlCommand(query2, sqlConn); SqlDataReader sqlDR = sqlComm.ExecuteReader(); if (sqlDR.Read()) { objMark.SubjectID = Convert.ToInt32(sqlDR["SubjectID"]); } else { MessageBox.Show("This Subject not exist! Please repeat operation!"); } sqlDR.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlConn.Close(); } // insert into tblMark values Mark, StudentID and SubjectID string query3 = string.Format("insert into tblMark values ({0},{1},{2})", txtMarkEvaluation.Text, objMark.StudentID, objMark.SubjectID); try { sqlConn.Open(); SqlCommand comm = new SqlCommand(query3, sqlConn); comm.ExecuteNonQuery(); MessageBox.Show("Mark evaluation for Student succesfully added!"); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } finally { sqlConn.Close(); MarkView markView = new MarkView(); this.Close(); markView.ShowDialog(); } } else { MessageBox.Show("Please enter Mark evaluation, StudentName, StudentSurname and SubjectName before add data to database!"); } }