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 InitializesListViewColumns()
{
this.olvLottoOutlet.AspectGetter = delegate(object rowObject)
{
LotteryBet lotteryBet = (LotteryBet)rowObject;
LotteryOutlet outlet = lotteryBet.GetLotteryOutlet();
return(outlet);
};
this.olvLottoOutlet.AspectToStringConverter = delegate(object rowObject)
{
LotteryOutlet outlet = (LotteryOutlet)rowObject;
return(outlet.GetDescription());
};
this.olvLottoSeqGen.AspectGetter = delegate(object rowObject)
{
LotteryBet lotteryBet = (LotteryBet)rowObject;
LotterySequenceGenerator outlet = lotteryBet.GetLotterySequenceGenerator();
return(outlet);
};
this.olvLottoSeqGen.AspectToStringConverter = delegate(object rowObject)
{
LotterySequenceGenerator seqgen = (LotterySequenceGenerator)rowObject;
return(seqgen.GetDescription());
};
}
public int InsertSequenceGenerator(LotterySequenceGenerator seqGen)
{
int modified = 0;
using (OleDbConnection conn = DatabaseConnectionFactory.GetDataSource())
using (OleDbCommand command = new OleDbCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = " INSERT INTO `lottery_seq_gen` (`seqgencd`, `description`, `active`) VALUES(@seqgencd, @desc, true); ";
command.Connection = conn;
command.Parameters.AddWithValue("@seqgencd", seqGen.GetSeqGenCode());
command.Parameters.AddWithValue("@desc", seqGen.GetDescription());
conn.Open();
OleDbTransaction transaction = conn.BeginTransaction();
command.Transaction = transaction;
int result = command.ExecuteNonQuery();
if (result < 0)
{
transaction.Rollback();
throw new Exception(ResourcesUtils.GetMessage("lot_dao_impl_msg13"));
}
else
{
transaction.Commit();
modified = base.GetLastInsertedID(command);
}
}
return(modified);
}
private LotterySequenceGenerator GetSelectedLotterySequenceGenerator()
{
if (lvSeqGenDescriptions.SelectedItems.Count <= 0)
{
return(null);
}
ListViewItem item = lvSeqGenDescriptions.SelectedItems[0];
LotterySequenceGenerator seqgen = (LotterySequenceGenerator)item.Tag;
return(seqgen);
}
private void lvSeqGenDescriptions_SelectedIndexChanged(object sender, EventArgs e)
{
if (lvSeqGenDescriptions.SelectedItems.Count <= 0)
{
return;
}
LotterySequenceGenerator seqGen = GetSelectedLotterySequenceGenerator();
txtbGenSeqDescription.Text = seqGen.GetDescription();
UpdateSeqGenDescLenLbl();
}
private void ObjectListViewBets_CellEditStarting(object sender, BrightIdeasSoftware.CellEditEventArgs e)
{
if (e.Column == this.olvLottoOutlet)
{
ComboBox outletCodeEditorCmb = new ComboBox();
outletCodeEditorCmb.Items.AddRange(lotteryOutletList.ToArray());
outletCodeEditorCmb.Bounds = e.CellBounds;
outletCodeEditorCmb.Font = ((ObjectListView)sender).Font;
int selectedIndex = 0;
LotteryBet bet = (LotteryBet)e.RowObject;
for (int i = 0; i < outletCodeEditorCmb.Items.Count; i++)
{
LotteryOutlet outlet = (LotteryOutlet)outletCodeEditorCmb.Items[i];
if (outlet.GetOutletCode() == bet.GetOutletCode())
{
selectedIndex = i;
break;
}
}
// should select the entry that reflects the current value
if (outletCodeEditorCmb.Items.Count > 0)
{
outletCodeEditorCmb.SelectedIndex = selectedIndex;
}
e.Control = outletCodeEditorCmb;
}
else if (e.Column == this.olvLottoSeqGen)
{
ComboBox seqgenEditorCmb = new ComboBox();
seqgenEditorCmb.Items.AddRange(lotterySequenceGeneratorList.ToArray());
seqgenEditorCmb.Bounds = e.CellBounds;
seqgenEditorCmb.Font = ((ObjectListView)sender).Font;
int selectedIndex = 0;
LotteryBet bet = (LotteryBet)e.RowObject;
for (int i = 0; i < seqgenEditorCmb.Items.Count; i++)
{
LotterySequenceGenerator seqGen = (LotterySequenceGenerator)seqgenEditorCmb.Items[i];
if (seqGen.GetSeqGenCode() == bet.GetLotterySequenceGenerator().GetSeqGenCode())
{
selectedIndex = i;
break;
}
}
// should select the entry that reflects the current value
if (seqgenEditorCmb.Items.Count > 0)
{
seqgenEditorCmb.SelectedIndex = selectedIndex;
}
e.Control = seqgenEditorCmb;
}
}
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;
}
}
}
private void ObjectListViewBets_CellEditFinished(object sender, BrightIdeasSoftware.CellEditEventArgs e)
{
try
{
if (e.Column == this.olvLottoOutlet)
{
LotteryOutlet oldval = (LotteryOutlet)e.Value;
LotteryOutlet newval = (LotteryOutlet)e.NewValue;
if (newval == null)
{
e.Cancel = true; return;
}
if (oldval.GetOutletCode() == newval.GetOutletCode())
{
e.Cancel = true;
}
if (e.Cancel == false)
{
ObjectListView lv = (ObjectListView)sender;
LotteryBetSetup setup = (LotteryBetSetup)e.RowObject;
setup.OutletCode = newval.GetOutletCode();
e.ListViewItem.Tag = MODIFIED_TAG;
setup.LotteryOutlet = GetOutletObject(newval.GetOutletCode());
lv.RefreshObject(e.RowObject);
lv.Refresh();
}
}
else if (e.Column == this.olvLottoSeqGen)
{
LotterySequenceGenerator oldval = (LotterySequenceGenerator)e.Value;
LotterySequenceGenerator newval = (LotterySequenceGenerator)e.NewValue;
if (newval == null)
{
e.Cancel = true; return;
}
if (oldval.GetSeqGenCode() == newval.GetSeqGenCode())
{
e.Cancel = true;
}
if (e.Cancel == false)
{
ObjectListView lv = (ObjectListView)sender;
LotteryBetSetup setup = (LotteryBetSetup)e.RowObject;
e.ListViewItem.Tag = MODIFIED_TAG;
setup.LotterySeqGen = GetSeqGenObject(newval.GetSeqGenCode());
lv.RefreshObject(e.RowObject);
lv.Refresh();
}
}
else
{
if (e.NewValue.ToString() == e.Value.ToString())
{
e.Cancel = true;
}
if (e.Cancel == false)
{
int newValue = int.Parse(e.NewValue.ToString());
if (!lotteryTicketPanel.IsWithinMinMax(newValue))
{
throw new Exception(String.Format(ResourcesUtils.GetMessage("modfy_bets_msg_5"),
lotteryTicketPanel.GetMin(), lotteryTicketPanel.GetMax()));
}
ObjectListView lv = (ObjectListView)sender;
LotteryBetSetup setup = (LotteryBetSetup)e.RowObject;
setup.FillNumberBySeq(e.SubItemIndex - 1, newValue);
e.ListViewItem.Tag = MODIFIED_TAG;
lv.RefreshObject(e.RowObject);
lv.Refresh();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ResourcesUtils.GetMessage("modfy_bets_msg_6"));
e.Cancel = true;
}
finally
{
ColorListViewItemIfModified(e.ListViewItem);
}
}
private void InitializesObjectListViewDataBinding()
{
this.olvColBetMatch.ImageGetter = delegate(object rowObject) {
if (rowObject == null)
{
return(0);
}
LotteryBet p = (LotteryBet)rowObject;
if (p.GetMatchNumCount() <= 0)
{
return(0);
}
return(ImageUtils.GetStarWonImage(p.GetMatchNumCount()));
};
this.olvColBetMatch.AspectGetter = delegate(object rowObject) {
if (rowObject == null)
{
return(0);
}
LotteryBet p = (LotteryBet)rowObject;
return(p.GetMatchNumCount());
};
this.olvColBetMatch.AspectToStringConverter = delegate(object rowObject) {
return(String.Empty);
};
this.olvColBetOutlet.AspectGetter = delegate(object rowObject)
{
LotteryBet lotteryBet = (LotteryBet)rowObject;
LotteryOutlet outlet = lotteryBet.GetLotteryOutlet();
return(outlet);
};
this.olvColBetOutlet.AspectToStringConverter = delegate(object rowObject)
{
if (rowObject == null)
{
return(String.Empty);
}
LotteryOutlet outlet = (LotteryOutlet)rowObject;
return(outlet.GetDescription());
};
this.olvColBetSeqGen.AspectGetter = delegate(object rowObject)
{
LotteryBet lotteryBet = (LotteryBet)rowObject;
LotterySequenceGenerator outlet = lotteryBet.GetLotterySequenceGenerator();
return(outlet);
};
this.olvColBetSeqGen.AspectToStringConverter = delegate(object rowObject)
{
if (rowObject == null)
{
return(String.Empty);
}
LotterySequenceGenerator seqgen = (LotterySequenceGenerator)rowObject;
return(seqgen.GetDescription());
};
this.olvColDrawWinner.ImageGetter = delegate(object rowObject) {
if (rowObject == null)
{
return(0);
}
LotteryDrawResult p = (LotteryDrawResult)rowObject;
if (p.GetWinnersCount() <= 0)
{
return(0);
}
return(ImageUtils.GetStarJackpotImage(5));
};
this.olvColDrawWinner.AspectGetter = delegate(object rowObject) {
if (rowObject == null)
{
return(0);
}
LotteryDrawResult p = (LotteryDrawResult)rowObject;
return(p.GetWinnersCount());
};
this.olvColDrawWinner.AspectToStringConverter = delegate(object rowObject) {
return(String.Empty);
};
this.olvColDrawMatch.ImageGetter = delegate(object rowObject) {
if (rowObject == null)
{
return(0);
}
int matchCnt = CountMatchingBetToDrawnResult(rowObject);
if (matchCnt <= 0)
{
return(0);
}
return(ImageUtils.GetStarWonImage(matchCnt));
};
this.olvColDrawMatch.AspectGetter = delegate(object rowObject) {
if (rowObject == null)
{
return(0);
}
return(CountMatchingBetToDrawnResult(rowObject));
};
this.olvColDrawMatch.AspectToStringConverter = delegate(object rowObject) {
return(String.Empty);
};
}
