Rocky Rocky

Rocky Rocky

  • NA
  • 317
  • 152.3k

How to make code for these requirement?

Jul 4 2013 2:57 AM
Hai friends,
in my deatils.aspx page i ve two asp panels i.e
1)empdeatils
2)traveldetails

1)in my empdetails panel consists of

i)empdetails column
username,
designation,
department,
userid,
reporting
these information fetch the database and display into screen(already done)

ii)requirements column
travel purpose,
total amount
these information ve enter by user.
it ll store on the table travel_request its structure is

create table travel_request
(
request_id int identity primary key,
user_id varchar(100) foreign key references users(user_id)
purpose_travel varchar(100),
total_amount varchar(10)
)

2)travel details panel consists(already done)
departuredate,
from,
to,
travel mode
add(button after added the details ll show on grid view)
above the information ll store on onward_journey table thats structure is

create table onward_journey
(
onward_journey_id int identity,
request_id int foreign key references travel_request(request_id),
departuredate datetime,
from varchar(100),
to varchar(100),
travel mode varchar(100)
)
now my requirement is
1)when users logged and enter the travel purpose,total amount ll store on travel_request table i.e request_id ll created
depends upon that request_id onward_journey fields would be store the details.

2) how to store the onward_joureny details depends on request_id?
3) how to show that users only see request ?