private void ClassForm_FormClosing(object sender, FormClosingEventArgs e)
{
dgvClass[0, 0].Selected = true;
// ----------------------------------------------------------------------------------------------
//
var db = new LINQDataContext();
//
// Delete Group_ID_List Where Class_ID == this.ID
//
db.Group_ID_ListDeleteAll();
db.Priority_ProfessorDelete();
for (int rowCounter = 0; rowCounter < dgvClass.RowCount - 1; rowCounter++)
{
try
{
//
// search dgvClass.rows in db.Class
//
int id_class = int.Parse(dgvClass[0, rowCounter].Value.ToString());
var query = (from QC in db.Classes
where QC.Class_ID == id_class
select QC).SingleOrDefault();
if (dgvClass[2, rowCounter].Value.ToString() == "")
{
new LINQDataContext().ClassDelete(int.Parse(dgvClass[0, rowCounter].Value.ToString()));
throw new Exception("Null Professor Value's");
}
if (query != null) // edit (UPDATE)
{
int PU = 0;
int TU = 0;
decimal code = 0;
db.ClassEdit(id_class, (dgvClass[3, rowCounter].Value != null) ?
(from courseID in db.Courses
where (courseID.Name_Course == dgvClass[3, rowCounter].Value.ToString()) &&
(courseID.CourseCode == ((decimal.TryParse(dgvClass[4, rowCounter].Value.ToString(), out code)) ? code : 0))
select courseID.Course_ID).Single() : 0,
(int.TryParse(dgvClass[5, rowCounter].Value.ToString(), out PU)) ? PU : 0,
(int.TryParse(dgvClass[6, rowCounter].Value.ToString(), out TU)) ? TU : 0,
dgvClass[7, rowCounter].Value.ToString());
}
else //save (INSERT or Create NEW)
{
int PU = 0;
int TU = 0;
decimal code = 0;
db.ClassSave(id_class, (dgvClass[3, rowCounter].Value != null) ?
(from courseID in db.Courses
where (courseID.Name_Course == dgvClass[3, rowCounter].Value.ToString()) &&
(courseID.CourseCode == ((decimal.TryParse(dgvClass[4, rowCounter].Value.ToString(), out code)) ? code : 0))
select courseID.Course_ID).Single() : 0,
(int.TryParse(dgvClass[5, rowCounter].Value.ToString(), out PU)) ? PU : 0,
(int.TryParse(dgvClass[6, rowCounter].Value.ToString(), out TU)) ? TU : 0,
dgvClass[7, rowCounter].Value.ToString());
}
//
// Group in db.Group_ID_List
//
saveAndCompile_Groups((dgvClass[9, rowCounter].Value != null) ?
dgvClass[9, rowCounter].Value.ToString() : " ",
Convert.ToInt32(dgvClass[0, rowCounter].Value.ToString()));
//
// Priority in db.Priority_Professors
//
saveAndCompile_Priority((dgvClass[2, rowCounter].Value != null) ?
dgvClass[2, rowCounter].Value.ToString() : " ",
Convert.ToInt32(dgvClass[0, rowCounter].Value.ToString()));
}
catch { }
}
}
private void ClassForm_FormClosing(object sender, FormClosingEventArgs e)
{
dgvClass[0, 0].Selected = true;
// ----------------------------------------------------------------------------------------------
//
var db = new LINQDataContext();
//
// Delete Group_ID_List Where Class_ID == this.ID
//
db.Group_ID_ListDeleteAll();
db.Priority_ProfessorDelete();
for (int rowCounter = 0; rowCounter < dgvClass.RowCount - 1; rowCounter++)
{
try
{
//
// search dgvClass.rows in db.Class
//
int id_class = int.Parse(dgvClass[0, rowCounter].Value.ToString());
var query = (from QC in db.Classes
where QC.Class_ID == id_class
select QC).SingleOrDefault();
if (dgvClass[2, rowCounter].Value.ToString() == "")
{
new LINQDataContext().ClassDelete(int.Parse(dgvClass[0, rowCounter].Value.ToString()));
throw new Exception("Null Professor Value's");
}
if (query != null) // edit (UPDATE)
{
int PU = 0;
int TU = 0;
decimal code = 0;
db.ClassEdit(id_class, (dgvClass[3, rowCounter].Value != null) ?
(from courseID in db.Courses
where (courseID.Name_Course == dgvClass[3, rowCounter].Value.ToString()) &&
(courseID.CourseCode == ((decimal.TryParse(dgvClass[4, rowCounter].Value.ToString(), out code)) ? code : 0))
select courseID.Course_ID).Single() : 0,
(int.TryParse(dgvClass[5, rowCounter].Value.ToString(), out PU)) ? PU : 0,
(int.TryParse(dgvClass[6, rowCounter].Value.ToString(), out TU)) ? TU : 0,
dgvClass[7, rowCounter].Value.ToString());
}
else //save (INSERT or Create NEW)
{
int PU = 0;
int TU = 0;
decimal code = 0;
db.ClassSave(id_class, (dgvClass[3, rowCounter].Value != null) ?
(from courseID in db.Courses
where (courseID.Name_Course == dgvClass[3, rowCounter].Value.ToString()) &&
(courseID.CourseCode == ((decimal.TryParse(dgvClass[4, rowCounter].Value.ToString(), out code)) ? code : 0))
select courseID.Course_ID).Single() : 0,
(int.TryParse(dgvClass[5, rowCounter].Value.ToString(), out PU)) ? PU : 0,
(int.TryParse(dgvClass[6, rowCounter].Value.ToString(), out TU)) ? TU : 0,
dgvClass[7, rowCounter].Value.ToString());
}
//
// Group in db.Group_ID_List
//
saveAndCompile_Groups((dgvClass[9, rowCounter].Value != null) ?
dgvClass[9, rowCounter].Value.ToString() : " ",
Convert.ToInt32(dgvClass[0, rowCounter].Value.ToString()));
//
// Priority in db.Priority_Professors
//
saveAndCompile_Priority((dgvClass[2, rowCounter].Value != null) ?
dgvClass[2, rowCounter].Value.ToString() : " ",
Convert.ToInt32(dgvClass[0, rowCounter].Value.ToString()));
}
catch { }
}
}