public static int SaveDrawing(int lotteryDrawingId, LotteryDrawing drawingToSave) { //notes: instantiate BrokenRules collection and check for any validation errors BrokenRuleCollection saveBrokenRules = new BrokenRuleCollection(); if (lotteryDrawingId <= 0) saveBrokenRules.Add("Drawing", "Drawing must be associated with a valid Drawing"); if (drawingToSave == null) saveBrokenRules.Add("Drawing", "Invalid Drawing object."); else { if (string.IsNullOrEmpty(drawingToSave.PrizeAmount)) saveBrokenRules.Add("PrizeAmount", "Value is required"); } if (saveBrokenRules.Count() > 0) throw new BLLException("Validation rules failed.", saveBrokenRules); else { drawingToSave.PrizeAmount = new LotteryDrawing { LotteryDrawingId = lotteryDrawingId }; return LotteryDrawingDAL.Save(drawingToSave); } }
public static int Save(LotteryDrawing drawingToSave) { LotteryDrawing drawing = new LotteryDrawing(); drawing.LotteryGameId = drawingToSave.LotteryGameId; if (drawingToSave.LotteryGameId > 0) drawing.LotteryGameId = drawingToSave.LotteryGameId; if (drawingToSave.DrawingDate != null) drawing.DrawingDate = drawingToSave.DrawingDate; if (drawingToSave.PrizeAmount != null) drawing.PrizeAmount = drawingToSave.PrizeAmount; return LotteryDrawingDAL.Save(drawingToSave); }
private DrawingDTO DrawingItemToDTO(LotteryDrawing drawingDTO) { DrawingDTO tempItem = new DrawingDTO(); if (drawingDTO !=null) { tempItem.LotteryDrawingId = LotteryDrawing.LotteryDrawingId; if (!string.IsNullOrEmpty(LotteryDrawing.PrizeAmount)) tempItem.PrizeAmount = LotteryDrawing.PrizeAmount; if (!string.IsNullOrEmpty(LotteryDrawing.DrawingDate.ToDate())) tempItem.DrawingDate = LotteryDrawing.DrawingDate.ToDate(); } return tempItem; }
private void ProcessForm() { StringBuilder formControlValues = new StringBuilder(); int number = Number; string ballTypeText = BallList.SelectedItem.Text; int ballTypeValue = BallList.SelectedValue.ToInt(); //notes: set Game properties DrawingNumber numberToSave = new DrawingNumber(); LotteryDrawing h = new LotteryDrawing(); //notes: game specific info numberToSave.DrawingNumberValue = number; numberToSave.BallType = ballTypeValue.ToString(); //notes: detail specific info //notes: call middle tier to save details DrawingNumberManager.Save(numberToSave); //notes: set Id's from hidden fields h.LotteryGameId = LotteryGameId.Value.ToInt(); //Output if (numberToSave.DrawingNumberId > 0) { base.DisplayPageMessage(PageMessage, "Update was successful."); } else { //notes: INSERT was successful - redirect back Response.Redirect("Drawing.aspx?LotteryId=" + numberToSave.DrawingNumberId.ToString()); } }
private static void PowerBall() { bool l = false; do { System.Console.Clear(); System.Console.WriteLine("-----------------------------------------------------------------------"); System.Console.WriteLine("***********************************************************************"); System.Console.WriteLine("-----------------------------------------------------------------------"); System.Console.WriteLine(""); System.Console.WriteLine(" -- -- -- -- -- --"); System.Console.WriteLine(" -- -- -- -- -- -- -- --"); System.Console.WriteLine(" -- -- -- -- -- -- -- --"); System.Console.WriteLine(" -- -- -- -- --"); System.Console.WriteLine(""); System.Console.WriteLine(" POWERBALL"); System.Console.WriteLine(""); System.Console.WriteLine(""); System.Console.WriteLine("1. View Latest Drawing and its Winning Numbers "); System.Console.WriteLine("2. View Game Collection of Drawings"); System.Console.WriteLine("3. To return to the Main Menu"); System.Console.WriteLine(""); System.Console.WriteLine("-----------------------------------------------------------------------"); System.Console.WriteLine("***********************************************************************"); System.Console.WriteLine("-----------------------------------------------------------------------"); System.Console.WriteLine(""); System.Console.Write("Please make your selection:"); string select = System.Console.ReadLine(); int power; int page = 0; int row = 0; power = int.Parse(select); LotteryDrawing drawing = new LotteryDrawing(); drawing = LotteryDrawingDAL.GetItem(1); DrawingNumberCollection number = new DrawingNumberCollection(); number = DrawingNumberDAL.GetCollection(4); switch (power) { case 0: l = true; continue; case 1: System.Console.Clear(); System.Console.WriteLine(drawing.GetDrawing()); foreach (DrawingNumber item in number) { //System.Console.WriteLine(item.GetItem()); } System.Console.WriteLine(""); System.Console.WriteLine(" Press any key to return to Menu"); break; case 2: System.Console.Clear(); System.Console.WriteLine("Enter Page Number\t\t"); page = Convert.ToInt32(System.Console.ReadLine()); System.Console.WriteLine("Enter Number of Rows to view\t\t"); row = Convert.ToInt32(System.Console.ReadLine()); System.Console.Clear(); LotteryDrawingCollection draw = new LotteryDrawingCollection(); draw = LotteryDrawingDAL.GetCollection(1, page, row); foreach (LotteryDrawing item in draw) { System.Console.WriteLine(item.GetDrawing()); } System.Console.WriteLine(""); System.Console.WriteLine(" Press any key to return to Menu"); break; case 3: Project(); break; case 4: North(); break; default: if (power > 4) { Error(); } else Error(); continue; } System.Console.ReadKey(); System.Console.Clear(); } while (!l); }
// private static void PowerBall() // { // string firstGame = "PowerBall"; // DateTime dt = DateTime.Parse("18 Dec 2013"); // int firstNumber= 7; // int secondNumber= 24; // int thirdNumber= 37; // int fourthNumber= 39; // int fifthNumber = 40; // int powerBall = 1; // string estimatedJackpot = "$60,000,000"; // string estimatedCashoption = "$33,300,000"; // DateTime jackpotDrawingdate = DateTime.Parse("21 Dec 2013"); // System.Console.WriteLine(firstGame); // System.Console.WriteLine(dt); // System.Console.WriteLine(firstNumber); // System.Console.WriteLine(secondNumber); // System.Console.WriteLine(thirdNumber); // System.Console.WriteLine(fourthNumber); // System.Console.WriteLine(fifthNumber); // System.Console.WriteLine(powerBall); // System.Console.WriteLine(estimatedJackpot); // System.Console.WriteLine(estimatedCashoption); // System.Console.WriteLine(jackpotDrawingdate); // } // private static void MegaMillions() //{ // string secondGame= "Mega Millions"; // DateTime dt = DateTime.Parse("17 Dec 2013"); // int firstNumber = 8; // int secondNumber = 14; // int thirdNumber = 17; // int fourthNumber = 20; // int fifthNumber = 39; // int megaBall = 7; // string estimatedJackpot = "$15,000,000"; // string estimatedCashoption = "$8,000,000"; // DateTime jackpotDrawingdate = DateTime.Parse("20 Dec 2013"); // System.Console.WriteLine(secondGame); // System.Console.WriteLine(dt); // System.Console.WriteLine(firstNumber); // System.Console.WriteLine(secondNumber); // System.Console.WriteLine(thirdNumber); // System.Console.WriteLine(fourthNumber); // System.Console.WriteLine(fifthNumber); // System.Console.WriteLine(megaBall); // System.Console.WriteLine(estimatedJackpot); // System.Console.WriteLine(estimatedCashoption); // System.Console.WriteLine(jackpotDrawingdate); //} //private static void HotLotto() //{ // string thirdGame = "Mega Millions"; // DateTime dt = DateTime.Parse("18 Dec 2013"); // int firstNumber = 8; // int secondNumber = 27; // int thirdNumber = 32; // int fourthNumber = 40; // int fifthNumber = 46; // int hotBall = 4; // string estimatedJackpot = "$1,950,000"; // DateTime jackpotDrawingdate = DateTime.Parse("21 Dec 2013"); // System.Console.WriteLine(thirdGame); // System.Console.WriteLine(dt); // System.Console.WriteLine(firstNumber); // System.Console.WriteLine(secondNumber); // System.Console.WriteLine(thirdNumber); // System.Console.WriteLine(fourthNumber); // System.Console.WriteLine(fifthNumber); // System.Console.WriteLine(hotBall); // System.Console.WriteLine(estimatedJackpot); // System.Console.WriteLine(jackpotDrawingdate); //} //private static void Gopher5() //{ // string fourthGame = "Gopher 5"; // DateTime dt = DateTime.Parse("18 Dec 2013"); // int firstNumber = 2; // int secondNumber = 9; // int thirdNumber = 12; // int fourthNumber = 36; // int fifthNumber = 39; // string estimatedJackpot = "$130,000"; // // DateTime jackpotDrawingDate = DateTime.Parse("20 Dec 2013"); // DateTime jackpotDrawingDate = new DateTime(2013, 12, 20); // System.Console.WriteLine(fourthGame); // System.Console.WriteLine(dt); // System.Console.WriteLine(firstNumber); // System.Console.WriteLine(secondNumber); // System.Console.WriteLine(thirdNumber); // System.Console.WriteLine(fourthNumber); // System.Console.WriteLine(fifthNumber); // System.Console.WriteLine(estimatedJackpot); // System.Console.WriteLine(jackpotDrawingDate); //} //private static void ListArray() //{ // List<string> GameName = new List<string>(); // string[] WinningNumber = new string[4]; // string[] EstimatedJackpot = new string[4]; // GameName.Add("PowerBall"); // WinningNumber[0] = "7 24 37 39 40 1"; // EstimatedJackpot[0] = "$60,000,000"; // GameName.Add("Mega Millions"); // WinningNumber[1] = "8 14 17 20 39 7"; // EstimatedJackpot[1] = "$15,000,000"; // GameName.Add("Hot Lotto"); // WinningNumber[2] = "8 27 32 40 46 4"; // EstimatedJackpot[2] = "$1,950,000"; // GameName.Add("Gopher 5"); // WinningNumber[3] = "2 9 12 36 39"; // EstimatedJackpot[3] = "$130,000"; // int i = 0; // foreach (string stringValue in GameName) // { // System.Console.WriteLine(stringValue); // System.Console.WriteLine(WinningNumber[i]); // System.Console.WriteLine(EstimatedJackpot[i]); // i++; // } //} //private static void Menu() //{ // System.Console.WriteLine("Please select from the following options to view lottery game info:"); // System.Console.WriteLine("----------------------------------------------------------"); // System.Console.WriteLine("1 : Powerball"); // System.Console.WriteLine("2 : Mega Millions"); // System.Console.WriteLine("3 : Hot Lotto"); // System.Console.WriteLine("4 : Gopher 5"); // System.Console.WriteLine("----------------------------------------------------------"); // string GameName1, GameName2, GameName3, GameName4; // string WinningNumber1, WinningNumber2, WinningNumber3, WinningNumber4; // string EstimatedJackpot1, EstimatedJackpot2, EstimatedJackpot3, EstimatedJackpot4; // GameName1 = "PowerBall"; // WinningNumber1 = "7 24 37 39 40 1"; // EstimatedJackpot1 = "$60,000,000"; // GameName2 = "Mega Millions"; // WinningNumber2 = "8 14 17 20 39 7"; // EstimatedJackpot2 = "$15,000,000"; // GameName3 = "Hot Lotto"; // WinningNumber3 = "8 27 32 40 46 4"; // EstimatedJackpot3 = "$1,950,000"; // GameName4 = "Gopher 5"; // WinningNumber4 = "2 9 12 36 39"; // EstimatedJackpot4 = "$130,000"; // string Games = System.Console.ReadLine(); // try // { // switch (Games) // { // case "1": // System.Console.WriteLine(GameName1); // System.Console.WriteLine(WinningNumber1); // System.Console.WriteLine(EstimatedJackpot1); // break; // case "2": // System.Console.WriteLine(GameName2); // System.Console.WriteLine(WinningNumber2); // System.Console.WriteLine(EstimatedJackpot2); // break; // case "3": // System.Console.WriteLine(GameName3); // System.Console.WriteLine(WinningNumber3); // System.Console.WriteLine(EstimatedJackpot3); // break; // case "4": // System.Console.WriteLine(GameName4); // System.Console.WriteLine(WinningNumber4); // System.Console.WriteLine(EstimatedJackpot4); // break; // default: // System.Console.WriteLine("Please select a valid number!"); // break; // } // } // catch (FormatException ex) // { // System.Console.WriteLine("Exception: " + ex.Message); // } // finally // { // System.Console.WriteLine("Program has completed regardless of Exceptions."); // } //} private static void Code() { int game = 0; int drawing = 0; int number = 0; game = Convert.ToInt32(Console.ReadLine()); drawing = Convert.ToInt32(Console.ReadLine()); number = Convert.ToInt32(Console.ReadLine()); LotteryGameValue pb = new LotteryGameValue(); pb = LotteryGameDAL.GetItem(game); LotteryDrawing mb = new LotteryDrawing(); mb = LotteryDrawingDAL.GetItem(drawing); DrawingNumberCollection numc = new DrawingNumberCollection(); numc = DrawingNumberDAL.GetCollection(number); int id = 0; int page = 0; int row = 0; id = Convert.ToInt32(Console.ReadLine()); page = Convert.ToInt32(Console.ReadLine()); row = Convert.ToInt32(Console.ReadLine()); LotteryDrawingCollection drawc = new LotteryDrawingCollection(); drawc = LotteryDrawingDAL.GetCollection(id, page, row); foreach (LotteryDrawing item in drawc) { System.Console.WriteLine(item.GetDrawing()); } System.Console.ReadKey(); //System.Console.WriteLine(""); //foreach (DrawingNumber item in number) //{ // System.Console.WriteLine(item.GetItem()); //} //System.Console.WriteLine(pb.GetGame()); //System.Console.ReadKey(); //System.Console.WriteLine(""); //LotteryDrawing drawing = new LotteryDrawing(); //drawing = LotteryDrawingDAL.GetItem(12); // System.Console.WriteLine(drawing.GetDrawing()); //DrawingNumberCollection number = new DrawingNumberCollection(); //number = DrawingNumberDAL.GetCollection(5); //foreach (DrawingNumber item in number) //{ // System.Console.WriteLine(item.GetItem()); //} //LotteryGameCollection drawing = new LotteryGameCollection(); //drawing = LotteryGameDAL.GetCollection(); //foreach (LotteryGameValue item in drawing) //{ // System.Console.WriteLine(item.GetGame()); //} //LotteryDrawingCollection drawing = new LotteryDrawingCollection(); //drawing = LotteryDrawingDAL.GetCollection(4,1,5); //foreach (LotteryDrawing item in drawing) //{ // System.Console.WriteLine(item.GetDrawing()); //} }
private void ProcessForm() { StringBuilder formControlValues = new StringBuilder(); DateTime date = DrawingDate.Text.ToDate(); string prize = PrizeAmount.Text; //notes: set Game properties LotteryDrawing drawingToSave = new LotteryDrawing(); //notes: game specific info drawingToSave.DrawingDate = date; drawingToSave.PrizeAmount = prize; drawingToSave.LotteryGameId = _lotteryGameId; //notes: detail specific info //notes: call middle tier to save details DrawingManager.Save(drawingToSave); //notes: set Id's from hidden fields drawingToSave.LotteryGameId = LotteryGameId.Value.ToInt(); //Output if (drawingToSave.LotteryGameId > 0) { base.DisplayPageMessage(PageMessage, "Update was successful."); } else { //notes: INSERT was successful - redirect back Response.Redirect("Drawing.aspx?LotteryId=" + drawingToSave.LotteryGameId.ToString()); } }
private static LotteryDrawing FillDataRecord(IDataRecord myDataRecord) { LotteryDrawing myObject = new LotteryDrawing(); myObject.LotteryGameId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("LotteryGameId")); myObject.LotteryDrawingId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("LotteryDrawingId")); if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("PrizeAmount"))) myObject.PrizeAmount = myDataRecord.GetString(myDataRecord.GetOrdinal("PrizeAmount")); if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("DrawingDate"))) myObject.DrawingDate = myDataRecord.GetDateTime(myDataRecord.GetOrdinal("DrawingDate")); return myObject; }
public static int Save(LotteryDrawing drawingToSave) { int result = 0; ExecuteTypeEnum queryId = ExecuteTypeEnum.InsertItem; // notes: check for valid LotteryGameId - if exists then UPDATE , else INSERT if (drawingToSave.LotteryDrawingId > 0) queryId = ExecuteTypeEnum.UpdateItem; using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString)) { using (SqlCommand myCommand = new SqlCommand("usp_ExecuteLotteryDrawing", myConnection)) { myCommand.CommandType = CommandType.StoredProcedure; myCommand.Parameters.AddWithValue("@QueryId", queryId); myCommand.Parameters.AddWithValue("@LotteryGameId", drawingToSave.LotteryGameId); myCommand.Parameters.AddWithValue("@LotteryDrawingId", drawingToSave.LotteryDrawingId); if (drawingToSave.PrizeAmount != null) myCommand.Parameters.AddWithValue("@PrizeAmount", drawingToSave.PrizeAmount); if (drawingToSave.DrawingDate != null) myCommand.Parameters.AddWithValue("@DrawingDate", drawingToSave.DrawingDate); //notes: add return output parameter to command object myCommand.Parameters.Add(HelperDAL.GetReturnParameterInt("ReturnValue")); myConnection.Open(); myCommand.ExecuteNonQuery(); //notes: get return value from stored procedure and return Id result = (int)myCommand.Parameters["@ReturnValue"].Value; } myConnection.Close(); } return result; }