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