private void new_module_btn_Click(object sender, EventArgs e)
{
try
{
Add_Update_Module add_module_frm = new Add_Update_Module();
add_module_frm.update_btn.Visible = false;
add_module_frm.add_module_btn.Visible = true;
add_module_frm.add_update_lb.Text = "Add Module";
add_module_frm.ShowDialog();
this.module_infoTableAdapter.Fill(this.dataSet_getModule_Info.module_info);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void lecture_info_table_CellClick(object sender, DataGridViewCellEventArgs e)
{
databaseConnection.Open();
MySqlCommand cmd = new MySqlCommand("Select id from module_info where lecture_code = '" + this.module_info_table.CurrentRow.Cells[0].Value.ToString() + "'", databaseConnection);
int id = Convert.ToInt32(cmd.ExecuteScalar());
databaseConnection.Close();
if (e.ColumnIndex == 8)
{
Add_Update_Module add_module_frm = new Add_Update_Module(id);
add_module_frm.lecture_code_textbox.Text = this.module_info_table.CurrentRow.Cells[0].Value.ToString();
add_module_frm.abbr.Text = this.module_info_table.CurrentRow.Cells[1].Value.ToString();
add_module_frm.lecture_module_textbox.Text = this.module_info_table.CurrentRow.Cells[2].Value.ToString();
add_module_frm.credit_val.Value = Convert.ToInt32(this.module_info_table.CurrentRow.Cells[3].Value.ToString());
if (this.module_info_table.CurrentRow.Cells[4].Value.ToString() == "GPA")
{
add_module_frm.gpa_btn.Checked = true;
add_module_frm.ngpa_btn.Checked = false;
add_module_frm.mgpa_btn.Checked = false;
}
if (this.module_info_table.CurrentRow.Cells[4].Value.ToString() == "NGPA")
{
add_module_frm.ngpa_btn.Checked = true;
add_module_frm.gpa_btn.Checked = false;
add_module_frm.mgpa_btn.Checked = false;
}
if (this.module_info_table.CurrentRow.Cells[4].Value.ToString() == "MGPA")
{
add_module_frm.ngpa_btn.Checked = false;
add_module_frm.gpa_btn.Checked = false;
add_module_frm.mgpa_btn.Checked = true;
}
Char optionval = Convert.ToChar(module_info_table.Rows[e.RowIndex].Cells[5].Value.ToString());
if (optionval == 'C')
{
add_module_frm.compulsory_btn.Checked = true;
add_module_frm.elective_btn.Checked = false;
}
else
{
add_module_frm.elective_btn.Checked = true;
add_module_frm.compulsory_btn.Checked = false;
}
add_module_frm.select_sem_combo.SelectedItem = this.module_info_table.CurrentRow.Cells[6].Value.ToString();
add_module_frm.select_degree_programme.SelectedItem = this.module_info_table.CurrentRow.Cells[7].Value.ToString();
add_module_frm.update_btn.Visible = true;
add_module_frm.add_module_btn.Visible = false;
add_module_frm.add_update_lb.Text = "Edit Module";
add_module_frm.ShowDialog();
//Refresh Module Table
this.module_infoTableAdapter.Fill(this.dataSet_getModule_Info.module_info);
}
if (e.ColumnIndex == 9)
{
if (MessageBox.Show("Are you sure want to delete this record?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
databaseConnection.Open();
DataGridViewRow row = module_info_table.Rows[e.RowIndex];
MySqlCommand cmd1 = new MySqlCommand("Delete from module_info where lecture_code = '" + row.Cells[0].Value.ToString() + "'", databaseConnection);
cmd1.ExecuteNonQuery();
databaseConnection.Close();
//remove from datatable
moduleinfoBindingSource.RemoveCurrent();
//Refresh Module Table
this.module_infoTableAdapter.Fill(this.dataSet_getModule_Info.module_info);
}
}
}
