private void txtFind_TextChanged(object sender, EventArgs e) { // filter datagrid try { gridLecturers.DataSource = null; gridLecturers.DataSource = LecturerDataAccess.filterLecturers(txtFind.Text) .Select(x => new { LecturerID = x.LecturerId, Surname = x.SurName, Firstname = x.FirstName, Lastname = x.LastName, Nic = x.Nic, Mobile = x.Mobile, Email = x.Email, Address = x.Address, isRemoved = x.IsRemoved }).ToList(); gridLecturers.Columns["LecturerID"].HeaderText = "Lecturer ID"; gridLecturers.Columns["Surname"].HeaderText = "Surname"; gridLecturers.Columns["Firstname"].HeaderText = "First Name"; gridLecturers.Columns["Lastname"].HeaderText = "Last Name"; gridLecturers.Columns["Nic"].HeaderText = "NIC #"; gridLecturers.Columns["Mobile"].HeaderText = "Mobile #"; gridLecturers.Columns["Email"].HeaderText = "E-mail"; gridLecturers.Columns["Address"].HeaderText = "Address"; gridLecturers.Columns["isRemoved"].HeaderText = "Inactive";; } catch (Exception ex) { MessageBox.Show("Failed : " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void gridRefresh() { // refresh grid try { gridLecturers.DataSource = null; gridLecturers.DataSource = LecturerDataAccess.getLecturers() .Select(x => new { LecturerID = x.LecturerId, Surname = x.SurName, Firstname = x.FirstName, Lastname = x.LastName, Nic = x.Nic, Mobile = x.Mobile, Email = x.Email, Address = x.Address, isRemoved = x.IsRemoved }).ToList(); gridLecturers.Columns["LecturerID"].HeaderText = "Lecturer ID"; gridLecturers.Columns["Surname"].HeaderText = "Surname"; gridLecturers.Columns["Firstname"].HeaderText = "First Name"; gridLecturers.Columns["Lastname"].HeaderText = "Last Name"; gridLecturers.Columns["Nic"].HeaderText = "NIC #"; gridLecturers.Columns["Mobile"].HeaderText = "Mobile #"; gridLecturers.Columns["Email"].HeaderText = "E-mail"; gridLecturers.Columns["Address"].HeaderText = "Address"; gridLecturers.Columns["isRemoved"].HeaderText = "Inactive"; } catch (Exception ex) { MessageBox.Show("Failed : " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnDelete_Click(object sender, EventArgs e) { // edit lecturer data if (MessageBox.Show("Do you want to delete this record ?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { var lecturer = new Lecturer(); lecturer.LecturerId = LecturerId; lecturer.IsRemoved = true; LecturerDataAccess.deleteLecturer(lecturer); MessageBox.Show("Record has been deleted successfully", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); gridRefresh(); // call grid refresh method clearField(); // call clear field method } catch (Exception ex) { MessageBox.Show("Failed : " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { return; } }
private void btnEdit_Click(object sender, EventArgs e) { // edit lecturer data if (MessageBox.Show("Do you want to edit this record ?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { var lecturer = new Lecturer(); lecturer.LecturerId = LecturerId; lecturer.SurName = txtSurName.Text; lecturer.FirstName = txtFirstName.Text; lecturer.LastName = txtLastName.Text; lecturer.Nic = txtNic.Text; lecturer.Address = txtAddress.Text; lecturer.Mobile = txtMobile.Text; lecturer.Email = txtEmail.Text; LecturerDataAccess.editLecturer(lecturer); MessageBox.Show("Record has been updated successfully", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); gridRefresh(); // call grid refresh method clearField(); // call clear field method } catch (Exception ex) { MessageBox.Show("Failed : " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { return; } }
private void txtLecturerId_KeyDown(object sender, KeyEventArgs e) { try { if (e.KeyCode == Keys.Enter) { var lecturer = new Lecturer(); lecturer.LecturerId = txtLecturerId.Text; var record = LecturerDataAccess.findLecturerById(lecturer); if (record == null) { MessageBox.Show("Unable to locate lecturer. Please check lecturer-ID", "Message", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { txtLecturerName.Text = record.FirstName + " " + record.LastName; } } } catch (Exception ex) { MessageBox.Show("Failed : " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnAdd_Click(object sender, EventArgs e) { // add new lecturer try { var lecturer = new Lecturer(); lecturer.SurName = txtSurName.Text; lecturer.FirstName = txtFirstName.Text; lecturer.LastName = txtLastName.Text; lecturer.Nic = txtNic.Text; lecturer.Mobile = txtMobile.Text; lecturer.Email = txtEmail.Text; lecturer.Address = txtAddress.Text; var miliseconds = DateTime.Now.Millisecond.ToString(); var first = txtFirstName.Text.Trim().Substring(0, 3); var lecId = miliseconds + first; lecturer.LecturerId = lecId; // lecturer id var result = LecturerDataAccess.addLecturer(lecturer); if (result = true) { MessageBox.Show("Lecturer has been added successfully", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); gridRefresh(); // call grid refresh method clearField(); // call clear field method // assign courses if (MessageBox.Show("Do you want to assign courses for lecturer ?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { var fullname = lecturer.FirstName + " " + lecturer.LastName; var assign = new frm_assignCourses(lecId, fullname, Role); var record = assign.ShowDialog(); if (record == DialogResult.OK) { assign.Show(); } else { } } else { return; } } } catch (Exception ex) { MessageBox.Show("Failed : " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void showLecturers() { // show all lecturers try { var searchValue = txtFindLecturer.Text; var source = LecturerDataAccess.getLecturers(); gridLecturer.DataSource = source .Select(x => new { LecturerId = x.LecturerId, Surname = x.SurName, Firstname = x.FirstName, Lastname = x.LastName, Nic = x.Nic, Email = x.Email, Mobile = x.Mobile, Address = x.Address, IsRemoved = x.IsRemoved }).Where(x => x.IsRemoved == false).ToList(); gridLecturer.Columns["LecturerId"].HeaderText = "Lecturer ID"; gridLecturer.Columns["Surname"].HeaderText = "Surname"; gridLecturer.Columns["Firstname"].HeaderText = "Firstname"; gridLecturer.Columns["Lastname"].HeaderText = "Lastname"; gridLecturer.Columns["Nic"].HeaderText = "NIC #"; gridLecturer.Columns["Email"].HeaderText = "E-mail"; gridLecturer.Columns["Mobile"].HeaderText = "Mobile"; gridLecturer.Columns["Address"].HeaderText = "Address"; gridLecturer.Columns["IsRemoved"].HeaderText = "Status"; gridLecturer.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; gridLecturer.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; gridLecturer.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; gridLecturer.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; gridLecturer.Columns[8].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; } catch (Exception ex) { MessageBox.Show("Failed : " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }