private ModelEntites.ColumnCustomFormulaDTO ToColumnCustomFormulaDTO(ColumnCustomFormula item)
{
var result = new ModelEntites.ColumnCustomFormulaDTO();
result.ID = item.ID;
result.FormulaID = item.FormulaID ?? 0;
result.CalculateFormulaAsDefault = item.CalculateFormulaAsDefault;
result.OnlyOnEmptyValue = item.OnlyOnEmptyValue;
result.OnlyOnNewData = item.OnlyOnNewData;
result.Formula = new BizFormula().ToFormulaDTO(item.Formula, false);
return(result);
}
public void SaveColumnCustomFormula(int columnID, ModelEntites.ColumnCustomFormulaDTO message)
{
using (var projectContext = new DataAccess.MyProjectEntities())
{
var dbColumn = projectContext.Column.First(x => x.ID == columnID);
if (dbColumn.ColumnCustomFormula == null)
{
dbColumn.ColumnCustomFormula = new DataAccess.ColumnCustomFormula();
}
dbColumn.ColumnCustomFormula.FormulaID = message.FormulaID;
dbColumn.ColumnCustomFormula.CalculateFormulaAsDefault = message.CalculateFormulaAsDefault;
dbColumn.ColumnCustomFormula.OnlyOnEmptyValue = message.OnlyOnEmptyValue;
dbColumn.ColumnCustomFormula.OnlyOnNewData = message.OnlyOnNewData;
projectContext.SaveChanges();
}
}
