public async Task <IActionResult> Edit(int id, [Bind("Id,EventId,DateAdded,IsLive,StartTime,HomeTeam,AwayTeam,HOME,DRAW,AWAY,HOME_computed_,DRAW_computed_,AWAY_computed_,HOME_disc,DRAW_disc,AWAY_disc,HOMEAWAY,HOMEDRAW,DRAWAWAY,HOMEAWAY_computed_,HOMEDRAW_computed_,DRAWAWAY_computed_,HOMEAWAY_disc,HOMEDRAW_disc,DRAWAWAY_disc,TO_0_5,TU_0_5,TO_0_5_computed_,TU_0_5_computed_,TO_0_5_disc,TU_0_5_disc,TO_0_75,TU_0_75,TO_0_75_computed_,TU_0_75_computed_,TO_0_75_disc,TU_0_75_disc,TO_1_0,TU_1_0,TO_1_0_computed_,TU_1_0_computed_,TO_1_0_disc,TU_1_0_disc,TO_1_25,TU_1_25,TO_1_25_computed_,TU_1_25_computed_,TO_1_25_disc,TU_1_25_disc,TO_1_5,TU_1_5,TO_1_5_computed_,TU_1_5_computed_,TO_1_5_disc,TU_1_5_disc,TO_1_75,TU_1_75,TO_1_75_computed_,TU_1_75_computed_,TO_1_75_disc,TU_1_75_disc,TO_2_0,TU_2_0,TO_2_0_computed_,TU_2_0_computed_,TO_2_0_disc,TU_2_0_disc,TO_2_25,TU_2_25,TO_2_25_computed_,TU_2_25_computed_,TO_2_25_disc,TU_2_25_disc,TO_2_5,TU_2_5,TO_2_5_computed_,TU_2_5_computed_,TO_2_5_disc,TU_2_5_disc,TO_2_75,TU_2_75,TO_2_75_computed_,TU_2_75_computed_,TO_2_75_disc,TU_2_75_disc,TO_3_0,TU_3_0,TO_3_0_computed_,TU_3_0_computed_,TO_3_0_disc,TU_3_0_disc,TO_3_25,TU_3_25,TO_3_25_computed_,TU_3_25_computed_,TO_3_25_disc,TU_3_25_disc,TO_3_5,TU_3_5,TO_3_5_computed_,TU_3_5_computed_,TO_3_5_disc,TU_3_5_disc,TO_3_75,TU_3_75,TO_3_75_computed_,TU_3_75_computed_,TO_3_75_disc,TU_3_75_disc,TO_4_0,TU_4_0,TO_4_0_computed_,TU_4_0_computed_,TO_4_0_disc,TU_4_0_disc,TO_4_25,TU_4_25,TO_4_45_computed_,TU_4_25_computed_,TO_4_45_disc,TU_4_25_disc,TO_4_5,TU_4_5,TO_4_5_computed_,TU_4_5_computed_,TO_4_5_disc,TU_4_5_disc,TO_4_75,TU_4_75,TO_4_75_computed_,TU_4_75_computed_,TO_4_75_disc,TU_4_75_disc,TO_5_0,TU_5_0,TO_5_0_computed_,TU_5_0_computed_,TO_5_0_disc,TU_5_0_disc,TO_5_25,TU_5_25,TO_5_25_computed_,TU_5_25_computed_,TO_5_25_disc,TU_5_25_disc,TO_5_5,TU_5_5,TO_5_5_computed_,TU_5_5_computed_,TO_5_5_disc,TU_5_5_disc,TO_5_75,TU_5_75,TO_5_75_computed_,TU_5_75_computed_,TO_5_75_disc,TU_5_75_disc,TO_6_0,TU_6_0,TO_6_0_computed_,TU_6_0_computed_,TO_6_0_disc,TU_6_0_disc,TO_6_25,TU_6_25,TO_6_25_computed_,TU_6_25_computed_,TO_6_25_disc,TU_6_25_disc,TO_6_5,TU_6_5,TO_6_5_computed_,TU_6_5_computed_,TO_6_5_disc,TU_6_5_disc,T1O_0_5,T1U_0_5,T1O_0_5_computed_,T1U_0_5_computed_,T1O_0_5_disc,T1U_0_5_disc,T1O_0_75,T1U_0_75,T1O_0_75_computed_,T1U_0_75_computed_,T1O_0_75_disc,T1U_0_75_disc,T1O_1_0,T1U_1_0,T1O_1_0_computed_,T1U_1_0_computed_,T1O_1_0_disc,T1U_1_0_disc,T1O_1_25,T1U_1_25,T1O_1_25_computed_,T1U_1_25_computed_,T1O_1_25_disc,T1U_1_25_disc,T1O_1_5,T1U_1_5,T1O_1_5_computed_,T1U_1_5_computed_,T1O_1_5_disc,T1U_1_5_disc,T1O_1_75,T1U_1_75,T1O_1_75_computed_,T1U_1_75_computed_,T1O_1_75_disc,T1U_1_75_disc,T1O_2_0,T1U_2_0,T1O_2_0_computed_,T1U_2_0_computed_,T1O_2_0_disc,T1U_2_0_disc,T1O_2_25,T1U_2_25,T1O_2_25_computed_,T1U_2_25_computed_,T1O_2_25_disc,T1U_2_25_disc,T1O_2_5,T1U_2_5,T1O_2_5_computed_,T1U_2_5_computed_,T1O_2_5_disc,T1U_2_5_disc,T1O_2_75,T1U_2_75,T1O_2_75_computed_,T1U_2_75_computed_,T1O_2_75_disc,T1U_2_75_disc,T1O_3_0,T1U_3_0,T1O_3_0_computed_,T1U_3_0_computed_,T1O_3_0_disc,T1U_3_0_disc,T1O_3_25,T1U_3_25,T1O_3_25_computed_,T1U_3_25_computed_,T1O_3_25_disc,T1U_3_25_disc,T1O_3_5,T1U_3_5,T1O_3_5_computed_,T1U_3_5_computed_,T1O_3_5_disc,T1U_3_5_disc,T1O_3_75,T1U_3_75,T1O_3_75_computed_,T1U_3_75_computed_,T1O_3_75_disc,T1U_3_75_disc,T1O_4_0,T1U_4_0,T1O_4_0_computed_,T1U_4_0_computed_,T1O_4_0_disc,T1U_4_0_disc,T1O_4_25,T1U_4_25,T1O_4_25_computed_,T1U_4_25_computed_,T1O_4_25_disc,T1U_4_25_disc,T1O_4_5,T1U_4_5,T1O_4_5_computed_,T1U_4_5_computed_,T1O_4_5_disc,T1U_4_5_disc,T2O_0_5,T2U_0_5,T2O_0_5_computed_,T2U_0_5_computed_,T2O_0_5_disc,T2U_0_5_disc,T2O_0_75,T2U_0_75,T2O_0_75_computed_,T2U_0_75_computed_,T2O_0_75_disc,T2U_0_75_disc,T2O_1_0,T2U_1_0,T2O_1_0_computed_,T2U_1_0_computed_,T2O_1_0_disc,T2U_1_0_disc,T2O_1_25,T2U_1_25,T2O_1_25_computed_,T2U_1_25_computed_,T2O_1_25_disc,T2U_1_25_disc,T2O_1_5,T2U_1_5,T2O_1_5_computed_,T2U_1_5_computed_,T2O_1_5_disc,T2U_1_5_disc,T2O_1_75,T2U_1_75,T2O_1_75_computed_,T2U_1_75_computed_,T2O_1_75_disc,T2U_1_75_disc,T2O_2_0,T2U_2_0,T2O_2_0_computed_,T2U_2_0_computed_,T2O_2_0_disc,T2U_2_0_disc,T2O_2_25,T2U_2_25,T2O_2_25_computed_,T2U_2_25_computed_,T2O_2_25_disc,T2U_2_25_disc,T2O_2_5,T2U_2_5,T2O_2_5_computed_,T2U_2_5_computed_,T2O_2_5_disc,T2U_2_5_disc,T2O_2_75,T2U_2_75,T2O_2_75_computed_,T2U_2_75_computed_,T2O_2_75_disc,T2U_2_75_disc,T2O_3_0,T2U_3_0,T2O_3_0_computed_,T2U_3_0_computed_,T2O_3_0_disc,T2U_3_0_disc,T2O_3_25,T2U_3_25,T2O_3_25_computed_,T2U_3_25_computed_,T2O_3_25_disc,T2U_3_25_disc,T2O_3_5,T2U_3_5,T2O_3_5_computed_,T2U_3_5_computed_,T2O_3_5_disc,T2U_3_5_disc,T2O_3_75,T2U_3_75,T2O_3_75_computed_,T2U_3_75_computed_,T2O_3_75_disc,T2U_3_75_disc,T2O_4_0,T2U_4_0,T2O_4_0_computed_,T2U_4_0_computed_,T2O_4_0_disc,T2U_4_0_disc,T2O_4_25,T2U_4_25,T2O_4_25_computed_,T2U_4_25_computed_,T2O_4_25_disc,T2U_4_25_disc,T2O_4_5,T2U_4_5,T2O_4_5_computed_,T2U_4_5_computed_,T2O_4_5_disc,T2U_4_5_disc,HOME_HDP_3_5,AWAY_HDP__3_5,HOME_HDP_3_5_computed,AWAY_HDP__3_5_computed,HOME_HDP_3_5_disc,AWAY_HDP__3_5_disc,HOME_HDP_3_0,AWAY_HDP__3_0,HOME_HDP_3_0_computed,AWAY_HDP__3_0_computed,HOME_HDP_3_0_disc,AWAY_HDP__3_0_disc,HOME_HDP_2_75,AWAY_HDP__2_75,HOME_HDP_2_75_computed,AWAY_HDP__2_75_computed,HOME_HDP_2_75_disc,AWAY_HDP__2_75_disc,HOME_HDP_2_5,AWAY_HDP__2_5,HOME_HDP_2_5_computed,AWAY_HDP__2_5_computed,HOME_HDP_2_5_disc,AWAY_HDP__2_5_disc,HOME_HDP_2_0,AWAY_HDP__2_0,HOME_HDP_2_0_computed,AWAY_HDP__2_0_computed,HOME_HDP_2_0_disc,AWAY_HDP__2_0_disc,HOME_HDP_1_75,AWAY_HDP__1_75,HOME_HDP_1_75_computed,AWAY_HDP__1_75_computed,HOME_HDP_1_75_disc,AWAY_HDP__1_75_disc,HOME_HDP_1_5,AWAY_HDP__1_5,HOME_HDP_1_5_computed,AWAY_HDP__1_5_computed,HOME_HDP_1_5_disc,AWAY_HDP__1_5_disc,HOME_HDP_1_0,AWAY_HDP__1_0,HOME_HDP_1_0_computed,AWAY_HDP__1_0_computed,HOME_HDP_1_0_disc,AWAY_HDP__1_0_disc,HOME_HDP_0_75,AWAY_HDP__0_75,HOME_HDP_0_75_computed,AWAY_HDP__0_75_computed,HOME_HDP_0_75_disc,AWAY_HDP__0_75_disc,HOME_HDP_0_5,AWAY_HDP__0_5,HOME_HDP_0_5_computed,AWAY_HDP__0_5_computed,HOME_HDP_0_5_disc,AWAY_HDP__0_5_disc,HOME_HDP_0_25,AWAY_HDP__0_25,HOME_HDP_0_25_computed,AWAY_HDP__0_25_computed,HOME_HDP_0_25_disc,AWAY_HDP__0_25_disc,HOME_HDP_0_0,AWAY_HDP_0_0,HOME_HDP_0_0_computed,AWAY_HDP_0_0_computed,HOME_HDP_0_0_disc,AWAY_HDP_0_0_disc,HOME_HDP__0_25,AWAY_HDP_0_25,HOME_HDP__0_25_computed,AWAY_HDP_0_25_computed,HOME_HDP__0_25_disc,AWAY_HDP_0_25_disc,HOME_HDP__0_5,AWAY_HDP_0_5,HOME_HDP__0_5_computed,AWAY_HDP_0_5_computed,HOME_HDP__0_5_disc,AWAY_HDP_0_5_disc,HOME_HDP__0_75,AWAY_HDP_0_75,HOME_HDP__0_75_computed,AWAY_HDP_0_75_computed,HOME_HDP__0_75_disc,AWAY_HDP_0_75_disc,HOME_HDP__1_0,AWAY_HDP_1_0,HOME_HDP__1_0_computed,AWAY_HDP_1_0_computed,HOME_HDP__1_0_disc,AWAY_HDP_1_0_disc,HOME_HDP__1_25,AWAY_HDP_1_25,HOME_HDP__1_25_computed,AWAY_HDP_1_25_computed,HOME_HDP__1_25_disc,AWAY_HDP_1_25_disc,HOME_HDP__1_5,AWAY_HDP_1_5,HOME_HDP__1_5_computed,AWAY_HDP_1_5_computed,HOME_HDP__1_5_disc,AWAY_HDP_1_5_disc,HOME_HDP__2_0,AWAY_HDP_2_0,HOME_HDP__2_0_computed,AWAY_HDP_2_0_computed,HOME_HDP__2_0_disc,AWAY_HDP_2_0_disc,HOME_HDP__2_25,AWAY_HDP_2_25,HOME_HDP__2_25_computed,AWAY_HDP_2_25_computed,HOME_HDP__2_25_disc,AWAY_HDP_2_25_disc,HOME_HDP__2_5,AWAY_HDP_2_5,HOME_HDP__2_5_computed,AWAY_HDP_2_5_computed,HOME_HDP__2_5_disc,AWAY_HDP_2_5_disc,HOME_HDP__2_75,AWAY_HDP_2_75,HOME_HDP__2_75_computed,AWAY_HDP_2_75_computed,HOME_HDP__2_75_disc,AWAY_HDP_2_75_disc,HOME_HDP__3_0,AWAY_HDP_3_0,HOME_HDP__3_0_computed,AWAY_HDP_3_0_computed,HOME_HDP__3_0_disc,AWAY_HDP_3_0_disc,HOME_HDP__3_25,AWAY_HDP_3_25,HOME_HDP__3_25_computed,AWAY_HDP_3_25_computed,HOME_HDP__3_25_disc,AWAY_HDP_3_25_disc,HOME_HDP__3_5,AWAY_HDP_3_5,HOME_HDP__3_5_computed,AWAY_HDP_3_5_computed,HOME_HDP__3_5_disc,AWAY_HDP_3_5_disc")] PinacclePrices pinacclePrices)
{
if (id != pinacclePrices.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(pinacclePrices);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PinacclePricesExists(pinacclePrices.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(pinacclePrices));
}
public static DataTable ConvertPinacclePricesTodataTable(List <PinacclePrices> prices)
{
DataTable table = new DataTable();
PinacclePrices p = (PinacclePrices)prices[0];
PropertyInfo[] mas = p.GetType().GetProperties();
foreach (PropertyInfo property in mas)
{
if (property.Name.Contains("__") == true)
{
table.Columns.Add(property.Name.Replace("__", "-"));
continue;
}
table.Columns.Add(property.Name);
}
foreach (PinacclePrices price in prices)
{
PropertyInfo[] mas2 = price.GetType().GetProperties();
DataRow dataRow = table.NewRow();
for (int i = 0; i < mas2.Length; i++)
{
dataRow[i] = mas2[i].GetValue(price);
}
table.Rows.Add(dataRow);
}
return(table);
}
public async Task <IActionResult> Create([Bind("Id,EventId,DateAdded,IsLive,StartTime,HomeTeam,AwayTeam,HOME,DRAW,AWAY,HOME_computed_,DRAW_computed_,AWAY_computed_,HOME_disc,DRAW_disc,AWAY_disc,HOMEAWAY,HOMEDRAW,DRAWAWAY,HOMEAWAY_computed_,HOMEDRAW_computed_,DRAWAWAY_computed_,HOMEAWAY_disc,HOMEDRAW_disc,DRAWAWAY_disc,TO_0_5,TU_0_5,TO_0_5_computed_,TU_0_5_computed_,TO_0_5_disc,TU_0_5_disc,TO_0_75,TU_0_75,TO_0_75_computed_,TU_0_75_computed_,TO_0_75_disc,TU_0_75_disc,TO_1_0,TU_1_0,TO_1_0_computed_,TU_1_0_computed_,TO_1_0_disc,TU_1_0_disc,TO_1_25,TU_1_25,TO_1_25_computed_,TU_1_25_computed_,TO_1_25_disc,TU_1_25_disc,TO_1_5,TU_1_5,TO_1_5_computed_,TU_1_5_computed_,TO_1_5_disc,TU_1_5_disc,TO_1_75,TU_1_75,TO_1_75_computed_,TU_1_75_computed_,TO_1_75_disc,TU_1_75_disc,TO_2_0,TU_2_0,TO_2_0_computed_,TU_2_0_computed_,TO_2_0_disc,TU_2_0_disc,TO_2_25,TU_2_25,TO_2_25_computed_,TU_2_25_computed_,TO_2_25_disc,TU_2_25_disc,TO_2_5,TU_2_5,TO_2_5_computed_,TU_2_5_computed_,TO_2_5_disc,TU_2_5_disc,TO_2_75,TU_2_75,TO_2_75_computed_,TU_2_75_computed_,TO_2_75_disc,TU_2_75_disc,TO_3_0,TU_3_0,TO_3_0_computed_,TU_3_0_computed_,TO_3_0_disc,TU_3_0_disc,TO_3_25,TU_3_25,TO_3_25_computed_,TU_3_25_computed_,TO_3_25_disc,TU_3_25_disc,TO_3_5,TU_3_5,TO_3_5_computed_,TU_3_5_computed_,TO_3_5_disc,TU_3_5_disc,TO_3_75,TU_3_75,TO_3_75_computed_,TU_3_75_computed_,TO_3_75_disc,TU_3_75_disc,TO_4_0,TU_4_0,TO_4_0_computed_,TU_4_0_computed_,TO_4_0_disc,TU_4_0_disc,TO_4_25,TU_4_25,TO_4_45_computed_,TU_4_25_computed_,TO_4_45_disc,TU_4_25_disc,TO_4_5,TU_4_5,TO_4_5_computed_,TU_4_5_computed_,TO_4_5_disc,TU_4_5_disc,TO_4_75,TU_4_75,TO_4_75_computed_,TU_4_75_computed_,TO_4_75_disc,TU_4_75_disc,TO_5_0,TU_5_0,TO_5_0_computed_,TU_5_0_computed_,TO_5_0_disc,TU_5_0_disc,TO_5_25,TU_5_25,TO_5_25_computed_,TU_5_25_computed_,TO_5_25_disc,TU_5_25_disc,TO_5_5,TU_5_5,TO_5_5_computed_,TU_5_5_computed_,TO_5_5_disc,TU_5_5_disc,TO_5_75,TU_5_75,TO_5_75_computed_,TU_5_75_computed_,TO_5_75_disc,TU_5_75_disc,TO_6_0,TU_6_0,TO_6_0_computed_,TU_6_0_computed_,TO_6_0_disc,TU_6_0_disc,TO_6_25,TU_6_25,TO_6_25_computed_,TU_6_25_computed_,TO_6_25_disc,TU_6_25_disc,TO_6_5,TU_6_5,TO_6_5_computed_,TU_6_5_computed_,TO_6_5_disc,TU_6_5_disc,T1O_0_5,T1U_0_5,T1O_0_5_computed_,T1U_0_5_computed_,T1O_0_5_disc,T1U_0_5_disc,T1O_0_75,T1U_0_75,T1O_0_75_computed_,T1U_0_75_computed_,T1O_0_75_disc,T1U_0_75_disc,T1O_1_0,T1U_1_0,T1O_1_0_computed_,T1U_1_0_computed_,T1O_1_0_disc,T1U_1_0_disc,T1O_1_25,T1U_1_25,T1O_1_25_computed_,T1U_1_25_computed_,T1O_1_25_disc,T1U_1_25_disc,T1O_1_5,T1U_1_5,T1O_1_5_computed_,T1U_1_5_computed_,T1O_1_5_disc,T1U_1_5_disc,T1O_1_75,T1U_1_75,T1O_1_75_computed_,T1U_1_75_computed_,T1O_1_75_disc,T1U_1_75_disc,T1O_2_0,T1U_2_0,T1O_2_0_computed_,T1U_2_0_computed_,T1O_2_0_disc,T1U_2_0_disc,T1O_2_25,T1U_2_25,T1O_2_25_computed_,T1U_2_25_computed_,T1O_2_25_disc,T1U_2_25_disc,T1O_2_5,T1U_2_5,T1O_2_5_computed_,T1U_2_5_computed_,T1O_2_5_disc,T1U_2_5_disc,T1O_2_75,T1U_2_75,T1O_2_75_computed_,T1U_2_75_computed_,T1O_2_75_disc,T1U_2_75_disc,T1O_3_0,T1U_3_0,T1O_3_0_computed_,T1U_3_0_computed_,T1O_3_0_disc,T1U_3_0_disc,T1O_3_25,T1U_3_25,T1O_3_25_computed_,T1U_3_25_computed_,T1O_3_25_disc,T1U_3_25_disc,T1O_3_5,T1U_3_5,T1O_3_5_computed_,T1U_3_5_computed_,T1O_3_5_disc,T1U_3_5_disc,T1O_3_75,T1U_3_75,T1O_3_75_computed_,T1U_3_75_computed_,T1O_3_75_disc,T1U_3_75_disc,T1O_4_0,T1U_4_0,T1O_4_0_computed_,T1U_4_0_computed_,T1O_4_0_disc,T1U_4_0_disc,T1O_4_25,T1U_4_25,T1O_4_25_computed_,T1U_4_25_computed_,T1O_4_25_disc,T1U_4_25_disc,T1O_4_5,T1U_4_5,T1O_4_5_computed_,T1U_4_5_computed_,T1O_4_5_disc,T1U_4_5_disc,T2O_0_5,T2U_0_5,T2O_0_5_computed_,T2U_0_5_computed_,T2O_0_5_disc,T2U_0_5_disc,T2O_0_75,T2U_0_75,T2O_0_75_computed_,T2U_0_75_computed_,T2O_0_75_disc,T2U_0_75_disc,T2O_1_0,T2U_1_0,T2O_1_0_computed_,T2U_1_0_computed_,T2O_1_0_disc,T2U_1_0_disc,T2O_1_25,T2U_1_25,T2O_1_25_computed_,T2U_1_25_computed_,T2O_1_25_disc,T2U_1_25_disc,T2O_1_5,T2U_1_5,T2O_1_5_computed_,T2U_1_5_computed_,T2O_1_5_disc,T2U_1_5_disc,T2O_1_75,T2U_1_75,T2O_1_75_computed_,T2U_1_75_computed_,T2O_1_75_disc,T2U_1_75_disc,T2O_2_0,T2U_2_0,T2O_2_0_computed_,T2U_2_0_computed_,T2O_2_0_disc,T2U_2_0_disc,T2O_2_25,T2U_2_25,T2O_2_25_computed_,T2U_2_25_computed_,T2O_2_25_disc,T2U_2_25_disc,T2O_2_5,T2U_2_5,T2O_2_5_computed_,T2U_2_5_computed_,T2O_2_5_disc,T2U_2_5_disc,T2O_2_75,T2U_2_75,T2O_2_75_computed_,T2U_2_75_computed_,T2O_2_75_disc,T2U_2_75_disc,T2O_3_0,T2U_3_0,T2O_3_0_computed_,T2U_3_0_computed_,T2O_3_0_disc,T2U_3_0_disc,T2O_3_25,T2U_3_25,T2O_3_25_computed_,T2U_3_25_computed_,T2O_3_25_disc,T2U_3_25_disc,T2O_3_5,T2U_3_5,T2O_3_5_computed_,T2U_3_5_computed_,T2O_3_5_disc,T2U_3_5_disc,T2O_3_75,T2U_3_75,T2O_3_75_computed_,T2U_3_75_computed_,T2O_3_75_disc,T2U_3_75_disc,T2O_4_0,T2U_4_0,T2O_4_0_computed_,T2U_4_0_computed_,T2O_4_0_disc,T2U_4_0_disc,T2O_4_25,T2U_4_25,T2O_4_25_computed_,T2U_4_25_computed_,T2O_4_25_disc,T2U_4_25_disc,T2O_4_5,T2U_4_5,T2O_4_5_computed_,T2U_4_5_computed_,T2O_4_5_disc,T2U_4_5_disc,HOME_HDP_3_5,AWAY_HDP__3_5,HOME_HDP_3_5_computed,AWAY_HDP__3_5_computed,HOME_HDP_3_5_disc,AWAY_HDP__3_5_disc,HOME_HDP_3_0,AWAY_HDP__3_0,HOME_HDP_3_0_computed,AWAY_HDP__3_0_computed,HOME_HDP_3_0_disc,AWAY_HDP__3_0_disc,HOME_HDP_2_75,AWAY_HDP__2_75,HOME_HDP_2_75_computed,AWAY_HDP__2_75_computed,HOME_HDP_2_75_disc,AWAY_HDP__2_75_disc,HOME_HDP_2_5,AWAY_HDP__2_5,HOME_HDP_2_5_computed,AWAY_HDP__2_5_computed,HOME_HDP_2_5_disc,AWAY_HDP__2_5_disc,HOME_HDP_2_0,AWAY_HDP__2_0,HOME_HDP_2_0_computed,AWAY_HDP__2_0_computed,HOME_HDP_2_0_disc,AWAY_HDP__2_0_disc,HOME_HDP_1_75,AWAY_HDP__1_75,HOME_HDP_1_75_computed,AWAY_HDP__1_75_computed,HOME_HDP_1_75_disc,AWAY_HDP__1_75_disc,HOME_HDP_1_5,AWAY_HDP__1_5,HOME_HDP_1_5_computed,AWAY_HDP__1_5_computed,HOME_HDP_1_5_disc,AWAY_HDP__1_5_disc,HOME_HDP_1_0,AWAY_HDP__1_0,HOME_HDP_1_0_computed,AWAY_HDP__1_0_computed,HOME_HDP_1_0_disc,AWAY_HDP__1_0_disc,HOME_HDP_0_75,AWAY_HDP__0_75,HOME_HDP_0_75_computed,AWAY_HDP__0_75_computed,HOME_HDP_0_75_disc,AWAY_HDP__0_75_disc,HOME_HDP_0_5,AWAY_HDP__0_5,HOME_HDP_0_5_computed,AWAY_HDP__0_5_computed,HOME_HDP_0_5_disc,AWAY_HDP__0_5_disc,HOME_HDP_0_25,AWAY_HDP__0_25,HOME_HDP_0_25_computed,AWAY_HDP__0_25_computed,HOME_HDP_0_25_disc,AWAY_HDP__0_25_disc,HOME_HDP_0_0,AWAY_HDP_0_0,HOME_HDP_0_0_computed,AWAY_HDP_0_0_computed,HOME_HDP_0_0_disc,AWAY_HDP_0_0_disc,HOME_HDP__0_25,AWAY_HDP_0_25,HOME_HDP__0_25_computed,AWAY_HDP_0_25_computed,HOME_HDP__0_25_disc,AWAY_HDP_0_25_disc,HOME_HDP__0_5,AWAY_HDP_0_5,HOME_HDP__0_5_computed,AWAY_HDP_0_5_computed,HOME_HDP__0_5_disc,AWAY_HDP_0_5_disc,HOME_HDP__0_75,AWAY_HDP_0_75,HOME_HDP__0_75_computed,AWAY_HDP_0_75_computed,HOME_HDP__0_75_disc,AWAY_HDP_0_75_disc,HOME_HDP__1_0,AWAY_HDP_1_0,HOME_HDP__1_0_computed,AWAY_HDP_1_0_computed,HOME_HDP__1_0_disc,AWAY_HDP_1_0_disc,HOME_HDP__1_25,AWAY_HDP_1_25,HOME_HDP__1_25_computed,AWAY_HDP_1_25_computed,HOME_HDP__1_25_disc,AWAY_HDP_1_25_disc,HOME_HDP__1_5,AWAY_HDP_1_5,HOME_HDP__1_5_computed,AWAY_HDP_1_5_computed,HOME_HDP__1_5_disc,AWAY_HDP_1_5_disc,HOME_HDP__2_0,AWAY_HDP_2_0,HOME_HDP__2_0_computed,AWAY_HDP_2_0_computed,HOME_HDP__2_0_disc,AWAY_HDP_2_0_disc,HOME_HDP__2_25,AWAY_HDP_2_25,HOME_HDP__2_25_computed,AWAY_HDP_2_25_computed,HOME_HDP__2_25_disc,AWAY_HDP_2_25_disc,HOME_HDP__2_5,AWAY_HDP_2_5,HOME_HDP__2_5_computed,AWAY_HDP_2_5_computed,HOME_HDP__2_5_disc,AWAY_HDP_2_5_disc,HOME_HDP__2_75,AWAY_HDP_2_75,HOME_HDP__2_75_computed,AWAY_HDP_2_75_computed,HOME_HDP__2_75_disc,AWAY_HDP_2_75_disc,HOME_HDP__3_0,AWAY_HDP_3_0,HOME_HDP__3_0_computed,AWAY_HDP_3_0_computed,HOME_HDP__3_0_disc,AWAY_HDP_3_0_disc,HOME_HDP__3_25,AWAY_HDP_3_25,HOME_HDP__3_25_computed,AWAY_HDP_3_25_computed,HOME_HDP__3_25_disc,AWAY_HDP_3_25_disc,HOME_HDP__3_5,AWAY_HDP_3_5,HOME_HDP__3_5_computed,AWAY_HDP_3_5_computed,HOME_HDP__3_5_disc,AWAY_HDP_3_5_disc")] PinacclePrices pinacclePrices)
{
if (ModelState.IsValid)
{
_context.Add(pinacclePrices);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(pinacclePrices));
}
public void Add(PinacclePrices pinacclePrices)
{
throw new NotImplementedException();
}
public PinacclePrices ConvertPinnacleEventToDatabasePrices(OddEvent oddEvent)
{
eventDiscs.Clear();
this.pinaccle = new PinacclePrices();
this.pinaccle.IsLive = oddEvent.IsLive;
this.pinaccle.DateAdded = oddEvent.DateAdded;
this.pinaccle.EventId = oddEvent.EventId.ToString();
this.properties = this.pinaccle.GetType().GetProperties();
this.pinaccle.HomeTeam = oddEvent.HomeTeam;
this.pinaccle.AwayTeam = oddEvent.AwayTeam;
this.pinaccle.StartTime = oddEvent.StartTime;
OddPeriod oddPeriod = oddEvent.Periods[0];
MoneyLine moneyLine = oddPeriod.MoneyLine;
List <Handicap> handicaps = oddPeriod.Handicaps;
List <Total> totals = oddPeriod.Totals;
DoubleChance doubleChance = oddPeriod.DoubleChance;
if (oddPeriod.TeamTotal != null)
{
Total homeTotal = oddPeriod.TeamTotal.Home;
Total awayTeamTotal = oddPeriod.TeamTotal.Away;
if (homeTotal != null)
{
this.SetHomeTeamTotalPricesTodatabase(homeTotal);
}
if (awayTeamTotal != null)
{
this.SetAwayTeamTotalPricesToDatabase(awayTeamTotal);
}
}
this.SetMoneyLinePricesToDatabase(moneyLine);
//this.SetDoubleChanceToDatabasePrices(doubleChance);
this.SetTotalPricesToDatabase(totals);
//this.SetHomeTeamTotalPricesTodatabase(homeTotal);
//this.SetAwayTeamTotalPricesToDatabase(awayTeamTotal);
this.SetHandicapPricesToDatabase(handicaps);
//var result = MathClass.GetStatsForMarket(this.eventDiscs);
//this.pinaccle.EventDiscMax = result.maxDisc;
//this.pinaccle.EventDiscAverage = result.averageDisc;
//this.pinaccle.EventMediana = MathClass.GetMedForMarket(this.eventDiscs);
return(this.pinaccle);
}
