public static string ImportDepartmentsCells(SoftJailDbContext context, string jsonString) { var departmentsDto = JsonConvert.DeserializeObject <impDepartmentDto[]>(jsonString); StringBuilder sb = new StringBuilder(); List <Department> departments = new List <Department>(); foreach (var dto in departmentsDto) { if (!AttributeValidation.IsValid(dto) || dto.Cells.Any(x => !AttributeValidation.IsValid(x))) { sb.AppendLine("Invalid Data"); continue; } departments.Add(Mapper.Map <Department>(dto)); sb.AppendLine($"Imported {dto.Name} with {dto.Cells.Count} cells"); } context.Departments.AddRange(departments); context.SaveChanges(); return(sb.ToString().Trim()); }