Esempio n. 1
0
        public Guarantors(Guid guarantor_ID)
        {
            GuarantorsBL guarantors = new GuarantorsBL();
            tblGuarantors = guarantors.GetGuarantorByGuarantor_ID(guarantor_ID);

            Guarantor_ID = guarantor_ID;
            IsShow_IDNull = tblGuarantors[0].IsShow_IDNull();
            if (!IsShow_IDNull)
                Show_ID = tblGuarantors[0].Show_ID;
            IsChairman_Person_IDNull = tblGuarantors[0].IsChairman_Person_IDNull();
            if (!IsChairman_Person_IDNull)
                Chairman_Person_ID = tblGuarantors[0].Chairman_Person_ID;
            IsSecretary_Person_IDNull = tblGuarantors[0].IsSecretary_Person_IDNull();
            if (!IsSecretary_Person_IDNull)
                Secretary_Person_ID = tblGuarantors[0].Secretary_Person_ID;
            IsTreasurer_Person_IDNull = tblGuarantors[0].IsTreasurer_Person_IDNull();
            if (!IsTreasurer_Person_IDNull)
                Treasurer_Person_ID = tblGuarantors[0].Treasurer_Person_ID;
            IsCommittee1_Person_IDNull = tblGuarantors[0].IsCommittee1_Person_IDNull();
            if (!IsCommittee1_Person_IDNull)
                Committee1_Person_ID = tblGuarantors[0].Committee1_Person_ID;
            IsCommittee2_Person_IDNull = tblGuarantors[0].IsCommittee2_Person_IDNull();
            if (!IsCommittee2_Person_IDNull)
                Committee2_Person_ID = tblGuarantors[0].Committee2_Person_ID;
            IsCommittee3_Person_IDNull = tblGuarantors[0].IsCommittee3_Person_IDNull();
            if (!IsCommittee3_Person_IDNull)
                Committee3_Person_ID = tblGuarantors[0].Committee3_Person_ID;
        }
Esempio n. 2
0
        public List <Guarantors> GetGuarantorsByShow_ID(Guid show_ID)
        {
            List <Guarantors> guarantorList = new List <Guarantors>();

            try
            {
                GuarantorsBL guarantors = new GuarantorsBL(_connString);
                tblGuarantors = guarantors.GetGuarantorsByShow_ID(show_ID);

                if (tblGuarantors != null && tblGuarantors.Rows.Count > 0)
                {
                    foreach (DataRow row in tblGuarantors.Rows)
                    {
                        Guarantors guarantor = new Guarantors(_connString, Utils.DBNullToGuid(row["Guarantor_ID"]));
                        guarantorList.Add(guarantor);
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(guarantorList);
        }
Esempio n. 3
0
        public bool Update_Guarantor(Guid guarantor_ID, Guid user_ID)
        {
            bool success = false;

            try
            {
                GuarantorsBL guarantors = new GuarantorsBL(_connString);
                success = guarantors.Update_Guarantors(guarantor_ID, _show_ID, _chairman_Person_ID, _secretary_Person_ID, _treasurer_Person_ID,
                                                       _committee1_Person_ID, _committee2_Person_ID, _committee3_Person_ID, _deleteGuarantor, user_ID);
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(success);
        }
Esempio n. 4
0
        public Guid?Insert_Guarantor(Guid user_ID)
        {
            Guid?retVal = null;

            try
            {
                GuarantorsBL guarantors = new GuarantorsBL(_connString);
                retVal = (Guid?)guarantors.Insert_Guarantors(_show_ID, _chairman_Person_ID, _secretary_Person_ID, _treasurer_Person_ID,
                                                             _committee1_Person_ID, _committee2_Person_ID, _committee3_Person_ID, user_ID);
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(retVal);
        }
Esempio n. 5
0
        public Guarantors(string connString, Guid guarantor_ID)
        {
            _connString = connString;

            try
            {
                GuarantorsBL guarantors = new GuarantorsBL(_connString);
                tblGuarantors = guarantors.GetGuarantorByGuarantor_ID(guarantor_ID);
                DataRow row = tblGuarantors.Rows[0];

                _guarantor_ID         = guarantor_ID;
                _show_ID              = Utils.DBNullToGuid(row["Show_ID"]);
                _chairman_Person_ID   = Utils.DBNullToGuid(row["Chairman_Person_ID"]);
                _secretary_Person_ID  = Utils.DBNullToGuid(row["Secretary_Person_ID"]);
                _treasurer_Person_ID  = Utils.DBNullToGuid(row["Treasurer_Person_ID"]);
                _committee1_Person_ID = Utils.DBNullToGuid(row["Committee1_Person_ID"]);
                _committee2_Person_ID = Utils.DBNullToGuid(row["Committee2_Person_ID"]);
                _committee3_Person_ID = Utils.DBNullToGuid(row["Committee3_Person_ID"]);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Esempio n. 6
0
        public bool Update_Guarantor(Guid guarantor_ID, Guid user_ID)
        {
            bool success = false;

            GuarantorsBL guarantors = new GuarantorsBL();
            success = guarantors.Update_Guarantors(guarantor_ID, Show_ID, Chairman_Person_ID, Secretary_Person_ID, Treasurer_Person_ID,
                Committee1_Person_ID, Committee2_Person_ID, Committee3_Person_ID, DeleteGuarantor, user_ID);

            return success;
        }
Esempio n. 7
0
        public Guid? Insert_Guarantor(Guid user_ID)
        {
            GuarantorsBL guarantors = new GuarantorsBL();
            Guid? newID = (Guid?)guarantors.Insert_Guarantors(Show_ID, Chairman_Person_ID, Secretary_Person_ID, Treasurer_Person_ID,
                Committee1_Person_ID, Committee2_Person_ID, Committee3_Person_ID, user_ID);

            return newID;
        }
Esempio n. 8
0
        public List<Guarantors> GetGuarantorsByShow_ID(Guid show_ID)
        {
            List<Guarantors> guarantorList = new List<Guarantors>();
            GuarantorsBL guarantors = new GuarantorsBL();
            tblGuarantors = guarantors.GetGuarantorsByShow_ID(show_ID);

            if (tblGuarantors != null && tblGuarantors.Count > 0)
            {
                foreach (sss.tblGuarantorsRow row in tblGuarantors)
                {
                    Guarantors guarantor = new Guarantors(row.Guarantor_ID);
                    guarantorList.Add(guarantor);
                }
            }

            return guarantorList;
        }