Example #1
0
        public DogClasses(string connString, Guid dog_Class_ID)
        {
            _connString = connString;

            try
            {
                DogClassesBL dogClasses = new DogClassesBL(_connString);
                tblDogClasses = dogClasses.GetDog_ClassByDog_Class_ID(dog_Class_ID);
                DataRow row = tblDogClasses.Rows[0];

                _dog_Class_ID        = dog_Class_ID;
                _entrant_ID          = Utils.DBNullToGuid(row["Entrant_ID"]);
                _dog_ID              = Utils.DBNullToGuid(row["Dog_ID"]);
                _show_Entry_Class_ID = Utils.DBNullToGuid(row["Show_Entry_Class_ID"]);
                _preferred_Part      = Utils.DBNullToInt(row["Preferred_Part"]);
                _show_Final_Class_ID = Utils.DBNullToGuid(row["Show_Final_Class_ID"]);
                _handler_ID          = Utils.DBNullToGuid(row["Handler_ID"]);
                _ring_No             = Utils.DBNullToShort(row["Ring_No"]);
                _running_Order       = Utils.DBNullToShort(row["Running_Order"]);
                _special_Request     = Utils.DBNullToString(row["Special_Request"]);
                if (_show_Entry_Class_ID != null && _show_Entry_Class_ID != new Guid())
                {
                    Guid             sec_id = new Guid(_show_Entry_Class_ID.ToString());
                    ShowEntryClasses sec    = new ShowEntryClasses(_connString, sec_id);
                    if (sec.IsNFC)
                    {
                        IsNFC = true;
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Example #2
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);
        }
Example #3
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);
        }
Example #4
0
        public DogClasses(Guid dog_Class_ID)
        {
            DogClassesBL dogClasses = new DogClassesBL();
            tblDogClasses = dogClasses.GetDog_ClassByDog_Class_ID(dog_Class_ID);

            Dog_Class_ID = dog_Class_ID;
            IsEntrant_IDNull = tblDogClasses[0].IsEntrant_IDNull();
            if (!IsEntrant_IDNull)
                Entrant_ID = tblDogClasses[0].Entrant_ID;
            IsDog_IDNull = tblDogClasses[0].IsDog_IDNull();
            if (!IsDog_IDNull)
                Dog_ID = tblDogClasses[0].Dog_ID;
            IsShow_Entry_Class_IDNull = tblDogClasses[0].IsShow_Entry_Class_IDNull();
            if (!IsShow_Entry_Class_IDNull)
                Show_Entry_Class_ID = tblDogClasses[0].Show_Entry_Class_ID;
            IsShow_Final_Class_IDNull = tblDogClasses[0].IsShow_Final_Class_IDNull();
            if (!IsShow_Final_Class_IDNull)
                Show_Final_Class_ID = tblDogClasses[0].Show_Final_Class_ID;
            IsHandler_IDNull = tblDogClasses[0].IsHandler_IDNull();
            if (!IsHandler_IDNull)
                Handler_ID = tblDogClasses[0].Handler_ID;
            IsRing_NoNull = tblDogClasses[0].IsRing_NoNull();
            if (!IsRing_NoNull)
                Ring_No = tblDogClasses[0].Ring_No;
            IsRunning_OrderNull = tblDogClasses[0].IsRunning_OrderNull();
            if (!IsRunning_OrderNull)
                Running_Order = tblDogClasses[0].Running_Order;
            IsSpecial_RequestNull = tblDogClasses[0].IsSpecial_RequestNull();
            if (!IsSpecial_RequestNull)
                Special_Request = tblDogClasses[0].Special_Request;
            if (Show_Entry_Class_ID != null)
            {
                Guid sec_id = new Guid(Show_Entry_Class_ID.ToString());
                ShowEntryClasses sec = new ShowEntryClasses(sec_id);
                if (sec.IsNFC)
                    IsNFC = true;
            }
        }
Example #5
0
    protected void btnAddClass_Click(object sender, EventArgs e)
    {
        bool valid = true;
        if (string.IsNullOrEmpty(Club_ID))
        {
            MessageLabel.Text = "You must specify the Club";
        }
        else if (string.IsNullOrEmpty(Show_ID))
        {
            MessageLabel.Text = "You must specify the Show";
            valid = false;
        }
        else if (lstClassNames.SelectedIndex == -1 || lstClassNames.SelectedIndex == 0)
        {
            MessageLabel.Text = "You must select a Class Name";
            valid = false;
        }
        else if (string.IsNullOrEmpty(txtClassNo.Text))
        {
            MessageLabel.Text = "You must enter a Class Number";
            valid = false;
        }
        else if (lstClassGender.SelectedIndex == -1 || lstClassGender.SelectedIndex == 0)
        {
            MessageLabel.Text = "You must select a Class Gender";
            valid = false;
        }
        if (valid)
        {
            MembershipUser userInfo = Membership.GetUser();
            Guid user_ID = (Guid)userInfo.ProviderUserKey;

            if (string.IsNullOrEmpty(Class_Name_ID))
                Class_Name_ID = lstClassNames.SelectedValue;
            if (string.IsNullOrEmpty(Class_No))
                Class_No = txtClassNo.Text;
            if (string.IsNullOrEmpty(Class_Gender))
                Class_Gender = lstClassGender.SelectedValue;

            Guid show_ID = new Guid(Show_ID);
            int class_Name_ID = Convert.ToInt32(Class_Name_ID);
            short class_No = Convert.ToInt16(Class_No);
            short class_Gender = Convert.ToInt16(Class_Gender);

            ShowEntryClasses showEntryClasses = new ShowEntryClasses();
            showEntryClasses.Show_ID = show_ID;
            showEntryClasses.Class_Name_ID = class_Name_ID;
            showEntryClasses.Class_No = class_No;
            showEntryClasses.Class_Gender = class_Gender;

            Guid? show_Entry_Class_ID = showEntryClasses.Insert_Show_Entry_Class(user_ID);
            if (show_Entry_Class_ID != null)
            {
                Show_Entry_Class_ID = show_Entry_Class_ID.ToString();
                Common.Show_Entry_Class_ID = Show_Entry_Class_ID;
                MessageLabel.Text = "The Class Name was added successfully";
                ClearEntryFields();
                PopulateClassGridview(Show_ID);
                if (!string.IsNullOrEmpty(btnReturn.PostBackUrl))
                {
                    DivReturn.Visible = true;
                    divAddClasses.Visible = true;
                }
            }
        }
    }
 private void PopulateDogClassGridView()
 {
     List<DogClasses> tblDogClasses;
     DogClasses dogClasses = new DogClasses();
     Guid entrant_ID = new Guid(Entrant_ID);
     tblDogClasses = dogClasses.GetDog_ClassesByEntrant_ID(entrant_ID);
     List<DogClasses> dogClassList = new List<DogClasses>();
     foreach (DogClasses row in tblDogClasses)
     {
         if (!row.IsShow_Entry_Class_IDNull)
         {
             DogClasses dogClass = new DogClasses((Guid)row.Dog_Class_ID);
             Dogs dog = new Dogs((Guid)row.Dog_ID);
             dogClass.Dog_Class_ID = row.Dog_Class_ID;
             dogClass.Dog_KC_Name = dog.Dog_KC_Name;
             ShowEntryClasses showEntryClass = new ShowEntryClasses((Guid)row.Show_Entry_Class_ID);
             ClassNames className = new ClassNames(Int32.Parse(showEntryClass.Class_Name_ID.ToString()));
             dogClass.Class_Name_Description = string.Format("{0} : {1}", showEntryClass.Class_No, className.Description);
             if (!row.IsHandler_IDNull)
             {
                 People handler = new People((Guid)row.Handler_ID);
                 dogClass.Handler_Name = string.Format("{0} {1}", handler.Person_Forename, handler.Person_Surname);
             }
             dogClassList.Add(dogClass);
         }
     }
     if (dogClassList != null)
     {
         DogClassGridView.DataSource = dogClassList;
         DogClassGridView.DataBind();
     }
 }
Example #7
0
    protected void ClassGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        MembershipUser userInfo = Membership.GetUser();
        Guid user_ID = (Guid)userInfo.ProviderUserKey;

        string sec_id = ClassGridView.DataKeys[e.RowIndex]["Show_Entry_Class_ID"].ToString();
        Guid Show_Entry_Class_ID = new Guid(sec_id);
        ShowEntryClasses showEntryClasses = new ShowEntryClasses();
        showEntryClasses.DeleteShowEntryClass = true;
        if (showEntryClasses.Update_Show_Entry_Class(Show_Entry_Class_ID, user_ID))
        {
            PopulateClassGridview(Show_ID);
        }
    }
Example #8
0
    private void PopulateClassGridview(string show_ID)
    {
        bool valid = false;

        if (!string.IsNullOrEmpty(show_ID))
        {
            valid = true;
            if (valid)
            {
                if (!string.IsNullOrEmpty(show_ID))
                {
                    Guid newShow_ID = new Guid(show_ID);
                    ShowEntryClasses showEntryClasses = new ShowEntryClasses();
                    List<ShowEntryClasses> tblShowEntryClasses;
                    tblShowEntryClasses = showEntryClasses.GetShow_Entry_ClassesByShow_ID(newShow_ID);
                    ClassGridView.DataSource = tblShowEntryClasses;
                    ClassGridView.DataBind();
                }
            }
            divClassList.Visible = valid;
        }
    }
Example #9
0
 protected void DogGridView_RowDataBound(object sender, GridViewRowEventArgs e)
 {
     if (e.Row.RowType == DataControlRowType.DataRow)
     {
         string Dog_ID = ((HiddenField)e.Row.FindControl("hdnID")).Value;
         GridView gvClasses = e.Row.FindControl("ClassGridView") as GridView;
         List<DogClasses> tblDog_Classes;
         DogClasses dogClasses = new DogClasses();
         if (!string.IsNullOrEmpty(Dog_ID))
         {
             Guid dog_ID = new Guid(Dog_ID);
             tblDog_Classes = dogClasses.GetDog_ClassesByDog_ID(dog_ID);
             if (tblDog_Classes != null && tblDog_Classes.Count > 0)
             {
                 List<DogClasses> dogClassList = new List<DogClasses>();
                 foreach (DogClasses row in tblDog_Classes)
                 {
                     if (!row.IsShow_Entry_Class_IDNull)
                     {
                         DogClasses dogClass = new DogClasses((Guid)row.Dog_Class_ID);
                         Dogs dog = new Dogs((Guid)row.Dog_ID);
                         dogClass.Dog_Class_ID = row.Dog_Class_ID;
                         dogClass.Dog_KC_Name = dog.Dog_KC_Name;
                         ShowEntryClasses showEntryClass = new ShowEntryClasses((Guid)row.Show_Entry_Class_ID);
                         ClassNames className = new ClassNames(Int32.Parse(showEntryClass.Class_Name_ID.ToString()));
                         dogClass.Class_Name_Description = string.Format("{0} : {1}", showEntryClass.Class_No, className.Description);
                         if (!row.IsHandler_IDNull)
                         {
                             People handler = new People((Guid)row.Handler_ID);
                             dogClass.Handler_Name = string.Format("{0} {1}", handler.Person_Forename, handler.Person_Surname);
                         }
                         dogClassList.Add(dogClass);
                     }
                 }
                 if (dogClassList != null)
                 {
                     gvClasses.DataSource = dogClassList;
                     gvClasses.DataBind();
                 }
             }
         }
     }
 }
 private void PopulateClassList(string Show_ID)
 {
     if (!string.IsNullOrEmpty(Show_ID))
     {
         Guid show_ID = new Guid(Show_ID);
         ShowEntryClasses showEntryClasses = new ShowEntryClasses();
         List<ShowEntryClasses> tblShowEntryClasses = showEntryClasses.GetShow_Entry_ClassesByShow_ID(show_ID);
         List<ShowEntryClasses> classList = new List<ShowEntryClasses>();
         ShowEntryClasses allClasses = new ShowEntryClasses();
         allClasses.Class_Name_Description = "All Classes";
         allClasses.Show_Entry_Class_ID = new Guid();
         classList.Add(allClasses);
         foreach (ShowEntryClasses row in tblShowEntryClasses)
         {
             classList.Add(row);
         }
         lstClasses.DataSource = classList;
         lstClasses.DataBind();
     }
 }
Example #11
0
 protected void btnCommit_Click(object sender, EventArgs e)
 {
     FinalClassNameList = SplitClasses.DisplayFinalClassNames();
     StoreCommon();
     if (FinalClassNameList != null && FinalClassNameList.Count > 0)
     {
         MembershipUser userInfo = Membership.GetUser();
         Guid user_ID = (Guid)userInfo.ProviderUserKey;
         ClearFinalClassNames();
         foreach (FinalClassNames finalClassName in FinalClassNameList)
         {
             Guid? show_Final_Class_ID = null;
             ShowEntryClasses showEntryClass = new ShowEntryClasses(finalClassName.Show_Entry_Class_ID);
             ShowFinalClasses showFinalClass = new ShowFinalClasses();
             showFinalClass.Show_ID = showEntryClass.Show_ID;
             showFinalClass.Show_Entry_Class_ID = showEntryClass.Show_Entry_Class_ID;
             showFinalClass.Show_Final_Class_Description = finalClassName.Show_Final_Class_Description;
             showFinalClass.Show_Final_Class_No = finalClassName.OrderBy;
             show_Final_Class_ID = showFinalClass.Insert_Show_Final_Class(user_ID);
             if (show_Final_Class_ID == null)
             {
                 MessageLabel.Text = "Show Final Class Insert Failed!";
                 break;
             }
             else
             {
                 MessageLabel.Text = "Show Final Class Insert Successful.";
             }
         }
     }
 }
Example #12
0
        public static bool AllocateDogsToFinalClasses(Guid show_ID, Guid user_ID)
        {
            bool success = false;
            List<ShowEntryClasses> showEntryClassList = new List<ShowEntryClasses>();
            ShowEntryClasses showEntryClasses = new ShowEntryClasses();
            showEntryClassList = showEntryClasses.GetShow_Entry_ClassesByShow_ID(show_ID);
            foreach (ShowEntryClasses showEntryClass in showEntryClassList)
            {
                List<ShowFinalClasses> showFinalClassList = new List<ShowFinalClasses>();
                ShowFinalClasses showFinalClasses = new ShowFinalClasses();
                showFinalClassList = showFinalClasses.GetShow_Final_ClassesByShow_Entry_Class_ID(showEntryClass.Show_Entry_Class_ID);
                if (showFinalClassList != null && showFinalClassList.Count > 0)
                {
                    List<DogClasses> dogClassList = new List<DogClasses>();
                    DogClasses dogClasses = new DogClasses();
                    dogClassList = dogClasses.GetDog_ClassesByShow_Entry_Class_ID(showEntryClass.Show_Entry_Class_ID);
                    if (showFinalClassList.Count == 1)
                    {
                        foreach (DogClasses dogClass in dogClassList)
                        {
                            dogClass.Show_Final_Class_ID = showFinalClassList[0].Show_Final_Class_ID;
                            Guid dog_Class_ID = new Guid(dogClass.Dog_Class_ID.ToString());
                            success = dogClass.Update_Dog_Class(dog_Class_ID, user_ID);
                        }
                    }
                    else
                    {
                        List<ClassParts> classParts = new List<ClassParts>();
                        foreach (ShowFinalClasses showFinalClass in showFinalClassList)
                        {
                            ClassParts classPart = new ClassParts();
                            FinalClassNames finalClassNames = new FinalClassNames(showFinalClass.Show_Final_Class_No);
                            classPart.Show_Final_Class_ID = showFinalClass.Show_Final_Class_ID;
                            classPart.Show_Final_Class_Description = showFinalClass.Show_Final_Class_Description;
                            classPart.MaxDogsInPart = finalClassNames.Entries;
                            classParts.Add(classPart);
                        }
                        List<DogsInClass> allDogsInClass = new List<DogsInClass>();
                        allDogsInClass = AllocateDogsToClassParts(dogClassList, classParts);
                        List<DogClasses> failedUpdateList = new List<DogClasses>();
                        foreach (DogsInClass dog in allDogsInClass)
                        {
                            DogClasses dogClass = new DogClasses(dog.Dog_Class_ID);
                            dogClass.Show_Final_Class_ID = dog.Show_Final_Class_ID;
                            success = dogClass.Update_Dog_Class(dog.Dog_Class_ID, user_ID);
                            if (!success)
                                failedUpdateList.Add(dogClass);
                        }
                    }
                }

            }
            return success;
        }
Example #13
0
        private void SetOwnerDogCounts(sss.tblOwnersDogsClassesDrawnListRow row, Guid show_ID)
        {
            RunningOrders.OwnerDogCount = 0;
            RunningOrders.OwnerDogsInClassCount = 0;
            RunningOrders.ClassesPerOwnerEnteredCount = 0;
            RunningOrders.ClassesPerDogEnteredCount = 0;

            List<Guid> ownerDogsList = new List<Guid>();
            List<Guid> ownerDogsInClassList = new List<Guid>();
            List<Guid> classesPerOwnerEnteredList = new List<Guid>();
            List<Guid> classesPerDogEnteredList = new List<Guid>();
            DogClasses dogClass = new DogClasses();
            List<DogClasses> dogClasses1 = dogClass.GetDog_ClassesByDog_ID((Guid)row.Dog_ID);
            foreach (DogClasses dogClass1 in dogClasses1)
            {
                ShowFinalClasses sfc = new ShowFinalClasses((Guid)dogClass1.Show_Final_Class_ID);
                if ((Guid)sfc.Show_ID == show_ID)
                {
                    if (classesPerDogEnteredList.IndexOf((Guid)dogClass1.Show_Entry_Class_ID) == -1)
                        classesPerDogEnteredList.Add((Guid)dogClass1.Show_Entry_Class_ID);
                }
            }
            DogOwners dogOwner = new DogOwners();
            List<DogOwners> dogOwnerList = dogOwner.GetDogOwnersByOwner_ID(row.Owner_ID);
            foreach (DogOwners dogOwnerRow in dogOwnerList)
            {
                List<DogClasses> dogClasses = dogClass.GetDog_ClassesByEntrant_ID(row.Entrant_ID);
                foreach (DogClasses dcRow in dogClasses)
                {
                    ShowFinalClasses sfc = new ShowFinalClasses((Guid)dcRow.Show_Final_Class_ID);
                    if ((Guid)sfc.Show_ID == show_ID)
                    {
                        Guid dog_ID = (Guid)dcRow.Dog_ID;
                        Guid dog_Class_ID = (Guid)dcRow.Dog_Class_ID;
                        Guid show_Entry_Class_ID = (Guid)dcRow.Show_Entry_Class_ID;
                        ShowEntryClasses sec = new ShowEntryClasses(show_Entry_Class_ID);
                        ClassNames cn = new ClassNames(int.Parse(sec.Class_Name_ID.ToString()));
                        if (cn.Class_Name_Description != "NFC")
                        {
                            if (ownerDogsList.IndexOf(dog_ID) == -1)
                                ownerDogsList.Add(dog_ID);
                            if (classesPerOwnerEnteredList.IndexOf(show_Entry_Class_ID) == -1)
                                classesPerOwnerEnteredList.Add(show_Entry_Class_ID);
                            if (dcRow.Show_Entry_Class_ID == sfc.Show_Entry_Class_ID)
                            {
                                if (ownerDogsInClassList.IndexOf(dog_ID) == -1)
                                    ownerDogsInClassList.Add(dog_ID);
                            }
                        }
                    }
                }
            }
            RunningOrders.OwnerDogCount = ownerDogsList.Count;
            RunningOrders.OwnerDogsInClassCount = ownerDogsInClassList.Count;
            RunningOrders.ClassesPerOwnerEnteredCount = classesPerOwnerEnteredList.Count;
            RunningOrders.ClassesPerDogEnteredCount = classesPerDogEnteredList.Count;
        }
    private bool IsCorrectClassGender(Dogs dog)
    {
        bool correctGender = false;
        ShowEntryClasses sec = new ShowEntryClasses(new Guid(Show_Entry_Class_ID));
        DogGender dg = new DogGender((int)dog.Dog_Gender_ID);
        switch (dg.Description)
        {
            case "Dog":
                if (sec.Class_Gender == Constants.CLASS_GENDER_DB || sec.Class_Gender == Constants.CLASS_GENDER_D)
                    correctGender = true;
                break;
            case "Bitch":
                if (sec.Class_Gender == Constants.CLASS_GENDER_DB || sec.Class_Gender == Constants.CLASS_GENDER_B)
                    correctGender = true;
                break;
            default:
                break;
        }

        return correctGender;
    }
    private string GetClassName(Guid show_Entry_Class_ID)
    {
        ShowEntryClasses sec = new ShowEntryClasses(show_Entry_Class_ID);
        ClassNames cn = new ClassNames((int)sec.Class_Name_ID);

        return cn.Description;
    }
    protected void btnAddDogClass_Click(object sender, EventArgs e)
    {
        GetFormFields();
        StoreCommon();
        if (ValidEntry())
        {
            MembershipUser userInfo = Membership.GetUser();
            Guid user_ID = (Guid)userInfo.ProviderUserKey;

            List<DogClasses> tblDogClasses;
            DogClasses dogClasses = new DogClasses();
            Guid dog_ID = new Guid(Dog_ID);
            Guid show_Entry_Class_ID = new Guid(Show_Entry_Class_ID);
            Guid entrant_ID = new Guid(Entrant_ID);
            tblDogClasses = dogClasses.GetDog_ClassesByEntrant_ID(entrant_ID);
            bool rowUpdated = false;
            bool success = false;
            foreach (DogClasses row in tblDogClasses)
            {
                if (dog_ID == row.Dog_ID && !rowUpdated)
                {
                    if (row.IsShow_Entry_Class_IDNull || (!row.IsShow_Entry_Class_IDNull && row.Show_Entry_Class_ID == show_Entry_Class_ID))
                    {
                        Dog_Class_ID = row.Dog_Class_ID.ToString();
                        Guid dog_Class_ID = new Guid(Dog_Class_ID);
                        DogClasses dogClass = new DogClasses(dog_Class_ID);
                        dogClass.Show_Entry_Class_ID = show_Entry_Class_ID;
                        if (!string.IsNullOrEmpty(Special_Request))
                            dogClass.Special_Request = Special_Request;
                        if (!string.IsNullOrEmpty(Handler_ID))
                        {
                            if (GetClassName(show_Entry_Class_ID) != "NFC")
                            {
                                Guid handler_ID = new Guid(Handler_ID);
                                dogClass.Handler_ID = handler_ID;
                            }
                        }
                        dogClass.DeleteDogClass = false;
                        if (dogClass.Update_Dog_Class(dog_Class_ID, user_ID))
                        {
                            rowUpdated = true;
                            success = true;
                        }
                    }
                }
            }
            if (!rowUpdated)
            {
                DogClasses dogClass = new DogClasses();
                dogClass.Entrant_ID = entrant_ID;
                dogClass.Dog_ID = dog_ID;
                dogClass.Show_Entry_Class_ID = show_Entry_Class_ID;
                if (!string.IsNullOrEmpty(Special_Request))
                    dogClass.Special_Request = Special_Request;
                if (!string.IsNullOrEmpty(Handler_ID))
                {
                    if (GetClassName(show_Entry_Class_ID) != "NFC")
                    {
                        Guid handler_ID = new Guid(Handler_ID);
                        dogClass.Handler_ID = handler_ID;
                    }
                }
                Guid? dog_Class_ID = new Guid?();
                dog_Class_ID = dogClass.Insert_Dog_Class(user_ID);
                if (dog_Class_ID != null)
                    success = true;
            }
            if (success)
            {
                ShowEntryClasses showEntryClass = new ShowEntryClasses(show_Entry_Class_ID);
                int class_Name_ID = Int32.Parse(showEntryClass.Class_Name_ID.ToString());
                ClassNames className = new ClassNames(class_Name_ID);
                string class_Name_Description = className.Description;
                Dogs dog = new Dogs(dog_ID);
                MessageLabel.Text = string.Format("{0} was successfully added to {1}.", dog.Dog_KC_Name, class_Name_Description);
                PopulateDogClassGridView();
                ClearFormFields();
            }
        }
    }
Example #17
0
        public static bool AllocateDogsToFinalClasses(string connString, Guid show_ID, Guid user_ID)
        {
            bool retVal = false;

            try
            {
                List <ShowEntryClasses> showEntryClassList = new List <ShowEntryClasses>();
                ShowEntryClasses        showEntryClasses   = new ShowEntryClasses(connString);
                showEntryClassList = showEntryClasses.GetShow_Entry_ClassesByShow_ID(show_ID);
                foreach (ShowEntryClasses showEntryClass in showEntryClassList)
                {
                    List <ShowFinalClasses> showFinalClassList = new List <ShowFinalClasses>();
                    ShowFinalClasses        showFinalClasses   = new ShowFinalClasses(connString);
                    showFinalClassList = showFinalClasses.GetShow_Final_ClassesByShow_Entry_Class_ID(showEntryClass.Show_Entry_Class_ID);
                    if (showFinalClassList != null && showFinalClassList.Count > 0)
                    {
                        List <DogClasses> dogClassList = new List <DogClasses>();
                        DogClasses        dogClasses   = new DogClasses(connString);
                        dogClassList = dogClasses.GetDog_ClassesByShow_Entry_Class_ID(showEntryClass.Show_Entry_Class_ID);
                        if (showFinalClassList.Count == 1)
                        {
                            foreach (DogClasses dogClass in dogClassList)
                            {
                                dogClass.Show_Final_Class_ID = showFinalClassList[0].Show_Final_Class_ID;
                                Guid dog_Class_ID = new Guid(dogClass.Dog_Class_ID.ToString());
                                retVal = dogClass.Update_Dog_Class(dog_Class_ID, user_ID);
                            }
                        }
                        else
                        {
                            List <ClassParts> classParts = new List <ClassParts>();
                            foreach (ShowFinalClasses showFinalClass in showFinalClassList)
                            {
                                ClassParts      classPart       = new ClassParts();
                                FinalClassNames finalClassNames = new FinalClassNames(connString, showFinalClass.Show_Final_Class_No);
                                classPart.Show_Final_Class_ID          = showFinalClass.Show_Final_Class_ID;
                                classPart.Show_Final_Class_Description = showFinalClass.Show_Final_Class_Description;
                                classPart.MaxDogsInPart = finalClassNames.Entries;
                                classParts.Add(classPart);
                            }
                            List <DogsInClass> allDogsInClass = new List <DogsInClass>();
                            allDogsInClass = AllocateDogsToClassParts(connString, dogClassList, classParts, show_ID);
                            List <DogClasses> failedUpdateList = new List <DogClasses>();
                            foreach (DogsInClass dog in allDogsInClass)
                            {
                                DogClasses dogClass = new DogClasses(connString, dog.Dog_Class_ID);
                                dogClass.Show_Final_Class_ID = dog.Show_Final_Class_ID;
                                retVal = dogClass.Update_Dog_Class(dog.Dog_Class_ID, user_ID);
                                if (!retVal)
                                {
                                    failedUpdateList.Add(dogClass);
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(retVal);
        }
Example #18
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;
        }
    private void PopulateListBoxes()
    {
        List<DogClasses> tblDogClasses;
        DogClasses dogClasses = new DogClasses();
        Guid entrant_ID = new Guid(Entrant_ID);
        tblDogClasses = dogClasses.GetDog_ClassesByEntrant_ID(entrant_ID);
        List<Dogs> dogs = new List<Dogs>();
        foreach (DogClasses row in tblDogClasses)
        {
            Dogs dog = new Dogs((Guid)row.Dog_ID);
            Dogs dg = dogs.Find(delegate(Dogs d) { return d.Dog_ID == row.Dog_ID; });
            if (dg == null)
                dogs.Add(dog);
        }
        lstDogs.DataSource = dogs;
        lstDogs.DataBind();

        if (!string.IsNullOrEmpty(Show_ID))
        {
            Guid show_ID = new Guid(Show_ID);
            ShowEntryClasses showEntryClasses = new ShowEntryClasses();
            List<ShowEntryClasses> tblShowEntryClasses = showEntryClasses.GetShow_Entry_ClassesByShow_ID(show_ID);
            lstClasses.DataSource = tblShowEntryClasses;
            lstClasses.DataBind();
        }
    }