how to creating custom formula by user in c#

Question

1.00/5 (2 votes)

See more:

Hello

I am writing accounting software.I want the user to build a formula based on pre-defined parameters.Each parameter is calculated based on a function.
for example:
parameters are:
1)cost(calculated by function f1 based on some field of database)
2)count (calculated by function f2 based on some field of database)
3)time(calculated by function f3 based on some field of database)
4)weight (calculated by function f4 based on some field of database)
5) ...

and user define this formula :
A = cost/count* weight
B=count/Time
final cost=A+B

how to save this formula in database?
and how to allow user to define new formula(final cost) based old formula(A and B)?

Thanks.

Posted 8-Jul-15 1:04am

sahar11

Add a Solution

Comments

Leo Chapiro 8-Jul-15 7:20am

It would be easier by using Excel

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)

Leo Chapiro · Answer 1 · 2015-07-08T01:21:00

Take a look: How to save Formula in sqlserver and use this formula in app[^]

Quote:
I think you have to save the exactly formula in database and when you want to use it, process the formula string using replace method. you should get Variabl1,Variable2 data and use this code:

string f="Variabl1+Variable2*3.2+200";
f= System.Text.RegularExpressions.Regex.Replace(f, "Variabl1", TxBxVar1.Text);
f= System.Text.RegularExpressions.Regex.Replace(f, "Variabl2", TxBxVar2.Text);

and then process f to run the formula. for run you can use

System.Text.RegularExpressions.Regex.Split(f, "+");

and use this replace code for all math operators that you want.

But like I wrote in comment this would be easier to use Excel for this task :)