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