public static Guid SubmitNewRetweet(Guid AuthorKey, Guid tweetKey) { using (var db = new FHNWPrototypeDB()) { Guid newGuid = Guid.NewGuid(); var wall = db.ContentStreams.FirstOrDefault(x => x.Owner.ReferenceKey == AuthorKey); var tweet = db.Tweets.FirstOrDefault(x => x.Key == tweetKey); // var author = db.UserAccounts.Single(x => x.Key == AuthorKey); var author = db.BasicProfiles.FirstOrDefault(x => x.ReferenceKey == AuthorKey); Retweet newRetweet = new Retweet(); newRetweet.Author = author; newRetweet.Key = newGuid; newRetweet.PublishDateTime = DateTime.Now; newRetweet.Tweet = tweet; newRetweet.Wall = wall; db.Retweets.Add(newRetweet); db.SaveChanges(); return newGuid; } }
public static Retweet GetRetweet(Guid key) { Retweet thisRetweet = new Retweet(); using (var db = new FHNWPrototypeDB()) { var result = db.Retweets .Include("Author") .Include("Tweet") .FirstOrDefault(x => x.Key == key); thisRetweet.Key = result.Key; thisRetweet.Tweet = result.Tweet; thisRetweet.PublishDateTime = result.PublishDateTime; thisRetweet.Author = result.Author; } return thisRetweet; }