public async Task <ActionResult> CreateAsync([Bind("Date,Column1,Column2,Column3,Column4,Column5,Column6,Bonus")] ResultatJsonFormat item)
{
if (ModelState.IsValid)
{
await Respository.CreateItemAsync(item);
return(RedirectToAction("Index"));
}
return(View(item));
}
public async Task <ActionResult> DeleteAsync(string id)
{
if (id == null)
{
return(BadRequest());
}
ResultatJsonFormat item = await Respository.GetItemAsync(id);
if (item == null)
{
return(NotFound());
}
return(View(item));
}
private int PredictColumn(ITransformer model, ColumnEnum column)
{
var test = new ResultatJsonFormat()
{
Date = _datePrediction,
DateString = _datePrediction.ToShortDateString()
};
switch (column)
{
case ColumnEnum.Column1:
var predictionFunction = _mlContext.Model.CreatePredictionEngine <ResultatJsonFormat, PredictionColumn1>(model);
return((int)predictionFunction.Predict(test).Column1);
case ColumnEnum.Column2:
var predictionFunction2 = _mlContext.Model.CreatePredictionEngine <ResultatJsonFormat, PredictionColumn2>(model);
return((int)predictionFunction2.Predict(test).Column2);
case ColumnEnum.Column3:
var predictionFunction3 = _mlContext.Model.CreatePredictionEngine <ResultatJsonFormat, PredictionColumn3>(model);
return((int)predictionFunction3.Predict(test).Column3);
case ColumnEnum.Column4:
var predictionFunction4 = _mlContext.Model.CreatePredictionEngine <ResultatJsonFormat, PredictionColumn4>(model);
return((int)predictionFunction4.Predict(test).Column4);
case ColumnEnum.Column5:
var predictionFunction5 = _mlContext.Model.CreatePredictionEngine <ResultatJsonFormat, PredictionColumn5>(model);
return((int)predictionFunction5.Predict(test).Column5);
case ColumnEnum.Column6:
var predictionFunction6 = _mlContext.Model.CreatePredictionEngine <ResultatJsonFormat, PredictionColumn6>(model);
return((int)predictionFunction6.Predict(test).Column6);
case ColumnEnum.Bonus:
var predictionFunctionBonus = _mlContext.Model.CreatePredictionEngine <ResultatJsonFormat, PredictionBonus>(model);
return((int)predictionFunctionBonus.Predict(test).Bonus);
}
return(0);
}
private static void DisplayNumberOccurences(List <ResultatJsonFormat> data, DateTime dateSelected)
{
var datafiltered = data;
ResultatJsonFormat newDateSelected = new ResultatJsonFormat
{
Date = dateSelected
};
if (_includeDay)
{
datafiltered = datafiltered.Where(d => d.Day == newDateSelected.Day).ToList();
}
if (_includeWeek)
{
datafiltered = datafiltered.Where(d => d.Week == newDateSelected.Week).ToList();
}
if (_includeMonth)
{
datafiltered = datafiltered.Where(d => d.Month == newDateSelected.Month).ToList();
}
List <float> res = new List <float>();
foreach (var item in datafiltered)
{
res.AddRange(new float[] { item.Column1, item.Column2, item.Column3, item.Column4, item.Column5, item.Column6 });
}
foreach (var line in res.GroupBy(info => info)
.Select(group => new {
Metric = group.Key,
Count = group.Count()
})
.OrderBy(x => x.Count))
{
Console.WriteLine("{0} {1}", line.Metric, line.Count);
}
}
private static float TestPrediction(ITransformer model, ColumnEnum column)
{
switch (column)
{
case ColumnEnum.Column1:
var predictionFunction = _mlContext.Model.CreatePredictionEngine <ResultatJsonFormat, PredictionColumn1>(model);
var test = new ResultatJsonFormat()
{
Date = _datePrediction
};
return(predictionFunction.Predict(test).Column1);
case ColumnEnum.Column2:
var predictionFunction2 = _mlContext.Model.CreatePredictionEngine <ResultatJsonFormat, PredictionColumn2>(model);
var test2 = new ResultatJsonFormat()
{
Date = _datePrediction
};
return(predictionFunction2.Predict(test2).Column2);
case ColumnEnum.Column3:
var predictionFunction3 = _mlContext.Model.CreatePredictionEngine <ResultatJsonFormat, PredictionColumn3>(model);
var test3 = new ResultatJsonFormat()
{
Date = _datePrediction
};
return(predictionFunction3.Predict(test3).Column3);
case ColumnEnum.Column4:
var predictionFunction4 = _mlContext.Model.CreatePredictionEngine <ResultatJsonFormat, PredictionColumn4>(model);
var test4 = new ResultatJsonFormat()
{
Date = _datePrediction
};
return(predictionFunction4.Predict(test4).Column4);
case ColumnEnum.Column5:
var predictionFunction5 = _mlContext.Model.CreatePredictionEngine <ResultatJsonFormat, PredictionColumn5>(model);
var test5 = new ResultatJsonFormat()
{
Date = _datePrediction
};
return(predictionFunction5.Predict(test5).Column5);
case ColumnEnum.Column6:
var predictionFunction6 = _mlContext.Model.CreatePredictionEngine <ResultatJsonFormat, PredictionColumn6>(model);
var test6 = new ResultatJsonFormat()
{
Date = _datePrediction
};
return(predictionFunction6.Predict(test6).Column6);
case ColumnEnum.Bonus:
var predictionFunctionBonus = _mlContext.Model.CreatePredictionEngine <ResultatJsonFormat, PredictionBonus>(model);
var testBonus = new ResultatJsonFormat()
{
Date = _datePrediction
};
return(predictionFunctionBonus.Predict(testBonus).Bonus);
}
return(0);
}
