/// <summary>
        /// Saves the DojoSeminarRegistration object state to the database.
        /// </summary>
        public int Save()
        {
            if (parentSeminar != null)
            {
                parentSeminar.Save();
            }
            if (contact != null)
            {
                contact.Save();
            }

            if (isSynced)
            {
                return(iD);
            }

            if (iD == -1)
            {
                throw (new Exception("Invalid record; cannot be saved."));
            }
            if (iD == 0)
            {
                iD = DojoSeminarRegistrationManager._insert(this);
            }
            else
            {
                DojoSeminarRegistrationManager._update(this);
            }
            isSynced = iD != -1;
            return(iD);
        }
Exemple #2
0
        private void bind()
        {
            #region Bind Default Child Data

            DojoSeminarOptionManager         parentOptionManager    = new DojoSeminarOptionManager();
            DojoSeminarOptionCollection      parentOptionCollection = parentOptionManager.GetCollection(string.Empty, string.Empty, null);
            ComponentArt.Web.UI.ComboBoxItem ParentOptionNullItem   = new ComponentArt.Web.UI.ComboBoxItem();
            ParentOptionNullItem.Text  = "Null";
            ParentOptionNullItem.Value = "Null";
            comboParentOption.Items.Add(ParentOptionNullItem);
            foreach (DojoSeminarOption parentOption in parentOptionCollection)
            {
                ComponentArt.Web.UI.ComboBoxItem i = new ComponentArt.Web.UI.ComboBoxItem();
                i.Text  = parentOption.ToString();
                i.Value = parentOption.ID.ToString();
                comboParentOption.Items.Add(i);
            }

            DojoSeminarRegistrationManager    parentRegistrationManager    = new DojoSeminarRegistrationManager();
            DojoSeminarRegistrationCollection parentRegistrationCollection = parentRegistrationManager.GetCollection(string.Empty, string.Empty, null);
            ComponentArt.Web.UI.ComboBoxItem  ParentRegistrationNullItem   = new ComponentArt.Web.UI.ComboBoxItem();
            ParentRegistrationNullItem.Text  = "Null";
            ParentRegistrationNullItem.Value = "Null";
            comboParentRegistration.Items.Add(ParentRegistrationNullItem);
            foreach (DojoSeminarRegistration parentRegistration in parentRegistrationCollection)
            {
                ComponentArt.Web.UI.ComboBoxItem i = new ComponentArt.Web.UI.ComboBoxItem();
                i.Text  = parentRegistration.ToString();
                i.Value = parentRegistration.ID.ToString();
                comboParentRegistration.Items.Add(i);
            }

            #endregion
        }
Exemple #3
0
        private void Populate(string id)
        {
            DojoSeminar s;

            s = new DojoSeminar(int.Parse(id));

            DojoSeminarRegistrationManager    dsrm          = new DojoSeminarRegistrationManager();
            DojoSeminarRegistrationCollection registrations =
                dsrm.GetCollection("ParentSeminarID=" + id, "LastName, FirstName, MiddleName",
                                   DojoSeminarRegistrationFlags.Contact);

            name.Text        = s.Name;
            description.Text = s.Description;
            location.Text    = s.Location.BusinessName;

            Panel regPanel = new Panel();

            regPanel.ID = "regPanel";
            regPanel.Style.Add("overflow", "scroll");
            regPanel.Style.Add("height", "200px");
            addCells(table, new LiteralControl("Registrations"), regPanel);
            Table regTable = new Table();

            regPanel.Controls.Add(regTable);

            foreach (DojoSeminarRegistration r in registrations)
            {
                addCell(regTable, string.Empty, r.Contact.FullName);
            }
        }
        /// <summary>
        /// Duplicates DojoSeminarRegistration object into a database; may or may not be the same database
        /// as the parent object.
        /// </summary>
        /// <returns> A new DojoSeminarRegistration object reflecting the replicated DojoSeminarRegistration object.</returns>
        public DojoSeminarRegistration Duplicate()
        {
            DojoSeminarRegistration clonedDojoSeminarRegistration = this.Clone();

            // Insert must be called after children are replicated!
            clonedDojoSeminarRegistration.iD       = DojoSeminarRegistrationManager._insert(clonedDojoSeminarRegistration);
            clonedDojoSeminarRegistration.isSynced = true;
            return(clonedDojoSeminarRegistration);
        }
        /// <summary>
        /// Ensures that the object's fields and children are
        /// pre-loaded before any updates or reads.
        /// </summary>
        public void EnsurePreLoad()
        {
            if (!isPlaceHolder)
            {
                return;
            }

            DojoSeminarRegistrationManager._fill(this);
            isPlaceHolder = false;
        }
Exemple #6
0
        private void loadRegistrations()
        {
            if (registrationsLoaded)
            {
                return;
            }

            DojoSeminarRegistrationManager m = new DojoSeminarRegistrationManager();

            if (cbIsPaid.Checked)
            {
                registrations =
                    m.GetCollection("ParentSeminarID=" +
                                    ddParentSeminar.SelectedItem.Value + " AND " +
                                    "PaymentAmount > 0",
                                    "Contact.LastName, " +
                                    "Contact.FirstName",
                                    DojoSeminarRegistrationFlags.ParentSeminar,
                                    DojoSeminarRegistrationFlags.Contact);
            }
            else if (ddParentSeminar.SelectedItem.Value != "-1")
            {
                registrations =
                    m.GetCollection("ParentSeminarID=" +
                                    ddParentSeminar.SelectedItem.Value,
                                    "Contact.LastName, " +
                                    "Contact.FirstName",
                                    DojoSeminarRegistrationFlags.ParentSeminar,
                                    DojoSeminarRegistrationFlags.Contact);
            }
            else
            {
                registrations =
                    m.GetCollection(string.Empty,
                                    "Contact.LastName, " +
                                    "Contact.FirstName",
                                    DojoSeminarRegistrationFlags.ParentSeminar,
                                    DojoSeminarRegistrationFlags.Contact);
            }

            registrationsLoaded = true;
        }
Exemple #7
0
        /// <summary>
        /// Render this control to the output parameter specified.
        /// </summary>
        /// <param name="output"> The HTML writer to write out to </param>
        protected override void RenderContent(HtmlTextWriter output)
        {
            DojoSeminarRegistrationManager    m = new DojoSeminarRegistrationManager();
            DojoSeminarRegistrationCollection dojoSeminarRegistrationCollection = m.GetCollection(string.Empty, string.Empty, null);

            // Render Header Row
            this.headerLockEnabled = true;
            RenderRow(this.HeaderRowCssClass, );

            bool   rowflag = false;
            string rowCssClass;

            //
            // Render Records
            //
            foreach (DojoSeminarRegistration dojoSeminarRegistration in dojoSeminarRegistrationCollection)
            {
                if (rowflag)
                {
                    rowCssClass = defaultRowCssClass;
                }
                else
                {
                    rowCssClass = alternateRowCssClass;
                }
                rowflag = !rowflag;
                output.WriteBeginTag("tr");
                output.WriteAttribute("i", dojoSeminarRegistration.ID.ToString());
                output.WriteLine(HtmlTextWriter.TagRightChar);
                output.Indent++;

                output.Indent--;
                output.WriteEndTag("tr");
                output.WriteLine();
            }
        }
        private void bindDropDownLists()
        {
            #region Bind Default Child Data

            msParentOption.Items.Add(new ListItem("Null", "Null"));
            DojoSeminarOptionManager    parentOptionManager    = new DojoSeminarOptionManager();
            DojoSeminarOptionCollection parentOptionCollection = parentOptionManager.GetCollection(string.Empty, string.Empty, null);
            foreach (DojoSeminarOption parentOption in parentOptionCollection)
            {
                ListItem i = new ListItem(parentOption.ToString(), parentOption.ID.ToString());
                msParentOption.Items.Add(i);
            }

            msParentRegistration.Items.Add(new ListItem("Null", "Null"));
            DojoSeminarRegistrationManager    parentRegistrationManager    = new DojoSeminarRegistrationManager();
            DojoSeminarRegistrationCollection parentRegistrationCollection = parentRegistrationManager.GetCollection(string.Empty, string.Empty, null);
            foreach (DojoSeminarRegistration parentRegistration in parentRegistrationCollection)
            {
                ListItem i = new ListItem(parentRegistration.ToString(), parentRegistration.ID.ToString());
                msParentRegistration.Items.Add(i);
            }

            #endregion
        }
Exemple #9
0
        public DojoSeminarRegistrationOptionCollection GetCollection(int topCount, string whereClause, string sortClause, params DojoSeminarRegistrationOptionFlags[] optionFlags)
        {
            StringBuilder query;
            Database      database;
            DbCommand     dbCommand;
            IDataReader   r;
            DojoSeminarRegistrationOptionCollection dojoSeminarRegistrationOptionCollection;
            int hashcode;

            // Cache Handling

            hashcode = 0;

            if (cacheEnabled)
            {
                hashcode = topCount.GetHashCode() +
                           whereClause.GetHashCode() +
                           sortClause.GetHashCode() +
                           tableName.GetHashCode();

                DojoSeminarRegistrationOptionCollection collection = cacheFindCollection(hashcode);
                if (collection != null)
                {
                    return(collection);
                }
            }

            int innerJoinOffset;

            query = new StringBuilder("SELECT ");

            if (topCount > 0)
            {
                query.Append("TOP ");
                query.Append(topCount);
                query.Append(" ");
            }

            foreach (string columnName in InnerJoinFields)
            {
                query.Append("DojoSeminarRegistrationOption.");
                query.Append(columnName);
                query.Append(",");
            }

            innerJoinOffset = InnerJoinFields.GetUpperBound(0) + 1;
            int parentOptionOffset       = -1;
            int parentOptionItemOffset   = -1;
            int parentRegistrationOffset = -1;
            int parentRegistrationParentSeminarOffset  = -1;
            int parentRegistrationContactOffset        = -1;
            int parentRegistrationInvoiceLineOffset    = -1;
            int parentRegistrationSalesOrderLineOffset = -1;
            int parentRegistrationCustomerOffset       = -1;

            //
            // Append Option Flag Fields
            //
            if (optionFlags != null)
            {
                for (int x = 0; x < optionFlags.Length; x++)
                {
                    switch (optionFlags[x])
                    {
                    case DojoSeminarRegistrationOptionFlags.ParentOption:
                        for (int i = 0; i <= DojoSeminarOptionManager.InnerJoinFields.GetUpperBound(0); i++)
                        {
                            query.Append("ParentOption.");
                            query.Append(DojoSeminarOptionManager.InnerJoinFields[i]);
                            query.Append(",");
                        }
                        parentOptionOffset = innerJoinOffset;
                        innerJoinOffset    = parentOptionOffset + DojoSeminarOptionManager.InnerJoinFields.GetUpperBound(0) + 1;
                        break;

                    case DojoSeminarRegistrationOptionFlags.ParentOptionItem:
                        for (int i = 0; i <= RHItemManager.InnerJoinFields.GetUpperBound(0); i++)
                        {
                            query.Append("ParentOption_Item.");
                            query.Append(RHItemManager.InnerJoinFields[i]);
                            query.Append(",");
                        }
                        parentOptionItemOffset = innerJoinOffset;
                        innerJoinOffset        = parentOptionItemOffset + RHItemManager.InnerJoinFields.GetUpperBound(0) + 1;
                        break;

                    case DojoSeminarRegistrationOptionFlags.ParentRegistration:
                        for (int i = 0; i <= DojoSeminarRegistrationManager.InnerJoinFields.GetUpperBound(0); i++)
                        {
                            query.Append("ParentRegistration.");
                            query.Append(DojoSeminarRegistrationManager.InnerJoinFields[i]);
                            query.Append(",");
                        }
                        parentRegistrationOffset = innerJoinOffset;
                        innerJoinOffset          = parentRegistrationOffset + DojoSeminarRegistrationManager.InnerJoinFields.GetUpperBound(0) + 1;
                        break;

                    case DojoSeminarRegistrationOptionFlags.ParentRegistrationParentSeminar:
                        for (int i = 0; i <= DojoSeminarManager.InnerJoinFields.GetUpperBound(0); i++)
                        {
                            query.Append("ParentRegistration_ParentSeminar.");
                            query.Append(DojoSeminarManager.InnerJoinFields[i]);
                            query.Append(",");
                        }
                        parentRegistrationParentSeminarOffset = innerJoinOffset;
                        innerJoinOffset = parentRegistrationParentSeminarOffset + DojoSeminarManager.InnerJoinFields.GetUpperBound(0) + 1;
                        break;

                    case DojoSeminarRegistrationOptionFlags.ParentRegistrationContact:
                        for (int i = 0; i <= GreyFoxContactManager.InnerJoinFields.GetUpperBound(0); i++)
                        {
                            query.Append("ParentRegistration_Contact.");
                            query.Append(GreyFoxContactManager.InnerJoinFields[i]);
                            query.Append(",");
                        }
                        parentRegistrationContactOffset = innerJoinOffset;
                        innerJoinOffset = parentRegistrationContactOffset + GreyFoxContactManager.InnerJoinFields.GetUpperBound(0) + 1;
                        break;

                    case DojoSeminarRegistrationOptionFlags.ParentRegistrationInvoiceLine:
                        for (int i = 0; i <= RHInvoiceLineManager.InnerJoinFields.GetUpperBound(0); i++)
                        {
                            query.Append("ParentRegistration_InvoiceLine.");
                            query.Append(RHInvoiceLineManager.InnerJoinFields[i]);
                            query.Append(",");
                        }
                        parentRegistrationInvoiceLineOffset = innerJoinOffset;
                        innerJoinOffset = parentRegistrationInvoiceLineOffset + RHInvoiceLineManager.InnerJoinFields.GetUpperBound(0) + 1;
                        break;

                    case DojoSeminarRegistrationOptionFlags.ParentRegistrationSalesOrderLine:
                        for (int i = 0; i <= RHSalesOrderLineManager.InnerJoinFields.GetUpperBound(0); i++)
                        {
                            query.Append("ParentRegistration_SalesOrderLine.");
                            query.Append(RHSalesOrderLineManager.InnerJoinFields[i]);
                            query.Append(",");
                        }
                        parentRegistrationSalesOrderLineOffset = innerJoinOffset;
                        innerJoinOffset = parentRegistrationSalesOrderLineOffset + RHSalesOrderLineManager.InnerJoinFields.GetUpperBound(0) + 1;
                        break;

                    case DojoSeminarRegistrationOptionFlags.ParentRegistrationCustomer:
                        for (int i = 0; i <= RHCustomerManager.InnerJoinFields.GetUpperBound(0); i++)
                        {
                            query.Append("ParentRegistration_Customer.");
                            query.Append(RHCustomerManager.InnerJoinFields[i]);
                            query.Append(",");
                        }
                        parentRegistrationCustomerOffset = innerJoinOffset;
                        innerJoinOffset = parentRegistrationCustomerOffset + RHCustomerManager.InnerJoinFields.GetUpperBound(0) + 1;
                        break;
                    }
                }
            }

            //
            // Remove trailing comma
            //
            query.Length--;
            if (optionFlags != null)
            {
                query.Append(" FROM ");

                //
                // Start INNER JOIN expressions
                //
                for (int x = 0; x < optionFlags.Length; x++)
                {
                    query.Append("(");
                }

                query.Append("kitTessen_SeminarRegistrationOptions AS DojoSeminarRegistrationOption");
            }
            else
            {
                query.Append(" FROM kitTessen_SeminarRegistrationOptions AS DojoSeminarRegistrationOption");
            }
            //
            // Finish INNER JOIN expressions
            //
            if (optionFlags != null)
            {
                for (int x = 0; x < optionFlags.Length; x++)
                {
                    switch (optionFlags[x])
                    {
                    case DojoSeminarRegistrationOptionFlags.ParentOption:
                        query.Append(" LEFT JOIN kitTessen_SeminarOptions AS ParentOption ON DojoSeminarRegistrationOption.ParentOptionID = ParentOption.DojoSeminarOptionID)");
                        break;

                    case DojoSeminarRegistrationOptionFlags.ParentOptionItem:
                        query.Append(" LEFT JOIN RH_Items AS ParentOption_Item ON ParentOption.ItemID = ParentOption_Item.RHItemID)");
                        break;

                    case DojoSeminarRegistrationOptionFlags.ParentRegistration:
                        query.Append(" LEFT JOIN kitTessen_SeminarRegistrations AS ParentRegistration ON DojoSeminarRegistrationOption.ParentRegistrationID = ParentRegistration.DojoSeminarRegistrationID)");
                        break;

                    case DojoSeminarRegistrationOptionFlags.ParentRegistrationParentSeminar:
                        query.Append(" LEFT JOIN kitTessen_Seminars AS ParentRegistration_ParentSeminar ON ParentRegistration.ParentSeminarID = ParentRegistration_ParentSeminar.DojoSeminarID)");
                        break;

                    case DojoSeminarRegistrationOptionFlags.ParentRegistrationContact:
                        query.Append(" LEFT JOIN kitTessen_SeminarRegistrations_Contacts AS ParentRegistration_Contact ON ParentRegistration.ContactID = ParentRegistration_Contact.GreyFoxContactID)");
                        break;

                    case DojoSeminarRegistrationOptionFlags.ParentRegistrationInvoiceLine:
                        query.Append(" LEFT JOIN RH_InvoiceLines AS ParentRegistration_InvoiceLine ON ParentRegistration.InvoiceLineID = ParentRegistration_InvoiceLine.RHInvoiceLineID)");
                        break;

                    case DojoSeminarRegistrationOptionFlags.ParentRegistrationSalesOrderLine:
                        query.Append(" LEFT JOIN RH_SalesOrderLines AS ParentRegistration_SalesOrderLine ON ParentRegistration.SalesOrderLineID = ParentRegistration_SalesOrderLine.RHSalesOrderLineID)");
                        break;

                    case DojoSeminarRegistrationOptionFlags.ParentRegistrationCustomer:
                        query.Append(" LEFT JOIN RH_Customers AS ParentRegistration_Customer ON ParentRegistration.CustomerID = ParentRegistration_Customer.RHCustomerID)");
                        break;
                    }
                }
            }

            //
            // Render where clause
            //
            if (whereClause != string.Empty)
            {
                query.Append(" WHERE ");
                query.Append(whereClause);
            }

            //
            // Render sort clause
            //
            if (sortClause != string.Empty)
            {
                query.Append(" ORDER BY ");
                query.Append(sortClause);
            }

            //
            // Render final semicolon
            //
            query.Append(";");
            database  = DatabaseFactory.CreateDatabase();
            dbCommand = database.GetSqlStringCommand(query.ToString());
                        #if DEBUG
            try
            {
                r = database.ExecuteReader(dbCommand);
            }
            catch (Exception e)
            {
                string msg = e.Message;
                throw(new Exception(msg + " --- Query: " + query.ToString()));
            }
                        #else
            r = database.ExecuteReader(dbCommand);
                        #endif

            dojoSeminarRegistrationOptionCollection = new DojoSeminarRegistrationOptionCollection();

            while (r.Read())
            {
                DojoSeminarRegistrationOption dojoSeminarRegistrationOption = ParseFromReader(r, 0, 1);

                // Fill ParentOption
                if (parentOptionOffset != -1 && !r.IsDBNull(parentOptionOffset))
                {
                    DojoSeminarOptionManager.FillFromReader(dojoSeminarRegistrationOption.parentOption, r, parentOptionOffset, parentOptionOffset + 1);

                    // Fill
                    if (parentOptionItemOffset != -1 && !r.IsDBNull(parentOptionItemOffset))
                    {
                        RHItemManager.FillFromReader(dojoSeminarRegistrationOption.parentOption.Item, r, parentOptionItemOffset, parentOptionItemOffset + 1);
                    }
                }

                // Fill ParentRegistration
                if (parentRegistrationOffset != -1 && !r.IsDBNull(parentRegistrationOffset))
                {
                    DojoSeminarRegistrationManager.FillFromReader(dojoSeminarRegistrationOption.parentRegistration, r, parentRegistrationOffset, parentRegistrationOffset + 1);

                    // Fill
                    if (parentRegistrationParentSeminarOffset != -1 && !r.IsDBNull(parentRegistrationParentSeminarOffset))
                    {
                        DojoSeminarManager.FillFromReader(dojoSeminarRegistrationOption.parentRegistration.ParentSeminar, r, parentRegistrationParentSeminarOffset, parentRegistrationParentSeminarOffset + 1);
                    }

                    // Fill
                    if (parentRegistrationContactOffset != -1 && !r.IsDBNull(parentRegistrationContactOffset))
                    {
                        GreyFoxContactManager.FillFromReader(dojoSeminarRegistrationOption.parentRegistration.Contact, "kitTessen_SeminarRegistrations_Contacts", r, parentRegistrationContactOffset, parentRegistrationContactOffset + 1);
                    }

                    // Fill Invoice Line
                    if (parentRegistrationInvoiceLineOffset != -1 && !r.IsDBNull(parentRegistrationInvoiceLineOffset))
                    {
                        RHInvoiceLineManager.FillFromReader(dojoSeminarRegistrationOption.parentRegistration.InvoiceLine, r, parentRegistrationInvoiceLineOffset, parentRegistrationInvoiceLineOffset + 1);
                    }

                    // Fill Sales Order Line
                    if (parentRegistrationSalesOrderLineOffset != -1 && !r.IsDBNull(parentRegistrationSalesOrderLineOffset))
                    {
                        RHSalesOrderLineManager.FillFromReader(dojoSeminarRegistrationOption.parentRegistration.SalesOrderLine, r, parentRegistrationSalesOrderLineOffset, parentRegistrationSalesOrderLineOffset + 1);
                    }

                    // Fill Registrant
                    if (parentRegistrationCustomerOffset != -1 && !r.IsDBNull(parentRegistrationCustomerOffset))
                    {
                        RHCustomerManager.FillFromReader(dojoSeminarRegistrationOption.parentRegistration.Customer, r, parentRegistrationCustomerOffset, parentRegistrationCustomerOffset + 1);
                    }
                }

                dojoSeminarRegistrationOptionCollection.Add(dojoSeminarRegistrationOption);
            }

            // Microsoft DAAB still needs to close readers.
            r.Close();

            if (cacheEnabled)
            {
                cacheStoreCollection(hashcode, dojoSeminarRegistrationOptionCollection);
            }

            return(dojoSeminarRegistrationOptionCollection);
        }
Exemple #10
0
        protected override void RenderViewPane(HtmlTextWriter output)
        {
            this.InitializeRenderHelpers(output);

            DojoSeminar seminar = new DojoSeminar(int.Parse(HttpContext.Current.Request.QueryString[0]));

            RenderTableBeginTag("_viewPanel", this.CellPadding, this.CellSpacing, Unit.Percentage(100), Unit.Empty, this.CssClass);

            output.WriteFullBeginTag("tr");
            output.WriteBeginTag("th");
            output.WriteAttribute("colspan", "2");
            output.WriteAttribute("class", this.HeaderCssClass);
            output.Write(HtmlTextWriter.TagRightChar);
            output.Write(seminar.Name);
            output.Write(" (" + seminar.ID.ToString() + ")");
            output.WriteEndTag("th");
            output.WriteEndTag("tr");

            #region General Information

            output.WriteFullBeginTag("tr");
            output.WriteBeginTag("td");
            output.WriteAttribute("colspan", "2");
            output.WriteAttribute("class", this.SubHeaderCssClass);
            output.Write(HtmlTextWriter.TagRightChar);
            output.Write("General");
            output.WriteEndTag("td");
            output.WriteEndTag("tr");

            output.WriteFullBeginTag("tr");
            output.WriteBeginTag("td");
            output.WriteAttribute("colspan", "2");
            output.WriteAttribute("class", this.DefaultRowCssClass);
            output.Write(HtmlTextWriter.TagRightChar);
            output.Write("<strong>Location</strong> : ");
            output.Write(seminar.Location.BusinessName);
            output.WriteEndTag("td");
            output.WriteEndTag("tr");

            output.WriteFullBeginTag("tr");
            output.WriteBeginTag("td");
            output.WriteAttribute("colspan", "2");
            output.WriteAttribute("class", this.DefaultRowCssClass);
            output.Write(HtmlTextWriter.TagRightChar);
            output.Write("<strong>Partial Registration Fees</strong> : ");
            switch (seminar.ClassUnitType)
            {
            case DojoSeminarClassUnitType.Day:
                output.Write(seminar.ClassUnitFee.ToString("c"));
                output.Write(" Per Day");
                break;

            case DojoSeminarClassUnitType.Class:
                output.Write(seminar.ClassUnitFee.ToString("c"));
                output.Write(" Per Class");
                break;

            case DojoSeminarClassUnitType.None:
                output.Write(" None ");
                break;
            }
            output.WriteEndTag("td");
            output.WriteEndTag("tr");

            output.WriteFullBeginTag("tr");
            output.WriteBeginTag("td");
            output.WriteAttribute("colspan", "2");
            output.WriteAttribute("class", this.DefaultRowCssClass);
            output.Write(HtmlTextWriter.TagRightChar);
            output.Write("<strong>Full Registration Fee</strong> : ");
            output.Write(seminar.FullRegistrationFee.ToString("c"));
            output.WriteEndTag("td");
            output.WriteEndTag("tr");

            #endregion

            #region Students Attended

            output.WriteFullBeginTag("tr");
            output.WriteBeginTag("td");
            output.WriteAttribute("colspan", "2");
            output.WriteAttribute("class", this.SubHeaderCssClass);
            output.Write(HtmlTextWriter.TagRightChar);
            output.Write("Students");
            output.WriteEndTag("td");
            output.WriteEndTag("tr");

            DojoSeminarRegistrationManager    dsrm          = new DojoSeminarRegistrationManager();
            DojoSeminarRegistrationCollection registrations = dsrm.GetCollection("ParentSeminarID=" + seminar.ID.ToString(), "LastName, FirstName, MiddleName",
                                                                                 DojoSeminarRegistrationFlags.Contact);

            foreach (DojoSeminarRegistration registration in registrations)
            {
                output.WriteFullBeginTag("tr");
                output.WriteBeginTag("td");
                output.WriteAttribute("class", this.defaultRowCssClass);
                output.Write(HtmlTextWriter.TagRightChar);
                output.Write(registration.Contact.ConstructName("LS,FMi."));
                output.WriteEndTag("td");
                output.WriteBeginTag("td");
                output.WriteAttribute("class", this.defaultRowCssClass);
                output.Write(HtmlTextWriter.TagRightChar);
                if (registration.IsPaid)
                {
                    output.Write("Paid");
                }
                else
                {
                    output.Write("Preregistration");
                }
                output.WriteEndTag("td");
                output.WriteEndTag("tr");
            }

            #endregion

            output.WriteEndTag("table");
        }
Exemple #11
0
        private void bindDropDownLists()
        {
            #region Bind General Child Data

            msRegistration.Items.Add(new ListItem("Null", "Null"));
            DojoSeminarRegistrationManager    registrationManager    = new DojoSeminarRegistrationManager();
            DojoSeminarRegistrationCollection registrationCollection = registrationManager.GetCollection(string.Empty, string.Empty, null);
            foreach (DojoSeminarRegistration registration in registrationCollection)
            {
                ListItem i = new ListItem(registration.ToString(), registration.ID.ToString());
                msRegistration.Items.Add(i);
            }

            msParentReservation.Items.Add(new ListItem("Null", "Null"));
            DojoSeminarReservationManager    parentReservationManager    = new DojoSeminarReservationManager();
            DojoSeminarReservationCollection parentReservationCollection = parentReservationManager.GetCollection(string.Empty, string.Empty, null);
            foreach (DojoSeminarReservation parentReservation in parentReservationCollection)
            {
                ListItem i = new ListItem(parentReservation.ToString(), parentReservation.ID.ToString());
                msParentReservation.Items.Add(i);
            }

            #endregion

            #region Bind Classes Child Data

            msClass1.Items.Add(new ListItem("Null", "Null"));
            DojoClassManager    class1Manager    = new DojoClassManager();
            DojoClassCollection class1Collection = class1Manager.GetCollection(string.Empty, string.Empty, null);
            foreach (DojoClass class1 in class1Collection)
            {
                ListItem i = new ListItem(class1.ToString(), class1.ID.ToString());
                msClass1.Items.Add(i);
            }

            msClass2.Items.Add(new ListItem("Null", "Null"));
            DojoClassManager    class2Manager    = new DojoClassManager();
            DojoClassCollection class2Collection = class2Manager.GetCollection(string.Empty, string.Empty, null);
            foreach (DojoClass class2 in class2Collection)
            {
                ListItem i = new ListItem(class2.ToString(), class2.ID.ToString());
                msClass2.Items.Add(i);
            }

            msClass3.Items.Add(new ListItem("Null", "Null"));
            DojoClassManager    class3Manager    = new DojoClassManager();
            DojoClassCollection class3Collection = class3Manager.GetCollection(string.Empty, string.Empty, null);
            foreach (DojoClass class3 in class3Collection)
            {
                ListItem i = new ListItem(class3.ToString(), class3.ID.ToString());
                msClass3.Items.Add(i);
            }

            msClass4.Items.Add(new ListItem("Null", "Null"));
            DojoClassManager    class4Manager    = new DojoClassManager();
            DojoClassCollection class4Collection = class4Manager.GetCollection(string.Empty, string.Empty, null);
            foreach (DojoClass class4 in class4Collection)
            {
                ListItem i = new ListItem(class4.ToString(), class4.ID.ToString());
                msClass4.Items.Add(i);
            }

            msClass5.Items.Add(new ListItem("Null", "Null"));
            DojoClassManager    class5Manager    = new DojoClassManager();
            DojoClassCollection class5Collection = class5Manager.GetCollection(string.Empty, string.Empty, null);
            foreach (DojoClass class5 in class5Collection)
            {
                ListItem i = new ListItem(class5.ToString(), class5.ID.ToString());
                msClass5.Items.Add(i);
            }

            msClass6.Items.Add(new ListItem("Null", "Null"));
            DojoClassManager    class6Manager    = new DojoClassManager();
            DojoClassCollection class6Collection = class6Manager.GetCollection(string.Empty, string.Empty, null);
            foreach (DojoClass class6 in class6Collection)
            {
                ListItem i = new ListItem(class6.ToString(), class6.ID.ToString());
                msClass6.Items.Add(i);
            }

            msClass7.Items.Add(new ListItem("Null", "Null"));
            DojoClassManager    class7Manager    = new DojoClassManager();
            DojoClassCollection class7Collection = class7Manager.GetCollection(string.Empty, string.Empty, null);
            foreach (DojoClass class7 in class7Collection)
            {
                ListItem i = new ListItem(class7.ToString(), class7.ID.ToString());
                msClass7.Items.Add(i);
            }

            msClass8.Items.Add(new ListItem("Null", "Null"));
            DojoClassManager    class8Manager    = new DojoClassManager();
            DojoClassCollection class8Collection = class8Manager.GetCollection(string.Empty, string.Empty, null);
            foreach (DojoClass class8 in class8Collection)
            {
                ListItem i = new ListItem(class8.ToString(), class8.ID.ToString());
                msClass8.Items.Add(i);
            }

            msClass9.Items.Add(new ListItem("Null", "Null"));
            DojoClassManager    class9Manager    = new DojoClassManager();
            DojoClassCollection class9Collection = class9Manager.GetCollection(string.Empty, string.Empty, null);
            foreach (DojoClass class9 in class9Collection)
            {
                ListItem i = new ListItem(class9.ToString(), class9.ID.ToString());
                msClass9.Items.Add(i);
            }

            msClass10.Items.Add(new ListItem("Null", "Null"));
            DojoClassManager    class10Manager    = new DojoClassManager();
            DojoClassCollection class10Collection = class10Manager.GetCollection(string.Empty, string.Empty, null);
            foreach (DojoClass class10 in class10Collection)
            {
                ListItem i = new ListItem(class10.ToString(), class10.ID.ToString());
                msClass10.Items.Add(i);
            }

            #endregion

            #region Bind Definitions Child Data

            msDefinition1.Items.Add(new ListItem("Null", "Null"));
            DojoClassDefinitionManager    definition1Manager    = new DojoClassDefinitionManager();
            DojoClassDefinitionCollection definition1Collection = definition1Manager.GetCollection(string.Empty, string.Empty, null);
            foreach (DojoClassDefinition definition1 in definition1Collection)
            {
                ListItem i = new ListItem(definition1.ToString(), definition1.ID.ToString());
                msDefinition1.Items.Add(i);
            }

            msDefinition2.Items.Add(new ListItem("Null", "Null"));
            DojoClassDefinitionManager    definition2Manager    = new DojoClassDefinitionManager();
            DojoClassDefinitionCollection definition2Collection = definition2Manager.GetCollection(string.Empty, string.Empty, null);
            foreach (DojoClassDefinition definition2 in definition2Collection)
            {
                ListItem i = new ListItem(definition2.ToString(), definition2.ID.ToString());
                msDefinition2.Items.Add(i);
            }

            msDefinition3.Items.Add(new ListItem("Null", "Null"));
            DojoClassDefinitionManager    definition3Manager    = new DojoClassDefinitionManager();
            DojoClassDefinitionCollection definition3Collection = definition3Manager.GetCollection(string.Empty, string.Empty, null);
            foreach (DojoClassDefinition definition3 in definition3Collection)
            {
                ListItem i = new ListItem(definition3.ToString(), definition3.ID.ToString());
                msDefinition3.Items.Add(i);
            }

            #endregion
        }
 /// <summary>
 /// Overwrites and existing DojoSeminarRegistration object in the database.
 /// </summary>
 public void Overwrite(int id)
 {
     iD = id;
     DojoSeminarRegistrationManager._update(this);
     isSynced = true;
 }
 public void Delete()
 {
     DojoSeminarRegistrationManager._delete(this.iD);
     this.iD  = 0;
     isSynced = false;
 }
 public DojoSeminarRegistration(int id)
 {
     this.iD  = id;
     isSynced = DojoSeminarRegistrationManager._fill(this);
 }