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 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);
}
public LotteryWinningCombination GetLotteryWinningCombination(GameMode gameMode)
{
LotteryWinningCombinationSetup lotteryWinningCombinationSetup = null;
using (OleDbConnection conn = DatabaseConnectionFactory.GetDataSource())
using (OleDbCommand command = new OleDbCommand("SELECT * FROM lottery_winning_combination WHERE game_cd = ? AND active = true;", conn))
{
command.Parameters.AddWithValue("game_cd", gameMode);
conn.Open();
using (OleDbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
lotteryWinningCombinationSetup = GetModel(reader);
}
}
}
return(lotteryWinningCombinationSetup);
}
