private void CreateTheDatesAndTheRatesAtDigit(BrainGameDBEntities3 context)
{
for (int i = 1; i <= numberOfDigits; i++) // 4 signs >> + , - , x , /
{
var selectDirect =
from results in context.Results
where results.UserId == this.userId
select new
{
FirstNumber = results.FirstNumber,
SecondNumber = results.SecondNumber,
Date = results.Date
};
var selected =
from results in selectDirect.AsEnumerable()
where NumberOfDigitsEqualsWith(Math.Max((int)results.FirstNumber, (int)results.SecondNumber), i)
select results.Date;
List <DateTime> currentDateTimeList = selected.ToList();
currentDateTimeList = currentDateTimeList.Distinct().ToList();
currentDateTimeList = currentDateTimeList.OrderBy(x => x.Date).ToList();
List <int> currentRateList = new List <int>();
foreach (DateTime currentDay in currentDateTimeList)
{
var selectedTwoDirect =
from results in context.Results
where results.Date == currentDay
where results.UserId == this.userId
select new
{
FirstNumber = results.FirstNumber,
SecondNumber = results.SecondNumber,
Succeeded = results.Succeeded
};
var selectedTwo =
from results in selectedTwoDirect.AsEnumerable()
where NumberOfDigitsEqualsWith(Math.Max((int)results.FirstNumber, (int)results.SecondNumber), i)
select results.Succeeded;
List <bool> currentBoolList = new List <bool>();
foreach (bool currentBool in selectedTwo)
{
currentBoolList.Add(currentBool);
}
int currentRate = GetTheRate(currentBoolList);
currentRateList.Add(currentRate);
}
DailyRate currentDailyRateDigit = new DailyRate();
currentDailyRateDigit.Dates = currentDateTimeList;
currentDailyRateDigit.Rates = currentRateList;
this.DailyRateDigit.Add(currentDailyRateDigit);
}
}
private void CreateTheDatesAndTheRatesAtOperator(BrainGameDBEntities3 context)
{
for (int i = 1; i <= 4; i++) // 4 signs >> + , - , x , /
{
var selected =
from results in context.Results
where results.Operation == i
where results.UserId == this.userId
select results.Date;
List <DateTime> currentDateTimeList = selected.ToList();
currentDateTimeList = currentDateTimeList.Distinct().ToList();
currentDateTimeList = currentDateTimeList.OrderBy(x => x.Date).ToList();
List <int> currentRateList = new List <int>();
foreach (DateTime currentDay in currentDateTimeList)
{
var selectedTwo =
from results in context.Results
where results.Operation == i
where results.Date == currentDay
where results.UserId == this.userId
select results.Succeeded;
List <bool> currentBoolList = new List <bool>();
foreach (bool currentBool in selectedTwo)
{
currentBoolList.Add(currentBool);
}
int currentRate = GetTheRate(currentBoolList);
currentRateList.Add(currentRate);
}
DailyRate currentDailyRateOperator = new DailyRate();
currentDailyRateOperator.Dates = currentDateTimeList;
currentDailyRateOperator.Rates = currentRateList;
this.DailyRateOperator.Add(currentDailyRateOperator);
}
}
private void CreateTheDatesAndTheRatesAtOperator(BrainGameDBEntities3 context)
{
for (int i = 1; i <= 4; i++) // 4 signs >> + , - , x , /
{
var selected =
from results in context.Results
where results.Operation == i
where results.UserId == this.userId
select results.Date;
List<DateTime> currentDateTimeList = selected.ToList();
currentDateTimeList = currentDateTimeList.Distinct().ToList();
currentDateTimeList = currentDateTimeList.OrderBy(x => x.Date).ToList();
List<int> currentRateList = new List<int>();
foreach (DateTime currentDay in currentDateTimeList)
{
var selectedTwo =
from results in context.Results
where results.Operation == i
where results.Date == currentDay
where results.UserId == this.userId
select results.Succeeded;
List<bool> currentBoolList = new List<bool>();
foreach (bool currentBool in selectedTwo)
{
currentBoolList.Add(currentBool);
}
int currentRate = GetTheRate(currentBoolList);
currentRateList.Add(currentRate);
}
DailyRate currentDailyRateOperator = new DailyRate();
currentDailyRateOperator.Dates = currentDateTimeList;
currentDailyRateOperator.Rates = currentRateList;
this.DailyRateOperator.Add(currentDailyRateOperator);
}
}
private void CreateTheDatesAndTheRatesAtDigit(BrainGameDBEntities3 context)
{
for (int i = 1; i <= numberOfDigits; i++) // 4 signs >> + , - , x , /
{
var selectDirect =
from results in context.Results
where results.UserId == this.userId
select new
{
FirstNumber = results.FirstNumber,
SecondNumber = results.SecondNumber,
Date = results.Date
};
var selected =
from results in selectDirect.AsEnumerable()
where NumberOfDigitsEqualsWith(Math.Max((int)results.FirstNumber, (int)results.SecondNumber), i)
select results.Date;
List<DateTime> currentDateTimeList = selected.ToList();
currentDateTimeList = currentDateTimeList.Distinct().ToList();
currentDateTimeList = currentDateTimeList.OrderBy(x => x.Date).ToList();
List<int> currentRateList = new List<int>();
foreach (DateTime currentDay in currentDateTimeList)
{
var selectedTwoDirect =
from results in context.Results
where results.Date == currentDay
where results.UserId == this.userId
select new
{
FirstNumber = results.FirstNumber,
SecondNumber = results.SecondNumber,
Succeeded = results.Succeeded
};
var selectedTwo =
from results in selectedTwoDirect.AsEnumerable()
where NumberOfDigitsEqualsWith(Math.Max((int)results.FirstNumber, (int)results.SecondNumber), i)
select results.Succeeded;
List<bool> currentBoolList = new List<bool>();
foreach (bool currentBool in selectedTwo)
{
currentBoolList.Add(currentBool);
}
int currentRate = GetTheRate(currentBoolList);
currentRateList.Add(currentRate);
}
DailyRate currentDailyRateDigit = new DailyRate();
currentDailyRateDigit.Dates = currentDateTimeList;
currentDailyRateDigit.Rates = currentRateList;
this.DailyRateDigit.Add(currentDailyRateDigit);
}
}