public async Task Execute(IJobExecutionContext context) { try { DateTime date = DateTime.Now.AddDays(-9).Date; List <LotteryData> lotterylist = DbContext.LotteryDatas.Where(l => l.Date >= date).ToList(); List <NumeralGroup> numberlgroup = DbContext.NumeralGroups.OrderBy(n => n.Ranking).ToList(); List <ContinuityNumber> continuitynumber = DbContext.ContinuityNumbers.OrderBy(n => n.Id).ToList(); foreach (var lotteryitem in lotterylist) { for (int i = 1; i <= numberlgroup.Count; i++) { NumeralGroup numberlist = DbContext.NumeralGroups.Where(n => n.Ranking == i).FirstOrDefault <NumeralGroup>(); string[] intArray = numberlist.Group.Split(','); ContinuityNumber prize = DbContext.ContinuityNumbers.Where(c => c.RankingId == i).FirstOrDefault <ContinuityNumber>(); int contain = Array.IndexOf(intArray, lotteryitem.Champion.ToString()); if (contain > 0) { prize.Number++; if (prize.Number >= 5) { StatisticsTen statis = DbContext.StatisticsTens.Where(s => s.Frequency == prize.Number && prize.RankingId == i).FirstOrDefault <StatisticsTen>(); if (statis == null) { StatisticsTen statisnew = new StatisticsTen(); statisnew.RankingId = i; statisnew.Frequency = prize.Number; statisnew.Number = 1; DbContext.StatisticsTens.Add(statisnew); DbContext.SaveChanges(); } else { statis.Number++; } } } else { prize.Number = 0; } DbContext.SaveChanges(); } DbContext.SaveChanges(); } //foreach (var item in numberlgroup) //{ // string[] intArray = item.Group.Split(','); // foreach (var lotteryitem in lotterylist) // { // ContinuityNumber chacon = DbContext.ContinuityNumbers.Where(c => c.Id == 1).First(); // ContinuityNumber runcon = DbContext.ContinuityNumbers.Where(c => c.Id == 2).First(); // ContinuityNumber thicon = DbContext.ContinuityNumbers.Where(c => c.Id == 3).First(); // ContinuityNumber foucon = DbContext.ContinuityNumbers.Where(c => c.Id == 4).First(); // ContinuityNumber fifcon = DbContext.ContinuityNumbers.Where(c => c.Id == 5).First(); // ContinuityNumber sixcon = DbContext.ContinuityNumbers.Where(c => c.Id == 6).First(); // ContinuityNumber sevcon = DbContext.ContinuityNumbers.Where(c => c.Id == 7).First(); // ContinuityNumber eigcon = DbContext.ContinuityNumbers.Where(c => c.Id == 8).First(); // ContinuityNumber nincon = DbContext.ContinuityNumbers.Where(c => c.Id == 9).First(); // ContinuityNumber tencon = DbContext.ContinuityNumbers.Where(c => c.Id == 10).First(); // int Champion = Array.IndexOf(intArray, lotteryitem.Champion.ToString()); // int RunnerUp = Array.IndexOf(intArray, lotteryitem.RunnerUp.ToString()); // int Third = Array.IndexOf(intArray, lotteryitem.Third.ToString()); // int Fourth = Array.IndexOf(intArray, lotteryitem.Fourth.ToString()); // int Fifth = Array.IndexOf(intArray, lotteryitem.Fifth.ToString()); // int Sixth = Array.IndexOf(intArray, lotteryitem.Sixth.ToString()); // int Seventh = Array.IndexOf(intArray, lotteryitem.Seventh.ToString()); // int Eighth = Array.IndexOf(intArray, lotteryitem.Eighth.ToString()); // int Ninth = Array.IndexOf(intArray, lotteryitem.Ninth.ToString()); // int Tenth = Array.IndexOf(intArray, lotteryitem.Tenth.ToString()); // if (Champion > 0) // { // chacon.Number++; // if (chacon.Number >= 5) // { // StatisticsTen statis = DbContext.StatisticsTens.Where(s => s.Frequency == chacon.Number).First(); // if (statis != null) // { // statis.Number++; // } // else // { // StatisticsTen statisnew = new StatisticsTen(); // statisnew.RankingId = 1; // statisnew.Frequency = tencon.Number; // statisnew.Number = 1; // DbContext.StatisticsTens.Add(statisnew); // } // DbContext.SaveChanges(); // } // } // else // { // chacon.Number = 0; // } // if (RunnerUp > 0) // { // runcon.Number++; // if (runcon.Number >= 5) // { // StatisticsTen statis = DbContext.StatisticsTens.Where(s => s.Frequency == runcon.Number).First(); // if (statis != null) // { // statis.Number++; // } // else // { // StatisticsTen statisnew = new StatisticsTen(); // statisnew.RankingId = 2; // statisnew.Frequency = tencon.Number; // statisnew.Number = 1; // DbContext.StatisticsTens.Add(statisnew); // } // DbContext.SaveChanges(); // } // } // else // { // runcon.Number = 0; // } // if (Third > 0) // { // thicon.Number++; // if (thicon.Number >= 5) // { // StatisticsTen statis = DbContext.StatisticsTens.Where(s => s.Frequency == thicon.Number).First(); // if (statis != null) // { // statis.Number++; // } // else // { // StatisticsTen statisnew = new StatisticsTen(); // statisnew.RankingId = 3; // statisnew.Frequency = tencon.Number; // statisnew.Number = 1; // DbContext.StatisticsTens.Add(statisnew); // } // DbContext.SaveChanges(); // } // } // else // { // thicon.Number = 0; // } // if (Fourth > 0) // { // foucon.Number++; // if (foucon.Number >= 5) // { // StatisticsTen statis = DbContext.StatisticsTens.Where(s => s.Frequency == foucon.Number).First(); // if (statis != null) // { // statis.Number++; // } // else // { // StatisticsTen statisnew = new StatisticsTen(); // statisnew.RankingId = 4; // statisnew.Frequency = tencon.Number; // statisnew.Number = 1; // DbContext.StatisticsTens.Add(statisnew); // } // DbContext.SaveChanges(); // } // } // else // { // foucon.Number = 0; // } // if (Fifth > 0) // { // fifcon.Number++; // if (fifcon.Number >= 5) // { // StatisticsTen statis = DbContext.StatisticsTens.Where(s => s.Frequency == fifcon.Number).First(); // if (statis != null) // { // statis.Number++; // } // else // { // StatisticsTen statisnew = new StatisticsTen(); // statisnew.RankingId = 5; // statisnew.Frequency = tencon.Number; // statisnew.Number = 1; // DbContext.StatisticsTens.Add(statisnew); // } // DbContext.SaveChanges(); // } // } // else // { // fifcon.Number = 0; // } // if (Sixth > 0) // { // sixcon.Number++; // if (sixcon.Number >= 5) // { // StatisticsTen statis = DbContext.StatisticsTens.Where(s => s.Frequency == sixcon.Number).First(); // if (statis != null) // { // statis.Number++; // } // else // { // StatisticsTen statisnew = new StatisticsTen(); // statisnew.RankingId = 6; // statisnew.Frequency = tencon.Number; // statisnew.Number = 1; // DbContext.StatisticsTens.Add(statisnew); // } // DbContext.SaveChanges(); // } // } // else // { // sixcon.Number = 0; // } // if (Seventh > 0) // { // sevcon.Number++; // if (sevcon.Number >= 5) // { // StatisticsTen statis = DbContext.StatisticsTens.Where(s => s.Frequency == sevcon.Number).First(); // if (statis != null) // { // statis.Number++; // } // else // { // StatisticsTen statisnew = new StatisticsTen(); // statisnew.RankingId = 7; // statisnew.Frequency = tencon.Number; // statisnew.Number = 1; // DbContext.StatisticsTens.Add(statisnew); // } // DbContext.SaveChanges(); // } // } // else // { // sevcon.Number = 0; // } // if (Eighth > 0) // { // eigcon.Number++; // if (eigcon.Number >= 5) // { // StatisticsTen statis = DbContext.StatisticsTens.Where(s => s.Frequency == eigcon.Number).First(); // if (statis != null) // { // statis.Number++; // } // else // { // StatisticsTen statisnew = new StatisticsTen(); // statisnew.RankingId = 8; // statisnew.Frequency = tencon.Number; // statisnew.Number = 1; // DbContext.StatisticsTens.Add(statisnew); // } // DbContext.SaveChanges(); // } // } // else // { // eigcon.Number = 0; // } // if (Ninth > 0) // { // nincon.Number++; // if (nincon.Number >= 5) // { // StatisticsTen statis = DbContext.StatisticsTens.Where(s => s.Frequency == nincon.Number).First(); // if (statis != null) // { // statis.Number++; // } // else // { // StatisticsTen statisnew = new StatisticsTen(); // statisnew.RankingId = 9; // statisnew.Frequency = tencon.Number; // statisnew.Number = 1; // DbContext.StatisticsTens.Add(statisnew); // } // DbContext.SaveChanges(); // } // } // else // { // nincon.Number = 0; // } // if (Tenth > 0) // { // tencon.Number++; // if (tencon.Number >= 5) // { // StatisticsTen statis = DbContext.StatisticsTens.Where(s => s.Frequency == tencon.Number).FirstOrDefault<StatisticsTen>(); // if (statis != null) // { // statis.Number++; // } // else // { // StatisticsTen statisnew = new StatisticsTen(); // statisnew.RankingId = 10; // statisnew.Frequency = tencon.Number; // statisnew.Number = 1; // DbContext.StatisticsTens.Add(statisnew); // } // DbContext.SaveChanges(); // } // } // else // { // tencon.Number = 0; // } // DbContext.SaveChanges(); // } //} } catch (Exception ex) { throw; } }
public void GunsUpdate() { try { var connumdata = DbContext.ContinuityNumbers.OrderBy(a => a.Id).ToList(); foreach (var item in connumdata) { item.TenNumber = 0; DbContext.SaveChanges(); } int Lack = Convert.ToInt32(ConfigurationManager.AppSettings["Lack"]); var lottery = DbContext.LotteryDatas.OrderByDescending(o => o.IssueId).Take(Lack).ToList(); lottery = lottery.OrderBy(o => o.IssueId).ToList(); for (int i = 1; i <= 10; i++) { List <NumeralGroup> numberlist = DbContext.NumeralGroups.Where(n => n.Ranking == i).ToList <NumeralGroup>(); foreach (var item in numberlist) { string[] intArray = item.Group.Split(','); ContinuityNumber prize = DbContext.ContinuityNumbers.Where(c => c.NGId == item.Id).FirstOrDefault <ContinuityNumber>(); if (prize == null) { prize = new ContinuityNumber(); prize.NGId = item.Id; prize.RankingId = item.Ranking; prize.TenNumber = 0; prize.MonthNumber = 0; prize.ThreeMonthNumber = 0; prize.HalfYearNumber = 0; prize.YearNumber = 0; DbContext.ContinuityNumbers.Add(prize); DbContext.SaveChanges(); } foreach (var lotteryitem in lottery.Take(50)) { int contain = 0; switch (i) { case 1: contain = Array.IndexOf(intArray, lotteryitem.Champion.ToString()); break; case 2: contain = Array.IndexOf(intArray, lotteryitem.RunnerUp.ToString()); break; case 3: contain = Array.IndexOf(intArray, lotteryitem.Third.ToString()); break; case 4: contain = Array.IndexOf(intArray, lotteryitem.Fourth.ToString()); break; case 5: contain = Array.IndexOf(intArray, lotteryitem.Fifth.ToString()); break; case 6: contain = Array.IndexOf(intArray, lotteryitem.Sixth.ToString()); break; case 7: contain = Array.IndexOf(intArray, lotteryitem.Seventh.ToString()); break; case 8: contain = Array.IndexOf(intArray, lotteryitem.Eighth.ToString()); break; case 9: contain = Array.IndexOf(intArray, lotteryitem.Ninth.ToString()); break; case 10: contain = Array.IndexOf(intArray, lotteryitem.Tenth.ToString()); break; } if (contain < 0) { prize.TenNumber++; if (prize.TenNumber >= 5) { StatisticsTen statis = DbContext.StatisticsTens.Where(s => s.Frequency == prize.TenNumber && s.RankingId == i && s.NGId == item.Id).FirstOrDefault <StatisticsTen>(); if (statis == null) { StatisticsTen statisnew = new StatisticsTen(); statisnew.RankingId = i; statisnew.Frequency = prize.TenNumber; statisnew.Number = 1; statisnew.NGId = item.Id; DbContext.StatisticsTens.Add(statisnew); DbContext.SaveChanges(); } else { statis.Number++; } } } else { prize.TenNumber = 0; } DbContext.SaveChanges(); } } } } catch (Exception e) { } }
public async Task Execute(IJobExecutionContext context) { try { var data = DbContext.StatisticsMonths.OrderBy(a => a.Id).ToList(); foreach (var item in data) { item.Number = 0; DbContext.SaveChanges(); } var connumdata = DbContext.ContinuityNumbers.OrderBy(a => a.Id).ToList(); foreach (var item in connumdata) { item.MonthNumber = 0; DbContext.SaveChanges(); } DateTime date = DateTime.Now.AddMonths(-1).Date; List <LotteryData> lotterylist = DbContext.LotteryDatas.Where(l => l.Date >= date).OrderBy(o => o.IssueId).ToList(); foreach (var lotteryitem in lotterylist) { for (int i = 1; i <= 10; i++) { List <NumeralGroup> numberlist = DbContext.NumeralGroups.Where(n => n.Ranking == i).OrderBy(c => c.Id).ToList <NumeralGroup>(); foreach (var item in numberlist) { string[] intArray = item.Group.Split(','); ContinuityNumber prize = DbContext.ContinuityNumbers.Where(c => c.NGId == item.Id).FirstOrDefault <ContinuityNumber>(); if (prize == null) { prize = new ContinuityNumber(); prize.NGId = item.Id; prize.RankingId = item.Ranking; prize.TenNumber = 0; prize.MonthNumber = 0; prize.ThreeMonthNumber = 0; prize.HalfYearNumber = 0; prize.YearNumber = 0; DbContext.ContinuityNumbers.Add(prize); DbContext.SaveChanges(); } int contain = 0; switch (i) { case 1: contain = Array.IndexOf(intArray, lotteryitem.Champion.ToString()); break; case 2: contain = Array.IndexOf(intArray, lotteryitem.RunnerUp.ToString()); break; case 3: contain = Array.IndexOf(intArray, lotteryitem.Third.ToString()); break; case 4: contain = Array.IndexOf(intArray, lotteryitem.Fourth.ToString()); break; case 5: contain = Array.IndexOf(intArray, lotteryitem.Fifth.ToString()); break; case 6: contain = Array.IndexOf(intArray, lotteryitem.Sixth.ToString()); break; case 7: contain = Array.IndexOf(intArray, lotteryitem.Seventh.ToString()); break; case 8: contain = Array.IndexOf(intArray, lotteryitem.Eighth.ToString()); break; case 9: contain = Array.IndexOf(intArray, lotteryitem.Ninth.ToString()); break; case 10: contain = Array.IndexOf(intArray, lotteryitem.Tenth.ToString()); break; } if (contain < 0) { prize.MonthNumber++; if (prize.MonthNumber >= 5) { StatisticsMonth statis = DbContext.StatisticsMonths.Where(s => s.Frequency == prize.MonthNumber && s.RankingId == i && s.NGId == item.Id).FirstOrDefault <StatisticsMonth>(); if (statis == null) { StatisticsMonth statisnew = new StatisticsMonth(); statisnew.RankingId = i; statisnew.Frequency = prize.MonthNumber; statisnew.Number = 1; statisnew.NGId = item.Id; DbContext.StatisticsMonths.Add(statisnew); DbContext.SaveChanges(); } else { statis.Number++; } } } else { prize.MonthNumber = 0; } DbContext.SaveChanges(); } } DbContext.SaveChanges(); } } catch (Exception ex) { throw; } }
public async Task Execute(IJobExecutionContext context) { try { HttpWebRequest request = (HttpWebRequest)WebRequest.Create(Interface); request.Method = "GET"; request.ContentType = "text/html;charset=UTF-8"; HttpWebResponse response = (HttpWebResponse)request.GetResponse(); Stream myResponseStream = response.GetResponseStream(); StreamReader myStreamReader = new StreamReader(myResponseStream, Encoding.UTF8); string retString = myStreamReader.ReadToEnd(); JObject json = (JObject)JsonConvert.DeserializeObject(retString); LotteryData lottery = new LotteryData(); List <NumeralGroup> numberlgroup = DbContext.NumeralGroups.OrderBy(n => n.Ranking).ToList(); JObject data = (JObject)JsonConvert.DeserializeObject(json["data"].ToString()); JObject newest = (JObject)JsonConvert.DeserializeObject(data["newest"].ToString()); DateTime datetime = Convert.ToDateTime(newest["time"]); lottery.IssueId = Convert.ToInt32(newest["issue"]); var array = newest["array"].ToArray(); var lott = DbContext.LotteryDatas.Where(l => l.IssueId == lottery.IssueId).ToList().Count(); if (lott < 1) { lottery.Champion = Convert.ToInt32(array[0]); lottery.RunnerUp = Convert.ToInt32(array[1]); lottery.Third = Convert.ToInt32(array[2]); lottery.Fourth = Convert.ToInt32(array[3]); lottery.Fifth = Convert.ToInt32(array[4]); lottery.Sixth = Convert.ToInt32(array[5]); lottery.Seventh = Convert.ToInt32(array[6]); lottery.Eighth = Convert.ToInt32(array[7]); lottery.Ninth = Convert.ToInt32(array[8]); lottery.Tenth = Convert.ToInt32(array[9]); lottery.Date = Convert.ToDateTime(datetime.ToString("d")); lottery.Time = datetime.ToString("T"); DbContext.LotteryDatas.Add(lottery); DbContext.SaveChanges(); for (int i = 1; i <= 10; i++) { Omissions omission = DbContext.Omissions.Where(o => o.Ranking == i).First(); switch (Convert.ToInt32(array[i - 1])) { case 1: omission.One = 0; omission.Two++; omission.Three++; omission.Four++; omission.Five++; omission.Six++; omission.Seven++; omission.Eight++; omission.Nine++; omission.Ten++; DbContext.SaveChanges(); break; case 2: omission.One++; omission.Two = 0; omission.Three++; omission.Four++; omission.Five++; omission.Six++; omission.Seven++; omission.Eight++; omission.Nine++; omission.Ten++; DbContext.SaveChanges(); break; case 3: omission.One++; omission.Two++; omission.Three = 0; omission.Four++; omission.Five++; omission.Six++; omission.Seven++; omission.Eight++; omission.Nine++; omission.Ten++; DbContext.SaveChanges(); break; case 4: omission.One++; omission.Two++; omission.Three++; omission.Four = 0; omission.Five++; omission.Six++; omission.Seven++; omission.Eight++; omission.Nine++; omission.Ten++; DbContext.SaveChanges(); break; case 5: omission.One++; omission.Two++; omission.Three++; omission.Four++; omission.Five = 0; omission.Six++; omission.Seven++; omission.Eight++; omission.Nine++; omission.Ten++; DbContext.SaveChanges(); break; case 6: omission.One++; omission.Two++; omission.Three++; omission.Four++; omission.Five++; omission.Six = 0; omission.Seven++; omission.Eight++; omission.Nine++; omission.Ten++; DbContext.SaveChanges(); break; case 7: omission.One++; omission.Two++; omission.Three++; omission.Four++; omission.Five++; omission.Six++; omission.Seven = 0; omission.Eight++; omission.Nine++; omission.Ten++; DbContext.SaveChanges(); break; case 8: omission.One++; omission.Two++; omission.Three++; omission.Four++; omission.Five++; omission.Six++; omission.Seven++; omission.Eight = 0; omission.Nine++; omission.Ten++; DbContext.SaveChanges(); break; case 9: omission.One++; omission.Two++; omission.Three++; omission.Four++; omission.Five++; omission.Six++; omission.Seven++; omission.Eight++; omission.Nine = 0; omission.Ten++; DbContext.SaveChanges(); break; case 10: omission.One++; omission.Two++; omission.Three++; omission.Four++; omission.Five++; omission.Six++; omission.Seven++; omission.Eight++; omission.Nine++; omission.Ten = 0; DbContext.SaveChanges(); break; } List <NumeralGroup> numberlist = DbContext.NumeralGroups.Where(n => n.Ranking == i).ToList <NumeralGroup>(); foreach (var item in numberlist) { string[] intArray = item.Group.Split(','); ContinuityNumber prize = DbContext.ContinuityNumbers.Where(c => c.NGId == item.Id).FirstOrDefault <ContinuityNumber>(); if (prize == null) { prize = new ContinuityNumber(); prize.NGId = item.Id; prize.RankingId = item.Ranking; prize.TenNumber = 0; prize.MonthNumber = 0; prize.ThreeMonthNumber = 0; prize.HalfYearNumber = 0; prize.YearNumber = 0; DbContext.ContinuityNumbers.Add(prize); DbContext.SaveChanges(); } int contain = Array.IndexOf(intArray, array[i - 1].ToString()); if (contain < 0) { prize.TenNumber++; if (prize.TenNumber >= 5) { StatisticsTen statis = DbContext.StatisticsTens.Where(s => s.Frequency == prize.TenNumber && s.RankingId == i && s.NGId == item.Id).FirstOrDefault <StatisticsTen>(); if (statis == null) { StatisticsTen statisnew = new StatisticsTen(); statisnew.RankingId = i; statisnew.Frequency = prize.TenNumber; statisnew.Number = 1; statisnew.NGId = item.Id; DbContext.StatisticsTens.Add(statisnew); DbContext.SaveChanges(); } else { statis.Number++; } StatisticsMonth statimon = DbContext.StatisticsMonths.Where(s => s.Frequency == prize.TenNumber && s.RankingId == i && s.NGId == item.Id).FirstOrDefault <StatisticsMonth>(); if (statimon == null) { StatisticsMonth statisnew = new StatisticsMonth(); statisnew.RankingId = i; statisnew.Frequency = prize.TenNumber; statisnew.Number = 1; statisnew.NGId = item.Id; DbContext.StatisticsMonths.Add(statisnew); DbContext.SaveChanges(); } else { statimon.Number++; } StatisticsThreeMonth statithrmon = DbContext.StatisticsThreeMonths.Where(s => s.Frequency == prize.TenNumber && s.RankingId == i && s.NGId == item.Id).FirstOrDefault <StatisticsThreeMonth>(); if (statithrmon == null) { StatisticsThreeMonth statisnew = new StatisticsThreeMonth(); statisnew.RankingId = i; statisnew.Frequency = prize.TenNumber; statisnew.Number = 1; statisnew.NGId = item.Id; DbContext.StatisticsThreeMonths.Add(statisnew); DbContext.SaveChanges(); } else { statithrmon.Number++; } StatisticsHalfYear statihaye = DbContext.StatisticsHalfYears.Where(s => s.Frequency == prize.TenNumber && s.RankingId == i && s.NGId == item.Id).FirstOrDefault <StatisticsHalfYear>(); if (statihaye == null) { StatisticsHalfYear statisnew = new StatisticsHalfYear(); statisnew.RankingId = i; statisnew.Frequency = prize.TenNumber; statisnew.Number = 1; statisnew.NGId = item.Id; DbContext.StatisticsHalfYears.Add(statisnew); DbContext.SaveChanges(); } else { statihaye.Number++; } StatisticsYear statiyear = DbContext.StatisticsYears.Where(s => s.Frequency == prize.TenNumber && s.RankingId == i && s.NGId == item.Id).FirstOrDefault <StatisticsYear>(); if (statiyear == null) { StatisticsYear statisnew = new StatisticsYear(); statisnew.RankingId = i; statisnew.Frequency = prize.TenNumber; statisnew.Number = 1; statisnew.NGId = item.Id; DbContext.StatisticsYears.Add(statisnew); DbContext.SaveChanges(); } else { statiyear.Number++; } } } else { prize.TenNumber = 0; } } } DbContext.SaveChanges(); } } catch (Exception ex) { } }