internal static int SaveFormula(Formula formula)
{
int result = 0;
if (formula == null) { return result; }
using (var con = OpenOrCreateDb())
{
try
{
using (var command = con.CreateCommand())
{
command.CommandText = formula.Id == 0
? string.Format("insert into calcFormula (formulaName, formulaExpression) values('{0}', '{1}')",
formula.Name, formula.Expression)
: string.Format("update calcFormula set formulaName='{0}', formulaExpression='{1}' where formulaid={2}",
formula.Name, formula.Expression, formula.Id);
command.ExecuteNonQuery();
if (formula.Id == 0)
{
command.CommandText = "select max(formulaid) from calcFormula";
result = (int)command.ExecuteScalar();
}
else
{
result = formula.Id;
}
}
}
catch { }
finally { con.Close(); }
}
return result;
}
internal static void RemoveFormula(Formula formula)
{
if (formula == null) { return; }
using (var con = OpenOrCreateDb())
{
try
{
using (var command = con.CreateCommand())
{
command.CommandText = "delete calcFormulaParams where formulaId = " + formula.Id;
command.ExecuteNonQuery();
command.CommandText = "delete CalcFormula where formulaId = " + formula.Id;
command.ExecuteNonQuery();
}
}
catch { }
finally { con.Close(); }
}
}
