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