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