I have been at this for a few stressful hours and have given up on trying to find a question answered or problem solved for this particular approach I had in mind.
Thing is, I have been given a quite simple task to complete for a job application, but ran into a wall just at the end.
I am to develop an ASP.NET c# web application that shows a GridView with all entries in a SQL Server database table called Tasks which looks like this:
ID int IDENTITY(1,1) PRIMARY KEY,
Title nvarchar(50) not null,
DateOpened datetime not null,
Status bit not null DEFAULT (0) --> opened/closed,
DateClosed datetime null,
Description nvarchar(500) null
I will add the sql needed to understand better it's just I don't have it right now. Also the code you might think is most helpful to avoid a mile long question with lots of copy-pasted code. I didn't wait for it to become available just because I think the code itself would help little to nothing.
I am looking for a way to write an entry to the SQL Server Log File after a user attempts to insert a new Task with the same name AND status as an already existing one.
Basically, if there is an entry in the table like this:
Title 1, opened
and there is another one named Title 1 with status opened being insert into Tasks, the user should be alerted of the attempt, and it should be logged into SQL Server Log File.
I've never done such a thing, so I assume it should be somehow done from the Default.aspx.cs file inside the ValidateNewTask(Task t) method, where I run a foreach loop against all fetched entries, and if a "hit" appears, redirect the user to an error page or maybe keep it all on the same page with an error label since it's not that severe (like a RequiredFieldValidator would do), and THEN access the log to write the new entry of an error occurred.
Am I missing something that's right in front of me, or is this just not ever done (like this/ or at all)?
