private void ProfessorForm_FormClosing(object sender, FormClosingEventArgs e) { dgvProfessor[0, 0].Selected = true; // ---------------------------------------------------------------------------------------------- // var db = new LINQDataContext(); for (int rowCounter = 0; rowCounter < dgvProfessor.RowCount - 1; rowCounter++) { // // search dgvProfessor.rows in db.Professor // int ID_No = 0; int.TryParse(dgvProfessor[0, rowCounter].Value.ToString(), out ID_No); // Define the query expression. IEnumerable <int> query = from prof in db.Professors where prof.ID == ID_No select prof.ID; if (query.ToArray().Length > 0) // EDIT { db.ProfessorEdit(ID_No, (dgvProfessor[1, rowCounter].Value != null) ? (string)dgvProfessor[1, rowCounter].Value.ToString() : "", (dgvProfessor[2, rowCounter].Value != null) ? (string)dgvProfessor[2, rowCounter].Value.ToString() : "", (dgvProfessor[3, rowCounter].Value != null && dgvProfessor[3, rowCounter].Value.ToString().ValidateEmail()) ? (string)dgvProfessor[3, rowCounter].Value.ToString() : "", (dgvProfessor[4, rowCounter].Value != null) ? (string)dgvProfessor[4, rowCounter].Value.ToString() : "", (dgvProfessor[6, rowCounter].Value != null) ? (string)dgvProfessor[6, rowCounter].Value.ToString() : ""); } else // SAVE NEW { db.ProfessorSave(ID_No, (dgvProfessor[1, rowCounter].Value != null) ? (string)dgvProfessor[1, rowCounter].Value.ToString() : "", (dgvProfessor[2, rowCounter].Value != null) ? (string)dgvProfessor[2, rowCounter].Value.ToString() : "", (dgvProfessor[3, rowCounter].Value != null && dgvProfessor[3, rowCounter].Value.ToString().ValidateEmail()) ? (string)dgvProfessor[3, rowCounter].Value.ToString() : "", (dgvProfessor[4, rowCounter].Value != null) ? (string)dgvProfessor[4, rowCounter].Value.ToString() : "", (dgvProfessor[6, rowCounter].Value != null) ? (string)dgvProfessor[6, rowCounter].Value.ToString() : ""); } } db.Dispose(); }
private void ProfessorForm_FormClosing(object sender, FormClosingEventArgs e) { dgvProfessor[0, 0].Selected = true; // ---------------------------------------------------------------------------------------------- // var db = new LINQDataContext(); for (int rowCounter = 0; rowCounter < dgvProfessor.RowCount - 1; rowCounter++) { // // search dgvProfessor.rows in db.Professor // int ID_No = 0; int.TryParse(dgvProfessor[0, rowCounter].Value.ToString(), out ID_No); // Define the query expression. IEnumerable<int> query = from prof in db.Professors where prof.ID == ID_No select prof.ID; if (query.ToArray().Length > 0) // EDIT { db.ProfessorEdit(ID_No, (dgvProfessor[1, rowCounter].Value != null) ? (string)dgvProfessor[1, rowCounter].Value.ToString() : "", (dgvProfessor[2, rowCounter].Value != null) ? (string)dgvProfessor[2, rowCounter].Value.ToString() : "", (dgvProfessor[3, rowCounter].Value != null && dgvProfessor[3, rowCounter].Value.ToString().ValidateEmail()) ? (string)dgvProfessor[3, rowCounter].Value.ToString() : "", (dgvProfessor[4, rowCounter].Value != null) ? (string)dgvProfessor[4, rowCounter].Value.ToString() : "", (dgvProfessor[6, rowCounter].Value != null) ? (string)dgvProfessor[6, rowCounter].Value.ToString() : ""); } else // SAVE NEW { db.ProfessorSave(ID_No, (dgvProfessor[1, rowCounter].Value != null) ? (string)dgvProfessor[1, rowCounter].Value.ToString() : "", (dgvProfessor[2, rowCounter].Value != null) ? (string)dgvProfessor[2, rowCounter].Value.ToString() : "", (dgvProfessor[3, rowCounter].Value != null && dgvProfessor[3, rowCounter].Value.ToString().ValidateEmail()) ? (string)dgvProfessor[3, rowCounter].Value.ToString() : "", (dgvProfessor[4, rowCounter].Value != null) ? (string)dgvProfessor[4, rowCounter].Value.ToString() : "", (dgvProfessor[6, rowCounter].Value != null) ? (string)dgvProfessor[6, rowCounter].Value.ToString() : ""); } } db.Dispose(); }