private void LoadStudentCourseGrid() { DataTable studentCourseResults = null; switch (m_dbLayer) { case "linq": studentCourseResults = LinqLayer.GetAllStudentCourses(); break; case "lightweight": studentCourseResults = StudentDAL.SearchStudent(); break; default: break; } grdStudentCourse.DataSource = null; grdStudentCourse.DataSource = studentCourseResults; grdStudentCourse.Columns["Student Name"].Width = 200; grdStudentCourse.Columns["Course (Level)"].Width = 200; grdStudentCourse.Columns["StudentCourseId"].Visible = false; grdStudentCourse.Columns["StudentId"].Visible = false; grdStudentCourse.Columns["CourseId"].Visible = false; grdStudentCourse.Columns["isDeleted"].Visible = false; }
private void grdStudent_RowsRemoved(object sender, DataGridViewRowsRemovedEventArgs e) { if (m_editWithGridView) { if (m_grdStudent_SelectedRowId >= 0) { LinqLayer.DeleteStudent(m_grdStudent_SelectedRowId); m_grdStudent_SelectedRowId = -1; } } }
private void grdStudent_RowEnter(object sender, DataGridViewCellEventArgs e) { if (m_editWithGridView) { if (m_NewRowIndex < grdStudent.NewRowIndex) { LinqLayer.AddStudent(grdStudent["First Name", m_NewRowIndex].Value.ToString(), grdStudent["Last Name", m_NewRowIndex].Value.ToString()); m_NewRowIndex = grdStudent.NewRowIndex; } } }
private void btnStudentCourseDelete_Click(object sender, EventArgs e) { if (grdStudentCourse.SelectedRows.Count > 0) { LinqLayer.DeleteStudentCourse(Convert.ToInt32(grdStudentCourse.Rows[grdStudentCourse.SelectedRows[0].Index].Cells["StudentCourseId"].Value)); LoadStudentCourseGrid(); } else { MessageBox.Show("You must select a student course record to delete.", "Delete Student Course Record", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void grdStudent_RowLeave(object sender, DataGridViewCellEventArgs e) { if (m_editWithGridView) { if (grdStudent.RowCount > 0) { if (grdStudent.CurrentRow != null) { LinqLayer.UpdateStudentName(Convert.ToInt32(grdStudent.Rows[grdStudent.CurrentRow.Index].Cells["Id"].Value), grdStudent.Rows[grdStudent.CurrentRow.Index].Cells["First Name"].Value.ToString(), grdStudent.Rows[grdStudent.CurrentRow.Index].Cells["Last Name"].Value.ToString()); } } } }
private void LoadStudentGrid() { DataTable studentResults = null; switch (m_dbLayer) { case "linq": studentResults = LinqLayer.GetAllStudents(); break; case "lightweight": studentResults = StudentDAL.SearchStudent(); break; default: break; } grdStudent.DataSource = null; grdStudent.DataSource = studentResults; grdStudent.Columns["Id"].Visible = false; grdStudent.Columns["isDeleted"].Visible = false; }
private void btnOK_Click(object sender, EventArgs e) { if (txtFirstName.Text.Trim() == "") { MessageBox.Show("You must enter a first name.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (txtLastName.Text.Trim() == "") { MessageBox.Show("You must enter a last name.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (m_AddEdit == StudentOperation.Add) { LinqLayer.AddStudent(txtFirstName.Text, txtLastName.Text); } else { LinqLayer.UpdateStudentName(m_Id, txtFirstName.Text, txtLastName.Text); } this.Close(); }
private void btnOK_Click(object sender, EventArgs e) { if (cboStudentName.Text.Trim() == "-- Select Student Name --") { MessageBox.Show("You must select a student name.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (cboCourse.Text.Trim() == "-- Select Course Name --") { MessageBox.Show("You must select a course.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (m_AddEdit == StudentCourseOperation.Add) { LinqLayer.AddStudentCourse(Convert.ToInt32(cboStudentName.SelectedValue), Convert.ToInt32(cboCourse.SelectedValue), Convert.ToInt32(txtMark.Text)); } else { LinqLayer.UpdateStudentCourse(m_StudentCourseId, Convert.ToInt32(cboStudentName.SelectedValue), Convert.ToInt32(cboCourse.SelectedValue), Convert.ToInt32(txtMark.Text)); } this.Close(); }