private void btnLAWPASaveChanges_Click(object sender, EventArgs e)
{
try
{
DialogResult dr = MessageBox.Show(ResourcesUtils.GetMessage("lott_lwpa_msg3"),
ResourcesUtils.GetMessage("lott_lwpa_msg2"), MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation);
if (dr == DialogResult.No)
{
return;
}
Lottery lottery = (Lottery)cmbLWPAGameMode.SelectedItem;
LotteryWinningCombination originalCombination = this.lotteryDataServices.GetLotteryWinningCombinations(lottery.GetGameMode());
LotteryWinningCombinationSetup lotteryUpdated = (LotteryWinningCombinationSetup)originalCombination.Clone();
lotteryUpdated.Match1 = int.Parse(txtbLWPABet1.Value.ToString());
lotteryUpdated.Match2 = int.Parse(txtbLWPABet2.Value.ToString());
lotteryUpdated.Match3 = int.Parse(txtbLWPABet3.Value.ToString());
lotteryUpdated.Match4 = int.Parse(txtbLWPABet4.Value.ToString());
lotteryUpdated.Match5 = int.Parse(txtbLWPABet5.Value.ToString());
lotteryUpdated.Match6 = int.Parse(txtbLWPABet6.Value.ToString());
this.lotteryDataServices.SaveWinningCombination(lotteryUpdated);
MessageBox.Show(ResourcesUtils.GetMessage("lott_lwpa_msg1"));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void cmbLWPAGameMode_SelectedIndexChanged(object sender, EventArgs e)
{
Lottery lottery = (Lottery)cmbLWPAGameMode.SelectedItem;
lblLWPASelectedGame.Text = lottery.GetDescription();
LotteryWinningCombination prize = this.lotteryDataServices.GetLotteryWinningCombinations(lottery.GetGameMode());
txtbLWPABet1.Text = prize.GetMatch1().ToString();
txtbLWPABet2.Text = prize.GetMatch2().ToString();
txtbLWPABet3.Text = prize.GetMatch3().ToString();
txtbLWPABet4.Text = prize.GetMatch4().ToString();
txtbLWPABet5.Text = prize.GetMatch5().ToString();
txtbLWPABet6.Text = prize.GetMatch6().ToString();
}
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);
}
public int InsertWinningCombination(LotteryWinningCombination lwc)
{
int modified = 0;
using (OleDbConnection conn = DatabaseConnectionFactory.GetDataSource())
using (OleDbCommand command = new OleDbCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = " INSERT INTO `lottery_winning_combination` " +
" (`game_cd`, `active`, `match_0`, `match_1`, `match_2`, `match_3`, `match_4`, `match_5`, `match_6`) " +
" VALUES (@game_cd, true, @m0, @m1, @m2, @m3, @m4, @m5, @m6) ";
command.Parameters.AddWithValue("@game_cd", (int)lwc.GetGameMode());
command.Parameters.AddWithValue("@m0", lwc.GetMatch0());
command.Parameters.AddWithValue("@m1", lwc.GetMatch1());
command.Parameters.AddWithValue("@m2", lwc.GetMatch2());
command.Parameters.AddWithValue("@m3", lwc.GetMatch3());
command.Parameters.AddWithValue("@m4", lwc.GetMatch4());
command.Parameters.AddWithValue("@m5", lwc.GetMatch5());
command.Parameters.AddWithValue("@m6", lwc.GetMatch6());
command.Connection = conn;
conn.Open();
OleDbTransaction transaction = conn.BeginTransaction();
command.Transaction = transaction;
int result = command.ExecuteNonQuery();
if (result < 0)
{
transaction.Rollback();
throw new Exception(String.Format(ResourcesUtils.GetMessage("lot_win_com_impl_msg1"), lwc.GetID()));
}
else
{
transaction.Commit();
modified = base.GetLastInsertedID(command);
}
}
return(modified);
}
public void RemoveWinningCombination(LotteryWinningCombination lwc)
{
using (OleDbConnection conn = DatabaseConnectionFactory.GetDataSource())
using (OleDbCommand command = new OleDbCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = " UPDATE lottery_winning_combination SET active = false " +
" WHERE ID = @id AND game_cd = @game_cd AND active = true";
command.Parameters.AddWithValue("@id", lwc.GetID());
command.Parameters.AddWithValue("@game_cd", lwc.GetGameMode());
command.Connection = conn;
conn.Open();
OleDbTransaction transaction = conn.BeginTransaction();
command.Transaction = transaction;
int result = command.ExecuteNonQuery();
if (result < 0)
{
transaction.Rollback();
throw new Exception(String.Format(ResourcesUtils.GetMessage("lot_win_com_impl_msg1"), lwc.GetID()));
}
transaction.Commit();
}
}
