How to resolve the error above. Your help will be highly appreciated.
My HTML:
- <div class="form-group">
- <div class="input-group">
- <span asp-validation-for="Item2.DocumentName" class="text-danger input-group-addon">CV</span>
- <input asp-for="Item2.DocumentName" type="file" class="form-control" placeholder="Attach CV" name="DocumentName">
- </div>
- </div>
- <div class="form-group">
- <div class="input-group">
- <span asp-validation-for="Item2.DocumentNameTwo" class="text-danger input-group-addon">ID</span>
- <input asp-for="Item2.DocumentNameThree" type="file" class="form-control" placeholder="Attach ID Copy" name="DocumentNameTwo">
- </div>
- </div>
- <div class="form-group">
- <div class="input-group">
- <span asp-validation-for="Item2.DocumentNameThree" class="text-danger input-group-addon">Qualification</span>
- <input asp-for="Item2.DocumentNameThree" type="file" class="form-control" placeholder="Attach Qualification" name="DocumentNameThree">
- </div>
- </div>
- </div>
My Stored Procedure:
- ALTER PROCEDURE [dbo].[sp_Documents]
- (@UserID int = null
- ,@DocumentName varchar(MAX) = null
- ,@Description varchar(MAX) = null
- ,@DocTypeID int = null
- ,@DocURL varchar(MAX) = null
- )
- AS
- INSERT INTO [dbo].[Documents]
- ([UserID]
- ,[DocumentName]
- ,[Description]
- ,[DocTypeID]
- ,[DocURL]
-
-
-
-
-
-
- )
- VALUES
- (@UserID
- ,@DocumentName
- ,@Description
- ,@DocTypeID
- ,@DocURL
-
-
-
-
-
-
- )
My C# code:
- conn.Open();
- cmd2.CommandType = CommandType.StoredProcedure;
-
- document.DocURL = "~/Documents/";
- cmd2.Parameters.AddWithValue("@UserID", (document.UserID));
- cmd2.Parameters.AddWithValue("@DocumentName", (document.DocumentName));
- cmd2.Parameters.AddWithValue("@Description", "CV");
- cmd2.Parameters.AddWithValue("@DocURL", document.DocURL + document.DocumentName);
-
-
- if(document.DocumentName != document.DocumentNameTwo)
- {
- document.DocURL = "~/Documents/";
- document.DocumentName = document.DocumentNameTwo;
- cmd2.Parameters.AddWithValue("@UserID", (document.UserID));
- cmd2.Parameters.AddWithValue("@DocumentName", (document.DocumentName));
- cmd2.Parameters.AddWithValue("@Description", "ID Copy");
- cmd2.Parameters.AddWithValue("@DocURL", document.DocURL + document.DocumentName);
- }
- if (document.DocumentName != document.DocumentNameThree) {
- document.DocURL = "~/Documents/";
- document.DocumentName = document.DocumentNameThree;
- cmd2.Parameters.AddWithValue("@UserID", (document.UserID));
- cmd2.Parameters.AddWithValue("@DocumentName", (document.DocumentName));
- cmd2.Parameters.AddWithValue("@Description", "Qualification");
- cmd2.Parameters.AddWithValue("@DocURL", document.DocURL + document.DocumentName);
- cmd2.CommandType = CommandType.StoredProcedure;
- cmd2.ExecuteNonQuery();
- conn.Close();
- }
- else { return "Files Not Saved"; }