hai every1
-
hi i'm doing a project on travel & tourism in asp.net..am using oracle as the backend...so far i've created 3 tables : 1.customer table which contains all the usernames & passwords 2.package table which contains the different packages my website provides..this table consists of the package no,package name & its cost...am dealing with only 5 packages... 3.bookings table which contains almost all details i've provided in d webform like credit card no,status,date of journey,bookings date,package no etc... for checking out the ticket availability say me if this wud work out: like comparing the booking date & date of journey, checking if booking date is 1month before the date of journey, 1/2month before or not?? if 1 month means tickets r available,1/2 month means only half the seats r available..is it possible to compare dates???? waiting for some1 to reply & help me out pls...
-
hi i'm doing a project on travel & tourism in asp.net..am using oracle as the backend...so far i've created 3 tables : 1.customer table which contains all the usernames & passwords 2.package table which contains the different packages my website provides..this table consists of the package no,package name & its cost...am dealing with only 5 packages... 3.bookings table which contains almost all details i've provided in d webform like credit card no,status,date of journey,bookings date,package no etc... for checking out the ticket availability say me if this wud work out: like comparing the booking date & date of journey, checking if booking date is 1month before the date of journey, 1/2month before or not?? if 1 month means tickets r available,1/2 month means only half the seats r available..is it possible to compare dates???? waiting for some1 to reply & help me out pls...
hai this is a sample code. check whether this wld help to solve ur prob. Dim t1 As New DateTime(100) Dim t2 As New DateTime(20) If DateTime.Compare(t1, t2) > 0 Then Console.WriteLine("t1 > t2") End If If DateTime.Compare(t1, t2) = 0 Then Console.WriteLine("t1 == t2") End If If DateTime.Compare(t1, t2) < 0 Then Console.WriteLine("t1 < t2") End If
-
hi i'm doing a project on travel & tourism in asp.net..am using oracle as the backend...so far i've created 3 tables : 1.customer table which contains all the usernames & passwords 2.package table which contains the different packages my website provides..this table consists of the package no,package name & its cost...am dealing with only 5 packages... 3.bookings table which contains almost all details i've provided in d webform like credit card no,status,date of journey,bookings date,package no etc... for checking out the ticket availability say me if this wud work out: like comparing the booking date & date of journey, checking if booking date is 1month before the date of journey, 1/2month before or not?? if 1 month means tickets r available,1/2 month means only half the seats r available..is it possible to compare dates???? waiting for some1 to reply & help me out pls...
Ofcourse you can compare two dates Ishwarya! Now, lets say the dateofjourney is more than 30 days then display a message like 'Booking Not Open'. If the dateofjourney is less than 30 days then you do your calculations like say from Hyderabad to bangalore on 18th Feb there are 30 tickets available and custmer wants 5 tickets then you have to do 30-5. so this way the tickets availabilty would be changed..... basic idea!!!
Gautham