Models.StudentAssessment IRepository.CreateStudentAssessment(Models.StudentAssessment model)
{
var parameters = new[] { new SqlParameter("@StudentId", model.StudentId.Value), new SqlParameter("@AssessmentTypeId", model.AssessmentTypeId.Value) };
using (var db = new Db(ConnectionString))
{
model.Id = db.CallProcWithReturnValue(StoredProcedures.CreateStudentAssessment, parameters);
}
return(model);
}
Models.StudentAssessment IRepository.GetStudentAssessment(int id)
{
var result = new Models.StudentAssessment {
Id = id
};
var parameters = new[] { new SqlParameter("@Id", id) };
using (var db = new Db(ConnectionString))
{
db.UseDataReader(StoredProcedures.GetStudentAssessment, parameters, reader =>
{
while (reader.Read())
{
result.StudentId = reader.GetInt("StudentId");
result.AssessmentTypeId = reader.GetInt("AssessmentTypeId");
result.StudentName = reader.GetString("StudentName");
result.AssessmentTypeName = reader.GetString("AssessmentTypeName");
}
});
}
return(result);
}