Set route in net core api - ASP.NET Discussion Boards

Member 1483395815-May-20 22:27

15-May-20 22:27

Bonjour,

Je débute le développement et l’utilisation des web services.

Ce web service sera développé dans un environnement ASP.NET et doit permettre d'accéder à une base des données oracle 11g distante pour récupérer des données de certaines tables.

Après sera appelé et utilisé dans une application web mcv développée sous visuel studio 2012.

Comment faire afin de développer et utiliser ce web service ?

Merci.

développer et utiliser le web service

Member 1483395815-May-20 22:27

Member 14833958

15-May-20 22:27

insert data into list from form and

Member 1322055211-May-20 0:41

Member 13220552

11-May-20 0:41

Hello I am working on a project where I must be able to display information recorded via a form in a datatable without going through the registration of the database, I suppose that it will be to record the information in a list to browse it and display the information in the datatable. but I really don't know how to do it. and is it already possible?

[REPOST] insert data into list from form and

Richard Deeming11-May-20 4:18

Richard Deeming

11-May-20 4:18

You have already posted this in QA:
Insert data into list from form[^]

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

IServiceCollection / DependencyInjection issue

Super Lloyd7-May-20 21:39

Super Lloyd

7-May-20 21:39

In our web app, as expected, the DbContext for our data is injected with DI.

It is registered with this extension method (the one that take a Func<> factory method):

public static IServiceCollection AddScoped<TService>(this IServiceCollection services, Func<IServiceProvider, TService> implementationFactory) where TService : class;

Now every now and then, due to maintenance task in our UAT servers, the Database is offline for a little while.
If that ever happen while someone try to connect to the DB, anyservice that need that DbContext fail with the same exception. Regardless whether the DB is back online or not.
We need to restart the app to fix that.

Now I wonder.. is there a way to fix that? (A way that doesn't involve restarting our app!)

[EDIT] Solved
It was DI for Startup.Configure() which prevented the application from running.
DI itself is fine and as expected!

A new .NET Serializer
All in one Menu-Ribbon Bar
Taking over the world since 1371!

modified 12-May-20 1:20am.

Re: IServiceCollection / DependencyInjection issue

Richard Deeming10-May-20 23:01

Richard Deeming

10-May-20 23:01

That doesn't sound right. Each request should result in a new instance of the DbContext, which should make a new connection. The failure of a previous connection shouldn't affect it.

What does the implementation factory look like, and what's the exception?

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

Re: IServiceCollection / DependencyInjection issue

Super Lloyd11-May-20 20:19

Super Lloyd

11-May-20 20:19

my bad....
it was DI for Startup.Configure() which was bringing the application down....
so DI is fine, it's just the app was broken!

A new .NET Serializer
All in one Menu-Ribbon Bar
Taking over the world since 1371!

Set route in net core api

pkfox5-May-20 8:20

pkfox

5-May-20 8:20

Hi all, how do I set a route ( or attribute or whatever ) so I can call this method which is present in a net core api controller ? assume my controller is called MyController - I've googled endlessly and can't find a simple answer

I would like to be able to access it something like this

myipaddress:myportnumber/MyController/1

public ActionResult<Actuator> GetAValue(int id)
{
// businesslayer is my DAL and is instantiated in my controller c'tor
    return businessLayer.GetAValue(id);
}

"We can't stop here - this is bat country" - Hunter S Thompson - RIP

Re: Set route in net core api

Richard Deeming5-May-20 9:41

Richard Deeming

5-May-20 9:41

There's an example on the Microsoft docs site which is close to what you want:
Routing to controller actions in ASP.NET Core | Microsoft Docs[^]

[Route("[controller]")]
[ApiController]
public class MyController : ControllerBase
{
    [HttpGet("{id:int}")] // GET /MyController/1
    public ActionResult<Actuator> GetAValue(int id)
    {
        ...
    }
}

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

Re: Set route in net core api

pkfox5-May-20 11:06

pkfox

5-May-20 11:06

Hi Richard thanks for the suggestion but I'm still getting a 404 - v weird

Edit

Apologies Richard it does work - thanks again

"We can't stop here - this is bat country" - Hunter S Thompson - RIP

modified 6-May-20 5:37am.

Re: Set route in net core api

jkirkerx7-May-20 9:58

jkirkerx

7-May-20 9:58

I use this for API JSON Calls. But you can tweak into other uses as well

[Produces("application/json")]
[Route("api/[controller]")]
[ApiController]
public class MyController : ControllerBase
{
  [HttpGet("GetWarehousesKv/{vendorId}")]
  public async Task<List<KeyValue>> GetWarehousesKv(string vendorId)
  {
     return await myRepository.GetWarehousesKv(vendorId);<br />
  }
}

And I call it like this.

Notice the controller route prefix api?
and notice the controller name My

https://domain.com/api/my/GetWarehousesKV/500689

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

Re: Set route in net core api

pkfox13-May-20 2:07

pkfox

13-May-20 2:07

Hi thanks for that I have it sorted now

"We can't stop here - this is bat country" - Hunter S Thompson - RIP

Re: Set route in net core api

jkirkerx13-May-20 6:27

jkirkerx

13-May-20 6:27

Cool!

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

Securing a Web Project Using ASP.Net

MadDashCoder30-Apr-20 21:01

MadDashCoder

30-Apr-20 21:01

Suppose I have a web project that is made up of a Web API, a bunch of HTML files, and some Javascript files. Is it possible to provide security to my project files with nothing more than a login page which posts a user's credentials to the Web API which then queries the database to check if the user exists?

If it's possible, how would I control things like redirect users to a certain page upon successful login or better yet prevent users from accessing any page other than the login page if they're not logged in?

modified 1-May-20 2:59am.

Re: Securing a Web Project Using ASP.Net

Richard MacCutchan30-Apr-20 22:37

Richard MacCutchan

30-Apr-20 22:37

That is a fairly standard part of many web sites; see asp.net authorization - Google Search[^]

Re: Securing a Web Project Using ASP.Net

MadDashCoder1-May-20 3:39

MadDashCoder

1-May-20 3:39

Hi, thanks for replying. I don't know if you understood my questions above but let me rephrase. What I'm asking is if my web project consists of only HTML files, some Javascript files, a Web API, and nothing else. Would it be possible to provide security to my web project?

Remember that I did not mention MVC or Web Form. If it is possible to secure my project without using MVC controllers or web form, how would I authorize users after successful logins?

modified 1-May-20 8:46am.

Re: Securing a Web Project Using ASP.Net

Richard MacCutchan1-May-20 5:16

Richard MacCutchan

1-May-20 5:16

MadDashCoder wrote:
I did not mention MVC or Web Form

True, but the issue is much the same: we api authorization[^]

Generate an MVC Project Folder and Files Using Web API 2.2

Liagapi30-Apr-20 20:42

Liagapi

30-Apr-20 20:42

Is it possible to generate an MVC project folder and files using Web API 2.2? I'd like to know because I need to generate MVC project folder and files dynamically.

Re: Generate an MVC Project Folder and Files Using Web API 2.2

Richard MacCutchan30-Apr-20 22:36

Richard MacCutchan

30-Apr-20 22:36

You can do it with Visual Studio.

Re: Generate an MVC Project Folder and Files Using Web API 2.2

MadDashCoder1-May-20 3:29

MadDashCoder

1-May-20 3:29

I guess my question is not very clear. What I meant is can a web project folder and web files (.cshtml, web.config, etc.) be generated using functions we write in a Web API after the Web API project has been built and deployed to the server.

Basically the question is, can we send a call to the Web API functions at run time to create a web project folder and web files dynamically (meaning this happens after building and deploying our Web API project to the server).

modified 1-May-20 8:48am.

Re: Generate an MVC Project Folder and Files Using Web API 2.2

Richard MacCutchan1-May-20 4:23

Richard MacCutchan

1-May-20 4:23

Well, assuming you have the skills to create all the files then I would guess it is possible.

BTW, why are you using two accounts here? You should close one of them.

Re: Generate an MVC Project Folder and Files Using Web API 2.2

Mycroft Holmes1-May-20 13:05

Mycroft Holmes

1-May-20 13:05

You can generate the files on the server and pass them to the client but if the client is a browser then it will be a download as it cannot write to the local disk.

Otherwise you are going to have to write a client to write the file to disk.

Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

C++,Jquery, SQL MVC, produce Excel pie graph?

Member 1464122429-Apr-20 21:47

Member 14641224

29-Apr-20 21:47

Hey chaps

Young programmer here.

Does anyone know how to produce an excel pie graph in excel through MVC C+, Jquery or even SQL? I have the pie graph with rows 1 to 10 and would like to produce a pie excel graph with data in it when the excel is downloaded through a website.Any links would be appreciated, many thanks and remember to sneeze into your elbow!!

Re: C++,Jquery, SQL MVC, produce Excel pie graph?

Richard MacCutchan30-Apr-20 0:29

Richard MacCutchan

30-Apr-20 0:29

As far as I know the graph details need to be embedded in the Excel worksheet. I guess it may be possible if you know the worksheet layout to add the details through the use of the ACE Excel driver. But I am not 100% sure that that is what you are asking.

Re: C++,Jquery, SQL MVC, produce Excel pie graph?

Member 1464122430-Apr-20 0:44

Member 14641224

30-Apr-20 0:44

Thanks

Not quite, but I guess close. Someone is going to be drawing a report from a website. Inside the excel spreadsheet is various data. I want this data (when opened in excel) to also have a pie graph attributed to it. Thanks!

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.