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); }