private void dgv_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0 && dgv.Rows[e.RowIndex].Cells[e.ColumnIndex] is DataGridViewButtonCell) { if (dgv.Columns[e.ColumnIndex].DefaultCellStyle.NullValue.ToString() == "Modify") { if (dgv.Columns[e.ColumnIndex].DefaultCellStyle.NullValue.ToString() == "Modify") { using (ChoosingInfoModify cim = new ChoosingInfoModify() { connection = connection, year = dgv.Rows[e.RowIndex].Cells["chosen_year"].Value.ToString(), score = dgv.Rows[e.RowIndex].Cells["score"].Value.ToString(), student = string.Format("{0}({1})", dgv.Rows[e.RowIndex].Cells["student_id"].Value, dgv.Rows[e.RowIndex].Cells["name"].Value), teacher = string.Format("{0}({1})", current_teacher_id, current_teacher_name), course = string.Format("{0}({1})", dgv.Rows[e.RowIndex].Cells["course_id"].Value, dgv.Rows[e.RowIndex].Cells["name1"].Value), credit = dgv.Rows[e.RowIndex].Cells["credit"].Value.ToString(), role = Common.UserType.TEACHER }) { cim.ShowDialog(); ClearDGV(); RefreshYearData(); RefreshDGV(); } } } } }
private void dgv_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0 && dgv.Rows[e.RowIndex].Cells[e.ColumnIndex] is DataGridViewButtonCell) { if (dgv.Columns[e.ColumnIndex].DefaultCellStyle.NullValue.ToString() == "Modify") { using (ChoosingInfoModify cim = new ChoosingInfoModify() { connection = connection, year = dgv.Rows[e.RowIndex].Cells["Chosen Year"].Value.ToString(), score = dgv.Rows[e.RowIndex].Cells["Score"].Value.ToString(), student = string.Format("{0}({1})", dgv.Rows[e.RowIndex].Cells["Student ID"].Value, dgv.Rows[e.RowIndex].Cells["Student Name"].Value), teacher = string.Format("{0}({1})", dgv.Rows[e.RowIndex].Cells["Teacher ID"].Value, dgv.Rows[e.RowIndex].Cells["Teacher Name"].Value), course = string.Format("{0}({1})", dgv.Rows[e.RowIndex].Cells["Course ID"].Value, dgv.Rows[e.RowIndex].Cells["Course Name"].Value), credit = dgv.Rows[e.RowIndex].Cells["Credit"].Value.ToString(), role = Common.UserType.ADMIN }) { cim.ShowDialog(); choosing_clear_button.PerformClick(); choosing_query_button.PerformClick(); } } else if (dgv.Columns[e.ColumnIndex].DefaultCellStyle.NullValue.ToString() == "Delete") { if (Common.ShowChoice("Delete Confirm", string.Format("Are you sure to delete the record ({0},{1},{2},{3})", dgv.Rows[e.RowIndex].Cells["Student Name"].Value, dgv.Rows[e.RowIndex].Cells["Course Name"].Value, dgv.Rows[e.RowIndex].Cells["Teacher Name"].Value, dgv.Rows[e.RowIndex].Cells["Chosen Year"].Value) + "?", MessageBoxIcon.Warning) == DialogResult.Yes) { int delete_result = SQL_Help.ExecuteNonQuery("delete from course_choosing_info where (course_id=@course_id and teacher_id=@teacher_id and student_id=@student_id and chosen_year=@year);", connection, new MySqlParameter[] { new MySqlParameter("@course_id", MySqlDbType.VarChar) { Value = dgv.Rows[e.RowIndex].Cells["Course ID"].Value }, new MySqlParameter("@teacher_id", MySqlDbType.VarChar) { Value = dgv.Rows[e.RowIndex].Cells["Teacher ID"].Value }, new MySqlParameter("@student_id", MySqlDbType.VarChar) { Value = dgv.Rows[e.RowIndex].Cells["Student ID"].Value }, new MySqlParameter("@year", MySqlDbType.Int32) { Value = dgv.Rows[e.RowIndex].Cells["Chosen Year"].Value }, }); if (delete_result > 0) { Common.ShowInfo("Done", "Delete successfully!"); choosing_clear_button.PerformClick(); choosing_query_button.PerformClick(); } } } } }