public bool RegisterProfile(ETProfile eProfile) { bool answer = false; try { using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["AuthContext"].ToString())) { con.Open(); var query = new SqlCommand("SpInsertProfile", con); query.CommandType = CommandType.StoredProcedure; paIdGuidAspNetUsers = query.Parameters.Add("@IdGuidAspNetUsers", SqlDbType.NVarChar, 128); paIdGuidAspNetUsers.Direction = ParameterDirection.Input; paFirstName = query.Parameters.Add("@FirstName", SqlDbType.NVarChar, 256); paFirstName.Direction = ParameterDirection.Input; paLastName = query.Parameters.Add("@LastName", SqlDbType.NVarChar, 256); paLastName.Direction = ParameterDirection.Input; paAddress = query.Parameters.Add("@Address", SqlDbType.NVarChar, 1000); paAddress.Direction = ParameterDirection.Input; paGender = query.Parameters.Add("@Gender", SqlDbType.NVarChar, 256); paGender.Direction = ParameterDirection.Input; paImage = query.Parameters.Add("@Image", SqlDbType.NVarChar, 256); paImage.Direction = ParameterDirection.Input; paIdClienteSeguro = query.Parameters.Add("@IdClienteSeguro", SqlDbType.NVarChar, 256); paIdClienteSeguro.Direction = ParameterDirection.Input; paRetVal = query.Parameters.Add("RetVal", SqlDbType.Int); paRetVal.Direction = ParameterDirection.ReturnValue; paIdGuidAspNetUsers.Value = eProfile.IdGuidAspNetUsers; paFirstName.Value = eProfile.FirstName; paLastName.Value = eProfile.LastName; paAddress.Value = eProfile.Address; paGender.Value = eProfile.Gender; paImage.Value = eProfile.Image; paIdClienteSeguro.Value = eProfile.IdClienteSeguro; query.ExecuteNonQuery(); answer = true; } } catch (Exception ex) { throw; } return(answer); }
public async Task <IdentityResult> RegisterUser(UserModel userModel) { IdentityUser user = new IdentityUser { UserName = userModel.UserName, Email = userModel.Email }; UserModelRole modelRoles = new UserModelRole { Role = userModel.Role }; //Register rol await AddRole(modelRoles); //Register User var result = await _userManager.CreateAsync(user, userModel.Password); //Register of user in rol await AddUserInRole(user.Id, userModel); //Register profile dLprofile = new DLProfile(); ETProfile eProfile = new ETProfile(); eProfile.IdGuidAspNetUsers = user.Id; eProfile.FirstName = userModel.eProfile.FirstName; eProfile.LastName = userModel.eProfile.LastName; eProfile.Address = userModel.eProfile.Address; eProfile.Gender = userModel.eProfile.Gender; eProfile.Image = userModel.eProfile.Image; eProfile.IdClienteSeguro = userModel.eProfile.IdClienteSeguro; dLprofile.RegisterProfile(eProfile); return(result); }
public ETProfile GetProfile(string userId) { var ePersona = new ETProfile(); try { using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["AuthContext"].ToString())) { con.Open(); var query = new SqlCommand("SpSelectProfileId", con); query.Parameters.AddWithValue("@IdGuidAspNetUsers", userId); query.CommandType = CommandType.StoredProcedure; using (var dr = query.ExecuteReader()) { dr.Read(); if (dr.HasRows) { ePersona.ProfileID = Convert.ToInt32(dr["ProfileID"]); ePersona.IdGuidAspNetUsers = dr["IdGuidAspNetUsers"].ToString(); ePersona.FirstName = dr["FirstName"].ToString(); ePersona.LastName = dr["LastName"].ToString(); ePersona.Address = dr["Address"].ToString(); ePersona.Gender = dr["Gender"].ToString(); ePersona.Image = dr["Image"].ToString(); ePersona.IdClienteSeguro = dr["IdClienteSeguro"].ToString(); } } } } catch (Exception ex) { throw; } return(ePersona); }