public static string ImportComments(InstagraphContext context, string xmlString)
{
var xml = XElement.Parse(xmlString);
var jArray = new JArray();
foreach (var item in xml.Elements())
{
var content = item.Element("content")?.Value;
var username = item.Element("user")?.Value;
var postId = item.Element("post")?.Attribute("id")?.Value;
jArray.Add(new JObject(
new JProperty("content", content),
new JProperty("user", username),
new JProperty("postId", postId)));
}
var commentsJson = JsonConvert.SerializeObject(jArray, Newtonsoft.Json.Formatting.Indented, new JsonSerializerSettings {
NullValueHandling = NullValueHandling.Ignore
});
var comments = JsonConvert.DeserializeObject <List <CommentImportDTO> >(commentsJson);
var result = new StringBuilder();
comments.ForEach(c =>
{
if (DeserializeHelper.IsUserExist(c.User, context) &&
DeserializeHelper.IsPostExist(c.PostId, context))
{
var user = context.Users.First(u => u.Username == c.User);
var post = context.Posts.Find(int.Parse(c.PostId));
var comment = Mapper.Map <Comment>(c, opt =>
{
opt.Items["User"] = user;
opt.Items["UserId"] = user.Id;
opt.Items["Post"] = post;
opt.Items["PostId"] = post.Id;
});
context.Comments.Add(comment);
result.AppendLine($"Successfully imported Comment {c.Content}.");
}
else
{
result.AppendLine(Constants.ErrorInvalidData);
}
});
context.SaveChanges();
return(result.ToString());
}
public static string ImportPosts(InstagraphContext context, string xmlString)
{
var xmlPosts = XDocument.Parse(xmlString);
var jArray = new JArray();
foreach (var item in xmlPosts.Root.Elements())
{
jArray.Add(new JObject(
new JProperty("caption", item.Element("caption")?.Value),
new JProperty("user", item.Element("user")?.Value),
new JProperty("picture", item.Element("picture")?.Value)));
}
var jsonPosts = JsonConvert.SerializeObject(jArray, Newtonsoft.Json.Formatting.Indented,
new JsonSerializerSettings {
NullValueHandling = NullValueHandling.Ignore
});
var posts = JsonConvert.DeserializeObject <List <PostImportDTO> >(jsonPosts);
var result = new StringBuilder();
posts.ForEach(p =>
{
if (DeserializeHelper.IsUserExist(p.User, context) &&
DeserializeHelper.IsPictureExist(p.Picture, context))
{
var user = context.Users.First(u => u.Username == p.User);
var picture = context.Pictures.First(p2 => p2.Path == p.Picture);
var post = Mapper.Map <Post>(p, opt => { opt.Items["User"] = user; opt.Items["Picture"] = picture; });
context.Posts.Add(post);
result.AppendLine($"Successfully imported Post {p.Caption}.");
}
else
{
result.AppendLine(Constants.ErrorInvalidData);
}
});
context.SaveChanges();
return(result.ToString());
}