Beispiel #1
0
        public async Task <Guid> Save(BankSubQuestionDTO _Dto, Guid Id, int EntityState)
        {
            BankSubQuestion _BankSubQuestion = new BankSubQuestion();

            if (_Dto != null)
            {
                _BankSubQuestion.Id              = Id;
                _BankSubQuestion.BankId          = _Dto.BankId;
                _BankSubQuestion.Questions       = _Dto.Questions;
                _BankSubQuestion.Description     = _Dto.Description;
                _BankSubQuestion.ActivatedDate   = DateTime.Now;
                _BankSubQuestion.DeActivatedDate = DateTime.Now;
                _BankSubQuestion.StatusCode      = EMPConstants.Active;
            }

            if (_Dto.Id != null)
            {
                _BankSubQuestion.CreatedBy       = _Dto.UserId;
                _BankSubQuestion.CreatedDate     = DateTime.Now;
                _BankSubQuestion.LastUpdatedBy   = _Dto.UserId;
                _BankSubQuestion.LastUpdatedDate = DateTime.Now;
            }
            else
            {
                _BankSubQuestion.LastUpdatedBy   = _Dto.UserId;
                _BankSubQuestion.LastUpdatedDate = DateTime.Now;
            }

            if (EntityState == (int)System.Data.Entity.EntityState.Modified)
            {
                db.Entry(_BankSubQuestion).State = System.Data.Entity.EntityState.Modified;
            }
            else
            {
                db.BankSubQuestions.Add(_BankSubQuestion);
            }

            try
            {
                await db.SaveChangesAsync();

                return(_BankSubQuestion.Id);
            }

            catch (DbUpdateConcurrencyException)
            {
                if (!IsExists(_BankSubQuestion.Id))
                {
                    return(_BankSubQuestion.Id);
                }
                else
                {
                    throw;
                }
            }
        }
Beispiel #2
0
        public async Task <Guid> SaveStatus(BankSubQuestionDTO _Dto, Guid Id, int EntityState)
        {
            BankSubQuestion bankSubQuestion = new BankSubQuestion();

            bankSubQuestion = await db.BankSubQuestions.Where(o => o.Id == Id).FirstOrDefaultAsync();

            if (bankSubQuestion.StatusCode == EMPConstants.InActive)
            {
                bankSubQuestion.StatusCode = EMPConstants.Active;
            }
            else if (bankSubQuestion.StatusCode == EMPConstants.Active)
            {
                bankSubQuestion.StatusCode = EMPConstants.InActive;
            }

            if (EntityState == (int)System.Data.Entity.EntityState.Modified)
            {
                bankSubQuestion.LastUpdatedDate = DateTime.Now;
                bankSubQuestion.LastUpdatedBy   = _Dto.UserId;
                db.Entry(bankSubQuestion).State = System.Data.Entity.EntityState.Modified;
            }

            try
            {
                await db.SaveChangesAsync();

                db.Dispose();
                return(bankSubQuestion.Id);
            }

            catch (DbUpdateConcurrencyException)
            {
                if (!IsExists(bankSubQuestion.Id))
                {
                    return(Guid.Empty);
                }
                else
                {
                    throw;
                }
            }
        }