public bool CreateNewEmailVerificationCode(EmailVerificationCode emailverificationcode)
{
return(ExecuteProcedureNonQuery("CREATE_NEW_EMAIL_VERIFICATION_CODE",
new List <SqlParameter>()
{
new SqlParameter("@UserId", emailverificationcode.UserId),
new SqlParameter("@DateCreated", emailverificationcode.DateCreated),
new SqlParameter("@VerificationCode", emailverificationcode.VerificationCode),
new SqlParameter("@ExpirationDate", emailverificationcode.ExpirationDate),
},
iCommandTimeout: 60));
}
public async Task <IActionResult> GetEmailPriorityCode(EmailConfirmationRequest model)
{
var result = await _emailConfirmationService.GetPriorityCode(model.Email, model.PartnerId);
if (result == null)
{
return(BadRequest("Code not found."));
}
var response = new EmailVerificationCode(result.Code, result.CreationDateTime, result.ExpirationDate);
return(Ok(response));
}
public EmailVerificationCode ViewEmailVerificationCodeById(Int64 EmailVerificationCodeId)
{
EmailVerificationCode response = null;
DataTable lQueryResult = ExecuteProcedureQuery("VIEW_EMAIL_VERIFICATION_CODE_BY_ID",
new SqlParameter("@EmailVerificationCodeId", EmailVerificationCodeId),
iCommandTimeout: 30);
if (lQueryResult.Rows.Count > 0)
{
response = AutoMap <EmailVerificationCode> .FromDataRow(lQueryResult.Rows[0]);
}
return(response);
}