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