Exemple #1
0
        public List <Entrants> GetEntrantsByShow_IDAndDog_ID(Guid show_ID, Guid dog_ID, bool includeLinked)
        {
            List <Entrants> retVal = new List <Entrants>();

            try
            {
                EntrantsBL entrants = new EntrantsBL(_connString);
                tblEntrants = entrants.GetEntrantsByShow_IDAndDog_ID(show_ID, dog_ID, includeLinked);

                if (tblEntrants != null && tblEntrants.Rows.Count > 0)
                {
                    foreach (DataRow row in tblEntrants.Rows)
                    {
                        Entrants entrant = new Entrants(_connString, Utils.DBNullToGuid(row["Entrant_ID"]));
                        retVal.Add(entrant);
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(retVal);
        }
Exemple #2
0
        public Entrants(string connString, Guid entrant_ID)
        {
            _connString = connString;

            try
            {
                EntrantsBL entrants = new EntrantsBL(_connString);
                tblEntrants = entrants.GetEntrantsByEntrant_ID(entrant_ID);
                DataRow row = tblEntrants.Rows[0];

                _entrant_ID         = entrant_ID;
                _show_ID            = Utils.DBNullToGuid(row["Show_ID"]);
                _catalogue          = Utils.DBNullToBool(row["Catalogue"]);
                _overnight_Camping  = Utils.DBNullToBool(row["Overnight_Camping"]);
                _overpayment        = Utils.DBNullToDec(row["Overpayment"]);
                _underpayment       = Utils.DBNullToDec(row["Underpayment"]);
                _offer_Of_Help      = Utils.DBNullToBool(row["Offer_Of_Help"]);
                _help_Details       = Utils.DBNullToString(row["Help_Details"]);
                _withold_Address    = Utils.DBNullToBool(row["Withold_Address"]);
                _send_Running_Order = Utils.DBNullToBool(row["Send_Running_Order"]);
                _entry_Date         = Utils.DBNullToDate(row["Entry_Date"]);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Exemple #3
0
        public bool Update_Entrant(Guid entrant_ID, Guid user_ID)
        {
            bool retVal = false;

            try
            {
                EntrantsBL entrants = new EntrantsBL(_connString);
                retVal = entrants.Update_Entrants(entrant_ID, _show_ID, _catalogue, _overnight_Camping, _overpayment,
                                                  _underpayment, _offer_Of_Help, _help_Details, _withold_Address, _send_Running_Order, _entry_Date, _deleteEntrant, user_ID);
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(retVal);
        }
Exemple #4
0
        public Guid?Insert_Entrant(Guid user_ID)
        {
            Guid?retVal = null;

            try
            {
                EntrantsBL entrants = new EntrantsBL(_connString);
                retVal = entrants.Insert_Entrants(_show_ID, _catalogue, _overnight_Camping, _overpayment,
                                                  _underpayment, _offer_Of_Help, _help_Details, _withold_Address, _send_Running_Order, _entry_Date, user_ID);
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(retVal);
        }
Exemple #5
0
        public Entrants(Guid entrant_ID)
        {
            EntrantsBL entrants = new EntrantsBL();
            tblEntrants = entrants.GetEntrantsByEntrant_ID(entrant_ID);

            Entrant_ID = entrant_ID;
            if (!tblEntrants[0].IsShow_IDNull())
                Show_ID = tblEntrants[0].Show_ID;
            if (!tblEntrants[0].IsCatalogueNull())
                Catalogue = tblEntrants[0].Catalogue;
            else
                Catalogue = false;
            if (!tblEntrants[0].IsOvernight_CampingNull())
                Overnight_Camping = tblEntrants[0].Overnight_Camping;
            else
                Overnight_Camping = false;
            if (!tblEntrants[0].IsOverpaymentNull())
                Overpayment = decimal.Parse(tblEntrants[0].Overpayment.ToString("#.00"));
            if (!tblEntrants[0].IsUnderpaymentNull())
                Underpayment = decimal.Parse(tblEntrants[0].Underpayment.ToString("#.00"));
            if (!tblEntrants[0].IsOffer_Of_HelpNull())
                Offer_Of_Help = tblEntrants[0].Offer_Of_Help;
            else
                Offer_Of_Help = false;
            if (!tblEntrants[0].IsHelp_DetailsNull())
                Help_Details = tblEntrants[0].Help_Details;
            if (!tblEntrants[0].IsWithold_AddressNull())
                Withold_Address = tblEntrants[0].Withold_Address;
            else
                Withold_Address = false;
            if (!tblEntrants[0].IsSend_Running_OrderNull())
                Send_Running_Order = tblEntrants[0].Send_Running_Order;
            else
                Send_Running_Order = false;
            if (!tblEntrants[0].IsEntry_DateNull())
                Entry_Date = tblEntrants[0].Entry_Date;
        }
Exemple #6
0
        public bool Update_Entrant(Guid entrant_ID, Guid user_ID)
        {
            bool success = false;

            EntrantsBL entrants = new EntrantsBL();
            success = entrants.Update_Entrants(entrant_ID, Show_ID, Catalogue, Overnight_Camping, Overpayment,
                Underpayment, Offer_Of_Help, Help_Details, Withold_Address, Send_Running_Order, Entry_Date, DeleteEntrant, user_ID);

            return success;
        }
Exemple #7
0
        public Guid? Insert_Entrant(Guid user_ID)
        {
            EntrantsBL entrants = new EntrantsBL();
            Guid? newID = (Guid?)entrants.Insert_Entrants(Show_ID, Catalogue, Overnight_Camping, Overpayment,
                Underpayment, Offer_Of_Help, Help_Details, Withold_Address, Send_Running_Order, Entry_Date, user_ID);

            return newID;
        }
Exemple #8
0
        public List<Entrants> GetEntrantsByShow_IDAndDog_ID(Guid show_ID, Guid dog_ID, bool includeLinked)
        {
            List<Entrants> entrantList = new List<Entrants>();
            EntrantsBL entrants = new EntrantsBL();
            tblEntrants = entrants.GetEntrantsByShow_IDAndDog_ID(show_ID, dog_ID, includeLinked);

            if (tblEntrants != null && tblEntrants.Count > 0)
            {
                foreach (sss.tblEntrantsRow row in tblEntrants)
                {
                    Entrants entrant = new Entrants(row.Entrant_ID);
                    entrantList.Add(entrant);
                }
            }

            return entrantList;
        }