asp.net mvc - many to one Find(id) entity framework MVC 4 -


i have 1 many relationship between table userprofiles , companies in details action method i'm trying username have company userprofile userid display company owner using find(id) method not working.

the details action method 

    public actionresult details(int id = 0)     {         var companys = db.companys.include(c => c.userprofile.userid);         var company = companys.find(id);         if (company == null)         {             return httpnotfound();         }         return view(company);     }

so i'm doing wrong please correct me , help.

and models company

 public class company {     [scaffoldcolumn(false)]     public int companyid { get; set; }      [required(errormessage = "company name required")]     [displayname("company name")]     [stringlength(40)]     public string companyname { get; set; }      [required(errormessage = "mobile number required")]     [displayname("mobile number")]     //[datatype(datatype.phonenumber)]     public string companyphonenumber { get; set; }      [required(errormessage = "company address required")]     [displayname("company address")]     [stringlength(128)]     public string companyaddress { get; set; }      //must change in view(linq) give manager user     [required(errormessage = "manager name required")]     [displayname("manager name")]     public int userid { get; set; }     public userprofile userprofile { get; set; }      public icollection<store> stores { get; set; }     public icollection<product> products { get; set; } }

}

and userprofile model 

 [table("userprofile")] public class userprofile {      [key]     [databasegeneratedattribute(databasegeneratedoption.identity)]     public int userid { get; set; }     public string username { get; set; }     public icollection<usersinroles> usersinroles { get; set; }     public membership membership { get; set; }     public icollection<company> companys { get; set; }     public icollection<comment> comments { get; set; }     public icollection<like> likes { get; set; }  }  }

try : 

 public actionresult details(int id = 0)     {         var companys = db.companys.where(x => x.companyid == id).tolist();         if (companys == null)         {             return httpnotfound();         }         return view(companys);     }

Comments

Post a Comment

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

i have add following code htaccess file removing .php extension , add trailing slash urls. worked fine reduced page loading speed , css code not loading @ all. pages ugly. please help rewriteengine on rewritebase / ## hide .php extension snippet # externally redirect /dir/foo.php /dir/foo rewritecond %{the_request} ^[a-z]{3,}\s([^.]+)\.php [nc] rewriterule ^ %1/ [r,l] # add trailing slash rewritecond %{request_filename} !-f rewritecond %{request_uri} !/$ rewriterule . %{request_uri}/ [l,r=301] # internally forward /dir/foo /dir/foo.php rewritecond %{request_filename} !-d rewritecond %{request_filename}.php -f rewriterule ^(.*?)/?$ $1.php [l] we can rewrite urls using .htaccess files. before writing in .htaccess files need verify kind of server using. can check server adding a <?php phpinfo(); ?> in php page. ensure mod_rewrite module enabled in apache server. can identified checking phpinfo included page. common methods used url rewriting follows ...
Read more

inno setup - TLabel or TNewStaticText - change .Font.Style on Focus like Cursor changes with .Cursor -

is possible change .font.style on focus tlabel or tnewstatictext happens cursor when use .cursor ? there no built-in support track mouse hovering in inno setup @ time. however, intercepting window procedure of controls can track yourself. following example need innocallback library: [setup] appname=my program appversion=1.5 defaultdirname={pf}\my program outputdir=userdocs:inno setup examples output [files] source: "innocallback.dll"; destdir: "{tmp}"; flags: dontcopy [code] #ifdef unicode #define aw "w" #else #define aw "a" #endif const gwl_wndproc = -4; wm_mousemove = $0200; type wparam = uint_ptr; lparam = longint; lresult = longint; twindowproc = function(hwnd: hwnd; umsg: uint; wparam: wparam; lparam: lparam): lresult; function setcapture(hwnd: hwnd): hwnd; external 'setcapture@user32.dll stdcall'; function releasecapture: bool; external 'releasecapture@user32.dll stdcall'; func...
Read more