Remove From My Forums. Asked by:. Archived Forums. Web Forms. Sign in to vote. User posted Hi, i have a textbox which i allow the user to enter a date. When the submit button is click, and if the textbox is empty, my class pass other info into the database and the colunm which store the date will be null. How should i do it? Monday, February 23, AM. User posted Use DBNull. User posted Try inserting null, or leave that field out of the insert statement. User posted I recently encountered similiar issue, I'm not sure if I like the fact that you can't set a DateTime variable to Null.
There is a. So assuming you will never need to save this date you could do the check to see if the data is. MinValue and then save a Null. I actually changed my business objects date properties to strings rather than DateTime for this issue and intend to revisit this 'problem' in the future.
User posted i try usin that, but it don't work. User posted SushilaSB What I don't like about this is that a date is being treated as a string.
In a business object I would like to use a DateTime property and not a string. Due to the fact that a DateTime cannot be null adds a significant amount of checking that would otherwise not be needed. In this case I can't check for "" to know the user did not enter a date. Any suggestions here? Hope this helps, -- Aaron. Monday, February 23, PM. Try that and see if it helps. User posted Aaron, Thats a good work around given what we have to work with. What I don't like is the entity objects date field is an object and the front will have to deal with DBNull and there is also 1 date that can't be used.
I'm not criticizing your solution, my only point is that I don't see an easy fix for a non nullable dateTime variable type. I was hoping I was missing something. Let's work to help developers, not make them feel stupid. Related Questions. Check if image column is empty. How to check an object is empty or null. Error handling for empty text in ASP. Angularjs verify not null and compare dates. Layout: fixed fluid. Web01 2. Strip HTML.
Encode HTML. Paste as-is. Code block. Quoted Text. Best guess. Optional Password. An invalid model state is tested by adding errors using AddModelError as shown in the first test below:. The test doesn't attempt to pass in an invalid model. Passing an invalid model isn't a valid approach, since model binding isn't running although an integration test does use model binding.
In this case, model binding isn't tested. These unit tests are only testing the code in the action method. Mocked calls that aren't called are normally ignored, but calling Verifiable at the end of the setup call allows mock validation in the test. This is performed with the call to mockRepo. Verify , which fails the test if the expected method wasn't called. The Moq library used in this sample makes it possible to mix verifiable, or "strict", mocks with non-verifiable mocks also called "loose" mocks or stubs.
Learn more about customizing Mock behavior with Moq. SessionController in the sample app displays information related to a particular brainstorming session. The controller includes logic to deal with invalid id values there are two return scenarios in the following example to cover these scenarios. The unit tests include one test for each return scenario in the Session controller Index action:. The sample app contains two ForSession tests. The checks also examine the first idea to confirm its Name property is correct:.
To test the behavior of the Create method when the ModelState is invalid, the sample app adds a model error to the controller as part of the test. Don't try to test model validation or model binding in unit tests—just test the action method's behavior when confronted with an invalid ModelState :.
The second test of Create depends on the repository returning null , so the mock repository is configured to return null. There's no need to create a test database in memory or otherwise and construct a query that returns this result. The test can be accomplished in a single statement, as the sample code illustrates:.
The mock is called with Verifiable , and the mocked repository's Verify method is called to confirm the verifiable method is executed. It's not the unit test's responsibility to ensure that the UpdateAsync method saved the data—that can be performed with an integration test. In ASP. NET Core 2. If the session id doesn't exist, the controller returns NotFound :.
The first test confirms that the controller returns an ActionResult but not a nonexistent list of ideas for a nonexistent session id :. The sample app also includes a method to create a new Idea for a given session.
The controller returns:.
0コメント