public static DrawingNumberCollection GetCollection(int LotteryDrawingId) { DrawingNumberCollection tempList = null; using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString)) { using (SqlCommand myCommand = new SqlCommand("usp_GetDrawingNumber", myConnection)) { myCommand.CommandType = CommandType.StoredProcedure; myCommand.Parameters.AddWithValue("@QueryId", SelectTypeEnum.GetCollection); myCommand.Parameters.AddWithValue("@LotteryDrawingId", LotteryDrawingId); myConnection.Open(); using (SqlDataReader myReader = myCommand.ExecuteReader()) { if (myReader.HasRows) { tempList = new DrawingNumberCollection(); while (myReader.Read()) { tempList.Add(FillDataRecord(myReader)); } } myReader.Close(); } } } return tempList; }
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()); //} }