c# - Populating List with related information -

-

i have list view populated using controller:

        public actionresult listclubmembershiptype(int clubid)     {         //populate list         var types = s in db.membershiptypes                     (s.clubid == clubid)                     orderby s.type                     select s;         viewbag.typescount = types.count();         var model = types.select(t => new listmembershiptypeviewmodel                 {         type = t.type,         clubid = clubid,         cost = t.cost,         reducedcost = t.reducedcost,         minage = t.minage,         maxage = t.maxage,     });          return partialview("_listclubmembershiptype", model);     }

i populate variable in view model called reduceddate data pulled 2 other tables, day & month.

ive tried following line:

            reduceddate = db.days.find(t.dayid).daynum + "/" + db.months.find(t.monthid).monthname,

but gives following error:

additional information: method 'grcwebapp.models.day find(system.object[])' declared on type 'system.data.entity.dbset1[grcwebapp.models.day]' cannot called instance of type 'system.data.entity.core.objects.objectquery1[grcwebapp.models.day]'

what correct way reference data?

the models are:

membershiptype

public int membershiptypeid { get; set; }  [stringlength(150)] [column(typename = "nvarchar")] public string type { get; set; }  [stringlength(350)] [column(typename = "nvarchar")] public string description { get; set; }  [column(typename = "int")] public int clubid { get; set; }  [column(typename = "decimal")] public decimal cost { get; set; }  [column(typename = "decimal")] public decimal reducedcost { get; set; }  [column(typename = "int")] public int? dayid { get; set; }  [column(typename = "int")] public int? monthid { get; set; }  [column(typename = "int")] public int minage { get; set; }  [column(typename = "int")] public int maxage { get; set; }  [column(typename = "bit")] public bool? dormant { get; set; } }

the day model:

public class day { public int dayid { get; set; }  [column(typename = "int")] public int daynum { get; set; }  public virtual icollection<membershiptype> membershiptypes { get; set; } }

the month model:

    public class month { public int monthid { get; set; }  [column(typename = "nvarchar")] public string monthname { get; set; }  public virtual icollection<membershiptype> membershiptypes { get; set; } }

and viewmodel is:

    public class listmembershiptypeviewmodel { [display(name = "type")] public string type { get; set; }  public int clubid { get; set; }  [display(name = "full cost")] public decimal cost { get; set; }  [display(name = "reduced cost")] public decimal reducedcost { get; set; }  [display(name = "reduced from")] public string reduceddate { get; set; }  [display(name = "min age")] public int minage { get; set; }  [display(name = "max age")] public int maxage { get; set; } }

you have dayid , monthid on membershiptype don't have properties of public day day {get;set;} , public month month {get;set;}

if had properties use reduceddate = t.day.daynum + "/" + t.month.monthname

this might give error since daynum int you'll need convert daynum string. can use sqlfunctions.stringconvert((double)t.day.daynum) this.


Comments

Post a Comment

Popular posts from this blog

rewrite asp to php based on asp query -

-
i have seen several questions similar , tried solutions @ loss. need redirect example.com/products.asp?lob=health to example.com/services/healthcare/ i need several lob= different value . there way can redirect each url. maybe kind of rewrite condition on lob if value of lob = health, redirect here. if equals home, redirect somewhere else? not sure "correct" way works. rewritecond %{query_string} ^lob=value1$ [nc] rewriterule ^products.asp$ http://example.org/sample/one/? [r=301,l] and different value: rewritecond %{query_string} ^lob=value2$ [nc] rewriterule ^products.asp$ http://example.org/sample/two/? [r=301,l] and doesn't match value: rewriterule ^products\.asp$ [insert new url here] [r=301,l] the last example works if want redirect .asp url .php. keep in mind have other conditions , rules removing .php extension , adding / files: rewritecond %{request_filename} !-f rewriterule ^([^/]+)/$ $1.php rewriterule ^([^/]+)/([^/]+)/$ /$1...
Read more

android - questions about switching from C2DM to GCM -

-
i'm converting app c2dm gcm , have questions. i've modified gcmquickstart example found here: git clone https://github.com/googlesamples/google-services.git in class extends application, i've got: public class myapp extends application { @override public void oncreate() { super.oncreate(); if (this.checkplayservices()) { intent intent = new intent(this, registrationintentservice.class); startservice(intent); } else{ log.e(tag,"failed checkforgcm"); } } } afaik, starts service , it'll run forever or if operating system shuts down whereupon operating system restart it. correct? checkplayservices() makes sure android 2.3 or greater , google play services installed these requirements use gcm. correct? public class registrationintentservice extends intentservice{ private static final string tag = "regintentservice"; public registratio...
Read more

visual studio 2010 - Error on RDLC Expression -

-
i using exp calculate total fees paid on rdlc report: =sum(iif(fields!responsedescription.value ="approved successful",int(fields!amount.value), 0)) and #error in resulting column , can issue ? . and similar exp above work fine : =sum(iif(fields!responsedescription.value <> "",int(fields!amount.value), 0)) few notes: 1- amount integer , present. 2- responsedescription string , present. thank you you can use expression: =sum(cint(iif(fields!responsedescription.value ="approved successful", fields!amount.value, 0))) you have convert every possible values same type before aggregation. i think second expression works fine because in true case ( fields!responsedescription.value <> "" ) used expression converted integer .
Read more