private UIColumnValueRangeDTO ToUIColumnValueRangeDTO(UIColumnValueRange item) { UIColumnValueRangeDTO msgtem = new UIColumnValueRangeDTO(); msgtem.ColumnValueRangeID = item.ColumnValueRangeID; msgtem.ID = item.ID; msgtem.EnumTag = (EnumColumnValueRangeTag)item.EnumTag; msgtem.Value = item.Value; return(msgtem); }
public int UpdateActionActivitys(UIActionActivityDTO UIActionActivity) { using (var projectContext = new DataAccess.MyProjectEntities()) { var dbActionActivity = projectContext.UIActionActivity.FirstOrDefault(x => x.ID == UIActionActivity.ID); if (dbActionActivity == null) { dbActionActivity = new DataAccess.UIActionActivity(); } if (dbActionActivity.UIColumnValue != null) { while (dbActionActivity.UIColumnValue.Any()) { projectContext.UIColumnValue.Remove(dbActionActivity.UIColumnValue.First()); } } if (UIActionActivity.UIColumnValue.Any()) { foreach (var item in UIActionActivity.UIColumnValue) { var dbColumnValue = new UIColumnValue(); dbColumnValue.ColumnID = item.ColumnID; dbColumnValue.ExactValue = item.ExactValue; dbColumnValue.EvenIsNotNew = item.EvenIsNotNew; dbColumnValue.EvenHasValue = item.EvenHasValue; //while (dbColumnValue.ColumnValue_ValidValues.Any()) // dbColumnValue.ColumnValue_ValidValues.Remove(dbColumnValue.ColumnValue_ValidValues.First()); //foreach (var value in UIActionActivity.ColumnValue.ValidValues) // dbColumnValue.ColumnValue_ValidValues.Add(new ColumnValue_ValidValues() { ValidValue = value.Value }); dbActionActivity.UIColumnValue.Add(dbColumnValue); } } //if (UIActionActivity.UIEnablity.EntityRelationshipTailID != 0) // dbUIEnablity.EntityRelationshipTailID = UIActionActivity.UIEnablity.EntityRelationshipTailID; //else // dbUIEnablity.EntityRelationshipTailID = null; while (dbActionActivity.UIEnablityDetails.Any()) { projectContext.UIEnablityDetails.Remove(dbActionActivity.UIEnablityDetails.First()); } foreach (var item in UIActionActivity.UIEnablityDetails) { //if (item.RelationshipID != 0) //{ // var relationship = projectContext.Relationship.First(x => x.ID == item.RelationshipID); // if (relationship.MasterTypeEnum == (short)Enum_MasterRelationshipType.FromPrimartyToForeign) // { // throw new Exception("امکان تععین وضعیت برای رابطه" + " " + relationship.ID + " " + "میسر نمی باشد"); // } // else // { // foreach (var relCol in relationship.RelationshipColumns) // { // UIEnablityDetails dbItem = new UIEnablityDetails(); // dbItem.Hidden = item.Hidden; // dbItem.Readonly = item.Readonly; // dbItem.ColumnID = relCol.FirstSideColumnID; // dbActionActivity.UIEnablityDetails.Add(dbItem); // } // } //} //else //{ UIEnablityDetails dbItem = new UIEnablityDetails(); dbItem.Hidden = item.Hidden; dbItem.Readonly = item.Readonly; if (item.ColumnID != 0) { dbItem.ColumnID = item.ColumnID; } else { dbItem.ColumnID = null; } if (item.RelationshipID != 0) { dbItem.RelationshipID = item.RelationshipID; } else { dbItem.RelationshipID = null; } //if (item.UICompositionID != 0) // dbItem.EntityUICompositionID = item.UICompositionID; //else // dbItem.EntityUICompositionID = null; dbActionActivity.UIEnablityDetails.Add(dbItem); //} } while (dbActionActivity.UIColumnValueRange.Any()) { projectContext.UIColumnValueRange.Remove(dbActionActivity.UIColumnValueRange.First()); } foreach (var item in UIActionActivity.UIColumnValueRange) { UIColumnValueRange dbItem = new UIColumnValueRange(); dbItem.ColumnValueRangeID = item.ColumnValueRangeID; dbItem.EnumTag = (short)item.EnumTag; dbItem.Value = item.Value; dbActionActivity.UIColumnValueRange.Add(dbItem); } //while (dbActionActivity.UIColumnValueRangeReset.Any()) // projectContext.UIColumnValueRangeReset.Remove(dbActionActivity.UIColumnValueRangeReset.First()); //foreach (var item in UIActionActivity.UIColumnValueRangeReset) //{ // UIColumnValueRangeReset dbItem = new UIColumnValueRangeReset(); // dbItem.ColumnValueRangeID = item.ColumnValueRangeID; // dbActionActivity.UIColumnValueRangeReset.Add(dbItem); //} //if (UIActionActivity.RelationshipEnablity != null && UIActionActivity.RelationshipEnablity.EntityRelationshipTailID != 0) //{ // var dbRelationshipEnablity = dbActionActivity.RelationshipEnablity.FirstOrDefault(); // if (dbRelationshipEnablity == null) // dbRelationshipEnablity = new RelationshipEnablity(); // dbRelationshipEnablity.EntityRelationshipTailID = UIActionActivity.RelationshipEnablity.EntityRelationshipTailID; // dbRelationshipEnablity.Enabled = UIActionActivity.RelationshipEnablity.Enable; // dbRelationshipEnablity.Readonly = UIActionActivity.RelationshipEnablity.Readonly; // if (dbRelationshipEnablity.ID == 0) // dbActionActivity.RelationshipEnablity.Add(dbRelationshipEnablity); //} //else //{ // //پاک کردنش //} dbActionActivity.ID = UIActionActivity.ID; dbActionActivity.Type = (short)UIActionActivity.Type; //dbActionActivity.ActivityType = (short)UIActionActivity.ActionActivityType; dbActionActivity.Title = UIActionActivity.Title; dbActionActivity.TableDrivedEntityID = UIActionActivity.EntityID; //dbActionActivity.StepType = (short)UIActionActivity.Step; //dbActionActivity.ResultSensetive = UIActionActivity.ResultSensetive; if (dbActionActivity.ID == 0) { projectContext.UIActionActivity.Add(dbActionActivity); } projectContext.SaveChanges(); return(dbActionActivity.ID); } }