|
It's been pretty rough trying to figure out how to write the MongoDB context and some sort of MongoInitializer that runs from Programs.cs while passing the settings to load the MongoDB parameters. I'm seeding in .Net Core and not Angular V6 because it just seems like the right place to do it.
So I've seeded my default users, countries, and now states / provinces. I decided to copy the format of my previous versions here, but was forced to really change it up MongoDB style. I'm trying to loop through the countries I just wrote, to create states.
So this is what I wrote based off research from the internet. Don't know if it's right or wrong and it's very foreign to me. I'm in uncharted waters here on this. I understand this:
var websiteCountries = _database.GetCollection<WEBSITE_COUNTRIES>("Website_Countries");
but not the cursor part:
using (IAsyncCursor<WEBSITE_COUNTRIES> cursor = await websiteCountries.FindAsync(new BsonDocument()))
So the above code must set the cursor position; perhaps it set it at the end, and that's why the batch is null.
I'm not even sure if I'm on the right track here. I really don't care if it's async or not.
I'll read up on this part here await websiteCountries.FindAsync(new BsonDocument())
public static async Task SeedAsync(IMongoDatabase _database)
{
var websiteStates = _database.GetCollection<WEBSITE_STATES>("Website_States");
double totalDocuments = websiteStates.CountDocuments(FilterDefinition<WEBSITE_STATES>.Empty);
if (totalDocuments == 0)
{
var websiteCountries = _database.GetCollection<WEBSITE_COUNTRIES>("Website_Countries");
try
{
using (IAsyncCursor<WEBSITE_COUNTRIES> cursor = await websiteCountries.FindAsync(new BsonDocument()))
{
IEnumerable<WEBSITE_COUNTRIES> batch = cursor.Current;
foreach (WEBSITE_COUNTRIES country in batch)
{
Console.WriteLine(country.LongName);
}
}
}
catch(Exception ex)
{
Console.WriteLine(ex.Message.ToString());
}
}
}
I wrote this, well sort of copied it, havn't tested it yet. This is in my UserRespository and according to documentation is a CRUD method of getting all the users. What's sort of confusing is the context. I can generate a context here in the repository, but had to use a manual connection in my Seed. Perhaps this is the answer to my problem. FindSync vs FindAsync(_ => true).ToListAsync(). Why true?
public class UserRepository : IUserRepository
{
private readonly MongoDBContext _context = null;
public UserRepository(IOptions<Settings> settings)
{
_context = new MongoDBContext(settings);
}
public async Task<IEnumerable<WEBSITE_USERS>> GetAllUsers()
{
try
{
return await _context.WebsiteUsers
.FindSync(_ => true).ToListAsync();
}
catch (Exception ex)
{
throw ex;
}
}
My MongoDBInitializer where I wasn't able to generate a context. This isn't that important but it did send me down a different road and how I ended up here on this path.
public static void SeedData(Settings settings)
{
IMongoDatabase _database = null;
var client = new MongoClient(settings.MongoDB.Connection);
if (client != null)
_database = client.GetDatabase(settings.MongoDB.Database);
WebsiteUsers.Seed(_database);
var countryTask = WebsiteCountries.Seed(_database);
var statesTask = WebsiteStates.SeedAsync(_database);
}
If it ain't broke don't fix it
Discover my world at jkirkerx.com
|
|
|
|
|
I have a states collection now in MongoDB
I sort of get it now. _ => true must be a wildcard like *, generate a list of countries, as a Result, now I can do the old school loop, which I needed in case I had to walk the code. There was .ForEach(country => { // do work } which did a single execution that may be more efficient.
Ended up with this ...
public static async Task SeedAsync(IMongoDatabase _database)
{
var websiteStates = _database.GetCollection<WEBSITE_STATES>("Website_States");
double totalDocuments = websiteStates.CountDocuments(FilterDefinition<WEBSITE_STATES>.Empty);
if (totalDocuments == 0)
{
var websiteCountries = _database.GetCollection<WEBSITE_COUNTRIES>("Website_Countries");
try
{<br />
foreach (var country in websiteCountries.FindSync(_ => true).ToListAsync().Result)
{
switch (country.ShortName)
{
case "US":
ObjectId US_AL_Id = ObjectId.GenerateNewId();
var state_AL = new WEBSITE_STATES() { Id = US_AL_Id, DisplayId = US_AL_Id.ToString(), CountryId = country.DisplayId, CountryCode = country.ShortName, LongName = "Alabama", ShortName = "AL", Enabled = true };
await websiteStates.InsertOneAsync(state_AL);
If it ain't broke don't fix it
Discover my world at jkirkerx.com
|
|
|
|
|
It was about updating the country collection, and not inserting.
Guess there are two ways to work with MongoDB, one being through a context using the driver, and the other working with the MongoDB .Net Core driver straight.
This is where I got confused. So I'm using my MongoDBContext in my repositories which are CRUD and just the driver in my services which are REST.
Anyways, this is just a learning exercise for later use. I'll dump it and replace it with a text file written in the same BSON format later down the road.
But at least I got this working for now, well I haven't consumed yet so I'll find out.
var filter_US = Builders<WEBSITE_COUNTRIES>.Filter.Eq(s => s.ShortName, country.ShortName.ToUpper());
var update_US = Builders<WEBSITE_COUNTRIES>.Update.Set(s => s.States, states_US);
await websiteCountries.UpdateOneAsync(filter_US, update_US);
And my result, I saw Arizona is wrong, fixed.
{
"_id" : ObjectId("5b8434defb1e6524f8cc0554"),
"DisplayId" : "5b8434defb1e6524f8cc0554",
"LongName" : "United States",
"ShortName" : "US",
"States" : [
{
"_id" : ObjectId("5b8434dffb1e6524f8cc0582"),
"Name" : "Alabama",
"Abbr" : "AL"
},
{
"_id" : ObjectId("5b8434dffb1e6524f8cc0583"),
"Name" : "Alaska",
"Abbr" : "AK"
},
{
"_id" : ObjectId("5b8434dffb1e6524f8cc0583"),
"Name" : "Arizona",
"Abbr" : "AZ"
},
{
"_id" : ObjectId("5b8434dffb1e6524f8cc0585"),
"Name" : "Arkansas",
"Abbr" : "AR"
},
On a side not about my Angular V6 .Net Core 2.1 training exercise:
I finally got all my folders and files organized efficiently. Basically modules, components and services in Angular, plus my routing with lazy loading is correct. Figured out how to change navbars and footers using *ngIf. Got my new Auth Guard authentication working in Angular, including the Auth0 token and wrote a REST service in .Net Core to handle it, with cookies and token generation. My ContactUs works with my CRUD Repository, just have to write the email part, and figure out if I should do it in .Net Core, Angular or write something in NodeJS for it. Perhaps a .Net console app. So now I can move forward with more head scratchers and frustration. What I have learned so far is that Angular V6 is one thing and .Net Core is a whole different beast, but sort of the same. It's really hard to integrate or write and learn the two together. I can see learning Angular V6 first, and then dropping it into .Net Core and hooking it up being a better path to take. But then you have to architect your.Net Core 2 project in order to pull that off, and can't really rely on a template.
I'm pretty sure I have the terminology correct here. If I'm wrong feel free to correct me so I can get it right.
If it ain't broke don't fix it
Discover my world at jkirkerx.com
|
|
|
|
|
I have following code in ASP.NET MVC5 custom helper need to be converted in ASP.NET Core MVC custom helper:
UrlHelper url = new UrlHelper(HttpContext.Current.Request.RequestContext);
string urlEdit = url.RouteUrl("Default");
I have read Microsoft doc about how to access HttpContext in ASP.NET Core but still cannot figure it out how to convert the above code.
-- modified 22-Aug-18 12:43pm.
|
|
|
|
|
ASP.NET Core is all about middleware and DI. In ASP.NET Core, the UrlHelper requires the current action context, and you can acquire that from the ActionContextAccessor. For example in your ConfigureServices method, you can do:
public void ConfigureServices(IServiceCollection services)
{
services.AddMvc();
services.AddSingleton<IHttpContextAccessor, HttpContextAccessor>();
}
You can then inject the IActionContextAccessor and use it in your custom helper service:
public class MyCustomHelper : IMyCustomHelper
{
private readonly IHttpContextAccessor _httpContextAccessor;
private readonly IUrlHelperFactory _urlHelperFactory;
public MyCustomHelper(IHttpContextAccessor httpContextAccessor, IUrlHelperFactory urlHelperFactory)
{
_httpContextAccessor = httpContextAccessor;
_urlHelperFactory = urlHelperFactory;
}
public string GetUrl()
{
var context = _httpContextAccessor.HttpContext;
IUrlHelper urlHelper = urlHelperFactory.GetUrlHelper(context);
}
}
|
|
|
|
|
Thanks for your response. I'm new to ASP.NET Core and still have following questions:
- Where should I put ConfigureServices method?
- My current MVC5 custom helper like following:
public static class HtmlHelperExt
{
public static IHtmlString CHGridTable<tmodel>(this HtmlHelper<tmodel> htmlHelper, DataTable dt, object htmlAttributes = null)
{
UrlHelper url = new UrlHelper(HttpContext.Current.Request.RequestContext);
string urlEdit = url.RouteUrl("Default");
......
}
......//many other custom helpers
}
How can I inject the IActionContextAccessor and use it in my custom helper CHGridTable and other helpers? - How can I use the ContextAccessor to get info for the code lines below:
UrlHelper url = new UrlHelper(HttpContext.Current.Request.RequestContext);
string urlEdit = url.RouteUrl("Default");
|
|
|
|
|
JimFeng wrote: I'm new to ASP.NET Core and still have following questions:
- Where should I put ConfigureServices method?
Configuring services should be placed inside startup.cs. For more details, see: ASP.NET Core fundamentals | Microsoft Docs[^]
JimFeng wrote: How can I inject the IActionContextAccessor and use it in my custom helper CHGridTable and other helpers?
While it may be possible, I would still recommend you to convert your static/extension class into a service whose concrete implementation would use the IHttpContextAccessor as a dependency that can be injected via its constructor just like what I've showed you on my first reply.
If you still want to follow the static class approach then you could try this:
public static class HtmlHelperExt{
private static IHttpContextAccessor _httpContextAccessor;
private static IUrlHelperFactory _urlHelperFactory;
public static void SetHttpContextAccessor(IHttpContextAccessor accessor, IUrlHelperFactory urlHelperFactory) {
_httpContextAccessor = accessor;
_urlHelperFactory = urlHelperFactory;
}
public static IHtmlString CHGridTable<tmodel>(this HtmlHelper<tmodel> htmlHelper, DataTable dt, object htmlAttributes = null)
{
var urlHelper = _urlHelperFactory.GetUrlHelper(_httpContextAccessor.HttpContext);
string urlEdit = urlHelper.RouteUrl("Default");
}
}
In the Startup.ConfigureServices method you can call services.BuildServiceProvider() to get the IServiceProvider to resolve the type you seek. For example:
public void ConfigureServices(IServiceCollection service) {
services.AddMvc();
var serviceProvider = services.BuildServiceProvider();
var accessor = serviceProvider.GetService<IHttpContextAccessor>()
var userHelperFactory = serviceProvider.GetService<IUrlHelperFactory>()
HtmlHelperExt.SetHttpContextAccessor(accessor,userHelperFactory);
}
|
|
|
|
|
Thanks again for your patient. when I code following:
var urlHelper = _urlHelperFactory.GetUrlHelper(_httpContextAccessor.HttpContext);
and got the following error:
Argument 1: cannot convert from 'Microsoft.AspNetCore.Http.HttpContext' to 'Microsoft.AspNetCore.Mvc.ActionContext'
the error was caused by argument: _httpContextAccessor.HttpContext
|
|
|
|
|
Hmm.. it's really hard to test it out without a dev machine. Anyway instead of passing IHttpContextAccessor, try to pass the IActionContextAccessor instead. For example in your Helper class, you can do:
private static IActionContextAccessor _actionContextAccessor;
private static IUrlHelperFactory _urlHelperFactory;
public static void SetHttpContextAccessor(IActionContextAccessor accessor, IUrlHelperFactory urlHelperFactory) {
_actionContextAccessor = accessor;
_urlHelperFactory = urlHelperFactory;
}
then you can do:
var urlHelper = _urlHelperFactory.GetUrlHelper(_actionContextAccessor.ActionContext);
and finally, configure the IActionContextAccessor in Startup.ConfigureServices method:
var accessor = serviceProvider.GetService<IActionContextAccessor>()
var userHelperFactory = serviceProvider.GetService<IUrlHelperFactory>()
HtmlHelperExt.SetHttpContextAccessor(accessor,userHelperFactory);
You could also try what's suggested by Richard.
|
|
|
|
|
asp.net core - how to get IUrlHelper from inside Html helper - Stack Overflow[^]
Correcting the typo in that answer gives:
public static IHtmlContent CHGridTable<TModel>(this IHtmlHelper<TModel> htmlHelper, DataTable dt, object htmlAttributes = null)
{
var urlHelperFactory = (IUrlHelperFactory)htmlHelper.ViewContext.HttpContext.RequestServices.GetService(typeof(IUrlHelperFactory));
var urlHelper = urlHelperFactory.GetUrlHelper(htmlHelper.ViewContext);
string urlEdit = url.RouteUrl("Default");
...
}
You might also want to consider whether a custom tag helper might be a better choice for what you're trying to do:
Tag Helpers in ASP.NET Core | Microsoft Docs[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Thanks, I corrected error in my custom helper, but when I call the helper from views as following:
@HtmlHelperExt.CHGridTable(Model, new { tablename = "tblTest", defaultcolsort = "3" })
and got following error:
Error CS0411 The type arguments for method 'HtmlHelperExt.CHGridTable<TModel>(HtmlHelper<TModel>, DataTable, object)' cannot be inferred from the usage. Try specifying the type arguments explicitly.
The call on MVC5 works file, How can I use the custom helper on view of Core Web Application (MVC6):
The custom helper code as following:
public static IHtmlContent CHGridTable<tmodel>(this HtmlHelper<tmodel> htmlHelper, DataTable dt, object htmlAttributes = null)
{
var urlHelperFactory = (IUrlHelperFactory)htmlHelper.ViewContext.HttpContext.RequestServices.GetService(typeof(IUrlHelperFactory));
var url = urlHelperFactory.GetUrlHelper(htmlHelper.ViewContext);
......
return new HtmlString(tbBtnAdd.ToString() + tbGridTable.ToString() + script.ToString());
}
|
|
|
|
|
JimFeng wrote: @HtmlHelperExt.CHGridTable(Model, new { tablename = "tblTest", defaultcolsort = "3" })
That should probably be:
@Html.CHGridTable(Model, new { tablename = "tblTest", defaultcolsort = "3" })
You need to call it as an extension method on the IHtmlHelper instance, not call the static method directly.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
@Html.CHGridTable(......) works on MVC5 but not ASP.NET Core MVC.
|
|
|
|
|
|
I added @addTagHelper *, HtmlHelperExt in _ViewImports.cshtml file but still got error:
Error: CS1061 'IHtmlHelper<dataset>' does not contain a definition for 'CHDropdownMenu' and no accessible extension method 'CHDropdownMenu' accepting a first argument of type 'IHtmlHelper<dataset>' could be found (are you missing a using directive or an assembly reference?)
on the View page like this (the same as on MVC 5):
@model System.Data.DataSet
@using HtmlHelperExt;
......
@Html.CHDropdownMenu(Model, "mnuSample1", new { MenuOpenType = "Hover" })
......
My Custom helper like this:
namespace HtmlHelperExt
{
public static class HtmlHelperExt
{
public static IHtmlContent CHDropdownMenu<tmodel>(this HtmlHelper<tmodel> htmlHelper, DataSet ds, string divID, object htmlAttributes = null)
{
......
return new HtmlString(tbDiv_Menu.ToString());
}
}
}
|
|
|
|
|
JimFeng wrote: IHtmlHelper<dataset>' does not contain a definition for 'CHDropdownMenu'
CHDropdownMenu<tmodel>(this HtmlHelper<tmodel> htmlHelper,
You need to declare the helper method as an extension method against the IHtmlHelper interface, not the HtmlHelper class.
public static IHtmlContent CHDropdownMenu<TModel>(this IHtmlHelper<TModel> htmlHelper, ...
IHtmlHelper Interface (Microsoft.AspNetCore.Mvc.Rendering) | Microsoft Docs[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
My assembly is a custom HtmlHelper NOT TagHelper.
|
|
|
|
|
Yes, of course. 
You'll want @using statements for your namespace, rather than @addTagHelper statements. Still in the _ViewImports.cshml file, though.
@using HtmlHelperExt
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
@using HtmlHelperExt is already in the _ViewImports.cshml, but got the same error.
|
|
|
|
|
Did you change the first parameter of the extension method, as I suggested yesterday?
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Thank you Rick, after I changed the parm type, and the helper works in my ASP.NET Core 2.1 MVC app.
|
|
|
|
|
Hi All,
My application is build in framework 3.5 and now i m converting into 4.5. Here is the code.
Response.Redirect(Request.ApplicationPath + path, true);
While converting this line to 4.5, i m getting "\" in Request.ApplicationPath. But i need application path.
Please anyone tell me why i m getting the "\" insider of the application path.
|
|
|
|
|
If you don't want the "\" then remove it using TrimStart or TrimEnd depending where you want to remove it from.
|
|
|
|
|
Hi,
Getting "\" is not a problem. Insider of getting "\", i need application path.
|
|
|
|
|
What is your definition of the "application path"?
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
