C# (CSharp) ExecuteAutoSQL.SerieIDsToStr Examples

SerieIDsToStr() public method

public SerieIDsToStr ( List serieIDs ) : string
serieIDs	List
return	string

Example #1

File: executeAuto.cs Project: kleopatra999/chronojump

    /*
     * class methods
     */

    public static void Insert(bool dbconOpened, ExecuteAutoSQL eaSQL)
    {
        if (!dbconOpened)
        {
            Sqlite.Open();
        }

        dbcmd.CommandText = "INSERT INTO " + Constants.ExecuteAutoTable +
                            " (uniqueID, name, mode, description, " +
                            " serie1IDs, serie2IDs, serie3IDs, " +
                            " future1, future2, future3)" +
                            " VALUES ( NULL, \"" +
                            eaSQL.name + "\", \"" + eaSQL.Mode.ToString() + "\", \"" + eaSQL.Description + "\", \"" +
                            eaSQL.SerieIDsToStr(eaSQL.Serie1IDs) + "\", \"" +
                            eaSQL.SerieIDsToStr(eaSQL.Serie2IDs) + "\", \"" +
                            eaSQL.SerieIDsToStr(eaSQL.Serie3IDs) + "\", " +
                            "\"\", \"\", \"\")"; //future1, future2, future3
        LogB.SQL(dbcmd.CommandText.ToString());
        dbcmd.ExecuteNonQuery();

        if (!dbconOpened)
        {
            Sqlite.Close();
        }
    }

Example #2

File: executeAuto.cs Project: GNOME/chronojump

    /*
     * class methods
     */
    public static void Insert(bool dbconOpened, ExecuteAutoSQL eaSQL)
    {
        if(! dbconOpened)
            Sqlite.Open();

        dbcmd.CommandText = "INSERT INTO " + Constants.ExecuteAutoTable +
            " (uniqueID, name, mode, description, " +
            " serie1IDs, serie2IDs, serie3IDs, " +
            " future1, future2, future3)" +
            " VALUES ( NULL, \"" +
            eaSQL.name + "\", \"" + eaSQL.Mode.ToString() + "\", \"" + eaSQL.Description + "\", \"" +
            eaSQL.SerieIDsToStr(eaSQL.Serie1IDs) + "\", \"" +
            eaSQL.SerieIDsToStr(eaSQL.Serie2IDs) + "\", \"" +
            eaSQL.SerieIDsToStr(eaSQL.Serie3IDs) + "\", " +
            "\"\", \"\", \"\")"; //future1, future2, future3
        LogB.SQL(dbcmd.CommandText.ToString());
        dbcmd.ExecuteNonQuery();

        if(! dbconOpened)
            Sqlite.Close();
    }