public int getLastStudentId()
{
List <StudentDo> listStudents = studentRepository.GetAll();
StudentDo student = listStudents.Last();
int studentId = student.Id;
return(++studentId);
}
public bool insertStudent(StudentDo studentData)
{
bool isInserted = false;
studentRepository.Insert(studentData);
isInserted = true;
return(isInserted);
}
public void Insert(StudentDo student)
{
if (student == null)
{
throw new Exception("An insert with null value can't be made!");
}
var query = InsertQuery.Create("students", student);
database.Execute(query);
}
private List <StudentDo> GetStudentsFromQueryResult(IQueryResult query)
{
List <StudentDo> students = new List <StudentDo>();
foreach (var row in query.Result.Rows)
{
StudentDo studentDo = new StudentDo();
new AutoMapper(studentDo, row.Values).Start();
students.Add(studentDo);
}
return(students);
}
public StudentDo Get(int studentId)
{
var query = database.Query(string.Format(Queries.GetStudentById, studentId));
if (query == null)
{
return(null);
}
var studentDo = new StudentDo();
new AutoMapper(studentDo, query.Result.Rows.First().Values).Start();
return(studentDo);
}
public void test_InsertStudent()
{
databaseContextMock.Setup(t => t.Student.GetAll()).Returns(GetStudentData);
var formInsertStudent = new InsertStudent(databaseContextMock.Object);
var nextStudentId = formInsertStudent.getLastStudentId();
var newStudent = new StudentDo()
{
Id = nextStudentId,
FirstName = "Mihai",
LastName = "Popa",
Age = "25",
EmailAddress = "*****@*****.**",
Gender = "M"
};
Assert.IsTrue(formInsertStudent.insertStudent(newStudent));
}
public void UpdateQuery_SuccesfullyMappedExpected()
{
var tableName = "students";
StudentDo student = new StudentDo()
{
Id = 1,
Age = "22",
EmailAddress = "*****@*****.**",
FirstName = "Iliusa",
Gender = "M",
LastName = "Niculae",
LinkedStatus = "1"
};
var expectedQuery = "update students set Age = '22', Gender = 'M', FirstName = 'Iliusa', LastName = 'Niculae', EmailAddress = '*****@*****.**', LinkedStatus = '1' where Id = '1';";
var result = UpdateQuery.Create(tableName, student);
Assert.IsTrue(result.Equals(expectedQuery));
}
public void InsertQuery_SuccesfullyMappedExpected()
{
var tableName = "students";
StudentDo student = new StudentDo()
{
Id = 1,
Age = "22",
EmailAddress = "*****@*****.**",
FirstName = "Iliusa",
Gender = "M",
LastName = "Niculae",
LinkedStatus = "1"
};
var expectedQuery = "insert into students (Id, Age, Gender, FirstName, LastName, EmailAddress, LinkedStatus) values ('1', '22', 'M', 'Iliusa', 'Niculae', '*****@*****.**', '1');";
var result = InsertQuery.Create(tableName, student);
Assert.IsTrue(result.Equals(expectedQuery));
}
private void btnImport_Click(object sender, EventArgs e)
{
var result = openFileDialog1.ShowDialog();
var file = openFileDialog1.FileName;
if (result != DialogResult.OK)
{
return;
}
var itemList = File.ReadLines(file).ToList();
foreach (var line in itemList)
{
var splitter = line.Split('\t');
var listStudents = studentRepository.GetAll();
var student = listStudents.Last();
var studentId = student.Id;
StudentDo studentData = new StudentDo
{
Id = ++studentId,
Age = splitter[0],
FirstName = splitter[1],
LastName = splitter[2],
Gender = splitter[3],
EmailAddress = splitter[4]
};
studentRepository.Insert(studentData);
var listClassStudents = studentClassRepository.GetAll();
var studentClass = listClassStudents.Last();
var studentClassId = student.Id;
var studentClassData = new StudentClassDo()
{
Id = ++studentClassId,
StudentId = studentId,
};
MessageBox.Show("Done !");
}
}
private void Insert_Click(object sender, EventArgs e)
{
int nextStudentId = getLastStudentId();
//TODO: not complete
StudentDo studentData = new StudentDo();
studentData.Id = nextStudentId;
studentData.Age = textAge.Text;
studentData.FirstName = textFirstName.Text;
studentData.LastName = textLastName.Text;
studentData.Gender = textGender.Text;
studentData.EmailAddress = textEmail.Text;
insertStudent(studentData);
List <StudentClassDo> listClassStudents = studentClassRepository.GetAll();
StudentClassDo studentClass = listClassStudents.Last();
//studentClassRepository.Insert(studentClassData);
MessageBox.Show("Done !");
}
public List <StudentView> GetLastSearchResult()
{
List <StudentView> resultStudents = new List <StudentView>();
List <int> studentsToAdd = GetStudentsToAdd();
List <int> studentsClassToAdd = GetStudentClassToAdd();
List <int> studentsStatusToAdd = GetStudentsStatusToAdd();
IEnumerable <int> firstresult = null;
IEnumerable <int> lastresult = null;
if (studentsClassToAdd.Count > 0)
{
if (studentsToAdd.Count > 0)
{
firstresult = studentsToAdd.Intersect(studentsClassToAdd);
}
else
{
firstresult = studentsClassToAdd;
}
}
else
{
if (studentsToAdd.Count > 0)
{
firstresult = studentsToAdd;
}
}
if (firstresult != null && firstresult.ToList().Count > 0)
{
if (studentsStatusToAdd.Count > 0)
{
lastresult = studentsStatusToAdd.Intersect(firstresult);
}
else
{
lastresult = firstresult;
}
}
else
{
if (studentsStatusToAdd.Count > 0)
{
lastresult = studentsStatusToAdd;
}
}
if (lastresult != null && lastresult.ToList().Count > 0)
{
List <int> result = lastresult.ToList();
foreach (var studId in result)
{
List <StudentStatusDo> studentsStatuses = studentStatusRepository.GetStudentStatuses(studId);
List <StudentClassDo> studentsClass = studentClassRepository.GetStudentClasses(studId);
StudentDo student = studentRepository.Get(studId);
StudentView studView = new StudentView();
if (studentsClass != null && studentsClass.Count > 0)
{
if (studentsClass.First().Promoted != null)
{
studView.Is_Promoted = studentsClass.First().Promoted;
}
studView.Class = studentsClass.First().Name;
}
if (studentsStatuses != null && studentsStatuses.Count > 0)
{
studView.Student_Year = studentsStatuses.First().Year.ToString();
studView.ECTS = studentsStatuses.First().ECTS.ToString();
}
if (student != null)
{
studView.ID = student.Id.ToString();
studView.First_Name = student.FirstName;
studView.Last_Name = student.LastName;
studView.Email_Address = student.EmailAddress;
studView.Age = student.Age;
studView.Gender = student.Gender;
}
resultStudents.Add(studView);
}
}
return(resultStudents);
}
