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 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); }