/// <summary>
        /// Searches for ConferenceFee
        /// </summary>
        /// <param name="item" />
        /// <returns>An IEnumerable set of ConferenceFee</returns>
        public static IEnumerable<ConferenceFee> Search(SearchConferenceFee item)
        {
            List<SqlParameter> parameters
                = new List<SqlParameter>
                    {
                        new SqlParameter("@ConferenceFeeId", item.ConferenceFeeId),
                        new SqlParameter("@ConferenceId", item.ConferenceId),
                        new SqlParameter("@FeeAdjustmentId", item.FeeAdjustment),
                        new SqlParameter("@FeeTypeId", item.FeeType),
                        new SqlParameter("@Multiplier", item.Multiplier),
                        new SqlParameter("@EffectiveStartDate", item.EffectiveStartDate),
                        new SqlParameter("@EffectiveEndDate", item.EffectiveEndDate)
                    };

            DataSet set = DataManager.ExecuteProcedure(ConferencePlusConnectionString, "ConferenceFee_Get", parameters);
            IEnumerable<DataRow> dataRows = set.GetRowsFromDataSet();
            return ConvertToEntityObject(dataRows);
        }
 /// <summary>
 /// Load ConferenceFee on ConferenceId
 /// </summary>
 /// <param name="conferenceId" />
 /// <returns>An IEnumerable set of ConferenceFee</returns>
 public static IEnumerable<ConferenceFee> LoadOnConferenceId(int conferenceId)
 {
     SearchConferenceFee search
         = new SearchConferenceFee
             {
                 ConferenceId = conferenceId
             };
     return Search(search);
 }
        /// <summary>
        /// Validate ConferenceFee Entity
        /// </summary>
        /// <param name="item">Entity to validate</param>
        /// <param name="errorMessage">error message if vlidation failed</param>
        /// <returns>return true if entity passes validation logic, else return false</returns>
        public static bool Validate(ConferenceFee item, out string errorMessage)
        {
            StringBuilder builder = new StringBuilder();

            if (item.ConferenceId == default(int))
            {
                builder.AppendHtmlLine("*Please specify the conference to assign this fee to");
            }

            if (item.FeeAdjustment == EnumFeeAdjustment.None)
            {
                builder.AppendHtmlLine("*Please specify pricing type for this conference");
            }

            if (item.FeeType == EnumFeeType.None)
            {
                builder.AppendHtmlLine("*Please specify the type of fee for this conference");
            }

            if (item.Multiplier < 0)
            {
                builder.AppendHtmlLine("*Multiplier must be greater than or equal to 0");
            }

            if (!item.EffectiveStartDate.IsValidWithSqlDateStandards())
            {
                builder.AppendHtmlLine("*EffectiveStartDate is not valid with Sql Date Standards.");
            }

            if (!item.EffectiveEndDate.IsValidWithSqlDateStandards())
            {
                builder.AppendHtmlLine("*EffectiveEndDate is not valid with Sql Date Standards.");
            }

            if (item.EffectiveEndDate <= item.EffectiveStartDate)
            {
                builder.AppendHtmlLine("*Effective End Date needs to be after the Effective Start Date");
            }

            //Validate Conference
            if (builder.ToString().IsNullOrWhiteSpace())
            {
                SearchConference search = new SearchConference { ConferenceId = item.ConferenceId };
                Conference conference = ConferenceManager.Search(search).FirstOrDefault();

                if (conference == null)
                {
                    builder.AppendHtmlLine("*Conference Does not exists.");
                }
                else
                {
                    if (item.EffectiveStartDate.OnOrAfter(conference.StartDate))
                    {
                        builder.AppendHtmlLine("*There is a conflict with the Conference Start date.");
                    }
                }
            }

            //Validate ConferenceFees
            if (builder.ToString().IsNullOrWhiteSpace())
            {
                SearchConferenceFee searchList = new SearchConferenceFee { FeeType = item.FeeType, FeeAdjustment = item.FeeAdjustment, ConferenceId = item.ConferenceId };
                List<ConferenceFee> feeList = Search(searchList).Where(t => t.ConferenceFeeId != item.ConferenceFeeId.GetValueOrDefault(0)).ToList();

                if (feeList.SafeAny())
                {
                    builder.AppendHtmlLine("*Cannot contain a duplicate Conference Fee Type Entry.");
                }
                else
                {
                    SearchConferenceFee allSearch = new SearchConferenceFee { FeeType = item.FeeType, ConferenceId = item.ConferenceId };
                    List<ConferenceFee> allList = Search(allSearch).Where(t => t.ConferenceFeeId != item.ConferenceFeeId.GetValueOrDefault(0)).ToList();

                    if (allList.SafeAny())
                    {

                        if (allList.SafeAny(t => item.EffectiveStartDate.Between(t.EffectiveStartDate, t.EffectiveEndDate) || item.EffectiveEndDate.Between(t.EffectiveStartDate, t.EffectiveEndDate)))
                        {
                            builder.AppendHtmlLine("*There is a conflict with the dates for Conference Fee.");
                        }

                        if (builder.ToString().IsNullOrWhiteSpace())
                        {
                            if (item.FeeAdjustment == EnumFeeAdjustment.Early)
                            {
                                if (allList.SafeAny(t => item.EffectiveStartDate.OnOrAfter(t.EffectiveStartDate)))
                                {
                                    builder.AppendHtmlLine("*Early Fee Type needs to be before Normal or On-Site Fee Type.");
                                }
                            }
                            else if (item.FeeAdjustment == EnumFeeAdjustment.Normal)
                            {
                                if (allList.SafeAny(t => item.EffectiveStartDate.OnOrAfter(t.EffectiveStartDate) && t.FeeAdjustment == EnumFeeAdjustment.OnSite))
                                {
                                    builder.AppendHtmlLine("*Normal Fee Type needs to be before On-Site Fee Type.");
                                }
                                else if (allList.SafeAny(t => item.EffectiveStartDate.OnOrBefore(t.EffectiveEndDate) && t.FeeAdjustment == EnumFeeAdjustment.Early))
                                {
                                    builder.AppendHtmlLine("*Normal Fee Type needs to be after Early Fee Type.");
                                }
                            }
                            else if (item.FeeAdjustment == EnumFeeAdjustment.OnSite)
                            {
                                if (allList.SafeAny(t => item.EffectiveStartDate.OnOrBefore(t.EffectiveEndDate)))
                                {
                                    builder.AppendHtmlLine("*On-Site Fee Type needs to be after Normal or Early Fee Type.");
                                }
                            }
                        }
                    }
                }
            }

            errorMessage = builder.ToString();

            return errorMessage.IsNullOrWhiteSpace();
        }
 /// <summary>
 /// Loads ConferenceFee by the id parameter
 /// </summary>
 /// <param name="conferenceFeeId">Primary Key of ConferenceFee table</param>
 /// <returns>ConferenceFee entity</returns>
 public static ConferenceFee Load(int conferenceFeeId)
 {
     SearchConferenceFee search
         = new SearchConferenceFee
             {
                 ConferenceFeeId = conferenceFeeId
             };
     return Search(search).FirstOrDefault();
 }
 /// <summary>
 /// Searches for ConferenceFee
 /// </summary>
 /// <param name="search" />
 /// <returns>An IEnumerable set of ConferenceFee</returns>
 public static IEnumerable<ConferenceFee> Search(SearchConferenceFee search)
 {
     return ConferenceFeeDao.Search(search);
 }