public bool Save(userSecurityAnswerModel _Dto)
{
try
{
List <SecurityAnswerUserMap> _SecurityAnswers = new List <SecurityAnswerUserMap>();
List <SecurityQuestionAnswerModel> _userSecurityAnswerModel = new List <SecurityQuestionAnswerModel>();
if (_Dto.Status == "2")
{
var result = db.SecurityAnswerUserMaps.Where(o => o.UserId == _Dto.Id).ToList();
if (result.Count() > 0)
{
db.SecurityAnswerUserMaps.RemoveRange(result);
}
}
foreach (var item in _Dto.QuestionsLst)
{
SecurityAnswerUserMap _SecurityAnswer = new SecurityAnswerUserMap();
_SecurityAnswer.Id = Guid.NewGuid();
_SecurityAnswer.QuestionId = item.QuestionId;
_SecurityAnswer.Answer = item.Answer;
_SecurityAnswer.DisplayOrder = item.DisplayOrder;
_SecurityAnswer.UserId = _Dto.Id;
_SecurityAnswer.CreatedBy = _Dto.Id;
_SecurityAnswer.LastUpdatedBy = _Dto.Id;
_SecurityAnswer.LastUpdatedDate = DateTime.Now;
_SecurityAnswer.CreatedDate = DateTime.Now;
_SecurityAnswer.StatusCode = EMPConstants.Active;
_SecurityAnswers.Add(_SecurityAnswer);
}
db.SecurityAnswerUserMaps.AddRange(_SecurityAnswers);
try
{
db.SaveChanges();
db.Dispose();
}
catch (DbUpdateConcurrencyException ex)
{
ExceptionLogger.LogException(ex.ToString(), "SecurityAnswer/PostSecurityQuestion", Guid.Empty);
return(false);
}
return(true);
}
catch (Exception ex)
{
ExceptionLogger.LogException(ex.ToString(), "SecurityAnswer/PostSecurityQuestion", Guid.Empty);
return(false);
}
}
public async Task <Guid> PostForgotPassword(ForgotPasswordModel _Dto)
{
emp_CustomerLoginInformation _CustomerLoginInformation = new emp_CustomerLoginInformation();
SecurityAnswerUserMap _SecurityAnswerUserMap = new SecurityAnswerUserMap();
var dbresult = await db.emp_CustomerLoginInformation.Where(o => o.CrossLinkUserId == _Dto.CrossLinkUserId).Select(o => new CustomerLoginModel
{
CrossLinkUserId = o.CrossLinkUserId,
}).FirstOrDefaultAsync();
if (dbresult != null)
{
var result = await db.SecurityAnswerUserMaps.Where(o => (o.QuestionId == _SecurityAnswerUserMap.QuestionId) && (o.Answer == _SecurityAnswerUserMap.Answer)).Select(o => new SecurityAnswerUserMap
{
UserId = o.UserId,
}).FirstOrDefaultAsync();
}
return(dbresult.UserId ?? Guid.Empty);
}
