c# - XML Parsing with LINQ with deep nested loops -

-

i having problems getting coveredpersons , coveredperson tag values. 

<header>     <model_name>sample model name</model_name> </header> <data>     <contractnumber>0-99-54321</contractnumber>     <initialeffectivedate>11/04/2011</initialeffectivedate>     <contractenddate></contractenddate>     <renewaldate>11/04/2021</renewaldate>     <nextcontractbirthdate>11/04/2011</nextcontractbirthdate>     <smokerclassification>non smoker</smokerclassification>     <billingfrequency>annually</billingfrequency>     <premiumwithtax>270.23</premiumwithtax>     <annualpolicyfee>100.00</annualpolicyfee>     <payerrelationtosubscriber></payerrelationtosubscriber>     <payerasperson>         <firstname>steve</firstname>         <middlename1></middlename1>         <lastname>jordan</lastname>         <secondlastname></secondlastname>     </payerasperson>     <subscribedoptions>         <offeredentity>             <code>a-1</code>             <name>sample entity</name>         </offeredentity>         <coveredpersons>             <coveredperson>                 <firstname>steve</firstname>                 <middlename1></middlename1>                 <lastname>square</lastname>                 <birthdate>01/01/1980</birthdate>                 <gender>male</gender>             </coveredperson>             <eliminationperiod></eliminationperiod>         </coveredpersons>         <coverageamount>75,000.00</coverageamount>         <premiumwithtax>61.50</premiumwithtax>         <initialeffectivedate>11/04/2011</initialeffectivedate>         <contractenddate></contractenddate>         <terminationdate></terminationdate>         <expirationdatetoconvert>01/01/2040</expirationdatetoconvert>         <coveredpersoncount>1</coveredpersoncount>     </subscribedoptions>     <subscribedoptions>         <offeredentity>             <code>b-1</code>             <name>sample entity 2</name>         </offeredentity>         <coveredpersons>             <coveredperson>                 <firstname>juan</firstname>                 <middlename1></middlename1>                 <lastname>osorio</lastname>                 <birthdate>01/01/1980</birthdate>                 <gender>male</gender>             </coveredperson>             <eliminationperiod></eliminationperiod>         </coveredpersons>         <coverageamount>5,000.00</coverageamount>         <premiumwithtax>0.00</premiumwithtax>         <initialeffectivedate>11/04/2011</initialeffectivedate>         <contractenddate></contractenddate>         <terminationdate></terminationdate>         <expirationdatetoconvert>01/01/2040</expirationdatetoconvert>         <coveredpersoncount>1</coveredpersoncount>     </subscribedoptions>             <subscriber>         <firstname>juan</firstname>         <lastname>osorio</lastname>         <middlename1></middlename1>         <secondlastname>uno</secondlastname>         <gender>male</gender>         <age>31</age>     </subscriber>     <offeredentity>         <name>sample base entity</name>         <code>code-54321</code>     </offeredentity> </data>

this have far:

foreach (var xsubscribedoptions in (from suboptions in xdoc.descendants("subscribedoptions")                                         suboptionsoffentity in xdoc.descendants("subscribedoptions").descendants("offeredentity")                                         suboptionscovperson in xdoc.descendants("subscribedoptions").descendants("coveredperson")                                         suboptionscovpersoncovperson in xdoc.descendants("coveredpersons").descendants("coveredperson")                                         select new                                         {                                             offeredentitycode = suboptionsoffentity.element("code").value,                                             offeredentityname = suboptionsoffentity.element("name").value,                                             subscribedoptionscoverageamount = suboptions.element("coverageamount").value,                                             subscribedoptionspremiumwithtax = suboptions.element("premiumwithtax").value,                                             subscribedoptionsinitialeffectivedate = suboptions.element("initialeffectivedate").value,                                             subscribedoptionscontractenddate = suboptions.element("contractenddate").value,                                             subscribedoptionsterminationdate = suboptions.element("terminationdate").value,                                             subscribedoptionsexpirationdatetoconvert = suboptions.element("expirationdatetoconvert").value,                                             subscribedoptionscoveredpersoncount = suboptions.element("coveredpersoncount").value,                                             coveredpersonfirstname = suboptionscovpersoncovperson.element("firstname").value,                                             coveredpersonmiddlename1 = suboptionscovpersoncovperson.element("middlename1").value,                                             coveredpersonlastname = suboptionscovpersoncovperson.element("lastname").value,                                             coveredpersonbirthdate = suboptionscovpersoncovperson.element("birthdate").value,                                             coveredpersongender = suboptionscovpersoncovperson.element("gender").value,                                             coveredpersoneliminationperiod = suboptionscovperson.element("eliminationperiod").value                                            }))     {    }

you use

coveredpersonfirstname = suboptions.xpathselectelement("./coveredpersons/coveredperson/firstname").value coveredpersonlastname = suboptions.xpathselectelement("./coveredpersons/coveredperson/lastname").value

etc. each element need retrieve coveredperson tag


Comments

Post a Comment

Popular posts from this blog

php - What is the difference between $_SERVER['PATH_INFO'] and $_SERVER['ORIG_PATH_INFO']? -

-
what’s difference between $_server['path_info'] , $_server['orig_path_info'] ? how use them? when run print_r($_server) , path_info , orig_path_info not present in array. why not? how can enable them? i have read php manual on them, still don’t understand them. the path_info variable present if invoke php script this: http://www.example.com/phpinfo.php/hello_there it's /hello_there part after .php script. if don't invoke url that, there won't $_server["path_info"] environment variable. the porig_ prefix uncommon. path_info standard cgi-environment variable, , should never prefixed. did read that? (there issues around php3/php4 if invoked php interpreter via cgi-bin/ - hardly has such setups today.) for reference: http://www.ietf.org/rfc/rfc3875
Read more

fortran - Function return type mismatch -

-
i'm attempting recode old c++ program in fortran make use of lapack (i'm aware c++ have lapack++, i'm having lot of trouble installing it, gave up). i didn't have problems compilation, when had variables declared real . when started coding section of program required lapack, found parameters passed dsyev need double precision . tried change double precision (including changing hard coded numbers double precision counterparts, i.e. 0.0 -> 0.0d0) when try compile, following error of functions , subroutines i've written: error: return type mismatch of function <function> @ (1) (real(4)/real(8)) i'm not sure coming from, in program has been changed double precision. for example, i've declared following: double precision :: alpha(3),d(3),zeta1,zeta2 double precision :: a1(3),a2(3),d1(3),d2(3) double precision :: pi pi = 3.14159265359d0 alpha = (/0.109818d0, 0.405771d0, 2.22766d0/) d = (/0.444635d0, 0.535328d0, 0.154329d0 /) 10 i=1,3 ...
Read more

queue - mq_receive: message too long -

-
i implementing communication between 2 processes using queue. problem when call function mq_receive, error: message long. i have done following: struct mq_attr attr; long size = attr.mq_msgsize; .... // initializing queue "/gateway" int rc = mq_receive(gateway, buffer, size, &prio); if print size value, size=1, while when print same size program (got same mechanism), not long integer ( -1217186280 )... how can solve error?....so while size = 1, believe it's right "message long" why 1? p.s. have tried put : int rc = mq_receive(gateway, buffer, sizeof(buffer), &prio); but no result. it seems need read docs more carefully. when call mq_receive should pass size of destination buffer. this size must greater mq_msgsize attribute of queue . in addition, seems have error in queue attributes initialisation makes proper mq_receive call impossible. here standard message queue session: fill mq_attr struct ( doc ): struct mq_a...
Read more