public void Copy(string newName, Guid?dataCollectionID, Guid?parentGroupID, bool updateOrderNumber = false) { DataItem newItem = this.CreateCopy <DataItem>(false); if (newName != "") { newItem.Name = newName; } newItem.LastPublishedDate = null; if (dataCollectionID.HasValue) { newItem.DataCollection = new DataCollection(); newItem.DataCollection.ID = dataCollectionID.Value; } if (parentGroupID.HasValue) { newItem.ParentGroup = new DataGroup(); newItem.ParentGroup.ID = parentGroupID.Value; } if (updateOrderNumber) { //gekopieerde item krijgt 1 plek hoger volgnummer newItem.OrderNumber++; } newItem.Save(); if (updateOrderNumber) { //de rest van de items moeten 1 plek opschuiven om plaats te maken int newOrderNumber = newItem.OrderNumber; if (newItem.ParentGroup != null) { string sql = String.Format("UPDATE DataItem SET OrderNumber = OrderNumber + 1 WHERE OrderNumber >= {0} AND ID != '{1} ' AND FK_Parent_Group = '{2}'", newOrderNumber, newItem.ID, this.ParentGroup.ID); DataBase.Get().Execute(sql); } else { string sql = String.Format("UPDATE DataItem SET OrderNumber = OrderNumber + 1 WHERE OrderNumber >= {0} AND ID != '{1} ' AND FK_DataCollection = '{2}' AND FK_Parent_Group IS NULL", newOrderNumber, newItem.ID, this.DataCollection.ID); DataBase.Get().Execute(sql); } } if (DataItemLanguages != null) { foreach (DataItemLanguage languageItem in DataItemLanguages) { DataItemLanguage newLanguageItem = languageItem.CreateCopy <DataItemLanguage>(false); newLanguageItem.DataItem = newItem; newLanguageItem.Save(); } } }
/// <summary> /// zet alle waardes van een DataItemLanguage regel in de DataItem /// Hierdoor kunnen dezelfde velden worden gebruikt in de dataModule /// </summary> /// <param name="languageCode"></param> public void Translate(string languageCode) { if (DataCollection.HasStaticLanguage || languageCode == Site.DefaultLanguage) { return; } string where = "FK_DataItem='" + this.ID + "' AND LanguageCode ='" + languageCode + "'"; DataItemLanguage itemLanguage = DataItemLanguage.GetFirst <DataItemLanguage>(where); if (itemLanguage == null) { return; } this.Title = itemLanguage.Title; foreach (DataField fld in this.DataCollection.DataItemFields) { if (fld.IsMultiLanguageField) { if (fld.FieldType != FieldTypeEnum.ImageList && fld.FieldType != FieldTypeEnum.FileList && fld.FieldType != FieldTypeEnum.DropDown) { System.Reflection.PropertyInfo propItem = this.GetType().GetProperty(fld.MappingColumn); System.Reflection.PropertyInfo propLanguage = itemLanguage.GetType().GetProperty(fld.MappingColumn); Object valueLanguage = propLanguage.GetValue(itemLanguage, null); propItem.SetValue(this, valueLanguage, null); } else if (fld.FieldType == FieldTypeEnum.ImageList) { _imageList1 = BaseCollection <DataFile> .Get("Type = '" + DataFile.TYPE_EXTRA_IMAGE + "' AND FK_Item='" + this.ID + "' AND Language='" + languageCode + "'", "Name"); _imageList1.IsLoaded = true; } else if (fld.FieldType == FieldTypeEnum.FileList) { _imageList1 = BaseCollection <DataFile> .Get("Type = '" + DataFile.TYPE_EXTRA_FILE + "' AND FK_Item='" + this.ID + "' AND Language='" + languageCode + "'", "Name"); _imageList1.IsLoaded = true; } else if (fld.FieldType == FieldTypeEnum.DropDown) { //todo } } } }