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; } }
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); }
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); }
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; } }
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(); } }
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); } }
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; } }
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(); } }
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."; } } } }
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; }
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(); } } }
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); }
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(); } }