You must Sign In to post a response.
  • Category: ASP.NET

    Online date booking calendar along with room.

    i am developing a website for Hotel For Dogs.
    am developed all the basics.Now am struggling.
    1.user A come to the site select any from date to todate in the calendar and book a kennel for his selected date.and logout.
    2.if new user B come to the site select date it same as user A.at the time it will display the error message.
    3.Am have a button like CLICK TO VIEW AVAILABLE KENNEL or ROOM user select the from and todates then if he clicks the button View button it will display only available kennels or rooms.that is unbooked rooms.
    3. Admin can able to update the kennelcalendar.
    Above is my requirements sir.If anyone know please post your reply to me
  • #761563
    Hi,

    Untill user confirms the request you should not deduct the rooms from the main table. You should only have the entry in a temp table. Once user clicks on the confirm button you should query the main table and deduct the available rooms.
    Seems like you are using the main table for all the users and it is getting locked.

    If you can provide the query you are using and bit of background we will be able to provide you more details about the issues.


    Regards,
    Asheej T K
    Microsoft MVP[ASP.NET/IIS]
    DotNetSpider MVM

  • #761568
    You can try the concept Block and Book concept.

    1. Once user selected the room, you can block the room.
    2. Blocked rooms should not be select by other user.
    3. You can give time limit for block one room for particular minutes/Seconds.
    4. If the user did not book the room in that particular time. you can unblock it automatically.

    By Nathan
    Direction is important than speed

  • #761576
    Sir below is my insert coding:
    OleDbConnection con = Connection.DBconnection();
    DataSet ds = new DataSet();
    string submit = "insert into tbl_kennel(Fromdate,Todate,Bookedkennel) values (@Fromdate,@Todate,@Bookedkennel)";
    OleDbCommand com = new OleDbCommand(submit, con);
    com.Parameters.AddWithValue("@Fromdate", txtfromdate.Text.Trim());
    com.Parameters.AddWithValue("@Todate", txttodate.Text.Trim());
    com.Parameters.AddWithValue("@Bookedkennel", GetKennel());
    com.ExecuteNonQuery();

    And am attached my msacces database sir.
    I want know the query for get the fromdate and todate then check the user input and insert the record.
    ->fromdate is notequal to any record in the table
    ->todate is not equal to any record in the table
    ->Between date is also not equal to from and todate

    then only user can book rooms.
    this is my requirement sir

    Dogsmanagement.mdb

    Delete Attachment


Sign In to post your comments