示例#1
0
        public List <ShowEntryClasses> GetShow_Entry_ClassesByShow_ID(Guid show_ID)
        {
            List <ShowEntryClasses> retVal = new List <ShowEntryClasses>();

            try
            {
                ShowEntryClassesBL showEntryClasses = new ShowEntryClassesBL(_connString);
                tblShowEntryClasses = showEntryClasses.GetShow_Entry_ClassesByShow_ID(show_ID);

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

            return(retVal);
        }
示例#2
0
        public Guid?Insert_Show_Entry_Class(Guid user_ID)
        {
            Guid?retVal = null;

            try
            {
                ShowEntryClassesBL showEntryClasses = new ShowEntryClassesBL(_connString);
                retVal = (Guid?)showEntryClasses.Insert_Show_Entry_Classes(_show_ID, _class_Name_ID, _class_No, _class_Gender, user_ID);
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(retVal);
        }
示例#3
0
        public ShowEntryClasses(Guid show_Entry_Class_ID)
        {
            ShowEntryClassesBL showEntryClasses = new ShowEntryClassesBL();
            tblShowEntryClasses = showEntryClasses.GetShow_Entry_ClassByShow_Entry_Class_ID(show_Entry_Class_ID);

            Show_Entry_Class_ID = show_Entry_Class_ID;
            Show_ID = tblShowEntryClasses[0].Show_ID;
            Class_Name_ID = tblShowEntryClasses[0].Class_Name_ID;
            if (tblShowEntryClasses[0].Class_Name_Description == "NFC")
                IsNFC = true;
            if (!tblShowEntryClasses[0].IsClass_NoNull())
                Class_No = tblShowEntryClasses[0].Class_No;
            if (!tblShowEntryClasses[0].IsGenderNull())
                Class_Gender = tblShowEntryClasses[0].Gender;

            Class_Name_Description = string.Format("{0} : {1}", Class_No, tblShowEntryClasses[0].Class_Name_Description);
        }
示例#4
0
        public bool Update_Show_Entry_Class(Guid show_Entry_Class_ID, Guid user_ID)
        {
            bool retVal = false;

            try
            {
                ShowEntryClassesBL showEntryClasses = new ShowEntryClassesBL(_connString);
                retVal = showEntryClasses.Update_Show_Entry_Classes(show_Entry_Class_ID, _show_ID, _class_Name_ID, _class_No,
                                                                    _class_Gender, _deleteShowEntryClass, user_ID);
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(retVal);
        }
示例#5
0
        public ShowEntryClasses GetShowEntryClassByShowAndClassNo(Guid show_ID, int class_No)
        {
            ShowEntryClasses retVal = null;

            try
            {
                ShowEntryClassesBL showEntryClasses = new ShowEntryClassesBL(_connString);
                tblShowEntryClasses = showEntryClasses.GetShowEntryClassByShowAndClassNo(show_ID, class_No);

                if (tblShowEntryClasses != null && tblShowEntryClasses.Rows.Count > 0)
                {
                    retVal = new ShowEntryClasses(_connString, new Guid(tblShowEntryClasses.Rows[0]["Show_Entry_Class_ID"].ToString()));
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(retVal);
        }
示例#6
0
        public ShowEntryClasses(string connString, Guid show_Entry_Class_ID)
        {
            _connString = connString;

            try
            {
                ShowEntryClassesBL showEntryClasses = new ShowEntryClassesBL(_connString);
                tblShowEntryClasses = showEntryClasses.GetShow_Entry_ClassByShow_Entry_Class_ID(show_Entry_Class_ID);
                DataRow row = tblShowEntryClasses.Rows[0];

                _show_Entry_Class_ID = show_Entry_Class_ID;
                _show_ID             = Utils.DBNullToGuid(row["Show_ID"]);
                _class_Name_ID       = Utils.DBNullToInt(row["Class_Name_ID"]);
                _isNFC                  = Utils.DBNullToString(row["Class_Name_Description"]) == "NFC";
                _class_No               = Utils.DBNullToShort(row["Class_No"]);
                _class_Gender           = Utils.DBNullToShort(row["Gender"]);
                _class_Name_Description = string.Format("{0} : {1}", _class_No, Utils.DBNullToString(row["Class_Name_Description"]));
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
示例#7
0
        public bool Update_Show_Entry_Class(Guid show_Entry_Class_ID, Guid user_ID)
        {
            bool success = false;

            ShowEntryClassesBL showEntryClasses = new ShowEntryClassesBL();
            success = showEntryClasses.Update_Show_Entry_Classes(show_Entry_Class_ID, Show_ID, Class_Name_ID, Class_No,
                Class_Gender, DeleteShowEntryClass, user_ID);

            return success;
        }
示例#8
0
        public Guid? Insert_Show_Entry_Class(Guid user_ID)
        {
            ShowEntryClassesBL showEntryClasses = new ShowEntryClassesBL();
            Guid? newID = (Guid?)showEntryClasses.Insert_Show_Entry_Classes(Show_ID, Class_Name_ID, Class_No, Class_Gender, user_ID);

            return newID;
        }
示例#9
0
        public List<ShowEntryClasses> GetShow_Entry_ClassesByShow_ID(Guid show_ID)
        {
            List<ShowEntryClasses> showEntryClassList = new List<ShowEntryClasses>();
            ShowEntryClassesBL showEntryClasses = new ShowEntryClassesBL();
            tblShowEntryClasses = showEntryClasses.GetShow_Entry_ClassesByShow_ID(show_ID);

            if (tblShowEntryClasses != null && tblShowEntryClasses.Count > 0)
            {
                foreach (sss.tblShow_Entry_ClassesRow row in tblShowEntryClasses)
                {
                    ShowEntryClasses showEntryClass = new ShowEntryClasses(row.Show_Entry_Class_ID);
                    showEntryClassList.Add(showEntryClass);
                }
            }

            return showEntryClassList;
        }