asp.net - INSERT stored procedure does not work? -

I am trying to merge with a database called suspension, which is called notification in the Animal Database. My stored procedure is:

  Alternate procedure [dbo]. [SpCreateNotification] - Parameters for stored procedure here: @notRecID int, @notName nvarchar (50), @notRecStatus nvarchar () 1), @ not added smalldatetime, start as @notByWho - SET set additional result set on NOCOUNT Added to stop - Interference with SELECT statement. Set nosenate on; - Insert the insert statement here for the procedures Animal.dbo.Notification (NotRecID, NotName, NotRecStatus, NotAdded, NotByWho) value (@notRecID, @notName, @notRecStatus, @notAdded, @notByWho); END  

To fill the blank is to fill a column again which will not be filled otherwise, I have tried in different ways, like the name of the column even after the name of the column And then just point out in those fields that I have. I know that this is not a problem with stored procedure because I execute it from SQL Server Management Studio and launch these standards Works in Then I think that when I call the stored procedure, then the problem should be in the repository:

  Public notice to create a zero (Notification) {try {DB.spCreateNotification (not. NotRecID, not.NotName, not .notRecStatus, (DateTime) No. Not added, (int) No, No, Not); } Hold {return; }}  

And I call the method here:

  Public Notification Information (IELIT & Lt; Temporal Notification & gt; Notification) { Foreach (var TNot in notes) {var Ts = repository service. _ Aspension.GatometoralSpensationFormificationId (TNotTanTouchIdID); Notification Notification = new Notification (); If (tscount! = 0) {notification.NotName = TNot.TnName; Notification.NotricID = Teenet.Noterexide; Notification.Notrestats = Teetate. Notrequestates; Notification.Not found = Tinet. Not added; Notification Not bad = T. Not. Not Bava; If (TNot.TnToReplace! = 0) {var suspensions = RepositoryService._suspension.getSuspensionsAttached ((int) TNot.TnToReplace); Foreign currency (different SOS in suspension) {sus.CtsEndDate = TNot.TnAdded; Sus.CtsEndNotRecID = TNot.TnRecID; DB.Spododiz Asspension when Notification Replace ((Int) T. Not Knot-to-Place, (Int.) Susp. CTSAndNotrexide, (Datetime) SCSCT & Dt; } DB Spray Place Notification ((int) T. Not to Ace, Datetime. Now); CreateNotification (notification); } Else {createNotification (notification); }}} DeleteTemoral Notifications (Notifications); }  

This does not record values ​​in the database. I'm debugging and being crazy about it because it works manually while executing it, but when I do not automate the process in my application, does anyone see anything wrong with my code?

thanks:

Edit: More code was added It still does not work that change, I mean, if I execute it then this process works, So I do not know what the error might be. In fact, I have not got any errors, can it be a matter of writing in the table which is not in the database, where you have your stored procedure?

"post-text" itemprop = "text">

I specify your column names and DONT enters all the columns for that column. Simply do SQL Server deal with it.

databar.notification (RecID, [name], RecStatus, added, by WHO) INSERT value (@notRecID, @notName, @notRecStatus, @ not added, @noBava );