asp.net mvc 3 - MVC3- Controller acces to several tables -


i new mvc, in following text may confusing :d can tell me, how write controller database tables following code in models:

public class kniha //in translate=book {     public int knihaid { get; set; } [maxlength(100, errormessage="text knihy muze byt dlouhy max 100 znaku")]     public string nazevknihy { get; set; }      public datetime datumvydani { get; set; }     public string popisknihy { get; set; }     public int pocetstran { get; set; }     public int pocetkapitol { get; set; }     public int autorid { get; set; }     public virtual autor autor { get; set; }     public virtual icollection<zanr> knihazanry { get; set; }     public virtual icollection<cenik> knihaceniky { get; set; } } public class autor //in translate= author     {         public int autorid { get; set; }         public string jmeno { get; set; }         public string heslo { get; set; }         public string prijmeni { get; set; }         public string stat { get; set; }         public string mesto { get; set; }         public string ulice { get; set; }         public datetime datumnarozeni { get; set; }         public int telefonicislo { get; set; }         public string email { get; set; }         public string konto { get; set; }         public string celejmeno         {                         {                 return jmeno + " " + prijmeni;             }         }         public virtual icollection<kniha> napsaneknihy { get; set; }     } public class cenik //in translate=price     {         public int cenikid { get; set; }         public int aktualnicena { get; set; }         public datetime datumceny { get; set; }         public kniha kniha { get; set; }         public virtual zamestnanec zamestnanec { get; set; }         public int zamestnanecid { get; set; }         public int knihaid { get; set; }     }  public class zanr //in translate=genre     {         public int zanrid { get; set; }         [maxlength(50, errormessage="maximalni delka 50 znaku!!")]         public string nazevzanru { get; set; }         public virtual icollection<kniha> zanrknihy { get; set; }     }  public class autorknihadalsi     {             public ienumerable<autor> autori { get; set; }             public ienumerable<kniha> knihy { get; set; }             public ienumerable<zanr> zanry { get; set; }             public ienumerable<cenik> ceniky { get; set; }      }

this controller, doesnt work:

public actionresult index()     {         var viewinfo = new autorknihadalsi();         viewinfo.knihy = db.knihy.include(c => c.autor).include(i=> i.knihaceniky.select(c=> c.aktualnicena));         return view(viewinfo);     }

i wanted print information books. in every book wanted print author, actual price , genre. dont know, how controller this. secondly want ask how execute saved t-sql procedures on server( found informations here on web, did not help). edit: tables complete


Comments

Post a Comment

Popular posts from this blog

Change php variable from jquery value using ajax (same page) -

what i'm trying this: i've php global variable $currentid , simple jquery script check if there "id" (page) in hash of url , if yes wanted give value $currentid . i've been reading lot , notice shall use ajax i'm not managing it. my code is: <script type="text/javascript"> $(document).ready(function(){ if (parent.location.hash != '' ) { var thecurrentid = parent.location.hash.split('#')[1]; $.ajax({ url: 'my.php', //current page type: 'post', data: {theid: thecurrentid }, datatype: 'json', success: function () { } }); } // code here }); </script> could me please? thank in advance. php server side language, meaning once has sent data browser, php variables , data cannot changed... however, using ajax, can send request php page , change data in dom based on result. consider th...
Read more

Pull out data related to my apps from Android Play Store and iOS App Store -

i want pull out data related apps (ratings, reviews, etc) google play store , apple app store ? how can accomplish ? i have found open source apis google mentioned not reliable. also there paid apis (e.g. appfigures) available. has idea how able pull data these play stores ?? i looking direction on how can accomplish this. can suggest ? we (appfigures) have been working on developing infrastructure give ability reviews , bunch of other data points major app stores several years :] we make available via our api though may want check out.
Read more

How can I fetch data from a web server in an android application? -

i want retrieve data web server in android application, , don't know begin. should use web services? i recommend these tutorials: connect android php , mysql , json in android , php , mysqli i used these tutorials , managed trying working without difficulty. between them describe each step in how attempting @ each stage, android application, database , web server side , has information included can process , use received information the thing add connect android php , mysql tutorial makes use of mysql_ in php deprecated. better use mysqli why included third link. the basic outline of want this: 1) in android app make request server php script using class this: import java.io.bufferedreader; import java.io.ioexception; import java.io.inputstream; import java.io.inputstreamreader; import java.io.unsupportedencodingexception; import java.util.list; import org.apache.http.httpentity; import org.apache.http.httpresponse; import org.apache.http.namevaluepair...
Read more