A fuel products prices management system in .NET

Question

1.00/5 (1 vote)

See more:

, +

hello

i have to developpe a fuel products prices management system

there are several prices with its formula that i have implemented and i have to calculate all this prices and store theme in database

-price for domestic customers
-prices for foreign customers
-price for foreign regular customers
-prices for guests
-price in national currency
-price in Hard currency
-prices for each region
-price for each structure per region
-the weighted margin
-the margins of each region ... etc

i have chosen asp.net mvc as technologie web and Entity framework for access to database for building thise application

What I have tried:

my questions are:

1. are asp.net mvc and Entity framework the best technologies For this case?
2. For implementing all these formulate, have i to use stored function or stored procedure in database or i have to use linq to entities?
3. is there the examples for this case or codes source?
i want advices
any idea?

Posted 7-Oct-17 8:39am

David2509

Updated 8-Oct-17 2:11am

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

F-ES Sitecore · Answer 1 · 2017-10-08T02:11:00

Solution 1

1 There is rarely a "best" technology, but asp.net and mvc are certainly more than capable and a good option

2 It's up to you. These days people tend to use Entity Framework\LINQ as it's easier to do. Especially for simple operations like CRUD and basic queries so EF is probably a good option for you.

3 Your project is quite specific so it's not likely you'll find source code, and before you ask this is not a code-to-order website so we're not going to do the work for you.

Posted 8-Oct-17 2:11am

F-ES Sitecore

Comments

David2509 8-Oct-17 10:04am

thank you but it still one question :

For implementing all these formulas of prices,in your opinion, have i to use stored function or stored procedure in database or i have to use linq to entities?

what's the bes practice for prices with lot of formulas

any advice?

F-ES Sitecore 8-Oct-17 10:14am

It depends. If you're doing calculations on a lot of data it might well be better to do that work in a stored procedure as it'll probably be quicker. To do complex calcs on a lot of data via EF it might involve reading all that data into your code and doing the maths in the code which won't be as efficient. You could always try doing both and seeing which one performs better.

David2509 8-Oct-17 13:21pm

thank you very much but what do you mean by on a lot of data ?

F-ES Sitecore 9-Oct-17 6:50am

If you have to process around 10,000 rows or more.

David2509 7-Nov-17 15:41pm

if i want to keep the history in the results of the calculations at the database how do i do that?

thank you

F-ES Sitecore 8-Nov-17 5:38am

There are two possible ways. You could keep all the calculations in a single database with a date they were generated and a bit flag to indicate which row is "current" and when you select the data always make sure you select where current=1. Alternatively you could keep a separate table for the history and when new records are generated you move the old record to the history table.

David2509 8-Nov-17 15:13pm

can i use views to store calculted result and to keep the history with date field ?

can the calculted data be stored in table? did that break not the database normalisation?