c#entity-frameworkasp.net-coreentity-framework-coreasp.net-identity
A suitable constructor for type 'System.Collections.Generic.IEnumerable`1[TeamCloud.Areas.Identity.Data.TeamCloudUser]' could not be located
I'm working on my ASP NET Core project with IdentityFramework and now I need to display list of users in parameters in table on my RazorPage. Also, I can't imagine how can I move object from razor OnGet method to view (I need to move members object and display it on view). Anyway, I need to display only users that has a similar Team that logged user has (see code below) but I stuck with this error. Hope u can help me. Thanks.
Error
MembersList.cshtml
@page
@using TeamCloud.Areas.Identity.Pages.Team.Manage
@model IEnumerable<TeamCloudUser>
@{
ViewData["Title"] = "Список участников";
ViewData["ActivePage"] = ManageNavPages.MembersList;
}
<br />
<div style="text-align: center;">
<h2 style="font-weight: 700;">Настройки команды</h2>
</div>
<hr />
<partial name="_ManageNav" />
<hr />
<body class="index">
<form method="post" asp-page="MembersList">
<h4 style="font-weight: 700; text-align: center;">@ViewData["Title"]</h4>
<div class="text-center">
<input type="submit" asp-page-handler="AddMember" class="btn alert-primary" value="Добавить участника" style="cursor: pointer; font-weight: 700;" />
<br />
<table class="table" style="text-align: center">
<tr>
<th>
<a>Имя</a>
</th>
<th>
<a>Почта</a>
</th>
<th>
<a>Кол-во файлов</a>
</th>
<th>
<a>Объем памяти</a>
</th>
<th>
<a>Действия</a>
</th>
</tr>
@foreach (var member in Model.TeamCloudUsers)
{
<tr>
<td>
@Html.DisplayFor(modelItem => member.ProfileName)
</td>
<td>
@Html.DisplayFor(modelItem => member.Email)
</td>
<td>
@Html.DisplayFor(modelItem => member.TotalFiles)
</td>
<td>
@Html.DisplayFor(modelItem => member.TotalSize)
</td>
<td>
@if (@member.IsBlockedToUpload == true)
{
<a href="" data-toggle="modal" data-target="#modalOnAllow" class="">
<img style="width: 30px;" src="~/Media/MenuIcons/allow.png" title="Заблокировать" />
</a>
}
else
{
<a href="" data-toggle="modal" data-target="#modalOnBlock" class="">
<img style="width: 30px;" src="~/Media/MenuIcons/block.png" title="Заблокировать" />
</a>
}
<a href="" data-toggle="modal" data-target="#modalOnDelete" class="">
<img style="width: 30px;" src="~/Media/MenuIcons/delete.png" title="Выгнать" />
</a>
<!--modalOnBlock-->
<div class="modal fade" id="modalOnBlock" tabindex="-1" role="dialog" aria-labelledby="title" aria-hidden="true">
<div class="modal-dialog modal-dialog-centered" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="title">Блокировка пользователя</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
Запретить участнику "@member.Email" загружать новые файлы в командное хранилище?.
</div>
<div class="modal-footer">
<button type="submit" asp-page-handler="BlockToUpload" class="btn alert-primary" value="@member.Id" name="userId">Запретить</button>
<button type="button" class="btn alert-primary" data-dismiss="modal">Отмена</button>
</div>
</div>
</div>
</div>
<!--modalOnAllow-->
<div class="modal fade" id="modalOnAllow" tabindex="-1" role="dialog" aria-labelledby="title" aria-hidden="true">
<div class="modal-dialog modal-dialog-centered" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="title">Разблокировка пользователя</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
Предоставить пользователю "@member.Email" доступ к загрузке файлов в хранилище команды?
</div>
<div class="modal-footer">
<button type="submit" asp-page-handler="AllowToUpload" class="btn alert-primary" value="@member.Id" name="userId">Разрешить</button>
<button type="button" class="btn alert-primary" data-dismiss="modal">Отмена</button>
</div>
</div>
</div>
</div>
<!--modalOnDelete-->
<div class="modal fade" id="modalOnDelete" tabindex="-1" role="dialog" aria-labelledby="title" aria-hidden="true">
<div class="modal-dialog modal-dialog-centered" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="title">Исключение пользователя</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
Исключить пользователя "@member.Email" из команды? (тут подумать над удалением его файлов)
</div>
<div class="modal-footer">
<button type="submit" asp-page-handler="DeleteFromTeam" class="btn alert-primary" value="@member.Id" name="userId">Исключить</button>
<button type="button" class="btn alert-primary" data-dismiss="modal">Отмена</button>
</div>
</div>
</div>
</div>
</td>
</tr>
}
</table>
</div>
</form>
MembersList.cshtml.cs
namespace TeamCloud.Areas.Identity.Pages.Team.Manage
{
public class MembersListModel : PageModel
{
private readonly IWebHostEnvironment webHostEnvironment;
private readonly UserManager<TeamCloudUser> _userManager;
private readonly ILogger<TeamCloudUser> _logger;
private readonly TeamCloudContext _context;
SqlConnection sqlConnection = new SqlConnection("Data Source=DESKTOP-LRLFA5K\\SQLEXPRESS;Initial Catalog=TeamCloud;Integrated Security=True");
private string currentUserId { get; set; }
public MembersListModel(IWebHostEnvironment webHostEnvironment, UserManager<TeamCloudUser> userManager, ILogger<TeamCloudUser> logger, TeamCloudContext context)
{
this.webHostEnvironment = webHostEnvironment;
_userManager = userManager;
_logger = logger;
_context = context;
}
public IActionResult OnGetAsync()
{
var teamFounder = _userManager.GetUserId(User);
currentUserId = teamFounder;
int currentTeamId = FindTeamIdByName();
var teamMembers = _context.AspNetUserTeams.Where(x => x.TeamId == currentTeamId).Select(x => x.UserId);
string partialValue = null;
var members = partialValue;
foreach (var member in teamMembers)
{
members += _context.Users.Where(x => x.Id == member).FirstOrDefault();
}
return ??? //How to move object modal members to view in RazorPages?
}
public IActionResult OnPostAddMember()
{
return RedirectToPage("AddMember");
}
private int FindTeamIdByName()
{
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand("select TeamId from AspNetUserTeams where UserId = @userId", sqlConnection);
sqlCommand.Parameters.Add("@userId", SqlDbType.NVarChar);
sqlCommand.Parameters["@userId"].Value = currentUserId;
DataSet dataSet = new DataSet();
var dataAdapter = new SqlDataAdapter { SelectCommand = sqlCommand };
dataAdapter.Fill(dataSet);
sqlConnection.Close();
return Convert.ToInt32(dataSet.Tables[0].Rows[0]["TeamId"]);
}
}
}
TeamCloudUser
namespace TeamCloud.Areas.Identity.Data
{
// Add profile data for application users by adding properties to the TeamCloudUser class
public class TeamCloudUser : IdentityUser
{
//public virtual new string Email { get; set; }
public string ProfileName { get; set; }
public bool IsBlockedToUpload { get; set; }
public int TotalFiles { get; set; }
public string TotalSize { get; set; }
}
}
Solution
You need firstly learn how to get started in razor pages:
Razor Pages do not use @model ModelName,it uses @model <PageName>Model,which is different from mvc.
For your requirement,you do not know how to return model in razor pages.Change like below:
MembersList.cshtml:
@page
@model MembersListModel //change here
<body class="index">
<form method="post" asp-page="MembersList">
<h4 style="font-weight: 700; text-align: center;">@ViewData["Title"]</h4>
<div class="text-center">
<input type="submit" asp-page-handler="AddMember" class="btn alert-primary" value="Добавить участника" style="cursor: pointer; font-weight: 700;" />
<br />
<table class="table" style="text-align: center">
<tr>
<th>
<a>Имя</a>
</th>
//....
</tr>
@foreach (var member in Model.TeamCloudUsers)
{
<tr>
<td>
@Html.DisplayFor(modelItem => member.ProfileName)
</td>
<td>
@Html.DisplayFor(modelItem => member.Email)
</td>
<td>
@Html.DisplayFor(modelItem => member.TotalFiles)
</td>
<td>
@Html.DisplayFor(modelItem => member.TotalSize)
</td>
<td>
@if (@member.IsBlockedToUpload == true)
{
<a href="" data-toggle="modal" data-target="#modalOnAllow" class="">
<img style="width: 30px;" src="~/Media/MenuIcons/allow.png" title="Заблокировать" />
</a>
}
else
{
<a href="" data-toggle="modal" data-target="#modalOnBlock" class="">
<img style="width: 30px;" src="~/Media/MenuIcons/block.png" title="Заблокировать" />
</a>
}
<a href="" data-toggle="modal" data-target="#modalOnDelete" class="">
<img style="width: 30px;" src="~/Media/MenuIcons/delete.png" title="Выгнать" />
</a>
<!--modalOnBlock-->
<div class="modal fade" id="modalOnBlock" tabindex="-1" role="dialog" aria-labelledby="title" aria-hidden="true">
<div class="modal-dialog modal-dialog-centered" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="title">Блокировка пользователя</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
Запретить участнику "@member.Email" загружать новые файлы в командное хранилище?.
</div>
<div class="modal-footer">
<button type="submit" asp-page-handler="BlockToUpload" class="btn alert-primary" value="@member.Id" name="userId">Запретить</button>
<button type="button" class="btn alert-primary" data-dismiss="modal">Отмена</button>
</div>
</div>
</div>
</div>
<!--modalOnAllow-->
<div class="modal fade" id="modalOnAllow" tabindex="-1" role="dialog" aria-labelledby="title" aria-hidden="true">
<div class="modal-dialog modal-dialog-centered" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="title">Разблокировка пользователя</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
Предоставить пользователю "@member.Email" доступ к загрузке файлов в хранилище команды?
</div>
<div class="modal-footer">
<button type="submit" asp-page-handler="AllowToUpload" class="btn alert-primary" value="@member.Id" name="userId">Разрешить</button>
<button type="button" class="btn alert-primary" data-dismiss="modal">Отмена</button>
</div>
</div>
</div>
</div>
<!--modalOnDelete-->
<div class="modal fade" id="modalOnDelete" tabindex="-1" role="dialog" aria-labelledby="title" aria-hidden="true">
<div class="modal-dialog modal-dialog-centered" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="title">Исключение пользователя</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
Исключить пользователя "@member.Email" из команды? (тут подумать над удалением его файлов)
</div>
<div class="modal-footer">
<button type="submit" asp-page-handler="DeleteFromTeam" class="btn alert-primary" value="@member.Id" name="userId">Исключить</button>
<button type="button" class="btn alert-primary" data-dismiss="modal">Отмена</button>
</div>
</div>
</div>
</div>
</td>
</tr>
}
</table>
</div>
</form>
</body>
MembersList.cshtml.cs:
public class MembersListModel : PageModel
{
//1. add the following property
public IEnumerable<TeamCloudUser> TeamCloudUsers { get; set; }
public void OnGet()
{
//2. set data for the property
//for easy testing,I hard-coded the data
//you could get the data from database
//e.g. TeamCloudUsers = _context.AspNetUserTeams
// .Where(x => x.TeamId == currentTeamId).ToList();
TeamCloudUsers = new List<TeamCloudUser>()
{
new TeamCloudUser(){ ProfileName ="a",IsBlockedToUpload=false,Email="[email protected]",TotalFiles=2,TotalSize="34"}
};
}
}
Result:
Update:
Modify your code to:
// change here...
<a href="" data-toggle="modal" data-target="#[email protected]" class="">
<img style="width: 30px;" src="~/Media/MenuIcons/block.png" title="Заблокировать" />
</a>
<!--modalOnBlock-->
//change here...
<div class="modal fade" id="[email protected]" tabindex="-1" role="dialog" aria-labelledby="title" aria-hidden="true">