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;
}
}
