Esempio n. 1
0
        /// <summary>
        /// Add courses to the criteria list via a csv list of course id's
        /// </summary>
        /// <param name="strClassifications">Csv list of classifications</param>
        public void AddClassifications(string strClassifications)
        {
            // Local variables
            string[] astrClassificationIDs  = strClassifications.Split(',');
            string   strClassificationNames = "";
            int      intClassificationType;
            string   strClassificationType;

            // Get Classification Type for the user's organisation
            BusinessServices.Classification objClassification = new BusinessServices.Classification();
            DataTable dtbClassificationType = objClassification.GetClassificationType(Utilities.UserContext.UserData.OrgID);

            intClassificationType = (int)dtbClassificationType.Rows[0]["ClassificationTypeID"];
            strClassificationType = dtbClassificationType.Rows[0]["Name"].ToString();


            // Get Classification List
            DataTable dtbClassification = objClassification.GetClassificationList(intClassificationType);

            // Loop through all Classifications
            foreach (DataRow drwClassification in dtbClassification.Rows)
            {
                // loop through all required Classifications
                for (int intClassification = 0; intClassification <= astrClassificationIDs.GetUpperBound(0); intClassification++)
                {
                    // if they match
                    if (astrClassificationIDs[intClassification] == drwClassification["ClassificationID"].ToString())
                    {
                        // Add it to the string.
                        strClassificationNames += drwClassification["Value"].ToString();
                        strClassificationNames += ", ";
                    }
                }
            }

            // Remove trailing command if it exists and replace with a full stop
            if (strClassificationNames.Length > 0)
            {
                strClassificationNames  = strClassificationNames.Substring(0, strClassificationNames.Length - 2);
                strClassificationNames += ".";
            }

            // add to the criteria list
            this.Criteria.Add(strClassificationType, strClassificationNames);
        }
Esempio n. 2
0
        /// <summary>
        ///
        /// </summary>
        private void DisplayClassifications()
        {
            try
            {
                // Get Classification Type for the dsiplayed user's organisation
                Classification objClassification     = new BusinessServices.Classification();
                DataTable      dtbClassificationType = objClassification.GetClassificationType(UserContext.UserData.OrgID);


                if (dtbClassificationType.Rows.Count > 0)
                {
                    this.lblCustomClassification.Text = dtbClassificationType.Rows[0]["Name"].ToString();

                    DataTable dtbClassificationList = objClassification.GetClassificationList((int)Convert.ToInt32(dtbClassificationType.Rows[0][CTypeColumnID].ToString()));
                    // Add blank row to the datatable
                    DataRow drwBlank;

                    drwBlank = dtbClassificationList.NewRow();

                    // Add a blank value
                    drwBlank[CListColumnClassificationID]     = 0;
                    drwBlank[CListColumnClassificationTypeID] = 0;
                    drwBlank[CListColumnValue]  = ResourceManager.GetString("lblAny");
                    drwBlank[CListColumnActive] = 1;

                    dtbClassificationList.Rows.InsertAt(drwBlank, 0);
                    this.cboCustomClassification.DataSource = dtbClassificationList;

                    // Add blank item
                    this.cboCustomClassification.DataTextField  = CListColumnValue;
                    this.cboCustomClassification.DataValueField = CListColumnClassificationID;
                    this.cboCustomClassification.DataBind();
                }
                else
                {
                    this.lblCustomClassification.Visible = false;
                    this.cboCustomClassification.Visible = false;
                }
            }
            catch (Exception Ex)
            {
                throw new Exception(Ex.Message);
            }
        }