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