public static bool openRouletteBet(int roullete_id)
{
DataToQueryInsert queryData = new DataToQueryInsert();
bool hasBetsOpen = rouletteHasBetsOpen(roullete_id);
bool created = false;
try
{
if (hasBetsOpen == false)
{
queryData.tableName = "roulette_bets";
FieldAndValue field = new FieldAndValue();
List <FieldAndValue> fieldsToInsert = new List <FieldAndValue>();
field.filedName = "roullete_id";
field.value = roullete_id.ToString();
fieldsToInsert.Add(field);
field.filedName = "state_id";
field.value = State.getID("open");
fieldsToInsert.Add(field);
queryData.fields = fieldsToInsert;
dataBaseConnect();
created = dataBaseInsert(queryData);
dataBaseDesconnect();
}
}
catch
{
created = false;
}
return(created);
}
public bool Open()
{
DataToQueryUpdate queryData = new DataToQueryUpdate();
bool updated = false;
try
{
queryData.tableName = "roulettes";
FieldAndValue field = new FieldAndValue();
List <FieldAndValue> fieldsToInsert = new List <FieldAndValue>();
field.filedName = "state_id";
field.value = State.getID("open");
fieldsToInsert.Add(field);
field.filedName = "last_number";
field.value = last_number.ToString();
fieldsToInsert.Add(field);
queryData.fields = fieldsToInsert;
queryData.id = id;
dataBaseConnect();
updated = dataBaseUpdate(queryData);
dataBaseDesconnect();
if (updated)
{
state = "open";
}
}
catch
{
updated = false;
}
return(updated);
}
public static bool addBetByNumber(Bet bet)
{
DataToQueryInsert queryData = new DataToQueryInsert();
int roulette_bets_id = getRouletteBetID(bet.roullete_id);
bool created = false;
try
{
queryData.tableName = "bet_by_number";
FieldAndValue field = new FieldAndValue();
List <FieldAndValue> fieldsToInsert = new List <FieldAndValue>();
field.filedName = "roulette_bets_id";
field.value = roulette_bets_id.ToString();
fieldsToInsert.Add(field);
field.filedName = "user_id";
field.value = bet.user_id.ToString();
fieldsToInsert.Add(field);
field.filedName = "number";
field.value = bet.betValue.ToString();
fieldsToInsert.Add(field);
field.filedName = "amount";
field.value = bet.amountToBet.ToString();
fieldsToInsert.Add(field);
queryData.fields = fieldsToInsert;
dataBaseConnect();
created = dataBaseInsert(queryData);
dataBaseDesconnect();
}
catch
{
created = false;
}
return(created);
}
public static int closeRouletteBet(int roullete_id)
{
DataToQueryUpdate queryData = new DataToQueryUpdate();
bool hasBetsOpen = rouletteHasBetsOpen(roullete_id);
bool created = false;
int openRouletteID = 0;
try
{
if (hasBetsOpen)
{
queryData.tableName = "roulette_bets";
FieldAndValue field = new FieldAndValue();
List <FieldAndValue> fieldsToInsert = new List <FieldAndValue>();
field.filedName = "roullete_id";
field.value = roullete_id.ToString();
fieldsToInsert.Add(field);
field.filedName = "state_id";
field.value = State.getID("close");
fieldsToInsert.Add(field);
field.filedName = "winner_number";
field.value = generateWinninNumber(roullete_id).ToString();
fieldsToInsert.Add(field);
queryData.fields = fieldsToInsert;
openRouletteID = getRouletteBetID(roullete_id);
queryData.id = getRouletteBetID(roullete_id);;
dataBaseConnect();
created = dataBaseUpdate(queryData);
dataBaseDesconnect();
}
}
catch
{
created = false;
}
return(openRouletteID);
}
public bool create()
{
DataToQueryInsert queryData = new DataToQueryInsert();
var exists = rouletteExists();
bool created = false;
try
{
if (exists == false && errorInConsult == false)
{
queryData.tableName = "roulettes";
FieldAndValue field = new FieldAndValue();
List <FieldAndValue> fieldsToInsert = new List <FieldAndValue>();
field.filedName = "last_number";
field.value = last_number.ToString();
fieldsToInsert.Add(field);
field.filedName = "state_id";
field.value = "2";
fieldsToInsert.Add(field);
queryData.fields = fieldsToInsert;
dataBaseConnect();
created = dataBaseInsert(queryData);
dataBaseDesconnect();
if (created)
{
id = getCreatedId();
}
}
}
catch
{
errorInConsult = true;
}
return(created);
}
