private int getStudentListID(int dAP)
{
// DB.TAM.StuListTableAdapter.FillByStudentIDClass(inter.IdB.StuList, Studentid, clase);
DateTime ahora = DateTime.Now;
Func <DB.StuListRow, bool> timecomparer = o =>
{
if (o.IsDateNull())
{
return(false);
}
double days = ahora.Subtract(o.Date).TotalDays; //dias periodo academico StuList
if (days < dAP)
{
return(true); // menos de 90 dias
}
return(false); // mas de 90
};
DB.StuListRow stu = inter.IdB.StuList.FirstOrDefault(timecomparer);
if (stu == null)
{
this.currentStudent = null;
this.currentExam = null;
return(0); // no le des SLID
}
else
{
return(stu.SLID); //HAY RECIENTE
}
}
/*
* public bool Working
* {
*
* set
* {
* if (!value)
* {
* // Exam.CurrentChanged += Exam_CurrentChanged;
* ExamsList.CurrentChanged += currentChanged;
* // Student.CurrentChanged += Exam_CurrentChanged;
* StudentsList.CurrentChanged += currentChanged;
* Questions.CurrentChanged += currentChanged;
* // Answers.CurrentChanged += Exam_CurrentChanged;
* // Preferences.CurrentChanged += Exam_CurrentChanged;
* LogPref.CurrentChanged += currentChanged;
* // Order.CurrentChanged += Exam_CurrentChanged;
* // Class.CurrentChanged += Exam_CurrentChanged;
* // AYear.CurrentChanged += Exam_CurrentChanged;
*
* Topics.CurrentChanged += currentChanged;
* }
* else
* {
* // Exam.CurrentChanged += Exam_CurrentChanged;
* ExamsList.CurrentChanged -= currentChanged;
* // Student.CurrentChanged += Exam_CurrentChanged;
* StudentsList.CurrentChanged -= currentChanged;
* Questions.CurrentChanged -= currentChanged;
* // Answers.CurrentChanged += Exam_CurrentChanged;
* // Preferences.CurrentChanged += Exam_CurrentChanged;
* LogPref.CurrentChanged -= currentChanged;
* // Order.CurrentChanged += Exam_CurrentChanged;
* // Class.CurrentChanged += Exam_CurrentChanged;
* // AYear.CurrentChanged += Exam_CurrentChanged;
*
* Topics.CurrentChanged -= currentChanged;
* }
* }
* }
*/
private void currentChanged(object sender, EventArgs e)
{
if (Working)
{
return;
}
try
{
// DataGridView dgv = sender as DataGridView;
BindingSource bs = sender as BindingSource;
if (bs.Current == null)
{
return;
}
DataRowView view = (bs.Current as DataRowView);
DataRow row = view.Row;
if (row == null)
{
return;
}
// byte[] auxiliar = null;
if (sender.Equals(this.Topics))
{
DB.TopicsRow r = row as DB.TopicsRow;
DB.QuestionsDataTable dt = set.Questions;
Questions.Filter = dt.TopicIDColumn.ColumnName + " = " + r.TopicID;
}
else if (sender.Equals(this.Questions))
{
DB.QuestionsRow r = row as DB.QuestionsRow;
string dt = set.Answers.QIDColumn.ColumnName;
Answers.Filter = dt + " = " + r.QID;
}
else if (sender.Equals(this.RandomQuestions))
{
DB.QuestionsRow r = row as DB.QuestionsRow;
string dt = auxiliar.Answers.QIDColumn.ColumnName;
RandomAnswers.Filter = dt + " = " + r.QID;
}
else if (sender.Equals(this.Exam))
{
string dt = auxiliar.Questions.QIDColumn.ColumnName;
DB.ExamsRow r = row as DB.ExamsRow;
// string[] aux = r.AIDString.Split(',');
RandomQuestions.Position = RandomQuestions.Find(dt, r.QID);
Questions.Position = Questions.Find(dt, r.QID);
}
else if (sender.Equals(this.StudentsList))
{
DB.StuListRow r = row as DB.StuListRow;
DB.StudentDataTable dt = set.Student;
Student.Filter = dt.EIDColumn.ColumnName + " = " + r.SLID;
// DB.TAM.ExamsTableAdapter.FillByEID(dt, r.EID);
}
else if (sender.Equals(this.ExamsList))
{
DB.ExamsListRow r = row as DB.ExamsListRow;
// DB.ExamsDataTable dt = set.Exams;
Exam.Filter = auxiliar.Exams.EIDColumn.ColumnName + " = " + r.EID;
Working = true;
auxiliar.PopulateExamQuestions(ref r);
Working = false;
Exam.MoveFirst();
}
else if (sender.Equals(this.LogPref))
{
DB.PreferencesRow r = row as DB.PreferencesRow;
DB.ExamsListDataTable dt = set.ExamsList;
ExamsList.Filter = dt.PIDColumn.ColumnName + " = " + r.PID;
DB.TAM.ExamsListTableAdapter.FillByPID(dt, r.PID);
/*
* if (!r.IsELDataNull())
* {
* // string pid = ExasmPath + r.PID.ToString() + ".xml";
* auxiliar = r.ELData;
* Tables.ReadDTBytes(ExasmPath,ref auxiliar, ref dt);
* }
* else
* {
* DB.TAM.ExamsListTableAdapter.FillByPID(dt, r.PID);
* // MakeTableBytes(ref r);
* }
*/
}
}
catch (SystemException ex)
{
}
}
public string AssignStudent(string old)
{
this.currentStudent = null;
string carne = old;
Tools.StripAnswer(ref carne);
if (carne.CompareTo(old) != 0)
{
return(carne);
}
if (string.IsNullOrEmpty(carne))
{
return(old);
}
if (string.IsNullOrWhiteSpace(carne))
{
return(old);
}
// old = valu;
inter.Status = Resources.BuscandoEstudiante;
try
{
// inter.IdB.Student.Clear();
DB.StuListRow stu = inter.IdB.StuList.FirstOrDefault(o => o.StudentID.CompareTo(carne) == 0);
if (stu == null)
{
inter.Status = Resources.NoEnListas;
return(carne);
}
inter.IBS.StudentsList.Position = inter.IBS.StudentsList.Find(inter.IdB.StuList.SLIDColumn.ColumnName, stu.SLID);
//fill students table with all exams from the student! all classes materias
DB.TAM.StudentTableAdapter.FillByStudentID(inter.IdB.Student, carne);
//esto es bien????????
currentStudent = new DB.StudentDataTable().NewStudentRow(); //crea un objeto nuevo para guardar info
//pero no lo guardes en la tabla
// Tools.StripAnswer(ref )
currentStudent.StudentID = carne;
//NEEDS CLASS MATERIA TO BE COMPLETE
// currentStudent = stu; //yes, but do not add to the table yet
inter.Status = Resources.EstudianteEncontrado;
// if (currentStudent == null) return valu;
if (currentStudent.IsScoreNull())
{
this.inter.Status = Resources.EstudianteNoEvaluado;
}
else
{
this.inter.Status = Resources.EstudianteEvaluado;
}
}
catch (Exception ex)
{
setStatusException(ref ex);
}
return(carne);
}
