Activities of "oaalvarado"

Hi exInt,

Thanks for the code. If I understand the code correctly, it is for a modal View. But I am not using a modal View, and want to use a normal View, because in the form I have to include several datatables, and this datatables will have modal Views to add or edit data.

Also, I don't know how to fix the "HTTP Error 415". How can I specify the Content Type in the submit? I believe the correct Content Type would be "application/JSON", right?

Hi maliming,

This is the code for the Create method in portsAppService:

    [AbpAuthorize(AppPermissions.Pages_Ports_Create)]        
    public async Task Create(CreatePortDto input)
    {
        var organization = new Organization()
        {
            Name = input.Name,
            Logo =  null, //input.Logo,
            Address = input.Address,
            Phone1 = input.Phone1,
            Phone2 = input.Phone2,
            Fax = input.Fax,
            EMail1 = input.EMail1,
            EMail2 = input.EMail2,
            Website = input.Website,
            CategoryId =  input.CategoryId,
            CountryId = input.CountryId,
            CityId = input.CityId
        };

        var result = await _organizationRepository.InsertAsync(organization);

        var port = new PortDetail()
        {
            Code = input.Code,
            Governance = input.Governance,
            OrganizationId = result.Id
        };

        var result2 = await _portDetailRepository.InsertAsync(port);
    }
   

This is the output for abp.services.

I have noticed that when I click in the Save button, the code in the portsAppService is not called. Neither the code in the Javascript. I think maybe is something with the CSHTML? This is the Create.cshtml code (I removed part of the code that is irrelevant):

@using CPMS.Authorization @using CPMS.Web.Areas.App.Models.Ports @using CPMS.Web.Areas.App.Startup

@model CreatePortViewModel @{ ViewBag.CurrentPageName = AppPageNames.Application.Ports; }

@section Scripts { <script abp-src="/view-resources/Areas/App/Views/Ports/Create.js" asp-append-version="true"></script> }

**<form class="kt-form createPort-form" id="CreatePortForm" name="CreatePortForm" role="form" novalidate asp-action="Create" asp-controller="Ports" asp-area="App" method="post">**
    <div class="kt-subheader kt-grid__item">
        <div class="kt-subheader__main">
            <h3 class="kt-subheader__title">
                <span>@L("CreateNewPort")</span>
            </h3>
            <span class="kt-subheader__separator kt-subheader__separator--v"></span>
            <div class="kt-subheader__desc">
                @*<h3> @Model.Code - @Model.Name </h3>*@
            </div>
        </div>
        <div class="kt-subheader__toolbar">
            <div class="kt-subheader__wrapper">
                <button id="ReturnPortList" class="btn btn-primary"><i class="fa fa-backward"></i> @L("PortsList")</button>
               ** <button id="Save" type="submit" class="btn btn-secondary btn-outline-secondary"><i class="fa fa-save"></i> @L("Save")</button>**
                <button id="SaveAndEdit" type="submit" class="btn btn-secondary btn-outline-secondary"><i class="fa fa-save"></i> @L("SaveAndEdit")</button>
            </div>
        </div>
    </div>
    

When I click the submit button, it goes to this URL: http://localhost:62114/api/services/app/Ports/Create but displays the error: HTTP Error 415.

Thanks for your help.

Hi @ismcagdas,

Sorry for the late response, I was out of the office last week. I enabled the Preserve log in Dev Tools and tried to Save a new port. At first I had a javascript error, the script file was not loading. I fixed this, and now I get this error in the Dev Tool Console:

POST http://localhost:62114/api/services/app/Ports/Create 415 (Unsupported Media Type)

Thanks for your help.

Hi @maliming,

The organization I work for doesn't allow the use of Teamviewer. I have Skype for Business. Is there another way to connect?

Hi @maliming,

I did the following as a test, created a simple View with 2 fields, added the code in controller and model to save the data from the View, but when I click the button to do the Post action, it displays the error message HTTP Error 415. I did this in a demo project, not the one I'm working on.

Hi maliming,

The issue was with the javascript. It works now. Thanks for your help.

Hi,

I'm using ASP.NET Zero Core MVC JQuery version is 7.0.0 with SQL Server Database. I need to access data from an Oracle Database, but can't get it to work.

I added the Oracle.EntityFrameworkCore nuget package to the EntityFrameworkCore and Web.Mvc projects. I created a connectionstring for the Oracle Database in the appsettings.json file in Web.Mvc project. Created another DbContext, DbContextconfigurer and DbContextFactory in the EntityFrameworkCore project for the Oracle Database. Added code in the PreInitialize subrutine in the EntityFrameworkCoreModule to configure the Oracle Database.

I tried to create a custom repository to query the Oracle Database, but I can't get it to connect to the database. I can't find any documentation on what to do next. Can you please provide some guidance?

Hi maliming,

Thanks. the second database is only to get data from, so no migration for this database is needed. I will just query this Oracle Database. I followed the example and I was missing the MyConnectionStringResolver.cs class. But now, when I try to connect to the Oracle Database, I get the error:

ArgumentException: IsolationLevel must be ReadCommitted or Serializable Parameter name: isolationLevel Oracle.ManagedDataAccess.Client.OracleConnection.BeginTransaction(IsolationLevel isolationLevel)

I'm using a Custom Repository to query the Oracle Database, I followed this https://aspnetboilerplate.com/Pages/Documents/Articles/Using-Stored-Procedures,-User-Defined-Functions-and-Views/index.html to add the Custom Repository to query a View in the Oracle Database, but when I try to connect to the database using this function:

private void EnsureConnectionOpen() { var connection = Context.Database.GetDbConnection();

if (connection.State != ConnectionState.Open)
{
    connection.Open();
}

}

I get the error in the Context.Database.GetDbConnection() call.

Hi maliming,

I figured out that I need to configure the Isolationlevel in the Preinitialize function of EntityFrameworkCoreModule:

Configuration.UnitOfWork.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;

And now I can connect to the Oracle Database.

Question: Is this something that can be configure only for the Oracle DBContext or is a global setting?

Is there a performance penalty on using IsolationLevel.ReadCommitted instead of IsolationLeve.ReadUncommitted?

Thanks maliming.