I have this SQL Statement "SELECT vYear, EmpCode, VacType, DocNum, DocDate, DepCode, SecCode, vName, vStart, vEnd, vDays, LType, CUsrName, CDate, MUsrName, MDate, Result, Reson, EmpCode_Act, MngID
WHERE ('12/07/2022' BETWEEN vStart AND vEnd) AND (vYear = 2022) AND (EmpCode = 5229) AND (VacType <> 10) AND (VacType <> 15) AND (VacType <> 16) AND (VacType <> 17) AND (VacType <> 18) AND (VacType <> 19) AND
(VacType <> 20) AND (VacType <> 21) AND (VacType <> 23) AND (VacType <> 24) AND (Result <> 1) OR
(vYear = 2022) AND (EmpCode = 5229) AND (VacType <> 10) AND (VacType <> 15) AND (VacType <> 16) AND (VacType <> 17) AND (VacType <> 18) AND (VacType <> 19) AND (VacType <> 20) AND (VacType <> 21) AND
(VacType <> 23) AND (VacType <> 24) AND (Result <> 1) AND (CONVERT(DATETIME, '2022-07-13 00:00:00', 102) BETWEEN vStart AND vEnd)" and it work fine, i would like to do the same with EF but not using ADO or >,<
Can anybody help me
I'd start by looking at what your SQL is trying to do and simplify it. From what I can see, your WHERE clause can be reduced to
vYear = 2022AND EmpCode = 5229ANDNOT VacType IN (10, 15, 16, 17, 18, 19, 20, 21, 23, 24)
AND Result <> 1AND ('12/07/2022'BETWEEN vStart AND vEnd
ORCONVERT(DATETIME, '2022-07-13 00:00:00', 102) BETWEEN vStart AND vEnd
I do not understand what the date ranges are for and why there are two different ways of representing dates unless your data has two sets of texts neither as real dates, in which case the comparisons are meaningless.
I'm trying to make a document comparison viewer for web browser that feels as same as Microsoft word's 'Track Changes' and 'Compare' (options available in Review Tab).
I am already using Aspose.Words to convert every file type to docx and compare two files which gives me a redline copy merged into one single document. What i want to get is the resulting document(s) in a **side by side comparison** on UI. Also i want to give the ability to do the basic:
1. Get a summary of changes made and able to navigate as to where to changes are made in the document.(Scroll to the position of change in the document, just like Review Pane in MS word)
2. Accept and Reject those changes and download the revised document.
3. Able to compare text as well as non text related changes.
I've looked for many 3rd party tools but always end up in a limitation surrounding them, to list a few
1. GroupDocs.Comparison - Gives navigation and auto scroll but in a
merged document not in side by side view. Also, does not gives a document but a set of images.
2. Draftable - Compares only text and style, no image/tagged file
objection insertion or deletion. No option to accept or reject
3. ipdf-net - No option to accept or reject changes.
4. PrizmDocs Document Compare API - No navigation to where the change is made in the document. Also no side by side comparison.
5. Litera Compare: No side by side comparison.
Where i could such 3rd party SDK that would help me achieve my objective or is there any was i could overcome the limitations i am getting from the tolls I've looked at ? The main concern is to have a navigation/mapping of change made to its position in the document and ability accept or reject those changes.
I am looking for some solution to call an API method inside another API. I am working on DotNet EF Core Web API project. I have implemented several Web APIs within the project....I can call some Web API Post method by defining data for the insertion....The data is inserted successfully in the respective table related to API. What I want to do is that after successful insertion of data , logging information is need to be added in some table related to other API in same project/solution.
The question is how can we pass data from first API to other to solve this ?
How can we invoke Post method of other API from first API to do this?
Sorry, we need to do this at Web API level. The thing is that if some record is entered, updated or deleted using some API, another record needs to be added in some table using other API at the same time
That may not strictly be true though. You might think that you want to do this via Web API, but that is not the same as actually needing to do this via Web APIs.
The proposal here is not a good idea because you have introduced a transactional dependency into your API at this point. Suppose that the API that deletes the record happens successfully, and then calls the second API, which is down. What are you going to do at that point? Undelete the record?
If you are logging things happening at the database, let the database take care of the logging. Alternatively, you need to consider how to cope with failure conditions and look at techniques such as event passing, retry mechanisms, queues and the likes to see if they can help you in this situation.
Bottom line - your current design is borked if it's only relying on happy path scenarios.
Either create an instance of the controller class and call the action method directly, or have the API method pass the call through to another class which implements the logic, and call that from both.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
The question is how can we pass data from first API to other to solve this ?
I can only suppose that you think that you are going to do this via the following
1. First API does just the main part of the functionality
2. That API exits (in some meaning of that word).
3. The log happens which invokes another API call.
Can you make that happen? Yes I believe so. It involves delving into some of the semantics of how it handles some of a Web call for you. For example you can intercept errors.
Should you do it? If there is only one method that needs this then no. Just do it in the same code that does the first functionaliy. If you want to do it with more than one API call, then start figuring out how the call flow is actually handled before it gets to your code and after it leaves your code. You should keep in mind that doing it this way ADDS complexity. That is because when something goes wrong it can interfere with stuff in unexpected ways (for example how you handle errors from the second call.)
Hello to all,
I'm developing a test console app that refers to an external dll, made with VS2022 and .net core 3.1.
Th console App should work on debian 10 and an arm processor.
I've installed all the netcore packages on debian, ad I've tested the "hello word" app in dotnet core.
Now I'm trying to create a "single file" .netcore console application that uses an external dll.
I've managed to have a "single file" application for the console app and a "single file" dll for the external library.
Every time I try to start the console app the system gives me the error:
A fatal error occurred. The required library libhostfxr.so could not be found.
If thisis a self-contained application, that library should exist in [/root/.net/SPLX/eY3MeD2sHDeSKgxGgVmzXD_NUUU2hdE=/].
If thisis a framework-dependent application, install the runtime in the global location [/usr/share/dotnet] or use the DOTNET_ROOT environment variable to specify the runtime location or register the runtime location in [/etc/dotnet/install_location].
The .NET Core runtime can be found at:
I'm not sure whether this question is still relevant but it misses the most crucial piece: how does your project reference your library.
Anyways, the most convenient way of attaching external dependencies is Nuget package manager. You can learn more in official docs What is NuGet and what does it do? | Microsoft Docs[^]
it's not supposed to be real timer or anything i just want it to happen in the background so i can make another actions.
the first Beep indicates for me that it starts but second one not really also i can't manage to use
as you can see i have pitifully tried updating it ?traditional? way.
i'm learning to code by myself (also english so sorry ) and this is my first attempt to use background worker i could really use some suggestions and please keep them simple after all i'm simpleton?
Your prank function is running on a background thread, and cannot directly update any UI controls. When you try to set the timer's Text property, an exception will be thrown, but since you're not handing the RunWorkerCompleted event[^] to inspect the result, you never see it.