public static List <MetaViewColumnModel> GetColumnsForView(Guid viewId, Guid masterEntityId, Guid?parentId)
{
MetaViewColumnModel.CreateMap();
List <MetaViewColumn> col;
List <MetadataEntityAttribute> metadataEntityAttribute;
using (DBEntities context = Settings.CreateDataContext())
{
col = MetaViewHelper.GetColumnsByViewId(viewId, context);
metadataEntityAttribute = MetadataEntityHelper.GetAttributes(context);
}
List <MetaViewColumnModel> res = Mapper.Map <IList <MetaViewColumn>, List <MetaViewColumnModel> >(col);
AddEntities(viewId, res, metadataEntityAttribute, masterEntityId, null);
return(res);
}
private void SyncViewColumns(MetaView target, List <MetaViewColumnModel> columnModel, DBEntities context)
{
MetaViewColumnModel.CreateMap();
var viewColumns = context.MetaViewColumn.Include("Attribute").Where(c => c.MetaViewId == target.Id).ToList();
foreach (var item in columnModel)
{
item.NeedSave = NeedSave(item, columnModel);
}
foreach (var item in columnModel)
{
item.NeedSave = NeedSaveSpecial(item, columnModel);
}
foreach (var item in columnModel)
{
MetaViewColumnModel item1 = item;
var viewColumn = viewColumns.FirstOrDefault(c => c.Id == item1.Id);
if (viewColumn == null)
{
if (!item.NeedSave)
{
continue;
}
viewColumn = new MetaViewColumn()
{
Id = item.Id
};
Mapper.Map(item, viewColumn);
viewColumn.MetaViewId = target.Id;
context.MetaViewColumn.AddObject(viewColumn);
}
else
{
if (item.NeedSave)
{
Mapper.Map(item, viewColumn);
viewColumn.MetaViewId = target.Id;
}
else
{
context.MetaViewColumn.DeleteObject(viewColumn);
}
}
}
for (int i = 0; i < viewColumns.Count; i++)
{
var viewColumn = viewColumns[i];
var item = columnModel.FirstOrDefault(c => c.Id == viewColumn.Id);
if (item == null)
{
context.MetaViewColumn.DeleteObject(viewColumns[i]);
viewColumns.RemoveAt(i);
i--;
}
else if (viewColumn.ParentId == null && viewColumn.Attribute.EntityId != target.MasterEntityId)
{
DeleteViewColoumnAndChilds(context, viewColumns, viewColumn);
i = -1;
}
else if (viewColumn.ParentId != null && viewColumn.Attribute != null)
{
var parent = viewColumns.FirstOrDefault(c => c.Id == viewColumn.ParentId);
if (parent != null && parent.Attribute.TypeId == (byte)AttributeType.Reference)
{
if (parent.Attribute.ReferencedEntityId != viewColumn.Attribute.EntityId)
{
DeleteViewColoumnAndChilds(context, viewColumns, viewColumn);
i = -1;
}
}
}
}
}
