public int SaveTestEntryData(TestEntryViewModel objTestEntry)
{
using (IDbConnection conn = Connection)
{
DynamicParameters ObjParm = new DynamicParameters();
ObjParm.Add("@TestDate", objTestEntry.TestDate);
ObjParm.Add("@TestTypeId", objTestEntry.TestTypeId);
conn.Open();
int getId;
if (objTestEntry.TestId == 0)
{
ObjParm.Add("@id", dbType: DbType.Int32, direction: ParameterDirection.Output);
conn.Execute("InsertTestEntryData", ObjParm, commandType: CommandType.StoredProcedure);
getId = ObjParm.Get <int>("@id");
}
else
{
ObjParm.Add("@TestId", objTestEntry.TestId);
ObjParm.Add("@getTestId", dbType: DbType.Int32, direction: ParameterDirection.Output);
conn.Execute("UpdateTestEntry", ObjParm, commandType: CommandType.StoredProcedure);
getId = ObjParm.Get <int>("@getTestId");
}
return(getId);
}
}
public IActionResult SaveTestData(TestEntryViewModel objTest)
{
try
{
int getId = _testRepo.SaveTestEntryData(objTest);
return(Ok(getId));
}
catch (Exception ex)
{
return(StatusCode(500, ex.Message));
}
}
public async Task <IActionResult> Index(long?errorTestId)
{
if (IsNotAdmin())
{
return(RedirectToAction("Index", "Home"));
}
var viewModel = new List <TestEntryViewModel>();
var tests = await _context.Tests.ToListAsync();
foreach (var testItem in tests)
{
var entry = new TestEntryViewModel {
Test = testItem
};
if (testItem.Id == errorTestId)
{
entry.Errors = ErrorsOfTest(testItem);
}
viewModel.Add(entry);
}
return(View(viewModel));
}
