private void PurchaseALotteryTicket(double moneyPayed, int userID)
{
StoreDL handler = StoreDL.Instance;
LotteryTicket lottery = new LotteryTicket(SystemID, (int)TotalMoneyPayed,
(int)(TotalMoneyPayed + moneyPayed), moneyPayed, userID);
handler.AddLotteryTicket(lottery);
TotalMoneyPayed += moneyPayed;
handler.EditLotteryInDatabase(this);
}
private bool Equals(LotteryTicket obj)
{
StockSyncher handler = StockSyncher.Instance;
return(obj.IntervalStart == IntervalStart &&
obj.IntervalEnd == IntervalEnd &&
obj.LotteryNumber == LotteryNumber &&
obj.myID == myID &&
EnumStringConverter.PrintEnum(obj.myStatus).Equals(EnumStringConverter.PrintEnum(myStatus)) &&
obj.UserID == UserID
);
}
public void AddLotteryTicket(LotteryTicket ticket)
{
object[] ticketVals = ticket.GetTicketValuesArray();
foreach (object val in ticketVals)
{
dbConnection.CheckInput(val.ToString());
}
dbConnection.InsertTable("LotteryTicket", "myID, LotteryID, IntervalStart, IntervalEnd,Cost, Status, UserID",
new[] { "@idParam", "@lotteryParam", "@interStart", "@interEnd", "@cost", "@stat", "@user" },
ticketVals);
}
public LotteryTicket GetLotteryTicket(string ticketid)
{
dbConnection.CheckInput(ticketid);
using (var dbReader = dbConnection.SelectFromTableWithCondition("LotteryTicket", "*", "myID = '" + ticketid + "'"))
{
while (dbReader.Read())
{
LotteryTicket lotty = new LotteryTicket(dbReader.GetString(0), dbReader.GetString(1),
dbReader.GetDouble(2), dbReader.GetDouble(3), dbReader.GetDouble(4), dbReader.GetInt32(6));
lotty.myStatus = EnumStringConverter.GetLotteryStatusString(dbReader.GetString(5));
return(lotty);
}
}
return(null);
}
public LinkedList <LotteryTicket> GetAllTickets(string systemid)
{
dbConnection.CheckInput(systemid);
LinkedList <LotteryTicket> result = new LinkedList <LotteryTicket>();
using (var dbReader = dbConnection.SelectFromTableWithCondition("LotteryTicket", "*", "LotteryID = '" + systemid + "'"))
{
while (dbReader.Read())
{
LotteryTicket lottery = new LotteryTicket(dbReader.GetString(0), dbReader.GetString(1),
dbReader.GetDouble(2), dbReader.GetDouble(3), dbReader.GetDouble(4), dbReader.GetInt32(6));
lottery.myStatus = EnumStringConverter.GetLotteryStatusString(dbReader.GetString(5));
result.AddLast(lottery);
}
}
return(result);
}
private LotteryTicket InformAllWinner(int winningNumber)
{
LotteryTicket winner = null;
StoreDL handler = StoreDL.Instance;
LinkedList <LotteryTicket> tickets = handler.GetAllTickets(SystemID);
foreach (LotteryTicket lotter in tickets)
{
if (lotter.IsWinning(winningNumber))
{
winner = lotter;
lotter.RunWinning();
}
else
{
lotter.RunLosing();
}
handler.EditLotteryTicketInDatabase(lotter);
}
return(winner);
}
public void EditLotteryTicketInDatabase(LotteryTicket ticket)
{
string[] columnNames =
{
"myID",
"LotteryID",
"IntervalStart",
"IntervalEnd",
"Cost",
"Status",
"UserID"
};
dbConnection.CheckInput(ticket.myID);
object[] ticketVals = ticket.GetTicketValuesArray();
foreach (object val in ticketVals)
{
dbConnection.CheckInput(val.ToString());
}
dbConnection.UpdateTable("LotteryTicket", "myID = '" + ticket.myID + "'", columnNames,
new [] { "@idParam", "@lotteryParam", "@interStart", "@interEnd", "@cost", "@stat", "@user" }, ticketVals);
}
public void RemoveLotteryTicket(LotteryTicket lottery)
{
dbConnection.CheckInput(lottery.myID);
dbConnection.DeleteFromTable("LotteryTicket", "myID = '" + lottery.myID + "'");
}