1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| public override MembershipUser CreateUser(string username, string password, string email, string passwordQuestion, string passwordAnswer, bool isApproved, object providerUserKey, out MembershipCreateStatus status)
{
Guid guid = new Guid();
SqlConnection cnx = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["SCNX"].ToString());
SqlCommand myCommande = new SqlCommand("[IntranetHeig].[dbo].[aspnet_Users_CreateUser]", cnx);
myCommande.CommandType = CommandType.StoredProcedure;
myCommande.Parameters.Add("@ApplicationId", SqlDbType.UniqueIdentifier).Value = ApplicationId;
myCommande.Parameters.Add("@UserName", SqlDbType.VarChar).Value = username;
myCommande.Parameters.Add("@IsUserAnonymous", SqlDbType.Bit).Value = 0;
myCommande.Parameters.Add("@LastActivityDate", SqlDbType.DateTime).Value = System.DateTime.Now;
myCommande.Parameters.Add("@UserId", SqlDbType.UniqueIdentifier).Value = guid;
myCommande.Parameters.Add("@UserLastName", SqlDbType.VarChar).Value = UserLastName;
myCommande.Parameters.Add("@UserLogin", SqlDbType.VarChar).Value = UserLogin;
myCommande.Parameters.Add("@IsActived", SqlDbType.Bit).Value = 0;
myCommande.Parameters.Add("@IsActif", SqlDbType.Bit).Value = 0;
cnx.Open();
int result = myCommande.ExecuteNonQuery();
cnx.Close();
if (result == 0)
{
return guid.ToString();
}
else
{
return result.ToString();
}
} |
Partager