private void dgvProfessor_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> query = from priority in db.Priority_Professors
where priority.Professor_ID == id
select priority.Class_ID;
//
// if exist data in table ?
//
if (query.ToArray().Length > 0)
{
string class_ID_List = "";
foreach (var anyClass in query)
{
class_ID_List += anyClass.ToString() + " and ";
}
class_ID_List = class_ID_List.Substring(0, class_ID_List.Length - 4);
e.Cancel = true;
MessageBox.Show("Information classes with class numbers " +
class_ID_List + "is related to Professor " +
((e.Row.Cells[1].Value != null) ? e.Row.Cells[1].Value.ToString() : "NULL") +
".\n First, this information can change classes.", "Delete Row Error",
MessageBoxButtons.OK, MessageBoxIcon.Stop, MessageBoxDefaultButton.Button1);
}
else
{
db.ClassroomDeleteProf(id);
db.ProfessorDelete(id);
}
db.Dispose();
}
}
private void dgvProfessor_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> query = from priority in db.Priority_Professors
where priority.Professor_ID == id
select priority.Class_ID;
//
// if exist data in table ?
//
if (query.ToArray().Length > 0)
{
string class_ID_List = "";
foreach (var anyClass in query)
{
class_ID_List += anyClass.ToString() + " and ";
}
class_ID_List = class_ID_List.Substring(0, class_ID_List.Length - 4);
e.Cancel = true;
MessageBox.Show("Information classes with class numbers " +
class_ID_List + "is related to Professor " +
((e.Row.Cells[1].Value != null) ? e.Row.Cells[1].Value.ToString() : "NULL") +
".\n First, this information can change classes.", "Delete Row Error",
MessageBoxButtons.OK, MessageBoxIcon.Stop, MessageBoxDefaultButton.Button1);
}
else
{
db.ClassroomDeleteProf(id);
db.ProfessorDelete(id);
}
db.Dispose();
}
}
