private void dgvBranch_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e) { int id = 0; if (int.TryParse(e.Row.Cells[0].Value.ToString(), out id)) { var db = new LINQDataContext(); // Define the query expression. IEnumerable <int> qGroupID = from groups in db.Groups where groups.Branch_Selection == id select groups.ID; // // Define the query expression. IEnumerable <int> qCourseID = from course in db.Courses where course.Branch_ID == id select course.Course_ID; // // if exist data in the Groups table : // if (qGroupID.ToArray().Length > 0) { string groups_ID_List = ""; foreach (var anyGroup in qGroupID) { groups_ID_List += anyGroup.ToString() + " and "; } groups_ID_List = groups_ID_List.Substring(0, groups_ID_List.Length - 4); e.Cancel = true; MessageBox.Show("Information Groups with group numbers " + groups_ID_List + "is related to Branch (" + ((e.Row.Cells[1].Value != null) ? e.Row.Cells[1].Value.ToString() : "NULL") + ").\n First, this information can change groups.", "Delete Row Error", MessageBoxButtons.OK, MessageBoxIcon.Stop, MessageBoxDefaultButton.Button1); } // // if exist data in the Groups table : // else if (qCourseID.ToArray().Length > 0) { string course_ID_List = ""; foreach (var anyCourse in qCourseID) { course_ID_List += anyCourse.ToString() + " and "; } course_ID_List = course_ID_List.Substring(0, course_ID_List.Length - 4); e.Cancel = true; MessageBox.Show("Information courses with course numbers " + course_ID_List + "is related to Branch (" + ((e.Row.Cells[1].Value != null) ? e.Row.Cells[1].Value.ToString() : "NULL") + ").\n First, this information can change courses.", "Delete Row Error", MessageBoxButtons.OK, MessageBoxIcon.Stop, MessageBoxDefaultButton.Button1); } else { db.BranchDelete(id); } db.Dispose(); } }
private void dgvBranch_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e) { int id = 0; if (int.TryParse(e.Row.Cells[0].Value.ToString(), out id)) { var db = new LINQDataContext(); // Define the query expression. IEnumerable<int> qGroupID = from groups in db.Groups where groups.Branch_Selection == id select groups.ID; // // Define the query expression. IEnumerable<int> qCourseID = from course in db.Courses where course.Branch_ID == id select course.Course_ID; // // if exist data in the Groups table : // if (qGroupID.ToArray().Length > 0) { string groups_ID_List = ""; foreach (var anyGroup in qGroupID) { groups_ID_List += anyGroup.ToString() + " and "; } groups_ID_List = groups_ID_List.Substring(0, groups_ID_List.Length - 4); e.Cancel = true; MessageBox.Show("Information Groups with group numbers " + groups_ID_List + "is related to Branch (" + ((e.Row.Cells[1].Value != null) ? e.Row.Cells[1].Value.ToString() : "NULL") + ").\n First, this information can change groups.", "Delete Row Error", MessageBoxButtons.OK, MessageBoxIcon.Stop, MessageBoxDefaultButton.Button1); } // // if exist data in the Groups table : // else if (qCourseID.ToArray().Length > 0) { string course_ID_List = ""; foreach (var anyCourse in qCourseID) { course_ID_List += anyCourse.ToString() + " and "; } course_ID_List = course_ID_List.Substring(0, course_ID_List.Length - 4); e.Cancel = true; MessageBox.Show("Information courses with course numbers " + course_ID_List + "is related to Branch (" + ((e.Row.Cells[1].Value != null) ? e.Row.Cells[1].Value.ToString() : "NULL") + ").\n First, this information can change courses.", "Delete Row Error", MessageBoxButtons.OK, MessageBoxIcon.Stop, MessageBoxDefaultButton.Button1); } else { db.BranchDelete(id); } db.Dispose(); } }