I need an example procedure written in C# .NET which I will be integrating into an existing web application.
The goal of the procedure is to evaluate 'rules' against a dataset to check the quality of the data. If a rule fails, it will be output to the user at the end
We need to effectively run two different types checks as part of this sample and we may need to get into more complex scenarios going forward. The types of checks we need to run:
1. Is A > B (and derivatives of this i.e. A >= B, A < B, A <= B, A=B,A!=B)
2. Is A+B > C or SUM(A,B) > C
If a rule is passed, we don't need to see any output.
If a rule fails, we would need to add it to a list and see a consolidated list of failures at the conclusion of the check.
Sample Data:
I've attached two tables in the file. One with data which should allow you to run these checks. You should import this into the application as json (see [login to view URL] attached for the same data converted to json) or similar.
Using this data, you need to implement the Rules checks on the 'Rules' tab of the Excel file.
This should not be hard coded. I need the ability to pass fields to any functions etc so I can make these checks dynamic in the future.
In your bid, please discuss a little about how you think you would solve this problem. Do you have experience implementing such algorithms in a dynamic manner? Also, please discuss how long you think this will take you and when you are able to start.
I will award this project quickly if someone shows they are able to complete and start quickly.
We are very interested in this project. I have read your above description and i think its well within our range to execute this is in a good time frame so would you be kind enough to message me so we can have a fast and understanding agreement.
Hi,
We’ve had a good look at your project description and we’re very interested in providing a solution. If you like what you see and if our quote fits within your budget then please PM me your response and we will take it on from there.
We are pleased to discuss your requirements and can start it today.
Please contact me before awarding the project so that i can verify your requirements by discussing my thoughts.
Thank you for your time.
I have 16 Years of experience in Software development Windows and Web. Expert in Sql Server and .NET. Microsoft Certified as MCP, MCTS, MCPD, MCT. Please contact me to clarify all details.
I have checked the sheet you have prepared and I think you have made a mistake in rule no two. You have written >0 instead of >100.
Right?
Well I can make this algorithm for you. I have 6 years of experience of working on .NET and I have build many complex logics before. Main critical and challenging thing in your work it making it dynamic and I think I can do it because I have prepared an application to create and evaluate formulas based on dynamic values.
Please let me know if you want to ask something before starting this project, I can start it as soon as you would like.
I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably you will get a quick response from my end.
Hi, I would like to bid for this project. I am currently working on asp.net technology and have good knowledge of solving this type of problem. If you are interested for further discussion please feel free to contact me.
Dear Employer,
I've just completed the full scope of work as I really wanted you to be sure that I can do this job.
Kindly please, just tell me when you are ready to test the C# script so you can pay only after being satisfied.
What I did ?
------------
I've converted the dataset to objects then I got all different attributes depending on their "identifier".
(Objects are : inventory, product_promo, product_promo_detail, product_tried_detail).
An engine was created for checking the rules stored in an another json file (for not hardcoding them) and apply dynamically the algorithm for printing all fails.
The rules file is written following a friendly syntax that I'll give you.
Next ?
------
Now I invite you to test the project and then I'll give you a help to integrate the engine (C# procedures) to your web project (ASP.NET or MVC suite).
I'll always be online so please don't hesitate to contact me at anytime.
Thanks & Best Regards.