示例#1
0
 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);
     }
 }
示例#2
0
        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);
            }
        }