예제 #1
0
        public ShowFinalClasses(string connString, Guid show_Final_Class_ID)
        {
            _connString = connString;

            if (show_Final_Class_ID != new Guid())
            {
                try
                {
                    ShowFinalClassesBL showfinalclasses = new ShowFinalClassesBL(_connString);
                    tblShowFinalClasses = showfinalclasses.GetShow_Final_ClassByShow_Final_Class_ID(show_Final_Class_ID);
                    DataRow row = tblShowFinalClasses.Rows[0];

                    Show_Final_Class_ID          = show_Final_Class_ID;
                    Show_ID                      = Utils.DBNullToGuid(row["Show_ID"]);
                    Show_Entry_Class_ID          = Utils.DBNullToGuid(row["Show_Entry_Class_ID"]);
                    Show_Final_Class_Description = Utils.DBNullToString(row["Show_Final_Class_Description"]);
                    Show_Final_Class_No          = Utils.DBNullToShort(row["Show_Final_Class_No"]);
                    Judge_ID                     = Utils.DBNullToGuid(row["Judge_ID"]);
                    Stay_Time                    = Utils.DBNullToDate(row["Stay_Time"]);
                    Lunch_Time                   = Utils.DBNullToDate(row["Lunch_Time"]);
                }
                catch (Exception ex)
                {
                    throw ex;
                }
            }
        }
예제 #2
0
        public List <ShowFinalClasses> GetSplitClassParts(Guid show_ID)
        {
            List <ShowFinalClasses> retVal = new List <ShowFinalClasses>();

            try
            {
                ShowFinalClassesBL showfinalclasses = new ShowFinalClassesBL(_connString);
                tblShowFinalClasses = showfinalclasses.GetSplitClassParts(show_ID);

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

            return(retVal);
        }
예제 #3
0
        public int DeleteShowFinalClassesByShowEntryClass(Guid show_Entry_Class_ID)
        {
            int retVal = 0;

            try
            {
                ShowFinalClassesBL showFinalClasses = new ShowFinalClassesBL(_connString);
                retVal = showFinalClasses.DeleteShowFinalClassesByShowEntryClass(show_Entry_Class_ID);
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(retVal);
        }
예제 #4
0
        public bool Update_Show_Final_Class(Guid show_Final_Class_ID, Guid user_ID)
        {
            bool retVal = false;

            try
            {
                ShowFinalClassesBL showfinalclasses = new ShowFinalClassesBL(_connString);
                retVal = showfinalclasses.Update_Show_Final_Classes(show_Final_Class_ID, _show_ID, _show_Entry_Class_ID,
                                                                    _show_Final_Class_Description, _show_Final_Class_No, _judge_ID, _stay_Time, _lunch_Time, _deleteShowFinalClass, user_ID);
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(retVal);
        }
예제 #5
0
        public Guid?Insert_Show_Final_Class(Guid user_ID)
        {
            Guid?retVal = null;

            try
            {
                ShowFinalClassesBL showfinalclasses = new ShowFinalClassesBL(_connString);
                retVal = (Guid?)showfinalclasses.Insert_Show_Final_Classes(_show_ID, _show_Entry_Class_ID,
                                                                           _show_Final_Class_Description, _show_Final_Class_No, _judge_ID, _stay_Time, _lunch_Time, user_ID);
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(retVal);
        }
예제 #6
0
        public ShowFinalClasses(Guid show_Final_Class_ID)
        {
            ShowFinalClassesBL showfinalclasses = new ShowFinalClassesBL();
            tblShowFinalClasses = showfinalclasses.GetShow_Final_ClassByShow_Final_Class_ID(show_Final_Class_ID);

            Show_Final_Class_ID = show_Final_Class_ID;
            Show_ID = tblShowFinalClasses[0].Show_ID;
            if (!tblShowFinalClasses[0].IsShow_Entry_Class_IDNull())
                Show_Entry_Class_ID = tblShowFinalClasses[0].Show_Entry_Class_ID;
            Show_Final_Class_Description = tblShowFinalClasses[0].Show_Final_Class_Description;
            Show_Final_Class_No = tblShowFinalClasses[0].Show_Final_Class_No;
            if (!tblShowFinalClasses[0].IsJudge_IDNull())
                Judge_ID = tblShowFinalClasses[0].Judge_ID;
            if (!tblShowFinalClasses[0].IsStay_TimeNull())
                Stay_Time = tblShowFinalClasses[0].Stay_Time;
            if (!tblShowFinalClasses[0].IsLunch_TimeNull())
                Lunch_Time = tblShowFinalClasses[0].Lunch_Time;
        }
예제 #7
0
        public bool Update_Show_Final_Class(Guid show_Final_Class_ID, Guid user_ID)
        {
            bool success = false;

            ShowFinalClassesBL showfinalclasses = new ShowFinalClassesBL();
            success = showfinalclasses.Update_Show_Final_Classes(show_Final_Class_ID, Show_ID, Show_Entry_Class_ID,
                Show_Final_Class_Description, Show_Final_Class_No, Judge_ID, Stay_Time, Lunch_Time, DeleteShowFinalClass, user_ID);

            return success;
        }
예제 #8
0
        public Guid? Insert_Show_Final_Class(Guid user_ID)
        {
            ShowFinalClassesBL showfinalclasses = new ShowFinalClassesBL();
            Guid? newID = (Guid?)showfinalclasses.Insert_Show_Final_Classes(Show_ID, Show_Entry_Class_ID,
                Show_Final_Class_Description, Show_Final_Class_No, Judge_ID, Stay_Time, Lunch_Time, user_ID);

            return newID;
        }
예제 #9
0
        public List<ShowFinalClasses> GetShow_Final_ClassesByShow_ID(Guid show_ID)
        {
            List<ShowFinalClasses> showFinalClassList = new List<ShowFinalClasses>();
            ShowFinalClassesBL showfinalclasses = new ShowFinalClassesBL();
            tblShowFinalClasses = showfinalclasses.GetShow_Final_ClassesByShow_ID(show_ID);

            if (tblShowFinalClasses != null && tblShowFinalClasses.Count > 0)
            {
                foreach (sss.tblShow_Final_ClassesRow row in tblShowFinalClasses)
                {
                    ShowFinalClasses showFinalClass = new ShowFinalClasses(row.Show_Final_Class_ID);
                    showFinalClassList.Add(showFinalClass);
                }
            }

            return showFinalClassList;
        }
예제 #10
0
        public int DeleteShowFinalClassesByShowEntryClass(Guid show_Entry_Class_ID)
        {
            ShowFinalClassesBL showFinalClasses = new ShowFinalClassesBL();

            return showFinalClasses.DeleteShowFinalClassesByShowEntryClass(show_Entry_Class_ID);
        }