/* 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;
}
