asp.net - Database relations query -

-

i have 2 database tables ticket table

tax table

this sample database of ticketing system.

figure 1: sample table of air ticket. figure 2: sample table of tax.

requirement: when ticket made interface, has multiple taxes of different names every time. how can store information i.e. 'n' number of taxes each ticket different names every time.

i have tried make many many relationship problem is: each ticket if tax not setup, need add tax first.

any optimal solution this?

"the problem is: each ticket if tax not setup, need add tax first."

this not real-life problem. in real life governments declare taxes in advance of collecting them, gives organizations sufficient time amend systems need handle taxes. tax never surprise.

"but tiring solution end user.... make bunch of tax setup each ticket"

this sort of thing reference data, , duty of system developer (hint: that's you) populate reference data tables. or @ least provide screen user can create or amend various taxes. different function defining ticket type.

the ticket creation screen should have drop-down list (or similar widget) displaying existing taxes, allows user pick relevant one(s). if reall think it's necessary can include link create tax screen, confusing workflow.

if commentators correct, , ticket purchasing function, design wrong. sales taxes must included automatically cost of purcahse part of transaction. otherwise nobody pay tax.


Comments

Post a Comment

Popular posts from this blog

html5 - What is breaking my page when printing? -

-
Image
i have questioner , don't know why when printing it's creating break before first question. live demo (link) i able resolve issue removing fieldset container had wrapped in.. having fieldset element causing of fields grouped together, , since not fit on first page, being pushed second page. removing fieldset element, able firefox print first 2 questions on page 1 identically chrome. it seems not new problem firefox , fieldset not playing nice found old bugzilla ticket 2008 has persisted , still being commented on in 2014 (link) if retaining fieldset important, found solution else came here (link) <script type='text/javascript'> $(window).bind('beforeprint', function(){ $('fieldset').each( function(item) { $(this).replacewith($('<div class="fieldset">' + this.innerhtml + '</div>')); } ) }); $(window).bind(
Read more

c# - must be a non-abstract type with a public parameterless constructor in redis -

-
when save object, got below error must non-abstract type public parameterless constructor in order use parameter 't' in generic type or method 'servicestack.redis.redisclient.store<t>(t) redisclass.getinstnace().store(msg); // error here redisclass.getinstnace().save(); as third party's class, can not edit how save object? could create wrapper around third party object call constructor, store wrapper? e.g. public class mywrapper { public thirdpartyobject thirdpartyinstance { get; set; } public mywrapper() { thirdpartyinstance = new thirdpartyobject("constructors"); } }
Read more

ajax - PHP/JSON Login script (Twitter style) not setting sessions -

-
i'm having trouble getting twitter style login work properly, reason gets stuck at session_register("useremail"); session_register("userpass"); and doesn't redirect after it. if enter wrong account data, works , appropriate error message pops up. this full code: <?php if(empty($_post['email']) || empty($_post['password'])) { die(msg(0,"all fields required")); } if(!(preg_match("/^[\.a-z0-9_\-\+]+[@][a-z0-9_\-]+([.][a-z0-9_\-]+)+[a-z]{1,4}$/", $_post['email']))) die(msg(0,"you haven't provided valid e-mail")); $host="localhost"; $username="root"; $password="x"; $db_name="x"; $tbl_name="x"; mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select db"); $useremail=$_post['email']; $userpass=
Read more