//private void RemoveFormulaItem(MyProjectEntities projectContext, FormulaItems formulaItems)
//{
// while (formulaItems.Any())
// {
// projectContext.FormulaItems.Remove(formulaItems);
// }
//}
private FormulaItems ToFormualaItem(FormulaItemDTO formulaItem, Formula dbFormula)
{
FormulaItems dbItem = new FormulaItems();
dbItem.ID = formulaItem.ID;
dbItem.RelationshipIDTail = formulaItem.RelationshipIDTail;
dbItem.RelationshipNameTail = formulaItem.RelationshipNameTail;
dbItem.ItemTitle = formulaItem.ItemTitle;
if (formulaItem.ItemType == FormuaItemType.Column)
{
dbItem.ColumnID = formulaItem.ItemID;
}
else if (formulaItem.ItemType == FormuaItemType.FormulaParameter)
{
dbItem.FormulaParameterID = formulaItem.ItemID;
}
else if (formulaItem.ItemType == FormuaItemType.Relationship)
{
dbItem.RelationshipID = formulaItem.ItemID;
}
else if (formulaItem.ItemType == FormuaItemType.DatabaseFunction)
{
dbItem.DatabaseFunction_TableDrivedEntityID = formulaItem.ItemID;
}
else if (formulaItem.ItemType == FormuaItemType.Code)
{
dbItem.CodeFunction_TableDrivedEntityID = formulaItem.ItemID;
}
else if (formulaItem.ItemType == FormuaItemType.State)
{
dbItem.TableDrivedEntityStateID = formulaItem.ItemID;
}
//foreach (var citem in formulaItem.ChildFormulaItems)
//{
// var sendRelationshipTail = relationshipTail;
// if (dbItem.RelationshipID != null)
// sendRelationshipTail = (sendRelationshipTail == "" ? dbItem.RelationshipID.ToString() : sendRelationshipTail + "," + dbItem.RelationshipID);
// var childItem = ToFormualaItem(citem, dbFormula, sendRelationshipTail);
// dbItem.FormulaItems1.Add(childItem);
//}
return(dbItem);
}
private FormulaItemDTO ToFormualaItemDTO(int entityID, FormulaItems dbFormulaItem)
{
FormulaItemDTO formulaItem = new FormulaItemDTO();
formulaItem.ID = dbFormulaItem.ID;
formulaItem.RelationshipIDTail = dbFormulaItem.RelationshipIDTail;
if (!string.IsNullOrEmpty(formulaItem.RelationshipIDTail))
{
var bizEntityRelationshipTail = new BizEntityRelationshipTail();
formulaItem.RelationshipTail = bizEntityRelationshipTail.ToEntityRelationshipTailDTO(entityID, formulaItem.RelationshipIDTail);
}
formulaItem.RelationshipNameTail = dbFormulaItem.RelationshipNameTail;
formulaItem.FormulaID = dbFormulaItem.FormulaID ?? 0;
formulaItem.ItemTitle = dbFormulaItem.ItemTitle;
if (dbFormulaItem.ColumnID != null)
{
formulaItem.ItemID = dbFormulaItem.ColumnID.Value;
formulaItem.ItemType = FormuaItemType.Column;
}
else if (dbFormulaItem.FormulaParameterID != null)
{
formulaItem.ItemID = dbFormulaItem.FormulaParameterID.Value;
formulaItem.ItemType = FormuaItemType.FormulaParameter;
}
else if (dbFormulaItem.RelationshipID != null)
{
formulaItem.ItemID = dbFormulaItem.RelationshipID.Value;
formulaItem.ItemType = FormuaItemType.Relationship;
}
//foreach (var dbcItem in dbFormulaItem.FormulaItems1)
//{
// formulaItem.ChildFormulaItems.Add(ToFormualaItemDTO(dbcItem));
//}
return(formulaItem);
}
