//helper method to update the data grid view
private void UpdateDataGrid()
{
dataAdapter = new SqlDataAdapter();
dataTable = new DataTable();
bindingSource = new BindingSource();
//call dal layer for records to update dgv
DatagridDALProcessing dgvRecordCall = new DatagridDALProcessing();
SqlCommand cmd = dgvRecordCall.GetDataDGBaseRecords();
dataAdapter.SelectCommand = cmd;
dataAdapter.Fill(dataTable);
bindingSource.DataSource = dataTable;
dgvViewStudentList.DataSource = bindingSource;
}
/*
* Button (Delete) - Code behind for deleting a student of the Linking Table StudentCourseLT
*/
private void btnDeleteStudent_Click(object sender, EventArgs e)
{
try
{
int delRecordid = (int)dgvViewStudentList.SelectedRows[0].Cells[0].Value;
//call DAL processing class for the DB Delete
DatagridDALProcessing delStudent = new DatagridDALProcessing();
SqlCommand cmd = delStudent.DeleteEnrolledStudent(delRecordid);
UpdateDataGrid();
}
catch (ArgumentOutOfRangeException ae)
{
MessageBox.Show("Please select a line to delete by clicking on it - No records to Delete until line is Selected", "System Notice", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (FormatException fe)
{
MessageBox.Show("Something went wrong with the selection - Make Sure You Click on Record before clicking OK", "System Notice", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/*
* Load event from the dgv - student details for editing through vars to event
* are taken by dgv student number, queried to DB and returned record passed to form
*/
private void EditStudent_Load(object sender, EventArgs e)
{
int studentID = SearchStudentID;
dataAdapter = new SqlDataAdapter();
dataTable = new DataTable();
DatagridDALProcessing editRecord = new DatagridDALProcessing();
SqlCommand cmd = editRecord.RetreiveStudentRecord(SearchStudentID);
dataAdapter.SelectCommand = cmd;
dataAdapter.Fill(dataTable);
int studentNumber = int.Parse(dataTable.Rows[0][0].ToString());
string firstName = dataTable.Rows[0][1].ToString();
string lastName = dataTable.Rows[0][2].ToString();
string email = dataTable.Rows[0][3].ToString();
string phone = dataTable.Rows[0][4].ToString();
string addressLine1 = dataTable.Rows[0][5].ToString();
string addressLine2 = dataTable.Rows[0][6].ToString();
string city = dataTable.Rows[0][7].ToString();
string county = dataTable.Rows[0][8].ToString();
string level = dataTable.Rows[0][9].ToString();
ucUpdateRecordControl1.DisplayEditRecord.StudentNumber = studentID;
ucUpdateRecordControl1.DisplayEditRecord.FirstName = firstName;
ucUpdateRecordControl1.DisplayEditRecord.Surname = lastName;
ucUpdateRecordControl1.DisplayEditRecord.Email = email;
ucUpdateRecordControl1.DisplayEditRecord.Phone = phone;
ucUpdateRecordControl1.DisplayEditRecord.AddressLine1 = addressLine1;
ucUpdateRecordControl1.DisplayEditRecord.AddressLine2 = addressLine2;
ucUpdateRecordControl1.DisplayEditRecord.City = city;
ucUpdateRecordControl1.DisplayEditRecord.County = county;
ucUpdateRecordControl1.DisplayEditRecord.Level = level;
//call LoadEditForm helper method
LoadEditForm(studentID, firstName, lastName, addressLine1, addressLine2, email, phone, city, county, level);
}
