public NewsModel getMoviesToNews()
{
NewsModel model = new NewsModel {
MoviesList = new List <Movies_ttl>()
};
var cass = new CassandraDatabase();
Cassandra.RowSet movies = cass.getAllDataFromTable("movies_ttl2");
foreach (var movie in movies)
{
Movies_ttl tmpMovie = new Movies_ttl
{
Id = movie["id"].ToString(),
Title = movie["title"].ToString(),
Date = movie["release_date"].ToString(),
Genere = movie["genere"].ToString(),
Runtime = movie["runtime"].ToString(),
Rating = movie["rating"].ToString(),
Summary = movie["summary"].ToString(),
RawImg = movie["img_base64"].ToString(),
Price = movie["price"].ToString()
};
model.MoviesList.Add(tmpMovie);
}
return(model);
}
public void CassandraNotification()
{
CartModel model = new CartModel();
model.Movies = new List <MovieCart>();
string actualCart = redisGetValue(this.HttpContext.Session.Id, 2);
var moviesId = actualCart.Split(";");
foreach (var movieId in moviesId)
{
MovieCart movie = new HttpRequestHelper().getMovieToCart(movieId);
model.Movies.Add(movie);
}
double totalPrice = 0.0;
foreach (var movie in model.Movies)
{
try
{
totalPrice += Convert.ToDouble(movie.Price);
}
catch
{
continue;
}
}
var cass = new CassandraDatabase();
cass.insertNotification(this.CurrentUser.Name, totalPrice.ToString());
}
public IActionResult Notification()
{
NotificationModel model = new NotificationModel();
model.Notifications = new List <Notification>();
var cass = new CassandraDatabase();
string condition = "where user_login = "******"'" + this.CurrentUser.Name + "'";
Cassandra.RowSet notifications = cass.getAllDataFromTableWithCondition("notification", condition);
foreach (var notification in notifications)
{
Notification tmpNotification = new Notification
{
User = notification["user_login"].ToString(),
Time = notification["added_time"].ToString().Split("+")[0],
Message = notification["message"].ToString(),
};
model.Notifications.Add(tmpNotification);
}
return(View(model));
}