public void RemoveLotterySchedule(LotterySchedule lsched)
{
using (OleDbConnection conn = DatabaseConnectionFactory.GetDataSource())
using (OleDbCommand command = new OleDbCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = " UPDATE lottery_schedule SET active = false " +
" WHERE ID = @id AND game_cd = @game_cd AND active = true";
command.Parameters.AddWithValue("@id", lsched.GetID());
command.Parameters.AddWithValue("@game_cd", (int)lsched.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_sched_com_impl_msg1"), lsched.GetID()));
}
transaction.Commit();
}
}
public int InsertLotterySchedule(LotterySchedule lsched)
{
int modified = 0;
using (OleDbConnection conn = DatabaseConnectionFactory.GetDataSource())
using (OleDbCommand command = new OleDbCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = " INSERT INTO `lottery_schedule` " +
" (`game_cd`, `active`, `mon`, `tues`, `wed`, `thurs`, `fri`, `sat`, `sun`) " +
" VALUES " +
" (@game_cd, true, @isMon, @isTue, @isWed, @isThu, @isFri, @isSat, @isSun) ";
command.Parameters.AddWithValue("@game_cd", (int)lsched.GetGameMode());
command.Parameters.AddWithValue("@isMon", lsched.IsMonday());
command.Parameters.AddWithValue("@isTue", lsched.IsTuesday());
command.Parameters.AddWithValue("@isWed", lsched.IsWednesday());
command.Parameters.AddWithValue("@isThu", lsched.IsThursday());
command.Parameters.AddWithValue("@isFri", lsched.IsFriday());
command.Parameters.AddWithValue("@isSat", lsched.IsSaturday());
command.Parameters.AddWithValue("@isSun", lsched.IsSunday());
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_sched_com_impl_msg1"), lsched.GetID()));
}
else
{
transaction.Commit();
modified = base.GetLastInsertedID(command);
}
}
return(modified);
}
