public async Task <IActionResult> GetMemberDetails(int userId) { JsonResponse <CompanyMemberDetails> objResult = new JsonResponse <CompanyMemberDetails>(); try { CompanyMemberDetails data = await this._settingService.GetMemberDetails(userId); if (data != null) { objResult.Data = data; objResult.Status = StaticResource.SuccessStatusCode; objResult.Message = StaticResource.SuccessMessage; return(new OkObjectResult(objResult)); } else { objResult.Data = null; objResult.Status = StaticResource.NotFoundStatusCode; objResult.Message = StaticResource.NotFoundMessage; return(new OkObjectResult(objResult)); } } catch (Exception ex) { HttpContext.RiseError(ex); objResult.Data = null; objResult.Status = StaticResource.FailStatusCode; objResult.Message = StaticResource.FailMessage; } return(new OkObjectResult(objResult)); }
public async Task <CompanyMemberDetails> GetMemberDetails(int userId) { try { CompanyMemberDetails memberDetails = new CompanyMemberDetails(); using (IDbConnection con = new SqlConnection(_connectionString)) { memberDetails = await con.QueryFirstOrDefaultAsync <CompanyMemberDetails>("dbo.SSP_getCompanyMemberDetails", new { UserId = userId }, commandType : CommandType.StoredProcedure); } return(memberDetails); } catch (Exception ex) { throw ex; } }