//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); }