private static string getValuesForInsert(DataToQueryInsert queryData)
{
string values = null;
try
{
foreach (FieldAndValue field in queryData.fields)
{
if (String.IsNullOrEmpty(values))
{
values = "'" + field.value + "'";
}
else
{
values = values + ", '" + field.value + "'";
}
}
}
catch
{
values = "";
}
return(values);
}
private static string getFieldsForInsert(DataToQueryInsert queryData)
{
string fields = null;
try
{
foreach (FieldAndValue field in queryData.fields)
{
if (String.IsNullOrEmpty(fields))
{
fields = field.filedName;
}
else
{
fields = fields + ", " + field.filedName;
}
}
}
catch
{
fields = "";
}
return(fields);
}
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 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 bool dataBaseInsert(DataToQueryInsert queryData)
{
bool insertResult;
int rowsAffected = 0;
DataTable table = new DataTable();
string fields = getFieldsForInsert(queryData);
string values = getValuesForInsert(queryData);
string query = "Insert Into " + queryData.tableName + "(" + fields + ") values (" + values + ");";
try
{
if (connected == true)
{
NpgsqlCommand command = new NpgsqlCommand(query, dataBaseConnection);
rowsAffected = command.ExecuteNonQuery();
if (rowsAffected > 0)
{
insertResult = true;
}
else
{
insertResult = false;
}
}
else
{
insertResult = false;
}
}
catch (Exception)
{
insertResult = false;
}
return(insertResult);
}
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);
}
