Guest User

Untitled

a guest
Oct 19th, 2018
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.85 KB | None | 0 0
  1. public async Task<bool> CheckIfUserRegistered(string phoneNumber, DateTime dateOfBirth)
  2. {
  3. if (string.IsNullOrWhiteSpace(phoneNumber))
  4. {
  5. return false;
  6. }
  7. using (var cmd = _dbContext.Database.GetDbConnection().CreateCommand())
  8. {
  9. cmd.CommandText = "dbo.CheckIfUserRegistered";
  10. cmd.CommandType = CommandType.StoredProcedure;
  11.  
  12. cmd.Parameters.Add(new SqlParameter("@phoneNumber", SqlDbType.NVarChar) { Value = phoneNumber });
  13. cmd.Parameters.Add(new SqlParameter("@dateOfBirth", SqlDbType.Date) { Value = dateOfBirth });
  14.  
  15. cmd.Parameters.Add(new SqlParameter("@registered", SqlDbType.Bit) { Direction = ParameterDirection.Output });
  16.  
  17. if (cmd.Connection.State != ConnectionState.Open)
  18. {
  19. cmd.Connection.Open();
  20. }
  21.  
  22. await cmd.ExecuteNonQueryAsync();
  23.  
  24. return (bool)cmd.Parameters["@registered"].Value;
  25. }
  26. }
  27.  
  28. bool isOpen = cmd.Connection.State == ConnectionState.Open;
  29. if (!isOpen)
  30. {
  31. cmd.Connection.Open();
  32. }
  33.  
  34. await cmd.ExecuteNonQueryAsync();
  35.  
  36. if (!isOpen)
  37. {
  38. cmd.Connection.Close();
  39. }
  40.  
  41. private SqlParameter BuildParamter(string name, SqlDbType type, object value, ParameterDirection? direction)
  42. {
  43. var parameter = new SqlParameter(name, type);
  44.  
  45. if (value != null)
  46. {
  47. parameter.Value = value;
  48. }
  49.  
  50. if (direction.HasValue)
  51. {
  52. parameter.Direction = direction.Value;
  53. }
  54.  
  55. return parameter;
  56. }
  57.  
  58. cmd.Parameters.Add(new SqlParameter("@phoneNumber", SqlDbType.NVarChar) { Value = phoneNumber });
  59. cmd.Parameters.Add(new SqlParameter("@dateOfBirth", SqlDbType.Date) { Value = dateOfBirth });
  60.  
  61. cmd.Parameters.Add(new SqlParameter("@registered", SqlDbType.Bit) { Direction = ParameterDirection.Output });
  62.  
  63. cmd.Parameters.Add(BuildParameter("@phoneNumber", SqlDbType.NVarChar, phoneNumber));
  64. cmd.Parameters.Add(BuildParameter("@dateOfBirth", SqlDbType.Date, dateOfBirth));
  65.  
  66. cmd.Parameters.Add(BuildParameter("@registered", SqlDbType.Bit, null, ParameterDirection.Output));
  67.  
  68. SetStoredProcedure("CheckIfUserRegistered", cmd):
  69.  
  70. cmd.Parameters.Add(BuildParameter("@phoneNumber", SqlDbType.NVarChar, phoneNumber));
  71. cmd.Parameters.Add(BuildParameter("@dateOfBirth", SqlDbType.Date, dateOfBirth));
  72.  
  73. cmd.Parameters.Add(BuildParameter("@registered", SqlDbType.Bit, null, ParameterDirection.Output));
  74.  
  75. ExecuteStoredProcedure(cmd);
  76.  
  77. return (bool)cmd.Parameters["@registered"].Value;
  78.  
  79. public virtual int DeleteBusiness(Nullable<int> p_COMPID)
  80. {
  81. var p_COMPIDParameter = p_COMPID.HasValue ?
  82. new ObjectParameter("p_COMPID", p_COMPID) :
  83. new ObjectParameter("p_COMPID", typeof(int));
  84.  
  85. return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("DeleteBusiness", p_COMPIDParameter);
  86. }
  87.  
  88. DbContext.DeleteBusiness(compId);
Add Comment
Please, Sign In to add comment