ASP.NET

Re: An unhandled exception occurred while processing the constructor in ASP.NET Core MVC

6-Dec-21 8:51

I use the following code for dependency injection of Register/Login controller. The problem is that I cannot use Repository pattern I have created previously.

private readonly UserManager<AppUser> _userManager;
        private readonly SignInManager<AppUser> _signInManager;
        private readonly IUserRepository _userRepository;

        public HomeController(UserManager<AppUser> userManager, SignInManager<AppUser> signInManager, IUserRepository userRepository)
        {
            _userManager = userManager;
            _signInManager = signInManager;
            _userRepository = userRepository;
        }

When I run the code, the following error is occured:

Quote:
InvalidOperationException: Unable to resolve service for type 'CustomizedIdentity.Repositories.IUserRepository' while attempting to activate 'CustomizedIdentity.Controllers.HomeController'.

modified 6-Dec-21 14:00pm.

Richard Deeming6-Dec-21 22:54

Re: An unhandled exception occurred while processing the constructor in ASP.NET Core MVC

6-Dec-21 22:54

You haven't registered an implementation of your IUserRepository service in your DI container. You need to fix your service registration code to register that service, and any services it depends on.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Alex Dunlop7-Dec-21 8:09

Use Active Directory for authentication

7-Dec-21 8:09

Thanks, Solved.

Joseline Riker2-Dec-21 6:50

Joseline Riker

2-Dec-21 6:50

I am trying to create a site on IIS that can allow users to manually thru their mobile phones (yes they will have access to this internal site), and use their AD username/password to login. Anyone that's valid is allowed in. Once authenticated will present the next page. Plus that next page wouldn't allow them on it unless they are authenticated. Does anyone have any sample ASP.NET Web examples to get me started? Don't usually develop applications within IIS other than HTML pages so looking for any samples to get me started. Having a hard time finding one that isn't how to use Azure online.

Is this data annotation correct for date and time?

Alex Dunlop25-Nov-21 23:26

Re: Is this data annotation correct for date and time?

25-Nov-21 23:26

Hi,
I'm creating models for my ASP.NET Core project. I want to use "Code First" approach to create database and tables. Please check these annotations to be correct:

[Required]
       [DataType(DataType.Date)]
       [DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:MM/dd/yyyy}")]
       public DateTime creationDate { get; set; }
       [Required]
       [DataType(DataType.Time)]
       [DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:HH:mm:ss}")]
       public DateTime creationTime { get; set; }

And please tell me that what 0 means inside the curly braces.

Richard MacCutchan26-Nov-21 1:02

Re: Is this data annotation correct for date and time?

26-Nov-21 1:02

The DataFormatString value is a format string to convert a date to a string in the format shown. The zero gives the position of the data parameter (following the format string) when the format is used, like:

string theDate = string.Format(DataFormatString, someDateTimeValue);

See String.Format Method (System) | Microsoft Docs[^]

Alex Dunlop26-Nov-21 1:28

Re: Is this data annotation correct for date and time?

26-Nov-21 1:28

Is data annotation for the time correct?

[DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:HH:mm:ss}")]

Richard MacCutchan26-Nov-21 1:39

Re: Is this data annotation correct for date and time?

26-Nov-21 1:39

I deliberately did not answer that part because I don't know the answer. Does it correspond to the documentation?

Alex Dunlop26-Nov-21 1:45

Re: Is this data annotation correct for date and time?

26-Nov-21 1:45

No, I did not find any reference for time format. Can I use String type instead?

Richard MacCutchan26-Nov-21 1:56

Re: Is this data annotation correct for date and time?

26-Nov-21 1:56

As I said above: DataType Enum (System.ComponentModel.DataAnnotations) | Microsoft Docs[^].

jkirkerx28-Nov-21 10:12

jkirkerx

28-Nov-21 10:12

I get what you want to do here, which is to create models to match your database perhaps, so each table has a matching model. But your over thinking this, and don't need that much detail. Keep it simple and flexible at first, and only add detail when needed. For some reason Microsoft likes to capitalize the first letter, and will nag you later about the first letter being lower case.

This is an example model in c# to match a DB table or collection. Your example is a like a model used to present data in the view. Even when presenting data in the view, I would keep that simple as well. You want to craft models as simple as possible, and try to make them as reusable as possible to keep models down in count.

public class PORTFOLIOS
    {
        // standard BsonId generated by MongoDb 

        public string Id { get; set; }
        public DateTime TimeStamp { get; set; }        
        public string Name { get; set; }
        public string Description { get; set; }
        public string CreatedBy { get; set; }
        public string UpdatedBy { get; set; }
        public DateTime UpdateDate { get; set; }
        public string HTML { get; set; }
        public string AvatarB64 { get; set; }
        public string AvatarName { get; set; }
        public string AvatarType { get; set; }
        public string AvatarUrl { get; set; }
        public int AvatarX { get; set; }
        public int AvatarY { get; set; }        
    }

If it ain't broke don't fix it
Discover my world at jkirkerx.com

Cannot establish local connection to SQL SERVER

Alex Dunlop25-Nov-21 0:15

Re: Cannot establish local connection to SQL SERVER

25-Nov-21 0:15

Hi,
I'm using ASP.NET Core 6. I'm trying to establish a local connection with SQL SERVER. The authentication method is Windows Auth. I used the following code in appsettings.json:

ASP

"ConnectionStrings": {
    "AuthConnectionString": "Server=.;Database=AspNetAuth;Trusted_Connection=True"
  }

And following code in program.cs:

ASP

builder.Services.AddDbContext<AuthDbContex>(options => options.UseSqlServer(builder.Configuration.GetConnectionString("AuthConnectionString")));
builder.Services.AddIdentity<IdentityUser, IdentityRole>().AddEntityFrameworkStores<AuthDbContex>();

I created Migration, but when I try to update database, the following error is occured:

Quote:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Richard MacCutchan25-Nov-21 1:37

Re: Cannot establish local connection to SQL SERVER

25-Nov-21 1:37

Are you sure that . is a valid server address?

Richard Deeming25-Nov-21 2:15

Re: Cannot establish local connection to SQL SERVER

25-Nov-21 2:15

In a SQL connection string, . resolves to the local computer.

You can even use it with a named instance - for example: server=.\SQLEXPRESS

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Richard MacCutchan25-Nov-21 2:18

Re: Cannot establish local connection to SQL SERVER

25-Nov-21 2:18

Thanks, not seen it used before.

Richard Deeming25-Nov-21 2:19

Re: Cannot establish local connection to SQL SERVER

25-Nov-21 2:19

There are many possible causes of that error. For example, do you have a default instance[^] (not a named instance) of SQL Server running on your local computer? Is it properly configured to accept named pipe connections[^]? Is your Windows account correctly configured for access[^]?

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

jsc4225-Nov-21 3:56

jsc42

25-Nov-21 3:56

A SO answer at "sql server - What is a Trusted Connection? - Stack Overflow[^]" has 'Trusted_Connection=Yes;', not 'Trusted_Connection=True;'. Worth a try?

Re: Cannot establish local connection to SQL SERVER

Richard Deeming25-Nov-21 4:33

Re: Cannot establish local connection to SQL SERVER

25-Nov-21 4:33

Both the System.Data.SqlClient and Microsoft.Data.SqlClient libraries say that you can use true, yes, or SSPI for the value, and either Trusted_Connection or Integrated Security as the key.

The "strongly recommended" version is Integrated Security=SSPI.

SqlConnection.ConnectionString Property (Microsoft.Data.SqlClient) | Microsoft Docs[^]
SqlConnection.ConnectionString Property (System.Data.SqlClient) | Microsoft Docs[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Alex Dunlop25-Nov-21 10:02

call a server side Powershell script?

25-Nov-21 10:02

I used app.UseAuthentication and the problem solved.

Joseline Riker19-Nov-21 7:44

Joseline Riker

19-Nov-21 7:44

I am trying to allow my users to check if they have ActiveSync enabled for email and if they do return you are good to go, else tell them they need to complete a form. So a simple test I setup tried to start with a powershell.asp page containing:

<form action="doPowershell.asp" method="post">
    Network Username: <input type="textbox" name="userName"/>
    <input type="submit"/>
</form>

Then the resulting doPowershell.asp page I have for testing:

<%
Dim userName
userName = Request.Form("userName")
response.write(userName)

Server.Execute("activesync.ps1")
%>

the activesync.ps1 file contains

(Get-CASMailbox -Identity <username>).ActiveSyncEnabled

On the screen it outputs the value the user entered and then outputs the content of the ps1 file. Doesn't physically run anything. Thoughts?

Note: The current form doesn't really effect the PowerShell script. Just a shell I wrote to see if I could run it. The PS1 right now is just hardcoded with a physical username.

Re: call a server side Powershell script?

Richard Deeming21-Nov-21 23:52