Convert a document file to pdf in c# web api -


i saving data table. in table have column called attacheddocumentno pdf file. ok here table structure:

create table tblrequirementtype(     [pkid] [bigint] identity(1,1) not null,     [szdescription] [varchar](max) null,     [irequirementtypeid] [bigint] not null,     [szrequirementnumber] [varchar](100) null,     [szrequirementissuer] [varchar](200) null,     [szorganization] [varchar](250) null,     [dissuedate] [datetime] null,     [dexpirydate] [datetime] null,     [szsignedby] [varchar](250) null,     [szattacheddocumentno] [varchar](200) null,     [dstampdate] [datetime] null,     [szsubject] [varchar](250) null,     [iapplicationdetailsid] [bigint] null,     [iempid] [bigint] null,     constraint [pk_tblrequirementtype] primary key clustered      (         [pkid] asc     )with (pad_index = off, statistics_norecompute = off, ignore_dup_key = off, allow_row_locks = on, allow_page_locks = on) on [primary]     ) on [primary] textimage_on [primary]      go      set ansi_padding off     go      alter table [dbo].[tblrequirementtype] add  constraint [df_tblrequirementtype_irequirementtypeid]  default ((-1)) [irequirementtypeid]     go      alter table [dbo].[tblrequirementtype] add  constraint [df_tblrequirementtype_szsubject]  default ('') [szsubject]     go      alter table [dbo].[tblrequirementtype] add  constraint [df_tblrequirementtype_iappid]  default ((-1)) [iapplicationdetailsid]     go     alter table [dbo].[tblrequirementtype] add  constraint [df_tblrequirementtype_iempid]  default ((-1)) [iempid]    go

so created web api service post data table. following api class:

    [route("postrequirementtypeprocessing")]     public ienumerable<npaaddrequirementtypeprocessing> postrequirementtypeprocessing(mdladdaddrequirementtypeprocessing requtypeprocess)     {         mdladdaddrequirementtypeprocessing rtyeprocessing = new mdladdaddrequirementtypeprocessing();           httpfilecollection hfc = httpcontext.current.request.files;          //filename = requtypeprocess.szsubject;         rtyeprocessing.szdescription = requtypeprocess.szdescription;         rtyeprocessing.irequirementtypeid = requtypeprocess.irequirementtypeid;         rtyeprocessing.szrequirementnumber = requtypeprocess.szrequirementnumber;         rtyeprocessing.szrequirementissuer = requtypeprocess.szrequirementissuer;         rtyeprocessing.szorganization = requtypeprocess.szorganization;         rtyeprocessing.dissuedate = requtypeprocess.dissuedate;         rtyeprocessing.dexpirydate = requtypeprocess.dexpirydate;         rtyeprocessing.szsignedby = requtypeprocess.szsignedby;         rtyeprocessing.szattacheddocumentno = requtypeprocess.szattacheddocumentno;         if (string.isnullorempty(rtyeprocessing.szattacheddocumentno))         {          }         else         {             uploadfiles(hfc);         }         rtyeprocessing.szsubject = requtypeprocess.szsubject;         rtyeprocessing.iapplicationdetailsid = requtypeprocess.iapplicationdetailsid;         rtyeprocessing.iempid = requtypeprocess.iempid;          npaentities context = new npaentities();         log.debug("postrequirementtypeprocessing request traced");          var newrtp = context.npaaddrequirementtypeprocessing(requtypeprocess.szdescription, requtypeprocess.irequirementtypeid,                                      requtypeprocess.szrequirementnumber, requtypeprocess.szrequirementissuer, requtypeprocess.szorganization,                                      requtypeprocess.dissuedate, requtypeprocess.dexpirydate, requtypeprocess.szsignedby,                                      requtypeprocess.szattacheddocumentno, requtypeprocess.szsubject, requtypeprocess.iapplicationdetailsid,                                      requtypeprocess.iempid);          return newrtp.tolist();     }

what want that, when saving database, should save szattacheddocumentno should saved pdf file in column.

i did search on internet , got piece of code , tried transformed need:

    public string uploadfiles(httpfilecollection strdocpath)     {         int iuploadedcnt = 0;          // define path want save files.         string spath = "";         //spath = system.web.hosting.hostingenvironment.mappath("~/locker/");          spath = convert.tostring(configurationmanager.appsettings["profilepath"]);          //httpfilecollection hfc = httpcontext.current.request.files;         httpfilecollection hfc = strdocpath;          // check file count.         (int icnt = 0; icnt <= hfc.count - 1; icnt++)         {             httppostedfile hpf = hfc[icnt];              if (hpf.contentlength > 0)             {                 // check if selected file(s) exists in folder. (avoid duplicate)                 if (!file.exists(spath + path.getfilename(hpf.filename)))                 {                     // save files in folder.                     hpf.saveas(spath + path.getfilename(hpf.filename));                     iuploadedcnt = iuploadedcnt + 1;                 }             }         }          // return message (optional).         if (iuploadedcnt > 0)         {             return iuploadedcnt + " files uploaded successfully";         }         else         {             return "upload failed";         }     }

cool. when run code , passed data swagger, have 2 different issues:

1-the first issue is, let's created docx file anywhere or in c:/ on machine , passes data follows:

 {     "szdescription": "business registration",     "irequirementtypeid": 30012,     "szrequirementnumber": "br3363347g",     "szrequirementissuer": "environment protection agency",     "szorganization": "blue ocean limited",     "dissuedate": "2014-02-09 00:00:00.000",     "dexpirydate": "2018-02-09 00:00:00.000",     "szsignedby": "somad",     "szattacheddocumentno": "c:\files\doc3.docx",     "szsubject": "sub1",     "iapplicationdetailsid": 01     "iempid": 40021 }

i got error saying: "object reference not set instance of object." error, know passing wrong data somewhere, , realized it's @ 'szattacheddocumentno' after debugging code. tried following second issue:

2-here passed name of document "doc3.docx". data have been saved database that's not looking for:

{    "szdescription": "business registration",    "irequirementtypeid": 30012,    "szrequirementnumber": "br3363347g",    "szrequirementissuer": "environment protection agency",    "szorganization": "blue ocean limited",    "dissuedate": "2014-02-09 00:00:00.000",    "dexpirydate": "2018-02-09 00:00:00.000",    "szsignedby": "somad",    "szattacheddocumentno": "doc3.docx",    "szsubject": "sub1",    "iapplicationdetailsid": 01    "iempid": 40021

}

i wnt way convert doc3.docx string in database, sorry in table...

thanks, appreciated.

somad y.

you need escape backslashes in path:

"c:\\files\\doc3.docx"

your json missing comma @ end of iapplicationdetailsid line, , 01 isn't valid json number.

valid json:

{     "szdescription": "business registration",     "irequirementtypeid": 30012,     "szrequirementnumber": "br3363347g",     "szrequirementissuer": "environment protection agency",     "szorganization": "blue ocean limited",     "dissuedate": "2014-02-09 00:00:00.000",     "dexpirydate": "2018-02-09 00:00:00.000",     "szsignedby": "somad",     "szattacheddocumentno": "c:\\files\\doc3.docx",     "szsubject": "sub1",     "iapplicationdetailsid": 1,     "iempid": 40021 }

Comments

Post a Comment

Popular posts from this blog

asynchronous - C# WinSCP .NET assembly: How to upload multiple files asynchronously -

i using winscp .net assembly uploading files. want upload multiple files asynchronous way. have created method works single upload. public class uploadingdata { private sessionoptions _sessionoptions; private session _session; //connection etc private void onconnected() { foreach (var fileinfo in localfileslist) { var task = task.factory.startnew(() => uploadfilesasync(fileinfo)); } } private async task uploadfilesasync(string file) { string remotefilepath = _session.translatelocalpathtoremote(file, @"/", "/test_data_upload"); var uploading = _session.putfiles(file, remotefilepath, false); //when done await task.run(() => thread.sleep(1000)); } } please suggest me correct way. thanks you can use backgroundworker class this: string[] images = new string[50]; foreach (var path in images) { backgroundworker
Read more

aws api gateway - SerializationException in posting new Records via Dynamodb Proxy Service in API -

i getting "__type": "com.amazon.coral.service#serializationexception" as reply in postman & in test console in api gateway trying post record directly dynamodb using api proxy services.. referring aws article - https://aws.amazon.com/blogs/compute/using-amazon-api-gateway-as-a-proxy-for-dynamodb/ here's mapping { "tablename": "tablenamegoeshere", "item": { "id" : "$context.requestid" "eventname" : "$input.path('$.eventname')", "timestamp" : $input.path('$.timestamp'), "answers": "$util.parsejson($input.path('$.answers'))" } } update: did asked ... , worked if try add array of json objects gives me above same error - here's trying now. please - couldnt find on google well #set($inputroot = $input.path('$')) { "tablename": "answer", "item": {
Read more

asp.net - Problems sending emails from forum -

i have been redesigning site has message board, has been written guy looked after site. it has few problems , written in .asp , uses .mdb files database. you can see whole thing here . feel free post if helps, test thing have set using original files , new database. the basic problem when posts message, supposed email sent them, have posted it. when replies, originator supposed message, replier has been posted. i’d have thought @ point in process there should script/file in postmessage.asp? the postmessage.asp page below. <% option explicit %> <!-- #include virtual="common/adovbs.inc" --> <html> <head> <meta http-equiv="content-type" content="text/html; charset=windows-1252"> <meta name="generator" content="microsoft frontpage 4.0"> <meta name="progid" content="frontpage.editor.document"> <title>new page 2</title> <base target="_self"
Read more