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.StatisticsTens.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.TenNumber = 0;
DbContext.SaveChanges();
}
DateTime date = DateTime.Now.AddDays(-9).Date;
//List<LotteryData> lotterylist = DbContext.LotteryDatas.Where(l => l.Date >= date).OrderBy(o => o.Date).OrderBy(t => t.Time).ToList();
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.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();
}
}
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)
{
}
}
