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 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 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 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; }