asp.net mvc - Advice on datamodel structure -


i'm practicing asp.net mvc 5, , i'm attempting build prototype events directory. i've started basic layout, adapted contoso university tutorial, want start develop more complex data model, i'm unsure best way develop model, specifically, different pricing options each listing can have.

my current data model is;

vendors

 public class vendor {     public int id { get; set; }     [required]     [display(name = "company name")]     [stringlength(50, errormessage = "company name cannot longer 50 characters.")]     public string companyname { get; set; }     [required]     [display(name = "first name")]     [stringlength(50, errormessage = "first name cannot longer 50 characters.")]     public string contactfirstname { get; set; }     [required]     [display(name = "last name")]     [stringlength(50, errormessage = "last name cannot longer 50 characters.")]     public string contactlastname { get; set; }     [required]     [display(name = "address")]     public string address { get; set; }     [required]     [display(name = "address line 2")]     public string addressline2 { get; set; }     [required]     public string region { get; set; }     [required]     public string city { get; set; }     [required]     public string postcode { get; set; }     [required]     [display(name = "email address")]     public string email { get; set; }     [required]     [display(name = "phone number")]     public string phone { get; set; }     [display(name = "twitter @username")]     public string twitterhandle { get; set; }     [display(name = "facebook url")]     public string facebookurl { get; set; }     [required]     [display(name = "active vendor?")]     public boolean activestatus { get; set; }      public virtual icollection<listing> listings { get; set; } }

listings

public class listing {     public int listingid { get; set; }     public int categoryid { get; set; }     public int vendorid { get; set; }     [required]     [display(name = "listing name")]     public string listingname { get; set; }     [required]     [display(name = "listing description")]     public string listingdesc { get; set; }     [required]     [display(name = "maximum capacity")]     public int capacity { get; set; }     [required]     [datatype(datatype.currency)]     [display(name = "price per guest")]     public decimal priceperguest { get; set; }     [required]     public string address { get; set; }     [display(name = "address line 2")]     public string address2 { get; set; }     [required]     public string city { get; set; }     [required]     public string postcode { get; set; }      public virtual category category { get; set; }     public virtual vendor vendor { get; set; } }

categories

 public class category     {         [databasegenerated(databasegeneratedoption.none)]         public int categoryid { get; set; }         public string categoryname { get; set; }         public string categorydescription { get; set; }          public virtual icollection<listing> listings { get; set; }     }

ideally, i'd add listing table new property called 'fixed price', giving vendors option either list price per guest or fixed price, not vendors can price services price per guest.

is separate table pricing options sufficient enough develop further?

p.s - haven't yet started format entities yet, hence why categories missing validation , on.

price (currency) , isfixedprice (bit) instead of priceperguest

thanks @nikhil vartak answer


Comments

Post a Comment

Popular posts from this blog

inversion of control - Autofac named registration constructor injection -

does autofac support specifying registration name in components' constructors? example: ninject's namedattribute . you need use autofac.extras.attributed package on top achieve this so let's have 1 interface , 2 classes: public interface ihello { string sayhello(); } public class englishhello : ihello { public string sayhello() { return "hello"; } } public class frenchhello : ihello { public string sayhello() { return "bonjour"; } } then have consumer class, in want select instance injected: public class helloconsumer { private readonly ihello helloservice; public helloconsumer([withkey("en")] ihello helloservice) { if (helloservice == null) { throw new argumentnullexception("helloservice"); } this.helloservice = helloservice; } public string sayhello() { return this.helloservice.sayhello()...
Read more

verilog - Systemverilog dynamic casting issues -

i've code snippet following in testbench function void write_to_port( my_data_type_base data ); my_data_type_extended data_ext; if(!$cast(data_ext, data)); `uvm_error(get_type_name(), "failed cast"); `uvm_info(get_name(), $psprintf("data_ext :\n%s", data_ext.sprint()), uvm_medium) // write data_ext out port.... endfunction when run it, i'm getting uvm_error "failed cast." i'm not quire sure why $cast not returning 1. can see, i'm printing out extended class data item after casting uvm_info. can see it's being cast properly. if don't use $cast if condition, don't runtime error. isn't coding practice use if dynamic cast check if $cast returning 1 ? what might reason behind cast not returning 1 in above case? i think semicolon on line 'if' not belong? i think consumes if statement, , uvm_error executes regardless of how if evaluates: if(!$cast(data_ext, data)); <- no semico...
Read more

ios - Change Storyboard View using Seague -

i have following code checks connection server, , depending on want change views if no connection found. nsstring *connect = [nsstring stringwithcontentsofurl:[nsurl urlwithstring:@"http://myserver.com"] encoding:nsutf8stringencoding error:nil]; if (connect == null) { [self performseguewithidentifier:@"network_failure" sender:self]; } else { // other code here } my problem not change views. have added storyboard segue between 2 views identifier of network_failure . not have navigation controller or that, problem? thanks help! no not problem. first of all, in objectivec exists nil object oriented null . must use that. so: if(connect == nil) or better: if(!connect) so due fact nil not same of null , probably code does't enter in if scope . you have been able discover breakpoint. anyway: be sure set trigger segue (line) 2 view controller , , name network_failure (that not best name. should instead view1toview2 ) as, m...
Read more