Advertisement
Guest User

Untitled

a guest
Mar 30th, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.95 KB | None | 0 0
  1. // Controller
  2. [Route("CreateUser")]
  3. public async Task<IHttpActionResult> PostCreateUser(SignUp parameters)
  4. {
  5. try
  6. {
  7. SignUpRepository repo = new SignUpRepository();
  8. var response = await repo.ResisterUser(parameters);
  9. }
  10. catch (Exception ex)
  11. {
  12. return Ok("Error occurred...." + ex.Message);
  13. }
  14.  
  15. return Ok("SignUp successfully completed.");
  16.  
  17. }
  18.  
  19.  
  20. // SignUpRepository Class
  21. public async Task<String> ResisterUser(SignUp signUp) {
  22.  
  23. SignUpManager manager = new SignUpManager();
  24. var createUser = await CreateUserAsync(signUp, manager);
  25.  
  26. if (String.IsNullOrWhiteSpace(createUser)) {
  27. return "No user created";
  28. }
  29.  
  30. return "User successfully created.";
  31. }
  32.  
  33. private Task<string> CreateUserAsync(SignUp signUp, SignUpManager manager)
  34. {
  35. return Task.Run<string>(() => CreateUserAccount(signUp, manager));
  36. }
  37.  
  38. private string CreateUserAccount(SignUp signUp, SignUpManager manager)
  39. {
  40. Customer customer = new Customer {
  41. User_Name = signUp.UserName,
  42. Password = signUp.Password,
  43. First_Name = signUp.FirstName,
  44. Last_Name = signUp.LastName,
  45. Email_Address = signUp.Email,
  46. Mobile_Number = signUp.Mobile,
  47. Country_Id = signUp.CountryId
  48. };
  49.  
  50.  
  51. return manager.RegisterUser(customer);
  52. }
  53.  
  54. // SignUpManager Class
  55. public string RegisterUser(Customer customer)
  56. {
  57. return new SQLHelper().RegisterUser(customer);
  58. }
  59.  
  60. // SQL Helper Class
  61. public string RegisterUser(Customer customer)
  62. {
  63. using (SqlConnection conn = new SqlConnection("Connection String value"))
  64. {
  65. conn.Open();
  66. using (SqlCommand cmd = new SqlCommand())
  67. {
  68. cmd.Connection = conn;
  69. // cmd.CommandText = "sp_RegisterUserByThirdParty";
  70. cmd.CommandText = "sp_RegisterUserByLEOSmart";
  71. cmd.CommandType = CommandType.StoredProcedure;
  72.  
  73. cmd.Parameters.Add(new SqlParameter("@UserName", customer.User_Name));
  74. cmd.Parameters.Add(new SqlParameter("@Password", customer.Password));
  75. cmd.Parameters.Add(new SqlParameter("@Full_Name", String.Format("{0} {1}", customer.First_Name, customer.Last_Name)));
  76. cmd.Parameters.Add(new SqlParameter("@Mobile_Number", customer.Mobile_Number));
  77. cmd.Parameters.Add(new SqlParameter("@Email", customer.Email_Address));
  78. cmd.Parameters.Add(new SqlParameter("@Country_ID", customer.Country_Id));
  79.  
  80. cmd.Parameters.Add(new SqlParameter("@outToken", SqlDbType.VarChar, 16));
  81. cmd.Parameters["@outToken"].Direction = ParameterDirection.Output;
  82.  
  83. cmd.ExecuteNonQuery();
  84. this.response = Convert.ToString(cmd.Parameters["@outToken"].Value);
  85. }
  86. }
  87.  
  88. return this.response;
  89. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement