public bool UpdatePost(ContentTypeUpdateGet ContentType) { string usp = "usp_ContentTypeUpdatePost @ContentTypeId, @CodePrefix , @CodeSuffix , @CodeTypeId , @ContentTypeGroupId , @ProcessTypeId ,@SecurityLevelId, @Name, @Description, @MenuName, @MouseOver, @UserId, @IsRelationBasedOwnership " + " , @IsProjectBasedOwnership " + " , @IsOrganizationBasedOwnership " + " , @IsFreeOwnership " + " , @IsRelationBasedEdit " + " , @IsRelationBasedEditSelectable " + " , @IsOrganizationBasedEdit " + " , @IsOrganizationBasedEditSelectable " + " , @IsOrganizationBasedEditSub " + " , @IsOrganizationBasedEditParent " + " , @IsProjectBasedEdit " + " , @IsProjectBasedEditSelectable " + " , @IsProjectBasedEditSub " + " , @IsProjectBasedEditParent " + " , @IsFreeEdit " + " , @IsFreeEditSelectable " + " , @IsRelationBasedRead " + " , @IsRelationBasedReadSelectable " + " , @IsOrganizationBasedRead " + " , @IsOrganizationBasedReadSelectable " + " , @IsOrganizationBasedReadSub " + " , @IsOrganizationBasedReadParent " + " , @IsProjectBasedRead " + " , @IsProjectBasedReadSelectable " + " , @IsProjectBasedReadSub " + " , @IsProjectBasedReadParent " + " , @IsFreeRead " + " , @IsFreeReadSelectable, @Color, @IconId, @ContentTypeClassificationTable"; //_sqlDataAccess.SaveData<ContentTypeUpdateGet>(usp, ContentType); //return true; System.Data.DataTable ClassificationTable = ContentTypeClassificationValueDataTable.CreateTable(); var xy = new List <ContentTypeClassification>(); foreach (var x in ContentType.ContentTypeClassifications) { //if (x. != null && x.ClassificationValueId != 0) //{ ClassificationTable.Rows.Add( x.ClassificationId , x.ObjectTypeClassificationStatusId); //} } // string usp = "usp_ContentTypeCreatePost @ContentTypeGroupId, @ProcessTypeId , @SecurityLevelId, @Name , @Description, @MenuName , @MouseOver, @CreatorID, @MouseOver, @IconID, @ContentTypeClassificationTable "; _sqlDataAccess.SaveData <dynamic>(usp, new { ContentTypeId = ContentType.ContentTypeId , ContentTypeGroupId = ContentType.ContentTypeGroupId , ProcessTypeId = ContentType.@ProcessTypeId , SecurityLevelId = ContentType.SecurityLevelId , Name = ContentType.Name , Description = ContentType.Description , MenuName = ContentType.MenuName , MouseOver = ContentType.MouseOver , UserId = ContentType.UserId , IsRelationBasedOwnership = ContentType.IsRelationBasedOwnership , IsProjectBasedOwnership = ContentType.IsProjectBasedOwnership , IsOrganizationBasedOwnership = ContentType.IsOrganizationBasedOwnership , IsFreeOwnership = ContentType.IsFreeOwnership , IsRelationBasedEdit = ContentType.IsRelationBasedEdit , IsRelationBasedEditSelectable = ContentType.IsRelationBasedEditSelectable , IsOrganizationBasedEdit = ContentType.IsOrganizationBasedEdit , IsOrganizationBasedEditSelectable = ContentType.IsOrganizationBasedEditSelectable , IsOrganizationBasedEditSub = ContentType.IsOrganizationBasedEditSub , IsOrganizationBasedEditParent = ContentType.IsOrganizationBasedEditParent , IsProjectBasedEdit = ContentType.IsProjectBasedEdit , IsProjectBasedEditSelectable = ContentType.IsProjectBasedEditSelectable , IsProjectBasedEditSub = ContentType.IsProjectBasedEditSub , IsProjectBasedEditParent = ContentType.IsProjectBasedEditParent , IsFreeEdit = ContentType.IsFreeEdit , IsFreeEditSelectable = ContentType.IsFreeEditSelectable , IsRelationBasedRead = ContentType.IsRelationBasedRead , IsRelationBasedReadSelectable = ContentType.IsRelationBasedReadSelectable , IsOrganizationBasedRead = ContentType.IsOrganizationBasedRead , IsOrganizationBasedReadSelectable = ContentType.IsOrganizationBasedReadSelectable , IsOrganizationBasedReadSub = ContentType.IsOrganizationBasedReadSub , IsOrganizationBasedReadParent = ContentType.IsOrganizationBasedReadParent , IsProjectBasedRead = ContentType.IsProjectBasedRead , IsProjectBasedReadSelectable = ContentType.IsProjectBasedReadSelectable , IsProjectBasedReadSub = ContentType.IsProjectBasedReadSub , IsProjectBasedReadParent = ContentType.IsProjectBasedReadParent , IsFreeRead = ContentType.IsFreeRead , IsFreeReadSelectable = ContentType.IsFreeReadSelectable , Color = ContentType.Color , IconId = ContentType.IconId , ContentTypeClassificationTable = ClassificationTable.AsTableValuedParameter("udt_ContentTypeClassificationNew") }); return(true); }
public async Task <List <ErrorMessage> > CreatePostCheck(ContentTypeCreateGet ContentType) { DataTable ClassificationTable = ContentTypeClassificationValueDataTable.CreateTable(); var xy = new List <ContentTypeClassification>(); foreach (var ContentTypeClassification in ContentType.ContentTypeClassifications) { ClassificationTable.Rows.Add( ContentTypeClassification.ClassificationId , ContentTypeClassification.ObjectTypeClassificationStatusId); } string usp = "usp_ContentTypeCreatePostCheck @ContentTypeGroupId,@CodePrefix , @CodeSuffix , @CodeTypeId , @ProcessTypeId , @SecurityLevelId, @Name , @Description, @MenuName , @MouseOver, @UserId " + " , @IsRelationBasedOwnership " + " , @IsProjectBasedOwnership " + " , @IsOrganizationBasedOwnership " + " , @IsFreeOwnership " + " , @IsRelationBasedEdit " + " , @IsRelationBasedEditSelectable " + " , @IsOrganizationBasedEdit " + " , @IsOrganizationBasedEditSelectable " + " , @IsOrganizationBasedEditSub " + " , @IsOrganizationBasedEditParent " + " , @IsProjectBasedEdit " + " , @IsProjectBasedEditSelectable " + " , @IsProjectBasedEditSub " + " , @IsProjectBasedEditParent " + " , @IsFreeEdit " + " , @IsFreeEditSelectable " + " , @IsRelationBasedRead " + " , @IsRelationBasedReadSelectable " + " , @IsOrganizationBasedRead " + " , @IsOrganizationBasedReadSelectable " + " , @IsOrganizationBasedReadSub " + " , @IsOrganizationBasedReadParent " + " , @IsProjectBasedRead " + " , @IsProjectBasedReadSelectable " + " , @IsProjectBasedReadSub " + " , @IsProjectBasedReadParent " + " , @IsFreeRead " + " , @IsFreeReadSelectable, @Color, @IconId, @ContentTypeClassificationTable"; var ErrorMessages = await _sqlDataAccess.LoadData <ErrorMessage, dynamic>(usp, new { ContentTypeGroupId = ContentType.ContentTypeGroupId , ProcessTypeId = ContentType.@ProcessTypeId , SecurityLevelId = ContentType.SecurityLevelId , Name = ContentType.Name , Description = ContentType.Description , MenuName = ContentType.MenuName , MouseOver = ContentType.MouseOver , UserId = ContentType.UserId , IsRelationBasedOwnership = ContentType.IsRelationBasedOwnership , IsProjectBasedOwnership = ContentType.IsProjectBasedOwnership , IsOrganizationBasedOwnership = ContentType.IsOrganizationBasedOwnership , IsFreeOwnership = ContentType.IsFreeOwnership , IsRelationBasedEdit = ContentType.IsRelationBasedEdit , IsRelationBasedEditSelectable = ContentType.IsRelationBasedEditSelectable , IsOrganizationBasedEdit = ContentType.IsOrganizationBasedEdit , IsOrganizationBasedEditSelectable = ContentType.IsOrganizationBasedEditSelectable , IsOrganizationBasedEditSub = ContentType.IsOrganizationBasedEditSub , IsOrganizationBasedEditParent = ContentType.IsOrganizationBasedEditParent , IsProjectBasedEdit = ContentType.IsProjectBasedEdit , IsProjectBasedEditSelectable = ContentType.IsProjectBasedEditSelectable , IsProjectBasedEditSub = ContentType.IsProjectBasedEditSub , IsProjectBasedEditParent = ContentType.IsProjectBasedEditParent , IsFreeEdit = ContentType.IsFreeEdit , IsFreeEditSelectable = ContentType.IsFreeEditSelectable , IsRelationBasedRead = ContentType.IsRelationBasedRead , IsRelationBasedReadSelectable = ContentType.IsRelationBasedReadSelectable , IsOrganizationBasedRead = ContentType.IsOrganizationBasedRead , IsOrganizationBasedReadSelectable = ContentType.IsOrganizationBasedReadSelectable , IsOrganizationBasedReadSub = ContentType.IsOrganizationBasedReadSub , IsOrganizationBasedReadParent = ContentType.IsOrganizationBasedReadParent , IsProjectBasedRead = ContentType.IsProjectBasedRead , IsProjectBasedReadSelectable = ContentType.IsProjectBasedReadSelectable , IsProjectBasedReadSub = ContentType.IsProjectBasedReadSub , IsProjectBasedReadParent = ContentType.IsProjectBasedReadParent , IsFreeRead = ContentType.IsFreeRead , IsFreeReadSelectable = ContentType.IsFreeReadSelectable , Color = ContentType.Color , IconId = ContentType.IconId , ContentTypeClassificationTable = ClassificationTable.AsTableValuedParameter("udt_ContentTypeClassificationNew") }); return(ErrorMessages); }