public void InsertWinningBet(LotteryWinningBet lotteryWinningBet)
{
using (OleDbConnection conn = DatabaseConnectionFactory.GetDataSource())
using (OleDbCommand command = new OleDbCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = " INSERT INTO lottery_winning_bet " +
" (bet_id, winning_amt, active, claim_status, num1, num2, num3, num4, num5, num6)" +
" VALUES (@lotteryBetID, @winningAmt, true, @claimStatus, @num1, @num2, @num3, @num4, @num5, @num6)";
command.Parameters.AddWithValue("@lotteryBetID", lotteryWinningBet.GetLotteryBetId());
command.Parameters.AddWithValue("@winningAmt", lotteryWinningBet.GetWinningAmount());
command.Parameters.AddWithValue("@claimStatus", lotteryWinningBet.IsClaimed());
command.Parameters.AddWithValue("@num1", lotteryWinningBet.GetNum1());
command.Parameters.AddWithValue("@num2", lotteryWinningBet.GetNum2());
command.Parameters.AddWithValue("@num3", lotteryWinningBet.GetNum3());
command.Parameters.AddWithValue("@num4", lotteryWinningBet.GetNum4());
command.Parameters.AddWithValue("@num5", lotteryWinningBet.GetNum5());
command.Parameters.AddWithValue("@num6", lotteryWinningBet.GetNum6());
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_dao_impl_msg10"), lotteryWinningBet.GetLotteryBetId()));
}
transaction.Commit();
}
}
private void objectListViewBets_ItemChecked(object sender, ItemCheckedEventArgs e)
{
OLVListItem eOlv = (OLVListItem)e.Item;
LotteryWinningBet bet = (LotteryWinningBet)eOlv.RowObject;
e.Item.Tag = (eOlv.Checked == bet.IsClaimed()) ? null : MODIFIED_TAG;
ColorListViewItemIfModified((OLVListItem)e.Item);
}
private void FillUpBetList()
{
objectListViewWinningBets.SetObjects(lotteryDataServices.GetLotteryWinningBets(dateTimePickerBets.Value));
foreach (OLVListItem item in objectListViewWinningBets.Items)
{
LotteryWinningBet bet = (LotteryWinningBet)item.RowObject;
item.Checked = bet.IsClaimed();
}
}
public void UpdateClaimStatus(LotteryWinningBet winBet)
{
using (OleDbConnection conn = DatabaseConnectionFactory.GetDataSource())
using (OleDbCommand command = new OleDbCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = " UPDATE lottery_winning_bet SET claim_status = @claim_status " +
" WHERE ID = @id AND active = true";
command.Parameters.AddWithValue("@claim_status", winBet.IsClaimed());
command.Parameters.AddWithValue("@id", winBet.GetID());
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_dao_impl_msg12"), winBet.GetID()));
}
transaction.Commit();
}
}