private TemplateVM MapEntityToVM(PublicationTemplate entity, bool includeFields)
{
TemplateVM res = new TemplateVM
{
CreationDate = entity.CreationDate,
Description = entity.Description,
ModifiedDate = entity.ModifiedDate,
Name = entity.Name,
TemplateId = entity.PublicationTemplateId,
IsActive = entity.IsActive,
PublicationsCount = entity.Publications.Count()
};
if (includeFields)
{
foreach (FieldTemplate field in entity.FieldsTemplates)
{
res.Fields.Add(new FieldVM
{
AttachId = field.FieldTemplateId,
FieldId = field.FieldId,
Type = field.Field.Type,
Name = field.Field?.Name
});
}
}
return(res);
}
public void Remove(int id)
{
PublicationTemplate entity = context.PublicationTemplates.FirstOrDefault(t => t.PublicationTemplateId == id);
if (entity != null)
{
context.PublicationTemplates.Remove(entity);
context.SaveChanges();
}
}
public TemplateVM GetTemplateById(int?id)
{
TemplateVM res = new TemplateVM();
if (id.HasValue)
{
PublicationTemplate templateEntity = context.PublicationTemplates
.Include(t => t.Publications)
.Include(t => t.FieldsTemplates)
.ThenInclude(ft => ft.Field)
.FirstOrDefault(t => t.PublicationTemplateId == id.Value);
if (templateEntity != null)
{
res = MapEntityToVM(templateEntity, true);
}
}
return(res);
}
public bool Save(SaveTemplateVM vm)
{
bool res = false;
try
{
PublicationTemplate templateEntity = null;
if (vm.TemplateId == -1) //save new template
{
templateEntity = new PublicationTemplate
{
CreationDate = DateTime.Now,
ModifiedDate = DateTime.Now,
Name = vm.Name,
Description = vm.Description,
IsActive = vm.IsActive
};
context.PublicationTemplates.Add(templateEntity);
context.SaveChanges();
}
else
{
templateEntity = context.PublicationTemplates.FirstOrDefault(t => t.PublicationTemplateId == vm.TemplateId);
if (templateEntity != null)
{
templateEntity.Name = vm.Name;
templateEntity.IsActive = vm.IsActive;
templateEntity.Description = vm.Description;
templateEntity.ModifiedDate = DateTime.Now;
context.Entry(templateEntity).State = EntityState.Modified;
context.SaveChanges();
}
}
if (templateEntity != null)
{
var newFields = vm.Fields.Where(f => f.AttachId == -1);
var oldFields = vm.Fields.Where(f => f.AttachId != -1);
var fieldsEnitites = context.FieldsTemplates.Where(ft => ft.TemplateId == vm.TemplateId).ToList();
foreach (var field in fieldsEnitites)
{
SaveFieldVM fieldVm = oldFields.FirstOrDefault(f => f.AttachId == field.FieldTemplateId);
if (fieldVm != null)
{
field.FieldId = fieldVm.FieldId;
context.Entry(field).State = EntityState.Modified;
}
else
{
context.FieldsTemplates.Remove(field);
}
}
context.SaveChanges();
foreach (SaveFieldVM field in newFields) //save new fields
{
FieldTemplate attachEntity = new FieldTemplate
{
TemplateId = templateEntity.PublicationTemplateId,
FieldId = field.FieldId
};
context.FieldsTemplates.Add(attachEntity);
}
context.SaveChanges();
}
vm.TemplateId = templateEntity.PublicationTemplateId;
res = true;
}
catch { }
return(res);
}
