Activities of "bilalhaidar"

Hello,

Is there a plan to provide a Forum/Blog module for the public website with backend management? If not, do you recommend any open-source Forum/Blog that I can integrate with ASPNETZERO?

Thanks

Hi, I have a bit complex query that I know how to write in SQL but not in LINQ-To-SQL.

Can I use the DbSset.FromSql() method to execute Raw SQL in a custom repository? (ASP.NET Core / Angular 2).

I dunno if you can help with the linq-to-sql.

I have the following setup:

OU (Region) with Parent Null OU (Camp) with Parent OU Region

This could be repeated many times in a sense I will have many regions and many camps within. (2 level only)

I have an entity that needs to store the OU Id.

Upon creation of this new entity, if the entity belongs to a region only, then OU (Region) Id is stored on the entity. If however, this entity belongs to an OU (Region) and OU (Camp), then the OU (Camp) Id is stored on the entity.

A user would have access (belongs) to OUs. if he belongs to an OU (Region) he/she can see all entities created within the O?OU (Region) and OU(Camp)s within the region. If he/she has access to a OU (Camp) only, he/she can see entities created in that OU (Camp) only.

Here's the SQL Query (entity in this case Blog Post). Can it be done in LINQ? Otherwise, can I use FromSql() method?

Thanks

DECLARE @code NVARCHAR(100) = '00001%'
DECLARE @user INT = 1;

WITH UserOus(OuId) AS
(
	SELECT 
		[ou].[Id]
	FROM
		[AbpUserOrganizationUnits] AS [ous]
	LEFT OUTER JOIN [AbpOrganizationUnits] AS [ou] ON [ou].Id = [ous].OrganizationUnitId
	WHERE [ous].UserId = @user
)
SELECT [bp].[Id], [bp].[Title], [bp].[OrganizationUnitId]
FROM [BlgPosts] AS [bp]
INNER JOIN [AbpOrganizationUnits] AS [ou] ON [bp].[OrganizationUnitId] =[ou].[Id]
INNER JOIN [UserOus] AS [uous] ON [ou].ParentId = [uous].[OuId] OR [ou].[Id] = [uous].OuId
GO 


SELECT TOP (1000) [Id]
      ,[TenantId]
      ,[ParentId]
      ,[Code]
      ,[DisplayName]
      ,[IsDeleted]
      ,[DeleterUserId]
      ,[DeletionTime]
      ,[LastModificationTime]
      ,[LastModifierUserId]
      ,[CreationTime]
      ,[CreatorUserId]
  FROM [MainApp].[dbo].[AbpOrganizationUnits]

SELECT TOP (1000) [Id]
      ,[CategoryId]
      ,[Title]
      ,[Content]
      ,[Tags]
      ,[Status]
      ,[CreationTime]
      ,[CreatorUserId]
      ,[OrganizationUnitId]
  FROM [MainApp].[dbo].[BlgPosts]
  
  SELECT TOP (1000) [Id]
      ,[UserId]
      ,[OrganizationUnitId]
      ,[CreationTime]
      ,[CreatorUserId]
      ,[TenantId]
  FROM [MainApp].[dbo].[AbpUserOrganizationUnits]

Hello, I configured both Web.Host and Web.Public to run at the same time in VS 2017.

Each website runs on its own Port.

When I click Login on the Public website, I am redirected to the Login page of the Web.Host.

In VS 2017, they are two websites or apps, possible they will be hosted separately.

How does it work to authenticate the public website using the Web.Host app? Can those 2 websites share sessions/cookies? I am lost a bit here.

Thanks

Hello,

Similar to the interfaces present currently in Abp the CreationFullEdit and others, I need to populate a common property on all my entities which is the full entity name. How can I implement such thing in Abp?

Thanks

Hello, I am in need to extend Users Screen UI to allow an admin to select multiple values from a list. This would be translated as many-to-many in the database.

Can you give me guidelines on how to do so?

In other words, when a new user is created, I need to let the admin select multiple values (Regions) then in the DB I would have a new Table UserRegions or something where 1 Region can have more than 1 User and 1 User can belong to more than 1 Regions.

Thanks Bilal

Hi I am following the Development Step by Step using ASP.NET Core and Angular 2.

Towards the end of the tutorial, there is a line of code as:

await _personRepository.EnsureLoadedAsync(person, p => p.Phones);

The method EnsureLoadedAsync() is not present anymore. I replaced it with EnsureCollectionLoadedAsync(). Is that correct?

Also, why do we need this method to be called? Is it something like Include()? Is it because the IRepository.Get() does a lazy load?

Thanks

For some reason, today, I cannot F5 or Ctrl+F5 my project and I am getting the attached error in VS 2017. Any idea?

Hello,

I noticed in so many places the '@' sign is being used when importing classes from the @shared and others.

How can one add this '@' to his own code? Anything special needed to make all my imports (code I write) make use of '@'?

Thanks

Hello, I am using ASP.NET Core / Angular / NET 4.6. Is the ASP.NET Boilerplate / Abp Framework the same for this project as in the ASP.NET MVC one?

Can you share with me links to GitHub to the ASP.NET Core Abo Framework?

Thanks

Hello, I noticed that when Web.Host runs, automatically swagger opens and not anything else. How is that configured in this project?

Also, all the Controllers (TokenAuthentication and the ProfileController, etc.) They are defined in the Web.Core project and added to IoC, that's why they are available when requested?

Thanks