private List <Entities.Bets> FilterBets(Entities.Roulettes roulette)
{
var apertura = DateTime.Parse(roulette.DateOpen, null, System.Globalization.DateTimeStyles.RoundtripKind);
var cierre = DateTime.Parse(roulette.DateClose, null, System.Globalization.DateTimeStyles.RoundtripKind);
List <Entities.Bets> bets = GetBets(roulette.Id);
List <Entities.Bets> filterBets = new List <Entities.Bets>();
foreach (var bet in bets)
{
var fecha = DateTime.Parse(bet.DateBet, null, System.Globalization.DateTimeStyles.RoundtripKind);
if (fecha >= apertura && fecha <= cierre)
{
filterBets.Add(bet);
}
}
return(filterBets);
}
public ActionResult <string> OpenRoulette(int id)
{
try
{
Entities.Roulettes roulette = roulettes.GetRoulette(id);
if (roulette.State == true)
{
return($"Ruleta {id} apertura DENY");
}
roulettes.OpenRoulette(id);
return($"Ruleta {id} apertura OK");
}
catch (Exception ex)
{
return(BadRequest(ex.Message.Contains("inner") ? ex.InnerException.Message : ex.Message));
}
}
public ActionResult <string> CloseRoulette(int id)
{
try
{
Entities.Roulettes roulette = roulettes.GetRoulette(id);
if (roulette.State == false)
{
return($"Ruleta {id} cierre DENY");
}
roulettes.CloseRoulette(id);
var bets = roulettes.BetsResults(id);
return($"Ruleta {id} cierre OK");
}
catch (Exception ex)
{
return(BadRequest(ex.Message.Contains("inner") ? ex.InnerException.Message : ex.Message));
}
}
public Entities.Roulettes GetRoulette(int id)
{
using (SqlConnection connection = new SqlConnection(configuration.GetConnectionString("ConnectionString")))
{
try
{
connection.Open();
var query = $"SELECT Id,State,DateOpen,DateClose FROM [BetPlay].[dbo].[Roulettes] WHERE Id = {id}";
SqlCommand command = new SqlCommand(query, connection);
command.ExecuteNonQuery();
SqlDataReader reader = command.ExecuteReader();
Entities.Roulettes response = ReadRows(reader).FirstOrDefault();
reader.Close();
connection.Close();
return(response);
}
catch (Exception ex)
{
throw ex;
}
}
}
public int CreateRoulette()
{
using (SqlConnection connection = new SqlConnection(configuration.GetConnectionString("ConnectionString")))
{
try
{
connection.Open();
var query = $"INSERT INTO [BetPlay].[dbo].[Roulettes]([State],DateOpen,DateClose) VALUES(0,'',''); " +
$"SELECT Id = CAST(SCOPE_IDENTITY() AS INT), [State] = CAST(0 AS bit), DateOpen = '', DateClose = ''";
SqlCommand command = new SqlCommand(query, connection);
command.ExecuteNonQuery();
SqlDataReader reader = command.ExecuteReader();
Entities.Roulettes response = ReadRows(reader).FirstOrDefault();
reader.Close();
connection.Close();
return(response.Id);
}
catch (Exception ex)
{
throw ex;
}
}
}
