c# - Passing List of Data to Other Controller -


so have action method in controller data csv file uploaded through web

i want pass data insert controller data csv automatically inserted tables in db , pass view

i'm using csv helper, mvc

        public actionresult importcsv(httppostedfilebase file, int compid)         {             var compname = db.couriercompanies.find(compid);              string path = null;              list<myviewmodel> csvd = new list<myviewmodel>();              try             {                 if(file.contentlength > 0)                 {                     var filename = path.getfilename(file.filename);                     path = appdomain.currentdomain.basedirectory + "upload\\" + filename;                     file.saveas(path);                      var csv = new csvreader(new streamreader(path));                     var invocsv = csv.getrecords<importcsv>();                      foreach(var in invocsv)                     {                         myviewmodel icsv = new myviewmodel();                          icsv.custid = i.cust_id;                         icsv.fullname = i.fullname;                         icsv.custcomp = i.company;                         icsv.invoiceno = i.rec_no;                         icsv.insertdate = datetime.parse(i.doc_dt);                         icsv.road = i.w_addr1;                         icsv.city = i.w_city;                         icsv.zip = i.w_zip;                         icsv.phone = i.w_phone;                         icsv.status = "belumterkirim";                         icsv.compid = compid;                         icsv.compname = compname.compname;                         icsv.statdate = datetime.now;                          csvd.add(icsv);                     }                 }             }             catch             {                 viewdata["error"] = "upload failed";             }              return view();         }

insert controller

public actionresult create( myviewmodel model, int compid, httppostedfilebase file)         {             if (file != null)             {                 using (memorystream ms = new memorystream())                 {                     file.inputstream.copyto(ms);                     model.image = ms.getbuffer();                 }             }              var cust = new customer()             {                 custid = model.custid,                 phone = model.phone,                 custcomp = model.custcomp,                 fullname = model.fullname             };              var addrdet = new addrdetail()             {                 road = model.road,                 city = model.city,                 zipcode = model.zip             };              var invoice = new invoice()             {                 invoiceno = model.invoiceno             };              var stat = new status()             {                 status1 = model.status,                 statdate = model.statdate,                 ket = model.ket             };              var image = new models.image()             {                 image1 = model.image             };              var detail = new detailpengiriman()             {                 namapenerima = model.namapenerima,                 statuspenerima = model.statuspenerima,                 trdate = model.trdate,                 insertdate = model.insertdate             };              if (modelstate.isvalid )             {                 //customer                 db.customers.add(cust);                 detail.custid = cust.custid;                 invoice.custid = cust.custid;                  //addrdet                 db.addrdetails.add(addrdet);                 cust.addrdetid = addrdet.addrdetid;                  //invoice                 db.invoices.add(invoice);                 stat.invoiceno = invoice.invoiceno;                 image.invoiceno = invoice.invoiceno;                 detail.invoiceno = invoice.invoiceno;                  //status                 db.status.add(stat);                 detail.statusid = stat.statusid;                  ////image                 db.images.add(image);                 detail.imageid = image.imageid;                  //detail                 detail.compid = compid;                 db.detailpengirimen.add(detail);                  db.savechanges();                  return redirecttoaction("index", new { compid = detail.compid});             }             return view();         }

you can abstract business logic in class , instantiate inside csv action.

this way can call methods inserting customers both actions!


Comments

Post a Comment

Popular posts from this blog

Retrieving ETA (estimated time of arrival) with Google Distance Matrix API and public transit as transport mode -

Image
is possible retrieve eta google's distancematrix api (or alternative api). fyi, eta different duration, when using public transport. following example clarify request. when leave on friday @ 8.15 i'll able catch train @ 8.30 , arrive @ 9.00 am. google says duration 30 minutes. however, when leave on saturday @ 8.15 i'll able catch first train @ 9.00 , arrive @ 9.30 am. google still says duration 30 minutes, means ignore delay. google map supports functionality there api around giving me eta instead of duration. can see, distance-matrix' response no good. clarifying question little. eta estimated time of arrival , it's clear user wants know entire duration of transport (including waiting time public transport).
Read more

javascript - Confirm a form & display message if form is valid with JQuery -

i'm developing django application , use javascript in order improve website. i have form , display 2 things : confirm form before submit if form submitted, display message : 'form saved' it's first time i'm using js , need make process. this code : <form class = "form" method='post' action=''> {% csrf_token %} <br></br> {{ form.as_p}} <br></br> <button type="submit">valider</button> </form> <script> $('#form').submit(function() { var c = confirm("click ok continue?"); return c; //you can return c because true or false }); </script> and if form valid , saved : <script type="text/javascript" > $(document).on('valider', 'form.form', function(form) { var $form = $(form); $.ajax({ ...
Read more

ionic framework - Meteor - Error: Failed to execute 'insertBefore' on 'Node' -

i trying make dynamic list display using meteor, idea load more elements each time bottom of page reached. the html template following : <template name="contacts"> {{#contentfor "headertitle"}} <div class="bar bar-header bar-assertive"> <h1 class="title">contacts :</h1> </div> {{/contentfor}} {{#ionview}} {{#ioncontent}} <div class="list"> {{#each contacts}} <a class="item item-avatar" href="/contacts/{{_id}}"> <img src="/img/ico_client.png"> <h2>{{full_name}}</h2> <p>{{company}}</p> </a> {{/each}} </div> {{#if moreresults}} <div id="showmoreresults" style="margin-left: 25px;"> <span class="loading">loading...</span> </div> {{/if}} {{/ioncontent}} {{/ionview}} </te...
Read more