Advice / Ideas / Comments

[Ann Marinas]

Hello all!

I really need your advice/ suggestions/ comments regarding a particular
program of mine that I am currently developing.

What the program does is that
1. the user imports data
2. the application calculates the estimated rates using a base rate as a
basis
against a data that holds item details to be charged.
3. The results from these calculations will then be compared to an invoice
data to check
whether a specific company charges the correct cost or not.
4. Saves to database and generates the report.

Now, I am having some problems as to how am I going to implement a form that
would allow the user to enter their own calculations based on the types of
base rates they are going to use. I've found out that the column from the
base rates vary, so does the formulas needed for consolidation.

If you guys have any suggestions on how I could implement this, or any
changes, I would really appreciate it!

Thank you so much and more power to all!

--A

 

[Nicholas Paldino [.NET/C# MVP]]

Ann,

Hmm, you might want to think about hosting a scripting language (like VB
script) in your application. This way, you can set up the variables (with
values assigned to them), and then you could have them write the code (or in
this case, the formulas) which are then evaluated.

Hope this helps.

 

[Ann Marinas]

Thank you for your help! I really do appreciate it!

But I still have some questions, if you may permit me to ask...

1. I'm not too familiar with scripting. Do you have any suggestions on some
materials that I could research on with regards to scripting?
2. Are there any alternatives besides scripting?

--Ann

Ann,

Hmm, you might want to think about hosting a scripting language (like VB
script) in your application. This way, you can set up the variables (with
values assigned to them), and then you could have them write the code (or in
this case, the formulas) which are then evaluated.

Hope this helps.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

Hello all!

I really need your advice/ suggestions/ comments regarding a particular
program of mine that I am currently developing.

What the program does is that
1. the user imports data
2. the application calculates the estimated rates using a base rate as a
basis
against a data that holds item details to be charged.
3. The results from these calculations will then be compared to an invoice
data to check
whether a specific company charges the correct cost or not.
4. Saves to database and generates the report.

Now, I am having some problems as to how am I going to implement a form that
would allow the user to enter their own calculations based on the types of
base rates they are going to use. I've found out that the column from the
base rates vary, so does the formulas needed for consolidation.

If you guys have any suggestions on how I could implement this, or any
changes, I would really appreciate it!

Thank you so much and more power to all!

--A

 

[Nicholas Paldino [.NET/C# MVP]]

Ann,

Besides scripting, you could always try and interpret the functions that
you wrote yourself. This might be a pain though. Also, just coming to
mind, you might be able to use MATLAB. I believe they have function
libraries that will interpret mathematical equations and return results. Of
course, you would have to use COM interop or the P/Invoke layer for this (I
don't believe there is a managed wrapper for this yet).

As for hosting scripting, check out the artile in MSDN magazine titled
"Add Scripting to Your Apps with Microsoft ScriptControl", located at (watch
for line wrap):

http://msdn.microsoft.com/msdnmag/issues/0600/visualprog/default.aspx


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

Thank you for your help! I really do appreciate it!

But I still have some questions, if you may permit me to ask...

1. I'm not too familiar with scripting. Do you have any suggestions on some
materials that I could research on with regards to scripting?
2. Are there any alternatives besides scripting?

--Ann

message news:Ovn%[email protected]...

Ann,

Hmm, you might want to think about hosting a scripting language

(like

VB
script) in your application. This way, you can set up the variables (with
values assigned to them), and then you could have them write the code

(or

in
this case, the formulas) which are then evaluated.

Hope this helps.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

Hello all!

I really need your advice/ suggestions/ comments regarding a particular
program of mine that I am currently developing.

What the program does is that
1. the user imports data
2. the application calculates the estimated rates using a base rate as a
basis
against a data that holds item details to be charged.
3. The results from these calculations will then be compared to an invoice
data to check
whether a specific company charges the correct cost or not.
4. Saves to database and generates the report.

Now, I am having some problems as to how am I going to implement a

form
that

would allow the user to enter their own calculations based on the

types

of

 

[Ann Marinas]

Once again, thank you so much for the help!

Ann,

Besides scripting, you could always try and interpret the functions that
you wrote yourself. This might be a pain though. Also, just coming to
mind, you might be able to use MATLAB. I believe they have function
libraries that will interpret mathematical equations and return results. Of
course, you would have to use COM interop or the P/Invoke layer for this (I
don't believe there is a managed wrapper for this yet).

As for hosting scripting, check out the artile in MSDN magazine titled
"Add Scripting to Your Apps with Microsoft ScriptControl", located at (watch
for line wrap):

http://msdn.microsoft.com/msdnmag/issues/0600/visualprog/default.aspx


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

Thank you for your help! I really do appreciate it!

But I still have some questions, if you may permit me to ask...

1. I'm not too familiar with scripting. Do you have any suggestions on some
materials that I could research on with regards to scripting?
2. Are there any alternatives besides scripting?

--Ann

message news:Ovn%[email protected]...

Ann,

Hmm, you might want to think about hosting a scripting language

(like

VB
script) in your application. This way, you can set up the variables (with
values assigned to them), and then you could have them write the code

(or

in
this case, the formulas) which are then evaluated.

Hope this helps.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

Hello all!

I really need your advice/ suggestions/ comments regarding a particular
program of mine that I am currently developing.

What the program does is that
1. the user imports data
2. the application calculates the estimated rates using a base rate

as

a types from
the