private void btnDelete_Click(object sender, EventArgs e) { if (MessageBox.Show("Do you want to delete this record ?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { var assign = new LecturerCourses(); assign.Id = Convert.ToInt32(recordId); var result = LecturerCoursesDataAccess.delete(assign); if (result == true) { MessageBox.Show("Record has been removed successfully", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); gridRefresh(); // call grid refresh method clearFileds(); // call clear field method } else { MessageBox.Show("Unable to delete record", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } catch (Exception ex) { MessageBox.Show("Failed : " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { return; } }
// assign courses to lecturers public static bool assignCourse(LecturerCourses assign) { using (var db = new NipunaDataContext()) { db.LecturerCourses.Add(assign); db.SaveChanges(); return(true); } }
// delete data public static bool delete(LecturerCourses assign) { using (var db = new NipunaDataContext()) { var record = db.LecturerCourses.SingleOrDefault(x => x.Id == assign.Id); db.LecturerCourses.Remove(record); db.SaveChanges(); return(true); } }
// edit data public static bool edit(LecturerCourses assign) { using (var db = new NipunaDataContext()) { var record = db.LecturerCourses.SingleOrDefault(x => x.Id == assign.Id); record.LecturerId = assign.LecturerId; record.LecturerName = assign.LecturerName; record.CourseId = assign.CourseId; record.CourseName = assign.CourseName; db.SaveChanges(); return(true); } }
private void btnEdit_Click(object sender, EventArgs e) { // edit lecturer course assign data if (MessageBox.Show("Do you want to update this record ?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { var assign = new LecturerCourses(); assign.Id = Convert.ToInt32(recordId); assign.LecturerId = txtLecturerId.Text; assign.LecturerName = txtLecturerName.Text; assign.CourseId = txtCourseId.Text; assign.CourseName = txtCourseName.Text; var result = LecturerCoursesDataAccess.edit(assign); if (result == true) { MessageBox.Show("Data have been updated sucessfully", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); gridRefresh(); // call grid refresh method clearFileds(); // call clear field method } else { MessageBox.Show("Unable to update data", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } catch (Exception ex) { MessageBox.Show("Failed : " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { return; } }
private void btnAdd_Click(object sender, EventArgs e) { // assign courses if (txtLecturerId.Text == "" || txtLecturerName.Text == "" || txtCourseId.Text == "" || txtCourseName.Text == "") { MessageBox.Show("Please check the fields", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { try { var assign = new LecturerCourses(); assign.LecturerId = txtLecturerId.Text; assign.LecturerName = txtLecturerName.Text; assign.CourseId = txtCourseId.Text; assign.CourseName = txtCourseName.Text; var result = LecturerCoursesDataAccess.assignCourse(assign); if (result == true) { MessageBox.Show("Lecturer has been added successfully", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); gridRefresh(); // call grid refresh method clearFileds(); // call clear field method } else { MessageBox.Show("Unable to add lecturer", "Message", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } catch (Exception ex) { MessageBox.Show("Failed : " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }