I have to import data from excel to SQL database. Excel data contains various parameters and there value like P1,P1,P4,P5 etc. I have to apply business rules Like if( P1 100 and P1 < 200) then insert the record in database. Similarly in some cases string values are also validated. Can I have any open source rule engine that contains UI to change , add , delete the rules. Am using C# to read the excel and and insert the records
One more thing which is best approach:
Read excel first and store every record as an object in a collection, then iterate through the collection, apply business rules on every object and then insert record in the database Or
Read one record from excel apply business rule and then insert record in the database. Repeat the process for whole excel.