public int GetUserMigrationId(string sourceUserPrincipalName, int projectId)
{
return(T2T.ExecuteScalar <int>(string.Format("SELECT [UserMigrationId] FROM UserMigration AS UM JOIN [User] AS SU ON UM.SourceUserID = SU.UserId WHERE [SU].[UserPrincipalName] = '{0}' AND [UM].[ProjectId] = {1}", sourceUserPrincipalName, projectId)));
}
public int GetProjectId(string projectName, int clientId = 0)
{
return(T2T.ExecuteScalar <int>(string.Format("SELECT [ProjectId] FROM Project WHERE [ProjectName] = '{0}' {1}", projectName, clientId > 0 ? string.Format("AND [ClientId] = {0}", clientId) : string.Empty)));
}
