c# - Create CSV with columns selected by the user -


i have little design problem. let's have project contains large number of people. want allow user export people csv file information chooses.
example, choose id, name, phone number , according choice create file.
of course, there simple of way doing if(idcheckbox.checked) getid(); etc.
i'm looking better. don't want each new option add need change ui (e.g. new checkbox).
thought of reading possible options file, solved ui problem. how know values without using "if's" again?

you don't need fancy design pattern task. understand have identified reason change (added options in future). want minimize amount of classes modified.

your real problem how decouple csv creation objects structure going change. don't want parsing logic affected whenever person class changed.

in following example csv object decoupled objects receives , parses. achieve this, coding abstraction rather implementation. way not coupled person object, welcome objects implement attributedobject interface. dependency being injected our csv parser.

i implemented in php, idea same. c# static language, fetching attributes bit of change. might use kind of arrayaccess interface.

interface attributedobject {     public function getattribute($attribute); }  class person implements attributedobject {      protected $firstname;     protected $lastname;     protected $age;     protected $iq;      public function __construct($firstname, $lastname, $age, $iq)     {         $this->firstname = $firstname;         $this->lastname = $lastname;         $this->age = $age;         $this->iq = $iq;     }      public function getattribute($attribute)     {         if(property_exists($this, $attribute)) {             return $this->$attribute;         }         throw new \exception("invalid attribute");     } }  class csv {      protected $attributedobject = null;     protected $attributestodisplay = null;     protected $csvrepresentation = null;     protected $delimiter = null;      public function __construct(attributedobject $attributedobject, array $attributestodisplay, $delimiter = '|')     {         $this->attributedobject = $attributedobject;         $this->attributestodisplay = $attributestodisplay;         $this->delimiter = $delimiter;          $this->generatecsv();     }      protected function generatecsv()     {         $tempcsv = null;          foreach ($this->attributestodisplay $attribute) {             $tempcsv[] = $this->attributedobject->getattribute($attribute);         }          $this->csvrepresentation = $tempcsv;     }      public function storecsv()     {         $file = fopen("tmp.csv", "w");         fputcsv($file, $this->csvrepresentation, $this->delimiter);     } }  $person1 = new person('john', 'doe', 30, 0); $csv = new csv($person1, array('firstname', 'age', 'iq')); $csv->storecsv();

Comments

Post a Comment

Popular posts from this blog

searchKeyword not working in AngularJS filter -

i writing app using angularjs on front end. want search through table word/field; 1 search box everything. according article here: http://hello-angularjs.appspot.com/searchtable can use filter: searchkeyword this. this code, , not working expected. <label>search: <input ng-model="searchkeyword"></label> <table ng-repeat="post in posts | orderby: sort | filter: searchkeyword"> <tr> <td> {{index(post)}} </td> <td> {{post.title}} </td> <td> {{post.author}} </td> <td> {{post.content}} </td> <td> {{post.date | date: "d/m/yyyy"}} </td> </tr> </table> what should do? thank you try this: controller $scope.posts = [ {title:'title one', author:'author one', content: 'content one'}, {title:'title two', author:'author two', content: 'cont...
Read more

sequelize.js - Sequelize: sort by enum cases -

i have model ( article ) field (the name type ) of type enum('source', 'translated') , return 1 article ordered type field. source articles should returned before translated articles. like: article.findone(order: [ { type: [ 'source', 'translated' ] } ]); unfortunately there appears no built-in solution sorting enums. instead have sort by case , couldn't find documentation on how sequelize. what conventional approach here? sorting case hard in sequelize, sort field (the second answer in linked post) should possible: order: sequelize.fn('field', sequelize.col('type'), 'source', 'translated') it's supported mysql far know though
Read more

user interface - how to replace an ongoing process of image capture from another process call over the same ImageLabel in python's GUI TKinter -

i trying use following code create interactive gui changes color-space(hsv, rbg, grayscale etc) on event of button click. display opencv video in tkinter using multiprocessing being new python having problems multiprocessing , attempts on making gui change it's color space on button clicks hangs entire system. on it's implementation highly appreciated. thankyou. below code: import cv2 pil import image,imagetk import tkinter tk import numpy np multiprocessing import process , queue def quit_it(root,process): root.destroy() process.terminate() def black_andwhite(root,process): process.terminate p=process(target=capture_image, args=(5,queue, )) p.start() root.after(0, func=lambda: update_all(root, image_label, queue)) def update_image(image_label, queue): frame = queue.get() = image.fromarray(frame) b = imagetk.photoimage(image=a) image_label.configure(image=b) image_label._image_cache = b root.update() def update_all(root...
Read more