如何在可预订的时间内预订，而不会在预订网站（ASP.NET VB）中发生冲突？ [英] How to reservation only in available time without exposure to clash in reservation website ( ASP.NET VB)?

问题描述

我有一个本页面大厅的预订页面（大厅的名称，预订日期和预订时间来往于）。例如，大厅A于2014年11月12日中午12:00至下午1:00预订。因此，除非在中午12:00或下午1:00之后，否则不得在同一时间内再次预订大厅。



好​​吧，我'编写代码，但即使有预订，程序也会插入。

我不知道错误是在条件或查询中，还是其他原因。没有任何错误或错误的迹象，它只是没有按要求工作。



我尝试过：



Gridview1：它用于数据库中的数据插入。



Gridview2：确定是否可以预留大厅或不通过（查询where）。

I have a booking page for the halls on this page (the name of the Hall, the date of booking and the time of booking "from and to"). For example, the hall "A" was booked on 12/11/2018 from 12:00 pm to 1:00 pm . So,The Hall must not be booked again during this time of the same date, except before 12:00 pm or after 1:00 pm.

Well, I've written the code but the program is going to insert even if there is a reservation.
I do not know if the error was in the condition or the Query or perhaps another reason. There is no indication of fault or error, it's just not working as required.

What I have tried:

Gridview1: it's for data insert in the database.

Gridview2: It is determined if it is possible to reserve the hall or not through the (Query "where").

Protected Sub Reserv_btn_Click(sender As Object, e As EventArgs) Handles Reserv_btn.Click



       If GridView2.Rows.Count > 0 Then
           Label1.Text = "Hall can not be reserved"
       Else
           If GridView1.Rows.Count > 0 Then

           ReservationDB.InsertParameters("Cpr").DefaultValue = Session.Item("cpr")
               ReservationDB.InsertParameters("Hall_Number").DefaultValue = HallName.SelectedValue
               ReservationDB.InsertParameters("Date").DefaultValue = Datetxt.Text
               ReservationDB.InsertParameters("Start_Time").DefaultValue = Startxt.Text
               ReservationDB.InsertParameters("End_Time").DefaultValue = Endtxt.Text
               ReservationDB.InsertParameters("Event_name").DefaultValue = Eventxt.Text
               ReservationDB.InsertParameters("Comments").DefaultValue = Commtxt.Text

               ReservationDB.Insert()

               Label1.Text = "hall was booked!!"
               Datetxt.Text = ""
               Startxt.Text = ""
               Endtxt.Text = ""
               Eventxt.Text = ""
               Commtxt.Text = ""

             End If
       End If

   End Sub

这是我在查询中的代码，意思是： -

（[Start_Time] BETWEEN'Start.text'和'End.text'）

或

（[End_Time] BETWEEN'Start.text'AND' End.text'））





（Start.text）：它是开始时间的文本框。

（End.text）：它是结束时间的文本框。

This is my code in the Query, it means:-
([Start_Time] BETWEEN 'Start.text' AND 'End.text')
OR
([End_Time] BETWEEN 'Start.text' AND 'End.text'))


(Start.text):it's text box for start time.
(End.text): it's text box for End time.

SELECT Event_ID, Start_Time, End_Time, [Date], Event_name, Number_of_Attendees, Cpr, Hall_Number, Comments
 FROM    Resevation_of_Halls
 WHERE  (Hall_Number = ?)
 ([Date] =? )
 (([Start_Time] BETWEEN ? AND ?)
 OR
 ([End_Time] BETWEEN ? AND ?))

推荐答案

Quote：

没有任何错误或错误的迹象，它只是没有按要求工作。

There is no indication of fault or error, it's just not working as required.

编译并不代表你的代码是正确的！ ：笑：

将开发过程想象成编写电子邮件：成功编译意味着您使用正确的语言编写电子邮件 - 例如英语而不是德语 - 而不是电子邮件包含您的邮件想发送。



所以现在你进入第二阶段的发展（实际上它是第四或第五阶段，但你将在之后的阶段进入）：测试和调试。



首先查看它的作用，以及它与你想要的有何不同。这很重要，因为它可以为您提供有关其原因的信息。例如，如果程序旨在让用户输入一个数字并将其翻倍并打印答案，那么如果输入/输出是这样的：

Compiling does not mean your code is right! :laugh:
Think of the development process as writing an email: compiling successfully means that you wrote the email in the right language - English, rather than German for example - not that the email contained the message you wanted to send.

So now you enter the second stage of development (in reality it's the fourth or fifth, but you'll come to the earlier stages later): Testing and Debugging.

Start by looking at what it does do, and how that differs from what you wanted. This is important, because it give you information as to why it's doing it. For example, if a program is intended to let the user enter a number and it doubles it and prints the answer, then if the input / output was like this:

Input   Expected output    Actual output
  1            2                 1
  2            4                 4
  3            6                 9
  4            8                16

然后很明显问题出在将它加倍的位 - 它不会将自身加到自身上，或者将它乘以2，它会将它自身相乘并返回输入的平方。

所以，你可以查看代码和很明显，它在某处：

Then it's fairly obvious that the problem is with the bit which doubles it - it's not adding itself to itself, or multiplying it by 2, it's multiplying it by itself and returning the square of the input.
So with that, you can look at the code and it's obvious that it's somewhere here:

int Double(int value)
   {
   return value * value;
   }

一旦你知道可能出现的问题，就开始使用调试器找出原因。在方法的第一行放置一个断点，然后运行你的应用程序。当它到达断点时，调试器将停止，并将控制权移交给您。您现在可以逐行运行代码（称为单步执行）并根据需要查看（甚至更改）变量内容（哎呀，您甚至可以更改代码并在需要时再试一次）。 />
在执行代码之前，请考虑代码中的每一行应该做什么，并将其与使用Step over按钮依次执行每一行时实际执行的操作进行比较。它符合您的期望吗？如果是这样，请转到下一行。

如果没有，为什么不呢？它有什么不同？

希望这可以帮助你找到代码的哪个部分有问题，以及问题是什么。

这是一项技能，它是一个值得开发的，因为它可以帮助你在现实世界和发展中。和所有技能一样，它只能通过使用来改善！

Once you have an idea what might be going wrong, start using the debugger to find out why. Put a breakpoint on the first line of the method, and run your app. When it reaches the breakpoint, the debugger will stop, and hand control over to you. You can now run your code line-by-line (called "single stepping") and look at (or even change) variable contents as necessary (heck, you can even change the code and try again if you need to).
Think about what each line in the code should do before you execute it, and compare that to what it actually did when you use the "Step over" button to execute each line in turn. Did it do what you expect? If so, move on to the next line.
If not, why not? How does it differ?
Hopefully, that should help you locate which part of that code has a problem, and what the problem is.
This is a skill, and it's one which is well worth developing as it helps you in the real world as well as in development. And like all skills, it only improves by use!

这篇关于如何在可预订的时间内预订，而不会在预订网站（ASP.NET VB）中发生冲突？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！