public int InsertUpdateTest(MstTestModel mstTestModel) { try { MstTest _mstTest = new MstTest(); mstTestModel.TestDate = mstTestModel.TestDate.Value.AddDays(1); _mstTest = _context.MstTest.Where(x => x.Id == mstTestModel.Id).FirstOrDefault(); _mstTest = Mapper.Map <MstTestModel, MstTest>(mstTestModel); if (_mstTest.Id == 0) { _context.MstTest.Add(_mstTest); } _context.SaveChanges(); return(1); } catch (Exception ex) { _errorLog.BindErrorLogModel("InsertUpdateTest", ex.Message, "error"); return(-1); } }
public int DeleteTest(int id) { try { // Check test have athletes or not int count = _context.TestAthleteMapping.Where(x => x.testId == id).Count(); if (count > 0) { //If test have athletes then remove before removing test _context.TestAthleteMapping.RemoveRange(_context.TestAthleteMapping.Where(x => x.testId == id)); _context.SaveChanges(); } MstTest _mstTest = _context.MstTest.Where(x => x.Id == id).FirstOrDefault(); _context.MstTest.Remove(_mstTest); _context.SaveChanges(); return(1); } catch (Exception ex) { _errorLog.BindErrorLogModel("DeleteTest", ex.Message, "error"); return(-1); } }