Search results for query: *

  • Users: raysefo
  • Content: Threads
  • Order by date
  1. R

    Question How to read data from Hyper-V?

    Hello there, I would like to get RAM, CPU, and disk data from Hyper-V, is there any tutorial that I can follow? I have no experience with virtualization or servers. Basically, let's say there are 10 Hyper-Vs. I would like to do is, retrieve RAM, CPU, and disk data of them in my console...
  2. R

    Question ASP.NET Core 6 Web API - How to return 400 bad request responses from middleware

    Hi guys, I have an ASP.NET Core 6 Web API that I am calling 3rd party web services. I have exception middleware in order to log exceptions and return 500 responses to hide the details from the user. When this 3rd party web service returns 400 bad request, I also want to return it to the user but...
  3. R

    How to check if the record exists with the same value in the database before insert

    Hello there, In my Blazor Server application, I am inserting a list of data into a database as follows with EF Core 6; public async Task AddStockAsync(List<GameBank> gameBank) { await _oyunPalasContext.GameBanks.AddRangeAsync(gameBank); await _oyunPalasContext.SaveChangesAsync(); } I...
  4. R

    Weird behavior SaveChangesAsync

    Hello guys, I have this Blazor Server application. I am adding (OnSubmit) records by selecting the game, quantity, and description. The problem is when I add records one after another by clicking the purchase button, the previously added record gets the value of the last added record as you can...
  5. R

    Question How to handle error in Parallel.ForEachAsync?

    Hello friends, There is a 3rd party web API that returns game codes. A single request can return a max of 10 codes. I am calling an asp.net core web API of mine as follows in a worker. (The worker and my API are on the same server.) Basically, I'm sending requests to process 100 codes and return...
  6. R

    EF Core how to query for a specific condition in related entities and update parent entity

    Hello, In my Blazor Server application, I have Order and Order Details entities which are related as you can imagine. They both have their own repositories. public class Order { public int Id { get; set; } [Required] public DateTime OrderDateTime {...
  7. R

    EF Core 6 UpdateRange Question?

    Hello friends, Long time no see :) There is something I want to talk to you experts. In my Blazor Server application, I am uploading an excel and updating records like this. public async Task UpdateReportAsync(List<OrderDetail> reports) { _db.UpdateRange(reports); await...
  8. R

    Question Bulk Insert Problem - inserting excel data

    Hi there, In my Blazor Server application, I am trying to insert excel data into a SQL database table. I am getting this error, but couldn't figure out why. Here is the sample excel, I am trying to bulk insert. Here is the table; CREATE TABLE [dbo].[RazerReconciliation]( [PID]...
  9. R

    Question How would you compare an excel with data in the database table?

    Hello friends, I am working on a Blazor Server application. I would like to upload an excel file, consisting of a couple of columns. (ReferenceId-guid, Order Date-datetime, Product Code-string, and Product Description-string) This excel file roughly has 200000 rows of data. I am gonna use...
  10. R

    EF Core 6 - Primary key incrementing problem

    Hello friends, I am working on a Blazor Server application which is running on production for a while. There is an Orders table, user can insert records. Here is the table structure; USE [InventoryManagement] GO /****** Object: Table [dbo].[Orders] Script Date...
  11. R

    ASP.NET Core Web API - Entity Relation Problem

    Hi, I am upgrading my legacy ASP.NET web API to Core. This upgrading process is harder than I expected. The problem I'm having now is, this query gets the GameBank and GameBankPin in my legacy application. But the same code doesn't work in the Core application, unfortunately...
  12. R

    Question Asp.Net Core Web API - BASIC Authentication Problem?

    Hello there, I implemented a basic authentication handler. I debugged it, and even though it enters AuthenticateResult.Fail, I get a response OK from the service. Where is the problem? public class BasicAuthenticationHandler : AuthenticationHandler<AuthenticationSchemeOptions> {...
  13. R

    Asp.Net Core Web Api - System.InvalidOperationException: The required column was not present in the results of a FromSql

    I am upgrading my legacy web API to core. It's harder than I expected :) I am getting this error, checked the entities and database as well but honestly, I couldn't find anything that makes sense. Hope you can see the problem. Here is the RawSQL: SELECT cf.Id, cf.referenceId...
  14. R

    Question Upgrading from ASP.NET Web API 2 to ASP.NET Web API Core 6

    Hello, I have had this ASP.NET Web API application running smoothly for 2-3 years in a live environment. I used EF, generic repository, unit of work and unity dependency injection in this application. I want to upgrade my application to take advantage of Core 6. How can I make this transition...
  15. R

    Resolved IText Empty PDF

    Hello, I am working on a Blazor Server application. I am trying to create and download PDFs as follows. PDF opens in a new browser tab but unfortunately, it is empty. What is wrong with my code? Could you please help? private async Task ReportPDF() { var memoryStream = new...
  16. R

    Question How to call a Rest API in a schedule

    I have an ASP.NET Core 2.1 web application. The admin gets online game codes from the page below by selecting the related game (Razer Gold Pin), quantity, and email to send those codes. A Rest API call is being made for the purchase. There is a limit for purchasing, a maximum of 200 purchases...
  17. R

    Update and retrieve data problem

    Hello guys, In my Blazor Server Application, there is this master-detail data grid. This data grid is populated with IsActive = 1 data OnInitializedAsync method. Here is the Order repository and related query which retrieves active data: public class...
  18. R

    Question How to position 2 divs side by side

    Hello, In my application, I am printing a razor page and I want to display 2 divs side by side. (Contact and Delivery Information) I want the grid to start from the left and closer to the others. Here is my sample razor: @page "/dialogcard/{Order}" @using IMS.CoreBusiness @using...
  19. R

    Question Blazor Server Application window.print page orientation problem

    Hi there, Depending on a business rule I need to print one dialog/modal landscape orientation. When I click on print on the Firefox page, the page layout option appears on the print preview page. But interestingly when I try to print the Blazor dialog/modal page, the layout option does not...
  20. R

    Question Dynamic Tab with @key Problem

    Hello friends, I am working on a Blazor Server App, here is the sample data. SET IDENTITY_INSERT [dbo].[OrdersDetail] ON INSERT INTO [dbo].[OrdersDetail] ([Id], [ProductCode], [ProductName], [Quantity], [CostRatio], [UnitCost], [TotalBuyPrice], [TotalSellPrice], [ShippingNumber], [Status]...
Back
Top Bottom