public void Delete(DalUsersTest e)
{
if (context.Database.Connection.State != ConnectionState.Open)
{
context.Database.Connection.Open();
}
UsersTests ut = context.Set <UsersTests>().
FirstOrDefault(a => a.id == e.Id);
context.Set <UsersTests>().Remove(ut);
}
public static UsersTestsEntity ToBllUsersTest(this DalUsersTest e)
{
return(new UsersTestsEntity()
{
Id = e.Id,
BeginningTime = e.BeginningTime,
EndingTime = e.EndingTime,
MarkForTest = e.MarkForTest,
RightAnswersCount = e.RightAnswersCount,
TestId = e.TestId,
UserId = e.UserId
});
}
public void Update(DalUsersTest entity)
{
if (context.Database.Connection.State != ConnectionState.Open)
{
context.Database.Connection.Open();
}
UsersTests ut = context.Set <UsersTests>().
FirstOrDefault(a => a.id == entity.Id);
ut.BeginningTime = entity.BeginningTime;
ut.EndingTime = entity.EndingTime;
ut.MarkForTest = entity.MarkForTest;
ut.RightAnswersCount = entity.RightAnswersCount;
ut.TestId = entity.TestId;
ut.UserId = entity.UserId;
}
public void Create(DalUsersTest e)
{
if (context.Database.Connection.State != ConnectionState.Open)
{
context.Database.Connection.Open();
}
UsersTests ut = new UsersTests()
{
id = e.Id,
BeginningTime = e.BeginningTime,
EndingTime = e.EndingTime,
MarkForTest = e.MarkForTest,
RightAnswersCount = e.RightAnswersCount,
TestId = e.TestId,
UserId = e.UserId
};
context.Set <UsersTests>().Add(ut);
}
public IEnumerable <DalUsersAnswers> GetByUsersTest(DalUsersTest usersTest)
{
if (context.Database.Connection.State != ConnectionState.Open)
{
context.Database.Connection.Open();
}
IEnumerable <UsersAnswers> ua = context.Set <UsersAnswers>().
Where(a => a.UsersTestId == usersTest.Id);
List <DalUsersAnswers> result = new List <DalUsersAnswers>();
foreach (UsersAnswers u in ua)
{
result.Add(new DalUsersAnswers()
{
AnswerStructure = u.AnswerStructure,
BeginningTime = u.BeginningTime,
EndingTime = u.EndingTime,
QuestionId = u.QuestionId,
UserTestId = u.UsersTestId
});
}
return(result);
}