Models.Teacher IRepository.CreateTeacher(Models.Teacher model)
{
var parameters = new[] { new SqlParameter("@UserId", model.UserId) };
using (var db = new Db(ConnectionString))
{
model.Id = db.CallProcWithReturnValue(StoredProcedures.CreateTeacher, parameters);
}
return(model);
}
Models.Teacher IRepository.GetTeacher(string userName)
{
var result = new Models.Teacher();
var parameters = new[] { new SqlParameter("@UserName", userName) };
using (var db = new Db(ConnectionString))
{
db.UseDataReader(StoredProcedures.GetTeacher, parameters, reader =>
{
while (reader.Read())
{
result.Id = reader.GetInt("Id");
result.UserId = reader.GetString("UserId");
}
});
}
return(result);
}
