public static FormulaField ExecuteFormula(string formula, decimal omset, decimal tarif)
{
DataTable table = new DataTable();
// Create the first column.
DataColumn omsetColumn = new DataColumn();
omsetColumn.DataType = System.Type.GetType("System.Decimal");
omsetColumn.ColumnName = "Omset";
omsetColumn.DefaultValue = omset;
// Create the first column.
DataColumn tarifColumn = new DataColumn();
tarifColumn.DataType = System.Type.GetType("System.Decimal");
tarifColumn.ColumnName = "Tarif";
tarifColumn.DefaultValue = tarif;
// Create the second, calculated, column.
DataColumn bagiHasilColumn = new DataColumn();
bagiHasilColumn.DataType = System.Type.GetType("System.Decimal");
bagiHasilColumn.ColumnName = "BagiHasil";
bagiHasilColumn.Expression = formula;
// Add columns to DataTable.
table.Columns.Add(omsetColumn);
table.Columns.Add(tarifColumn);
table.Columns.Add(bagiHasilColumn);
DataRow row = table.NewRow();
table.Rows.Add(row);
string _Omset=omset.ToString("N2");
string _Tarif = tarif.ToString("N2");
string replaceFormula = FormulaReplace(formula,_Omset,_Tarif);
FormulaField _formula = new FormulaField()
{
Tarif = (decimal)row["Tarif"],
Omset = (decimal)row["Omset"],
BagiHasil = (decimal)row["BagiHasil"],
FormulaName = formula,
FormulaProcess = replaceFormula
};
//DataView view = new DataView(table);
// dataGrid1.DataSource = view;
//Assert.AreEqual(909.09,row["BagiHasil"])
return _formula;
}
private void SetViewBagFormula(FormulaField formula)
{
ViewBag.FormulaKonsesi = formula.FormulaName;
ViewBag.FormulaProcess = formula.FormulaProcess;
}