Bug_Tracker (система эксплуатации программ) - копирование ASP.NET пользователей с другого сайта.

Эта проца запускается для каждого юзера, которого вы хотите скопировать со своего существующего ASP.NET сайта. Контекст запуска процедуры - база из которой вы копируете. В качестве имени [Bug].[dbo].[aspnet_Users] - укажите имя той базы, куда вы копируете пользователей для баг-трекера.


   1:  CREATE procedure [dbo].[CopyUser]
   2:  @UserID uniqueidentifier
   3:  as
   4:  declare @Bug_ApplicationId uniqueidentifier
   5:  select  @Bug_ApplicationId=ApplicationId from Bug.dbo.aspnet_Applications where ApplicationName='/'
   6:  declare @Bug_UserId uniqueidentifier
   7:  select  @Bug_UserId=UserID from Bug.dbo.aspnet_Users where  UserId=@UserID
   8:  if (@Bug_UserId is null) Begin
   9:   
  10:   
  11:  BEGIN TRY
  12:   
  13:  Begin tran
  14:  --
  15:  INSERT  [Bug].[dbo].[aspnet_Users]
  16:             ([ApplicationId]
  17:             ,[UserId]
  18:             ,[UserName]
  19:             ,[LoweredUserName]
  20:             ,[MobileAlias]
  21:             ,[IsAnonymous]
  22:             ,[LastActivityDate])
  23:  select  @Bug_ApplicationId
  24:             ,[UserId]
  25:             ,[UserName]
  26:             ,[LoweredUserName]
  27:             ,[MobileAlias]
  28:             ,[IsAnonymous]
  29:             ,[LastActivityDate]
  30:  from   dbo.aspnet_Users where  UserId=@UserID        
  31:  --
  32:  INSERT INTO [Bug].[dbo].[aspnet_Membership]
  33:             ([ApplicationId]
  34:             ,[UserId]
  35:             ,[Password]
  36:             ,[PasswordFormat]
  37:             ,[PasswordSalt]
  38:             ,[MobilePIN]
  39:             ,[Email]
  40:             ,[LoweredEmail]
  41:             ,[PasswordQuestion]
  42:             ,[PasswordAnswer]
  43:             ,[IsApproved]
  44:             ,[IsLockedOut]
  45:             ,[CreateDate]
  46:             ,[LastLoginDate]
  47:             ,[LastPasswordChangedDate]
  48:             ,[LastLockoutDate]
  49:             ,[FailedPasswordAttemptCount]
  50:             ,[FailedPasswordAttemptWindowStart]
  51:             ,[FailedPasswordAnswerAttemptCount]
  52:             ,[FailedPasswordAnswerAttemptWindowStart]
  53:             ,[Comment])
  54:  Select     @Bug_ApplicationId 
  55:             ,[UserId]
  56:             ,[Password]
  57:             ,[PasswordFormat]
  58:             ,[PasswordSalt]
  59:             ,[MobilePIN]
  60:             ,[Email]
  61:             ,[LoweredEmail]
  62:             ,[PasswordQuestion]
  63:             ,[PasswordAnswer]
  64:             ,[IsApproved]
  65:             ,[IsLockedOut]
  66:             ,[CreateDate]
  67:             ,[LastLoginDate]
  68:             ,[LastPasswordChangedDate]
  69:             ,[LastLockoutDate]
  70:             ,[FailedPasswordAttemptCount]
  71:             ,[FailedPasswordAttemptWindowStart]
  72:             ,[FailedPasswordAnswerAttemptCount]
  73:             ,[FailedPasswordAnswerAttemptWindowStart]
  74:             ,[Comment]
  75:  from  dbo.aspnet_Membership  where  UserId=@UserID  
  76:  --
  77:  INSERT INTO [Bug].[dbo].[aspnet_Profile]
  78:             ([UserId]
  79:             ,[PropertyNames]
  80:             ,[PropertyValuesString]
  81:             ,[PropertyValuesBinary]
  82:             ,[LastUpdatedDate])
  83:  Select     [UserId]
  84:             ,[PropertyNames]
  85:             ,[PropertyValuesString]
  86:             ,[PropertyValuesBinary]
  87:             ,[LastUpdatedDate]
  88:  from   [dbo].[aspnet_Profile] where  UserId=@UserID  
  89:  --
  90:   
  91:  If (@@Error=0) BEGIN
  92:      COMMIT
  93:      select 0  as Error, NULL as ErrorMessage
  94:      return 0
  95:      
  96:  END
  97:  else BEGIN
  98:      rollback tran
  99:      select  @@Error  as Error, ERROR_MESSAGE() AS ErrorMessage
 100:      return -1
 101:  END
 102:   
 103:      END TRY
 104:   
 105:      BEGIN CATCH
 106:          rollback tran
 107:          Select -3 as Error, ERROR_MESSAGE() AS ErrorMessage
 108:          return -3
 109:      END CATCH 
 110:   
 111:  end
 112:   
 113:  else Begin
 114:  select -2 as Error, 'User Always present' AS ErrorMessage
 115:  return -2
 116:  End


Comments ( )
<00>  <01>  <02>  <03>  <04>  <05>  <06>  <07>  <08>  <09>  <10>  <11>  <12>  <13>  <14>  <15>  <16>  <17>  <18>  <19>  <20>  <21>  <22>  <23
Link to this page: //www.vb-net.com/Bug_Tracker/CopyUser.htm
<SITEMAP>  <MVC>  <ASP>  <NET>  <DATA>  <KIOSK>  <FLEX>  <SQL>  <NOTES>  <LINUX>  <MONO>  <FREEWARE>  <DOCS>  <ENG>  <CHAT ME>  <ABOUT ME>  < THANKS ME>