/* Actions */ public string InsertEvaluateStudent(EvaluateStudent evaluateStudent) { string retorno = ""; int validation = 0; context = new Context(); connection = new SqlConnection(context.StringConnection()); connection.Open(); SqlTransaction insertValidation = connection.BeginTransaction(); cmd = connection.CreateCommand(); cmd.Transaction = insertValidation; cmd.CommandType = CommandType.StoredProcedure; try { cmd.Parameters.Clear(); cmd.CommandText = "UspCrudEvaluateStudent"; context.CleanParameter(); context.AddParameter("@idClassroom", evaluateStudent.idClassroom); context.AddParameter("@idStudent", evaluateStudent.idStudent); context.AddParameter("@evaluationDate", evaluateStudent.evaluationDate); context.AddParameter("@idLoginAccess", evaluateStudent.idLoginAccess); context.AddParameter("@Action", 1); foreach (SqlParameter itemParametros in context.parameterCollection) { cmd.Parameters.Add(new SqlParameter(itemParametros.ParameterName, itemParametros.Value)); } retorno = ""; retorno = cmd.ExecuteScalar().ToString(); int idEvaluateStudent = Convert.ToInt32(retorno); foreach (var item in evaluateStudent.listEvaluateStudentGrade) { cmd.Parameters.Clear(); cmd.CommandText = "UspCrudEvaluateStudentGrade"; context.CleanParameter(); context.AddParameter("@idEvaluateStudent", idEvaluateStudent); context.AddParameter("@idTeachingPlan", item.idTeachingPlan); context.AddParameter("@grade", item.grade); context.AddParameter("@Action", 1); foreach (SqlParameter itemParametros in context.parameterCollection) { cmd.Parameters.Add(new SqlParameter(itemParametros.ParameterName, itemParametros.Value)); } retorno = ""; retorno = cmd.ExecuteScalar().ToString(); validation = Convert.ToInt32(retorno); } insertValidation.Commit(); return(retorno); } catch (Exception ex) { if (retorno == "") { retorno = ex.Message; } insertValidation.Rollback(); return(retorno); } finally { if (connection.State == ConnectionState.Open) { cmd.Dispose(); connection.Close(); } } }
List<Student> FindStudents(EvaluateStudent comp) { List<Student> students = new List<Student>(); foreach (var tt in this.studentList.List) { Student t = tt as Student; if (comp(t)) students.Add(t); } return students; }