public List <Lottery> GetLotteries() { List <Lottery> lotterySetupArr = new List <Lottery>(); using (OleDbConnection conn = DatabaseConnectionFactory.GetDataSource()) using (OleDbCommand command = new OleDbCommand()) { command.CommandType = CommandType.Text; command.CommandText = "SELECT * FROM lottery WHERE active = true;"; command.Connection = conn; conn.Open(); using (OleDbDataReader reader = command.ExecuteReader()) { while (reader.Read()) { LotterySetup lotterySetup = new LotterySetup(); lotterySetup.GameCode = ClassReflectionUtil.FindGameMode(int.Parse(reader["game_cd"].ToString())); lotterySetup.Description = reader["description"].ToString(); lotterySetup.PricePerBet = double.Parse(reader["price_per_bet"].ToString()); lotterySetup.WebScrapeGameCode = int.Parse(reader["web_scrape_code"].ToString()); lotterySetupArr.Add(lotterySetup); } } } return(lotterySetupArr); }
private void btnExit_Click(object sender, EventArgs e) { this.Close(); textBoxDelimitersInput.Text = String.Empty; ClearTicketLayoutSelection(); if (!this.hasDataBeenSave) { return; } ClassReflectionUtil.RefreshMainFormBets(this); }
public void ProcessWinningBet(LotteryBet lotteryBet) { GameMode gameMode = ClassReflectionUtil.FindGameMode(lotteryBet.GetGameCode()); LotteryWinningCombinationDao lotteryWinningCombinationDao = LotteryWinningCombinationDaoImpl.GetInstance(); LotteryWinningCombination lotteryWinningCombination = lotteryWinningCombinationDao.GetLotteryWinningCombination(gameMode); RaiseEvent(LotteryDataWorkerEventStages.EXTRACTING, ResourcesUtils.GetMessage("lot_data_worker_cls_msg_3")); LotteryWinningBetDao lotteryWinningBetDao = LotteryWinningBetDaoImpl.GetInstance(); RaiseEvent(LotteryDataWorkerEventStages.EXTRACTING, ResourcesUtils.GetMessage("lot_data_worker_cls_msg_4")); LotteryDrawResultDao lotteryDrawResultDao = LotteryDrawResultDaoImpl.GetInstance(); LotteryDrawResult betDrawResult = lotteryDrawResultDao.GetLotteryDrawResultByDrawDate( gameMode, lotteryBet.GetTargetDrawDate()); LotteryWinningBetSetup lotteryWinningBet = new LotteryWinningBetSetup(); lotteryWinningBet.LotteryBetId = lotteryBet.GetId(); if (betDrawResult == null) { return; } if (betDrawResult.IsDrawResulDetailsEmpty()) { return; } int matchingNumberCtr = 0; foreach (int bet in lotteryBet.GetBetNumbersAsArray()) { if (betDrawResult.IsWithinDrawResult(bet)) { matchingNumberCtr++; lotteryWinningBet.FillNumberBySeq(matchingNumberCtr, bet); } } if (lotteryWinningBet.IsNumberSequenceMatchesAll(betDrawResult.GetAllNumberSequence())) { lotteryWinningBet.WinningAmount = betDrawResult.GetJackpotAmt(); } else { lotteryWinningBet.WinningAmount = lotteryWinningCombination.GetWinningAmount(matchingNumberCtr); } RaiseEvent(LotteryDataWorkerEventStages.INSERT, ResourcesUtils.GetMessage("lot_data_worker_cls_msg_5")); lotteryWinningBetDao.InsertWinningBet(lotteryWinningBet); }
private LotteryWinningCombinationSetup GetModel(OleDbDataReader reader) { LotteryWinningCombinationSetup setup = new LotteryWinningCombinationSetup(); setup.ID = int.Parse(reader["ID"].ToString()); setup.GameMode = ClassReflectionUtil.FindGameMode(int.Parse(reader["game_cd"].ToString())); setup.Match0 = double.Parse(reader["match_0"].ToString()); setup.Match1 = double.Parse(reader["match_1"].ToString()); setup.Match2 = double.Parse(reader["match_2"].ToString()); setup.Match3 = double.Parse(reader["match_3"].ToString()); setup.Match4 = double.Parse(reader["match_4"].ToString()); setup.Match5 = double.Parse(reader["match_5"].ToString()); setup.Match6 = double.Parse(reader["match_6"].ToString()); return(setup); }
private LotterySchedule GetModel(OleDbDataReader reader) { LotteryScheduleSetup lotterySched = new LotteryScheduleSetup(); lotterySched.Monday = Boolean.Parse(reader["mon"].ToString()); lotterySched.Tuesday = Boolean.Parse(reader["tues"].ToString()); lotterySched.Wednesday = Boolean.Parse(reader["wed"].ToString()); lotterySched.Thursday = Boolean.Parse(reader["thurs"].ToString()); lotterySched.Friday = Boolean.Parse(reader["fri"].ToString()); lotterySched.Saturday = Boolean.Parse(reader["sat"].ToString()); lotterySched.Sunday = Boolean.Parse(reader["sun"].ToString()); lotterySched.GameMode = ClassReflectionUtil.FindGameMode(int.Parse(reader["game_cd"].ToString())); lotterySched.ID = int.Parse(reader["ID"].ToString()); return(lotterySched); }
private void AddBet(List <LotteryBet> listViewItems) { using (AddBetFrm bet = new AddBetFrm(this.lotteryDataServices)) { StringBuilder sequence = new StringBuilder(); foreach (LotteryBet item in listViewItems) { bet.AddSequenceEntry(item.GetGNUFormat()); sequence.Clear(); } if (objLvGenSeq.Tag != null) { bet.SelectedSequenceGenerator = ((SequenceGenerator)objLvGenSeq.Tag).GetSequenceGeneratorType(); } Form refToMainForm = ClassReflectionUtil.GetMainFormObj(this, this.Owner); if (refToMainForm == null) { refToMainForm = this; } bet.ShowDialog(refToMainForm); } }
public LotteryTicketPanel GetLotteryTicketPanel(GameMode gameMode) { LotteryTicketPanelSetup lotteryTicketPanel = new LotteryTicketPanelSetup(); using (OleDbConnection conn = DatabaseConnectionFactory.GetDataSource()) using (OleDbCommand command = new OleDbCommand("SELECT * FROM lottery_ticket_panel WHERE game_cd = ? AND active = true;", conn)) { command.Parameters.AddWithValue("game_cd", gameMode); conn.Open(); using (OleDbDataReader reader = command.ExecuteReader()) { while (reader.Read()) { lotteryTicketPanel.Cols = int.Parse(reader["cols"].ToString()); lotteryTicketPanel.Rows = int.Parse(reader["rows"].ToString()); lotteryTicketPanel.Max = int.Parse(reader["max"].ToString()); lotteryTicketPanel.Min = int.Parse(reader["min"].ToString()); lotteryTicketPanel.GameDigitCount = int.Parse(reader["game_digit"].ToString()); lotteryTicketPanel.NumberDirection = ClassReflectionUtil.ConvertToNumberDirection(int.Parse(reader["num_dir"].ToString())); } } } return(lotteryTicketPanel); }
public LotteryDrawResult GetLatestDrawResult(int gameCd) { using (OleDbConnection conn = DatabaseConnectionFactory.GetDataSource()) using (OleDbCommand command = new OleDbCommand()) { command.CommandType = CommandType.Text; command.CommandText = " SELECT TOP 1 * " + " FROM `draw_results` " + " WHERE `game_cd`= @game_cd " + " ORDER BY `draw_date` DESC"; command.Parameters.AddWithValue("@game_cd", gameCd.ToString()); command.Connection = conn; conn.Open(); using (OleDbDataReader reader = command.ExecuteReader()) { while (reader.Read()) { return(GetLotteryDrawResultSetup(reader, ClassReflectionUtil.FindGameMode(int.Parse(reader["game_cd"].ToString())))); } } } return(null);; }