c# - How to pass method (class) into ApiController? -
i have class called query contains function calls data using sql query.
public static userdetails[] binddatatable() { datatable dt = new datatable(); list<userdetails> details = new list<userdetails>(); using (sqlconnection con = new sqlconnection(configurationmanager.connectionstrings["###"].connectionstring)) { using (sqlcommand cmd = new sqlcommand("select top 3 deal, [property], [event] [dbo].[database_cre_events]", con)) { con.open(); sqldataadapter da = new sqldataadapter(cmd); da.fill(dt); foreach (datarow dtrow in dt.rows) { userdetails user = new userdetails(); user.deal = dtrow["deal"].tostring(); user.loanproperty = dtrow["property"].tostring(); user.events = dtrow["event"].tostring(); details.add(user); } } } return details.toarray(); } i know how can pass query webapi controller? possible, not find examples online further guide me build.
public class testcontroller : apicontroller { private cdwentities db = new cdwentities(); private query respository; [httpget] public httpresponsemessage getdata() { // not sure how pass method query class here? } } many help.
first of why method in static?
public static userdetails[] binddatatable() so if static must consume this.
var result = query.binddatatable(); but if mistake must consume this, current implementation correct, have remove static modifier , call on respository instance.
[httpget] public httpresponsemessage getdata() { var result = repository.binddatatable(); }
Comments
Post a Comment