public void UpdateResultsOfExamTest()
{
List <bool> boolList = new List <bool>();
int id = 7;
ResultsOfExam resultsOfExam = (ResultsOfExam)dbContext.ResultsOfExamsRepository.GetById(id);
ResultsOfExam tmp = new ResultsOfExam();
tmp.Id = resultsOfExam.Id;
tmp.Exam = resultsOfExam.Exam;
tmp.Student = resultsOfExam.Student;
tmp.Result = resultsOfExam.Result;
resultsOfExam.Result = 2;
boolList.Add(dbContext.ResultsOfExamsRepository.Update(resultsOfExam));
ResultsOfExam updatedResultsOfExam = (ResultsOfExam)dbContext.ResultsOfExamsRepository.GetById(id);
boolList.Add(updatedResultsOfExam.Result == resultsExamObjCase.Result ? true : false);
dbContext.ResultsOfExamsRepository.Update(tmp);
bool isEqualCollections = boolList.Contains(false);
Assert.IsTrue(!isEqualCollections);
}
public void GetAllResultsOfExamsTest()
{
List <bool> isEqualList = new List <bool>();
List <ResultsOfExam> resultsOfExams = dbContext.ResultsOfExamsRepository.GetAll();
foreach (var resultsOfExam in resultsOfExams)
{
ResultsOfExam obj = resultsExamsCases.Where(o => o.Id == resultsOfExam.Id &&
o.ExamId == resultsOfExam.ExamId &&
o.StudentId == resultsOfExam.StudentId &&
o.Result == resultsOfExam.Result)
.FirstOrDefault();
isEqualList.Add(obj == null ? false : true);
}
bool isEqualCollections = isEqualList.Contains(false);
Assert.IsTrue(!isEqualCollections);
}
/// <summary>
/// Method for get results of exam by id value from the database
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public override BaseModel GetById(int id)
{
ResultsOfExam results = null;
using (SqlConnection connection = new SqlConnection(base.ConnectionString))
{
using (var query = new SqlCommand())
{
query.Connection = connection;
query.CommandText = SqlQueriesHelper.FormSelectByIdQuery(typeof(ResultsOfExam), id);
query.Connection.Open();
using (SqlDataReader reader = query.ExecuteReader())
{
if (reader.HasRows && reader.Read())
{
results = new ResultsOfExam()
{
Id = (int)reader["Id"],
Student = new Student {
Id = (int)reader["StudentId"]
},
Exam = new Exam {
Id = (int)reader["ExamId"]
},
Result = (int)reader["Result"]
};
}
}
query.Connection.Close();
}
}
if (results != null)
{
Student student = (Student)base.DbContext.StudentsRepository.GetById(results.Student.Id);
Exam exam = (Exam)base.DbContext.ExamsRepository.GetById(results.Exam.Id);
results.Student = student;
results.Exam = exam;
}
return(results);
}
public void GetResultsOfExamsByIdTest()
{
List <bool> isEqualList = new List <bool>();
List <int> ids = new List <int>()
{
4, 5, 7
};
foreach (int id in ids)
{
ResultsOfExam resultsOfExam = dbContext.ResultsOfExamsRepository.GetById(id);
ResultsOfExam obj = resultsExamsCases.Where(o => o.Id == resultsOfExam.Id &&
o.ExamId == resultsOfExam.ExamId &&
o.StudentId == resultsOfExam.StudentId &&
o.Result == resultsOfExam.Result)
.FirstOrDefault();
isEqualList.Add(obj == null ? false : true);
}
bool isEqualCollections = isEqualList.Contains(false);
Assert.IsTrue(!isEqualCollections);
}