示例#1
0
文件: Judge.cs 项目: slam900/WMTASite
    /*
     * Pre:
     * Post: The input preference is deleted front the judge's list of preferences
     * @param preferenceType is the type of the preference to delete
     * @param preference is the specific preference to delete
     * @returns true if the preference is successfully deleted and false otherwise
     */
    public bool deletePreference(Utility.JudgePreferences preferenceType, string preference)
    {
        bool            result;
        JudgePreference prefToDelete = new JudgePreference(-1, preferenceType, preference);

        result = DbInterfaceJudge.DeleteJudgePreference(id, preferenceType, preference);

        if (result)
        {
            preferences.Remove(prefToDelete);
        }

        return(result);
    }
示例#2
0
    /*
     * Pre:   The input contact id must exist in the database
     * Post:  The new preference is added to the database
     * @param contactId is the id of the contact that the new preference is to be associated with
     * @param prefType is the type of the preference
     * @param preferenceValue is the value of the preference
     */
    public static JudgePreference AddJudgePreference(int contactId, Utility.JudgePreferences prefType, string preferenceValue)
    {
        JudgePreference preference = null;
        DataTable       table      = new DataTable();
        SqlConnection   connection = new
                                     SqlConnection(ConfigurationManager.ConnectionStrings["WmtaConnectionString"].ConnectionString);

        try
        {
            connection.Open();
            string storedProc = "sp_JudgePreferenceNew";

            SqlCommand cmd = new SqlCommand(storedProc, connection);

            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.AddWithValue("@contactId", contactId);
            cmd.Parameters.AddWithValue("@prefTypeId", (int)prefType);
            cmd.Parameters.AddWithValue("@preference", preferenceValue);

            adapter.Fill(table);

            if (table.Rows.Count == 1)
            {
                int prefId = Convert.ToInt32(table.Rows[0]["PreferenceId"]);

                preference = new JudgePreference(prefId, prefType, preferenceValue);
            }
        }
        catch (Exception e)
        {
            Utility.LogError("DbInterfaceContact", "AddJudgePreference", "contactId: " + contactId + ", prefType: " +
                             prefType + ", preferenceValue: " + preferenceValue, "Message: " + e.Message +
                             "   StackTrace: " + e.StackTrace, -1);
        }

        connection.Close();


        return(preference);
    }
示例#3
0
文件: Judge.cs 项目: slam900/WMTASite
    /*
     * Pre:
     * Post:  The new preference is added to the judge's list of preferences
     *@param preferenceType is the type of the new preference
     *@param preference is the specific preference
     *@returns true if the preference was successfully added and false otherwise
     */
    public bool addPreference(Utility.JudgePreferences preferenceType, string preference)
    {
        bool            result  = true;
        JudgePreference newPref = DbInterfaceJudge.AddJudgePreference(id, preferenceType, preference);

        if (preferences == null)
        {
            preferences = new List <JudgePreference>();
        }

        if (newPref != null)
        {
            preferences.Add(newPref);
        }
        else
        {
            result = false;
        }

        return(result);
    }