public override void PopulateManagerFromExcelUsingDb(string path) { var easyLotteryResults = new List<EasyLottery>(); IList<int> dozens = new List<int>(); var connectionString = string.Format(_connectionStringFormat, path); var dt = GetDataTable(connectionString); foreach (DataRow rowValue in dt.Rows) { if (rowValue[0] == DBNull.Value) continue; var easyLottery = new EasyLottery { Concourse = Convert.ToInt16(rowValue[0]), Date = Convert.ToDateTime(rowValue[1]), FirstDozen = Convert.ToInt16(rowValue[2]), SecondDozen = Convert.ToInt16(rowValue[3]), ThirdDozen = Convert.ToInt16(rowValue[4]), FourthDozen = Convert.ToInt16(rowValue[5]), FifthDozen = Convert.ToInt16(rowValue[6]), SixthDozen = Convert.ToInt16(rowValue[7]), SeventhDozen = Convert.ToInt16(rowValue[8]), EighthDozen = Convert.ToInt16(rowValue[9]), NinethDozen = Convert.ToInt16(rowValue[10]), TenthDozen = Convert.ToInt16(rowValue[11]), EleventhDozen = Convert.ToInt16(rowValue[12]), TwelfthDozen = Convert.ToInt16(rowValue[13]), ThirteenthDozen = Convert.ToInt16(rowValue[14]), FourteenthDozen= Convert.ToInt16(rowValue[15]), FifteenthDozen = Convert.ToInt16(rowValue[16]), }; easyLotteryResults.Add(easyLottery); PopulateHowMany(easyLottery); } PopulateLastTenResults(easyLotteryResults); //Manager.Instance.Results = easyLotteryResults; }
private static void PopulateHowMany(EasyLottery easyLottery) { Manager.Instance.IncludeDozenInHowMany(easyLottery.FirstDozen); Manager.Instance.IncludeDozenInHowMany(easyLottery.SecondDozen); Manager.Instance.IncludeDozenInHowMany(easyLottery.ThirdDozen); Manager.Instance.IncludeDozenInHowMany(easyLottery.FourthDozen); Manager.Instance.IncludeDozenInHowMany(easyLottery.FifthDozen); Manager.Instance.IncludeDozenInHowMany(easyLottery.SixthDozen); Manager.Instance.IncludeDozenInHowMany(easyLottery.SeventhDozen); Manager.Instance.IncludeDozenInHowMany(easyLottery.EighthDozen); Manager.Instance.IncludeDozenInHowMany(easyLottery.NinethDozen); Manager.Instance.IncludeDozenInHowMany(easyLottery.TenthDozen); Manager.Instance.IncludeDozenInHowMany(easyLottery.EleventhDozen); Manager.Instance.IncludeDozenInHowMany(easyLottery.TwelfthDozen); Manager.Instance.IncludeDozenInHowMany(easyLottery.ThirteenthDozen); Manager.Instance.IncludeDozenInHowMany(easyLottery.FourteenthDozen); Manager.Instance.IncludeDozenInHowMany(easyLottery.FifteenthDozen); }