public async Task <bool> Logout(string userName)
{
var user = await _context.LoginActivity.Where(x => x.UserName == userName.ToLower()).FirstOrDefaultAsync();
if (user != null)
{
user.IsLogout = true;
user.LastLoginDate = DateTime.Now;
}
if (await _context.SaveChangesAsync() > 0)
{
return(true);
}
return(false);
}
//public async Task<int> AddTestResult(TestResultVM model)
//{
// lock (objLock)
// {
// using (System.Data.Entity.DbContextTransaction dbtrans = _context.Database.BeginTransaction())
// {
// int id = 0;
// if (model == null) throw new Exception("There is no Entry!");
// if (!ResultExist(model.testResultId))
// {
// var addQuestion = new TestResult
// {
// Answer = model.answer,
// Altanswer = model.altAnswer,
// DateTaken = DateTime.Now,
// FinishTime = DateTime.Now.TimeOfDay,
// Psid = model.psid,
// QuestionBankId = model.questionBankId,
// StartTime = DateTime.Now.TimeOfDay,
// TestCategoryId = model.testCategoryId
// };
// var test = _context.TestResult.Add(addQuestion);
// _context.SaveChangesAsync();
// dbtrans.Commit();
// return test.TestResultId;
// }
// else
// {
// UpdateTestResult(model);
// return model.testResultId;
// }
// }
// }
//}
public async Task <int> AddTestResult(IEnumerable <TestResultVM> model)
{
lock (objLock)
{
using (System.Data.Entity.DbContextTransaction dbtrans = _context.Database.BeginTransaction())
{
int id = 0;
if (model.Count() == 0)
{
throw new Exception("There is no Entry!");
}
foreach (var o in model)
{
//if (!ResultExist(o.testResultId))
//{
var addQuestion = new TestResult
{
Answer = o.answer,
Altanswer = o.altAnswer,
DateTaken = DateTime.Now,
FinishTime = DateTime.Now.TimeOfDay,
Psid = o.psid,
QuestionBankId = o.questionBankId,
StartTime = DateTime.Now.TimeOfDay,
TestCategoryId = o.testCategoryId
};
var test = _context.TestResult.Add(addQuestion);
// _context.SaveChangesAsync().Wait();
// dbtrans.Commit();
//return test.TestResultId;
// }
//else
//{
// UpdateTestResult(model);
// return o.testResultId;
//}
}
_context.SaveChangesAsync().Wait();
dbtrans.Commit();
return(1);
}
}
}
