public ActionResult Create(string text, string username) { var user = new UserRepository().Get(username); new TweetRepository().Create(new Tweet { Date = DateTime.UtcNow, Text = text, UserId = user.Id }); return Redirect("/"); }
public IEnumerable<Tweet> GetAll(string username = null) { using (var db = new CassandraContextFactory().Get()) { string query = string.Empty; if (username != null) { var user = new UserRepository().Get(username); query = "select * from tweets where userid='" + user.Id + "'"; } else { query = "select * from tweets"; } var tweets = db.ExecuteQuery(query); var repo = new UserRepository(); List<Tweet> tw = new List<Tweet>(); foreach (dynamic tweet in tweets) { int x = 4; var id = tweet.UserId; tw.Add( new Tweet { Date = tweet.date, Text = tweet.text, UserId = tweet.userid, // UserName = repo.Get().Username }); } return tw; } }