public async Task <MResultRequest <MTest_MainInfo> > GetByIdAsync(int Id)
{
try
{
MTest_MainInfoDb Test_MainInfoDb =
await
_context.Set <MTest_MainInfoDb>()
.Include(_ => _.Questions_ChoosingAnswerFromList)
.Include(_ => _.Questions_ChoosingAnswerFromList.Select(c => c.AnswerVariants))
.Include(_ => _.Questions_SetOrder)
.Include(_ => _.Questions_SetOrder.Select(c => c.AnswerVariants))
.Include(_ => _.User_TestAuthor)
.AsNoTracking()
.FirstOrDefaultAsync(_ => _.Id == Id)
.ConfigureAwait(false);
if (Test_MainInfoDb == null)
{
throw
new NullReferenceException();
}
return
(MResultRequest <MTest_MainInfo>
.Ok(_mapper.Map <MTest_MainInfo>(Test_MainInfoDb)));
}
catch (NullReferenceException)
{
return
((MResultRequest <MTest_MainInfo>) MResultRequest <MTest_MainInfo>
.Fail <MTest_MainInfo>($@"There is no test with the specified Id: {Id} in the system."));
}
}
public async Task <MResultRequest <string> > AddAsync(MReaderChoice_MainInfo ReaderChoice_MainInfo)
{
try
{
MReaderChoice_MainInfoDb ResultOfTheTestDb =
_mapper.Map <MReaderChoice_MainInfoDb>(ReaderChoice_MainInfo);
_context.Set <MReaderChoice_MainInfoDb>().Add(ResultOfTheTestDb);
await
_context
.SaveChangesAsync();
return
(MResultRequest <string>
.Ok("Complite !!!"));
}
catch (DbUpdateConcurrencyException e)
{
return
((MResultRequest <string>) MResultRequest <string> .Fail <string>($"Cannot save model. {e.Message}"));
}
catch (DbUpdateException e)
{
return
((MResultRequest <string>) MResultRequest <string> .Fail <string>($"Cannot save model. Duplicate field. {e.Message}"));
}
catch (DbEntityValidationException e)
{
return
((MResultRequest <string>) MResultRequest <string> .Fail <string>($"Invalid model. {e.Message}"));
}
}
public async Task <MResultRequest <MTest_MainInfo> > AddAsync(string User_TestAuthor_Id, MTest_MainInfo Test_MainInfo)
{
try
{
MTest_MainInfoDb Test_MainInfoDb =
_mapper.Map <MTest_MainInfoDb>(Test_MainInfo);
Test_MainInfoDb.User_TestAuthorDb_Id = User_TestAuthor_Id;
_context.Set <MTest_MainInfoDb>().Add(Test_MainInfoDb);
await
_context
.SaveChangesAsync();
return
(MResultRequest <MTest_MainInfo>
.Ok(_mapper.Map <MTest_MainInfo>(Test_MainInfo)));
}
catch (DbUpdateConcurrencyException e)
{
return
((MResultRequest <MTest_MainInfo>) MResultRequest <MTest_MainInfo> .Fail <MTest_MainInfo>($"Cannot save model. {e.Message}"));
}
catch (DbUpdateException e)
{
return
((MResultRequest <MTest_MainInfo>) MResultRequest <MTest_MainInfo> .Fail <MTest_MainInfo>($"Cannot save model. Duplicate field. {e.Message}"));
}
catch (DbEntityValidationException e)
{
return
((MResultRequest <MTest_MainInfo>) MResultRequest <MTest_MainInfo> .Fail <MTest_MainInfo>($"Invalid model. {e.Message}"));
}
}
// ------------ CheckCorrectAnswer
public MResultRequest <string> CheckTestAsync(string User_TestReaderr_Id, MReaderChoice_MainInfo ReaderChoice_MainInfo)
{
try
{
MTest_MainInfo Current_Test_MainInfo =
GetById(ReaderChoice_MainInfo.Test_MainInfoDb_Id).Data;
int NumberOfCorrectAnswer = 0;
NumberOfCorrectAnswer +=
_service_Question_ChoosingAnswerFromList.CheckQuestion(Current_Test_MainInfo, ReaderChoice_MainInfo);
NumberOfCorrectAnswer +=
_service_Question_SetOrder.CheckQuestion(Current_Test_MainInfo, ReaderChoice_MainInfo);
int NumberOfAttempt = 1;
if (_context.Set <MReaderChoice_MainInfoDb>().Any(c => c.Test_MainInfoDb_Id == ReaderChoice_MainInfo.Test_MainInfoDb_Id && c.User_TestReaderDb_Id == User_TestReaderr_Id))
{
NumberOfAttempt =
_context.Set <MReaderChoice_MainInfoDb>()
.Where(c => c.Test_MainInfoDb_Id == ReaderChoice_MainInfo.Test_MainInfoDb_Id && c.User_TestReaderDb_Id == User_TestReaderr_Id)
.Select(c => c.NumberOfAttempt)
.Max() + 1;
}
ReaderChoice_MainInfo.User_TestReaderDb_Id = User_TestReaderr_Id;
ReaderChoice_MainInfo.NumberOfAttempt = NumberOfAttempt;
ReaderChoice_MainInfo.ResultTest =
$@"{NumberOfCorrectAnswer} из {((Current_Test_MainInfo.Questions_ChoosingAnswerFromList.Any()) ? Current_Test_MainInfo.Questions_ChoosingAnswerFromList.Count : 0)}";
return
(MResultRequest <string> .Ok(ReaderChoice_MainInfo.ResultTest));
}
catch (Exception e)
{
return
((MResultRequest <string>) MResultRequest <string> .Fail <string>(e.Message));
}
}
public async Task <MResultRequest> DeleteByIdAsync(int Id)
{
try
{
_context.Entry(new MTest_MainInfoDb()
{
Id = Id
}).State = EntityState.Deleted;
await _context.SaveChangesAsync();
return
(MResultRequest.Ok());
}
catch (NullReferenceException e)
{
return
((MResultRequest <MTest_MainInfo>) MResultRequest <MTest_MainInfo> .Fail <MTest_MainInfo>($"Cannot delete model. {e.Message}"));
}
}
public MResultRequest <MTest_MainInfo> Update(string User_TestAuthor_Id, MTest_MainInfo Test_MainInfo)
{
try
{
MTest_MainInfoDb Test_MainInfoDb =
_mapper.Map <MTest_MainInfoDb>(Test_MainInfo);
Test_MainInfoDb.User_TestAuthorDb_Id = User_TestAuthor_Id;
_context.Set <MTest_MainInfoDb>().Remove(
_context.Set <MTest_MainInfoDb>().Find(Test_MainInfo.Id));
_context.Set <MTest_MainInfoDb>().Add(Test_MainInfoDb);
_context.SaveChanges();
return
(MResultRequest <MTest_MainInfo>
.Ok(_mapper.Map <MTest_MainInfo>(Test_MainInfoDb)));
}
catch (DbUpdateConcurrencyException e)
{
return
((MResultRequest <MTest_MainInfo>) MResultRequest <MTest_MainInfo> .Fail <MTest_MainInfo>($"Cannot update model. {e.Message}"));
}
catch (DbUpdateException e)
{
return
((MResultRequest <MTest_MainInfo>) MResultRequest <MTest_MainInfo> .Fail <MTest_MainInfo>($"Cannot update model. {e.Message}"));
}
catch (DbEntityValidationException e)
{
return
((MResultRequest <MTest_MainInfo>) MResultRequest <MTest_MainInfo> .Fail <MTest_MainInfo>($"Cannot update model. {e.Message}"));
}
}
public void GetByIdTest(int Id)
{
MResultRequest <MTest_MainInfo> Test_MainInfo = _service_Test.GetById(Id);
Assert.Warn($@"{Test_MainInfo.Data.Id}");
}
