//
// GET: /Ranking/Details/5
public ActionResult Ranking(int id)
{
PicRankDBDataContext ctx = new PicRankDBDataContext();
var basePictures = (from r in ctx.Rankings
join
p in ctx.Pictures on r.PicId equals p.Id
where r.BasePicId == id
orderby r.Score descending
select new { PicRank = r, Pic = p }).Take(20);
var mainPic = (from p in ctx.Pictures
where p.Id == id
select p).SingleOrDefault();
MainPicWithList ranking = new MainPicWithList();
ranking.MainPicture = new PictureView() { FullPath = mainPic.FullPath, Id = mainPic.Id };
foreach (var item in basePictures)
{
ranking.Pictures.Add(new PictureView()
{
Id = item.Pic.Id,
FullPath = item.Pic.FullPath,
RankingScore = item.PicRank.Score.Value
});
}
return View(ranking);
}
public ActionResult Play()
{
PicRankDBDataContext ctx = new PicRankDBDataContext();
var pictures = ctx.RandomPictures(1 + 12);
MainPicWithList gameView = new MainPicWithList();
Game game = new Game();
game.GameDate = DateTime.Now;
bool hasMain = false;
foreach (var item in pictures)
{
if (!hasMain)
{
gameView.MainPicture = new PictureView() { Id = item.Id, FullPath = item.FullPath };
//game main picture
game.BasePicId = gameView.MainPicture.Id;
hasMain = true;
}
else
{
//game participants
game.GameParticipants.Add(new GameParticipant() { PictureId = item.Id });
gameView.Pictures.Add(new PictureView() { Id = item.Id, FullPath = item.FullPath });
}
}
ctx.Games.InsertOnSubmit(game);
ctx.SubmitChanges();
gameView.GameId = game.Id;
//only for test
//if (gameView.MainPicture == null)
// gameView.MainPicture = new PictureView() { FullPath = @"http://picrank.eastgroup.pl/PicturesSets/pierscionki/image_2702399.jpg", Id = 123 };
//for (int i = 0; i < 10; i++)
//{
// gameView.Pictures.Add(gameView.MainPicture);
//}
return View(gameView);
}