For loop query sql database in asp.net c# -

-

i not sure how use loop or while loop ever suits problem better.
need query database based on selected item in drop down list , field processed ='false'

then code within loop

then update database based on selected item in drop down list , field processed becomes ='true'

my code below, need the loop within document.open , document.close

    protected void generatereport(object sender, eventargs e)     {         datarow dr = getdata("select * onsiteworktx docid = " + dropdownlistpdf.selecteditem.value).rows[0]; ;         document document = new document(pagesize.a4, 88f, 88f, 10f, 10f);         font normalfont = fontfactory.getfont("arial", 12, font.normal, basecolor.black);          using (system.io.memorystream memorystream = new system.io.memorystream())         {             pdfwriter writer = pdfwriter.getinstance(document, memorystream);             phrase phrase = null;             pdfpcell cell = null;             pdfptable table = null;             basecolor color = null;              document.open();              //header table             table = new pdfptable(2);             table.totalwidth = 500f;             table.lockedwidth = true;             table.setwidths(new float[] { 0.6f, 0.3f });               cell = imagecell("~/pic.jpg", 40f, pdfpcell.align_left);             table.addcell(cell);                phrase = new phrase(new chunk("qaf 018/2\n", fontfactory.getfont("arial", 8, font.normal, basecolor.black)));             phrase.add(new chunk("on site work                        " + "visit " + dr["visitnumber"] + "   " + dr["pagenumber"], fontfactory.getfont("arial", 15, font.normal, basecolor.black)));             // table.addcell(phrasecell(new phrase("on site work", fontfactory.getfont("arial", 20, font.underline, basecolor.black)), pdfpcell.align_left));             table.addcell(phrasecell(phrase, pdfpcell.align_left));             cell = phrasecell(new phrase(), pdfpcell.align_right);             cell.colspan = 2;             cell.paddingbottom = 13f;             table.addcell(cell);                //separater line             color = new basecolor(system.drawing.colortranslator.fromhtml("#a9a9a9"));             drawline(writer, 25f, document.top - 79f, document.pagesize.width - 25f, document.top - 79f, color);             drawline(writer, 25f, document.top - 80f, document.pagesize.width - 25f, document.top - 80f, color);             document.add(table);               table = new pdfptable(2);             table.setwidths(new float[] { 2f, 10f });             table.totalwidth = 480f;             table.lockedwidth = true;             table.spacingbefore = 15f;             table.horizontalalignment = element.align_right;                table.addcell(phrasecell(new phrase("company: ", fontfactory.getfont("arial", 10, basecolor.black)), pdfpcell.align_left));             phrase = new phrase(new chunk(dr["company"] + "          " + "           " + "          " + "           " + "           " + "           " + "           " + "email: " + dr["email"], fontfactory.getfont("arial", 10, font.normal, basecolor.black)));             table.addcell(phrasecell(phrase, pdfpcell.align_left));             cell = phrasecell(new phrase(), pdfpcell.align_center);             cell.colspan = 7;             cell.paddingbottom = 10f;             table.addcell(cell);              table.addcell(phrasecell(new phrase("plant: ", fontfactory.getfont("arial", 10, basecolor.black)), pdfpcell.align_left));             phrase = new phrase(new chunk(dr["plant"] + "          " + "           " + "          " + "           " + "           " + "           " + "          " + "contact tel: " + dr["contacttel"], fontfactory.getfont("arial", 10, font.normal, basecolor.black)));             table.addcell(phrasecell(phrase, pdfpcell.align_left));             cell = phrasecell(new phrase(), pdfpcell.align_center);             cell.colspan = 2;             cell.paddingbottom = 10f;             table.addcell(cell);              table.addcell(phrasecell(new phrase("contact person: ", fontfactory.getfont("arial", 10, basecolor.black)), pdfpcell.align_left));             phrase = new phrase(new chunk(dr["contactperson"] + "          " + "           " + "          " + "           " + "           " + "           " + "fax no: " + dr["faxno"], fontfactory.getfont("arial", 10, font.normal, basecolor.black)));             table.addcell(phrasecell(phrase, pdfpcell.align_left));             cell = phrasecell(new phrase(), pdfpcell.align_center);             cell.colspan = 2;             cell.paddingbottom = 10f;             table.addcell(cell);             document.add(table);             document.newpage();              try        {    string constring = "data source=(local);initial catalog=fauma;user id=sa;password=p@ssw0rd";             string query = "update onsiteworktx set processed = 'true' company = '" + dropdownlistpdf.text + "'and processed = 'false'";             sqlconnection condatabase = new sqlconnection(constring);             sqlcommand cmddatabase = new sqlcommand(query, condatabase);             sqldatareader reader;             condatabase.open();             reader = cmddatabase.executereader();              while (reader.read())             {             }          }         catch (exception ex)         {             response.write(ex.message);         }                 {              condatabase.close();          }             document.close();              byte[] bytes = memorystream.toarray();             memorystream.close();             response.clear();                   //save attachment                  response.contenttype = "application/pdf";                 response.addheader("content-disposition", "attachment; filename=onsitework.pdf");                 response.contenttype = "application/pdf";                 response.buffer = true;                 response.cache.setcacheability(httpcacheability.nocache);                 response.binarywrite(bytes);                 response.end();                 response.close();             }         }       }

to update company selected in dropdownlist, need this.

try {          string constring = "data source=(local);initial catalog=fauma;user id=sa;password=p@ssw0rd";      string query = @"update onsiteworktx set processed = 1                        company = @company , processed = 0";      using(sqlconnection condatabase = new sqlconnection(constring))      using(sqlcommand cmddatabase = new sqlcommand(query, condatabase))      {          cmddatabase.parameters.addwithvalue("@company", dropdownlistpdf.text);          condatabase.open();          cmddatabase.executenonquery();      } } catch (exception ex) {     response.write(ex.message); }

you prepare command using parameterized query instead of string concatenation , use 1 executenonquery update relevant records company. notice passing strings 'true' or 'false' values bit field in sqlserver doesn't work. pass 1 true , 0 false.

concerning execution of code every row returned getdata method, coud refactor code in way

protected void generatereport(object sender, eventargs e) {     datatable dt = getdata("select * onsiteworktx docid = " +                             dropdownlistpdf.selecteditem.value);     foreach(datarow dr in dt.rows)     {         preparedocument(dr);     } }

where preparedocument code have written , works on single row

private void preparedocument(datarow dr) {     document document = new document(pagesize.a4, 88f, 88f, 10f, 10f);     font normalfont = fontfactory.getfont("arial", 12, font.normal, basecolor.black);      using (system.io.memorystream memorystream = new system.io.memorystream())     {          ...... code above, datarow passed calling method     } }

Comments

Post a Comment

Popular posts from this blog

C# random value from dictionary and tuple -

-
i have following code, , need random item contains string "region_1" dictionary. public static dictionary<int, tuple<string, int, currencytype>> itemarray = new dictionary<int, tuple<string, int, currencytype>>() { { 0xb3e, new tuple<string, int, currencytype>("region_1", 1500, currencytype.fame) } }; public static int generateitemid(string shopid) { var generateditem = itemarray.elementat(new random().next(0, itemarray.count)).key; } how select this? it's not possible efficiently... first create static random @ class level... prevent non-random behaviour if run query on short period of time... (it's seeded discrete clock) static random rnd = new random(); then: var item = itemarray.values .where(t => t.item1 == shopid) .orderby(_ => rnd.next()) .firstordefault()
Read more

cgi - How do I interpret URLs without extension as files rather than missing directories in nginx? -

-
so i'm trying install zoneminder , have run under nginx, has few compiled files need run using fast-cgi. these files lack extension. if file has extension, there no issue , nginx interprets file , return 404 if can't find it. if has no extension, assume it's directory , return 404 when can't find sort of index page. here have now: # security camera domain. server { listen 888; server_name mydomain.com; root /srv/http/zm; # enable php support. include php.conf; location / { index index.html index.htm index.php; } # enable cgi support. location ~ ^/cgi-bin/(.+)$ { alias /srv/cgi-bin/zm/; fastcgi_pass unix:/run/fcgiwrap.sock; fastcgi_param script_filename $document_root/$1; include fastcgi.conf; } } the idea is, under cgi-bin directory goes through fastcgi pipe. any idea on howi can fix this? upon closer inspection, realized zoneminder has 2 cgi sc...
Read more

.htaccess - htaccess convert request to clean url and add slash at the end of the url -

-
ok , searched more 4 days , more 20 posts here in stach or in websites without kind of success first here htaccess file rewriteengine on rewriterule ^([a-za-z0-9_]+)/?$ index.php?page=$1 [nc] rewriterule ^([a-za-z0-9_]+)\/([a-za-z0-9_]+)\/?$ index.php?page=$1&action=$2 [nc] i tried many codes 1 worked me can call request , works me www.example.com/pagename => www.example.com/index.php?page=pagename here questions , please provide me information "in detail" understand code well 1- how convert request automatically www.example.com/index.php?page=pagename www.example.com/pagename 2- if tried add slash @ end shows me page without images or styling mean www.example.com/pagename => works www.example.com/pagename/ => doesn't work that's :) for first part need 301 rule this: rewritecond %{the_request} /index\.php\?page=([^\s&]+) [nc] rewriterule ^ /%1? [r=301,l] for second part use absolute path in css, js, images files r...
Read more