public void UpdateDescription(LotterySequenceGenerator updatedModel) { using (OleDbConnection conn = DatabaseConnectionFactory.GetDataSource()) using (OleDbCommand command = new OleDbCommand()) { command.CommandType = CommandType.Text; command.CommandText = " UPDATE lottery_seq_gen SET description= @description " + " WHERE ID = @id AND seqgencd = @seqgencd AND active = true"; command.Parameters.AddWithValue("@description", StringUtils.Truncate(updatedModel.GetDescription(), MAX_LEN_DESCRIPTION)); command.Parameters.AddWithValue("@id", updatedModel.GetID()); command.Parameters.AddWithValue("@seqgencd", updatedModel.GetSeqGenCode()); 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_msg2"), updatedModel.GetDescription())); } transaction.Commit(); } }
private void FocusItemOnLotterySequenceGenerators(int sequenceGenIdOrSeqId) { foreach (ListViewItem item in lvSeqGenDescriptions.Items) { LotterySequenceGenerator seqGen = (LotterySequenceGenerator)item.Tag; if (seqGen.GetSeqGenCode() == sequenceGenIdOrSeqId || seqGen.GetID() == sequenceGenIdOrSeqId) { item.Selected = true; item.EnsureVisible(); break; } } }