Guest User

Untitled

a guest
Mar 22nd, 2018
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.34 KB | None | 0 0
  1. CREATE PROCEDURE [dbo].[RMVerifyUser]
  2. @UserName as varchar(40)
  3. ,@Password as binary(42) OUTPUT
  4. ,@ClerkID as uniqueidentifier OUTPUT
  5. AS
  6.  
  7. SELECT @ClerkID = IDClerk
  8. ,@Password = (CONVERT(binary(8), ClkPassCode, 0)) // ClkPassCode is varchar(50) in the table.
  9. FROM tblClerkInfo
  10. WHERE ClkName = @UserName
  11. AND ISNULL(Canceled, 0) = 0
  12. RETURN
  13.  
  14. private string retrievePassword(object userName)
  15. {
  16. string strPassword = "";
  17. //uidClerkID = new Guid();
  18.  
  19. connect.Open();
  20.  
  21. try
  22. {
  23.  
  24. SqlCommand command = new SqlCommand("RMVerifyUser");
  25. command.Connection = connect;
  26. command.CommandType = CommandType.StoredProcedure
  27.  
  28. SqlParameter retUserName = new SqlParameter("@UserName", userName); // userName is passed in from another method.
  29. retUserName.ParameterName = "@UserName";
  30. retUserName.Value = userName;
  31. command.Parameters.Add(retUserName);
  32.  
  33. SqlParameter retPassword = new SqlParameter("@Password", strPassword); // I suspect the error is occurring somewhere in the declaration/definition of this parameter.
  34. retPassword.ParameterName = "@Password";
  35. retPassword.Direction = ParameterDirection.Output;
  36. retPassword.DbType.Equals(DbType.String);
  37. retPassword.Size = 50;
  38. retPassword.Value = strPassword;
  39. command.Parameters.Add(retPassword); // ClkPassCode is nvarchar(50) in the data table.
  40.  
  41. SqlParameter retUserID = new SqlParameter("@ClerkId", uidClerkID); // uidClerkID is a property in a separate class, but I also tried - uidClerkID = new Guid() - in this method. Same error thrown.
  42. retUserID.ParameterName = "@ClerkId";
  43. retUserID.Direction = ParameterDirection.Output;
  44. retUserID.Value = uidClerkID;
  45. command.Parameters.Add(retUserID);
  46.  
  47. command.ExecuteNonQuery();
  48.  
  49. uidClerkID = Guid.Parse(retUserID.Value.ToString());
  50.  
  51.  
  52. if (strPassword == DBNull.Value.ToString())
  53. {
  54. ReferenceEquals(strPassword, null);
  55. }
  56. else
  57. {
  58. strPassword = retPassword.Value.ToString();
  59. return strPassword;
  60. }
  61. }
  62. catch (Exception ex)
  63. ...
Add Comment
Please, Sign In to add comment