public Round DrawRound(int gameId)
{
using (var db = new ReallyLuckyContext())
{
var round = new Round {
GameId = gameId, DateTimeStarted = DateTime.UtcNow, DateTimeEnded = DateTime.UtcNow
};
var selectedGame = db.Games.Where(g => g.GameId == gameId).FirstOrDefault();
if (selectedGame.Name == "Lucky 6")
{
round.LuckySixBalls = new List <LuckySixBalls>();
// use const instead 20
for (int i = 0; i < 20; i++)
{
Random r = new Random();
var num = r.Next(48);
while (round.LuckySixBalls.Where(n => n.Number == num).Count() > 0)
{
num = r.Next(48);
}
round.LuckySixBalls.Add(new LuckySixBalls {
Color = Enums.Color.BLACK, Number = num, RoundId = round.RoundId
});
}
db.Rounds.Add(round);
db.SaveChanges();
}
return(round);
}
}
public void SetTicketStatus(long id, Enums.TicketStatus status)
{
using (var db = new ReallyLuckyContext())
{
var ticket = db.Tickets.Where(t => t.TicketId == id).FirstOrDefault();
ticket.Status = status;
db.Tickets.Attach(ticket);
db.Entry(ticket).Property(p => p.Status).IsModified = true;
db.SaveChanges();
}
}
public long CreateNewTicket(Ticket ticket)
{
using (var db = new ReallyLuckyContext())
{
ticket.DateCreated = DateTime.UtcNow;
db.Tickets.Add(ticket);
db.SaveChanges();
return(ticket.TicketId);
}
}
public static void InsertGames()
{
using (var db = new ReallyLuckyContext())
{
if (db.Games.Where(g => g.Name == "Lucky 6").Count() == 0)
{
Game game = new Game
{
Name = "Lucky 6",
Description = "Lucky Six is a draw based game where numbers are drawn from the drum. It is founded on the concept of the classic draw game where person gets the chance to pick random numbers or even colours, and follow live draw every five minutes. Due to its vibrant design and top-notch backend infrastructure, Lucky Six soon became our customers’ favourite and a proven profit generator.",
ImgSrc = "img/lucky6.jpg"
};
db.Games.Add(game);
db.SaveChanges();
}
}
}
