public static string getFieldsForUpdate(DataToQueryUpdate queryData)
{
string fields = null;
try
{
foreach (FieldAndValue field in queryData.fields)
{
if (String.IsNullOrEmpty(fields))
{
fields = field.filedName + " = '" + field.value + "'";
}
else
{
fields = fields + ", " + field.filedName + " = '" + field.value + "'";
}
}
}
catch
{
fields = "";
}
return(fields);
}
public static bool dataBaseUpdate(DataToQueryUpdate queryData)
{
bool updateResult;
int rowsAffected = 0;
DataTable table = new DataTable();
string fields = getFieldsForUpdate(queryData);
string query = "Update " + queryData.tableName + " set " + fields + " Where id = " + queryData.id + " ;";
try
{
if (connected == true)
{
NpgsqlCommand command = new NpgsqlCommand(query, dataBaseConnection);
rowsAffected = command.ExecuteNonQuery();
if (rowsAffected > 0)
{
updateResult = true;
}
else
{
updateResult = false;
}
}
else
{
updateResult = false;
}
}
catch (Exception)
{
updateResult = false;
}
return(updateResult);
}
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 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);
}
