private void PopulateOwnerList(Guid entrant_ID)
{
bool foundOwner = false;
List<DogClasses> tblDogClasses;
DogClasses dogClasses = new DogClasses();
tblDogClasses = dogClasses.GetDog_ClassesByEntrant_ID(entrant_ID);
foreach (DogClasses dogClassesRow in tblDogClasses)
{
Guid dog_ID = new Guid(dogClassesRow.Dog_ID.ToString());
List<DogOwners> lnkDogOwners;
DogOwners dogOwners = new DogOwners();
lnkDogOwners = dogOwners.GetDogOwnersByDog_ID(dog_ID);
foreach (DogOwners row in lnkDogOwners)
{
AddOwnerToList(row.Owner_ID.ToString());
foundOwner = true;
}
}
if (foundOwner)
divOwnerList.Visible = true;
}
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 InsertDogClass(Guid entrant_ID, Guid user_ID)
{
bool insertOK=true;
for (int i = 0; i < Common.MyDogList.Count; i++)
{
bool dogFound = false;
List<DogClasses> tblDogClasses;
DogClasses dogClasses = new DogClasses();
tblDogClasses=dogClasses.GetDog_ClassesByEntrant_ID(entrant_ID);
foreach (DogClasses row in tblDogClasses)
{
if (Common.MyDogList[i].Dog_ID == row.Dog_ID)
{
dogFound = true;
}
}
if (!dogFound)
{
DogClasses dogClass = new DogClasses();
dogClass.Entrant_ID = entrant_ID;
dogClass.Dog_ID = Common.MyDogList[i].Dog_ID;
Guid? dog_Class_ID = dogClass.Insert_Dog_Class(user_ID);
if (dog_Class_ID == null)
insertOK = false;
}
}
return insertOK;
}
private void PopulateDogList(Guid entrant_ID)
{
if (Common.MyDogList == null)
{
List<DogClasses> tblDogClasses;
DogClasses dogClasses = new DogClasses();
tblDogClasses = dogClasses.GetDog_ClassesByEntrant_ID(entrant_ID);
foreach (DogClasses dogClassesRow in tblDogClasses)
{
AddDogToList(dogClassesRow.Dog_ID.ToString());
}
}
}
private bool DeleteDogClass(Guid entrant_ID, Guid user_ID)
{
bool deletedOK = false;
List<DogClasses> tblDogClasses;
DogClasses dogClasses = new DogClasses();
tblDogClasses = dogClasses.GetDog_ClassesByEntrant_ID(entrant_ID);
foreach (DogClasses row in tblDogClasses)
{
bool dogFound = false;
for (int i = 0; i < Common.MyDogList.Count; i++)
{
if (Common.MyDogList[i].Dog_ID == row.Dog_ID)
{
dogFound = true;
}
}
if (!dogFound)
{
DogClasses dc = new DogClasses((Guid)row.Dog_Class_ID);
dc.DeleteDogClass = true;
deletedOK = dc.Update_Dog_Class((Guid)row.Dog_Class_ID, user_ID);
}
}
return deletedOK;
}
private short HasDogChanges()
{
bool Changed = false;
short del = Constants.DATA_NO_CHANGE;
short ins = Constants.DATA_NO_CHANGE;
List<DogClasses> tblDogClasses;
DogClasses dogClasses = new DogClasses();
Guid entrant_ID = new Guid(Entrant_ID);
tblDogClasses = dogClasses.GetDog_ClassesByEntrant_ID(entrant_ID);
foreach (DogClasses dogClassesRow in tblDogClasses)
{
bool foundDog = false;
for (int i = 0; i < Common.MyDogList.Count; i++)
{
if (Common.MyDogList[i].Dog_ID == dogClassesRow.Dog_ID)
//Dog in table still exists in list
foundDog = true;
}
if (!foundDog)
//Dog in table no longer exists in list (deleted)
Changed = true;
}
if (Changed)
del = Constants.DATA_DELETED;
Changed = false;
for (int i = 0; i < Common.MyDogList.Count; i++)
{
bool foundDog = false;
foreach (DogClasses dogClassesRow in tblDogClasses)
{
if (Common.MyDogList[i].Dog_ID == dogClassesRow.Dog_ID)
//Dog in List already exists in table
foundDog = true;
}
if (!foundDog)
//Dog in list does not exist in table (inserted)
Changed = true;
}
if (Changed)
ins = Constants.DATA_INSERTED;
return del += ins;
}
private void PopulateDogList()
{
List<DogClasses> tblDog_Classes;
DogClasses dogClasses = new DogClasses();
Guid entrant_ID = new Guid(Common.Entrant_ID);
DogList dogList = new DogList();
tblDog_Classes = dogClasses.GetDog_ClassesByEntrant_ID(entrant_ID);
if (tblDog_Classes != null && tblDog_Classes.Count > 0)
{
DogOwnerList dogOwnerList = new DogOwnerList();
foreach (DogClasses dogClassRow in tblDog_Classes)
{
Dogs dog = new Dogs((Guid)dogClassRow.Dog_ID);
dogList.AddDog(dog);
}
}
if (dogList != null)
Common.MyDogList = dogList.MyDogList;
}
protected void btnUpdateCompetitor_Click(object sender, EventArgs e)
{
SaveFormFields();
StoreCommon();
if (ValidEntry())
{
MembershipUser userInfo = Membership.GetUser();
Guid user_ID = (Guid)userInfo.ProviderUserKey;
Guid entrant_ID = new Guid(Entrant_ID);
bool EntrantChanges = false;
bool EntrantSuccess = false;
bool DogChanges = false;
bool DogSuccess = false;
if (HasEntrantChanges())
{
EntrantChanges = true;
Entrants entrant = new Entrants();
Guid show_ID = new Guid(Show_ID);
entrant.Show_ID = show_ID;
if (Catalogue)
entrant.Catalogue = Catalogue;
if (Overnight_Camping)
entrant.Overnight_Camping = Overnight_Camping;
if (!string.IsNullOrEmpty(Overpayment))
entrant.Overpayment = decimal.Parse(Overpayment);
if (!string.IsNullOrEmpty(Underpayment))
entrant.Underpayment = decimal.Parse(Underpayment);
if (Offer_Of_Help)
entrant.Offer_Of_Help = Offer_Of_Help;
if (!string.IsNullOrEmpty(Help_Details))
entrant.Help_Details = Help_Details;
if (Withold_Address)
entrant.Withold_Address = Withold_Address;
if (Send_Running_Order)
entrant.Send_Running_Order = Send_Running_Order;
if (!string.IsNullOrEmpty(Entry_Date))
{
if (entrant.Entry_Date.ToString() != Entry_Date && !string.IsNullOrEmpty(Entry_Date))
entrant.Entry_Date = DateTime.Parse(Entry_Date);
}
EntrantSuccess = entrant.Update_Entrant(entrant_ID, user_ID);
}
else
EntrantSuccess = true;
List<DogClasses> tblDogClasses;
DogClasses dogClasses = new DogClasses();
tblDogClasses = dogClasses.GetDog_ClassesByEntrant_ID(entrant_ID);
bool insertOK = true;
bool deleteOK = true;
switch (HasDogChanges())
{
case Constants.DATA_NO_CHANGE:
DogSuccess = true;
break;
case Constants.DATA_INSERTED:
DogChanges = true;
insertOK = InsertDogClass(entrant_ID, user_ID);
if (insertOK)
DogSuccess = true;
else
MessageLabel.Text = "Insert_Dog_Class Failed";
break;
case Constants.DATA_DELETED:
DogChanges = true;
deleteOK = DeleteDogClass(entrant_ID, user_ID);
if (deleteOK)
DogSuccess = true;
else
MessageLabel.Text = "Delete_Dog_Class Failed";
break;
case Constants.DATA_INSERTED_AND_DELETED:
DogChanges = true;
insertOK = InsertDogClass(entrant_ID, user_ID);
deleteOK = DeleteDogClass(entrant_ID, user_ID);
if (insertOK && deleteOK)
DogSuccess = true;
else
{
MessageLabel.Text = string.Empty;
if (!insertOK)
MessageLabel.Text = "Insert_Dog_Class Failed";
if (!deleteOK)
MessageLabel.Text += "Delete_Dog_Class Failed";
}
break;
default:
break;
}
if (EntrantChanges && !EntrantSuccess)
MessageLabel.Text = "Update_Entrant Failed!";
if (DogChanges && !DogSuccess)
MessageLabel.Text += " Error with Dog Changes!";
if (!EntrantChanges && !DogChanges)
{
string returnChars = Common.AppendReturnChars(Request.QueryString, "coc");
Server.Transfer("~/Competitors/AddDogToClasses.aspx?" + returnChars);
}
if (EntrantSuccess && DogSuccess)
{
string returnChars = Common.AppendReturnChars(Request.QueryString, "coc");
Server.Transfer("~/Competitors/AddDogToClasses.aspx?" + returnChars);
}
}
}
protected void EntryGridView_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
EntryGridRowIndex = e.Row.RowIndex;
Entrant_ID = EntryGridView.DataKeys[EntryGridRowIndex].Value.ToString();
if (!string.IsNullOrEmpty(Entrant_ID))
{
Guid entrant_ID = new Guid(Entrant_ID);
GridView gvDogs = e.Row.FindControl("DogGridView") as GridView;
GridView gvOwners = e.Row.FindControl("OwnerGridView") as GridView;
List<DogClasses> tblDog_Classes;
DogClasses dogClasses = new DogClasses();
tblDog_Classes = dogClasses.GetDog_ClassesByEntrant_ID(entrant_ID, ExclNFC);
if (tblDog_Classes != null && tblDog_Classes.Count > 0)
{
DogOwnerList dogOwnerList = new DogOwnerList();
DogList dogList = new DogList();
foreach (DogClasses dogClassRow in tblDog_Classes)
{
Dogs dog = new Dogs((Guid)dogClassRow.Dog_ID);
dogList.AddDog(dog);
List<DogOwners> lnkDog_Owners;
DogOwners dogOwner = new DogOwners();
lnkDog_Owners = dogOwner.GetDogOwnersByDog_ID((Guid)dogClassRow.Dog_ID);
if (lnkDog_Owners != null && lnkDog_Owners.Count > 0)
{
foreach (DogOwners dogOwnerRow in lnkDog_Owners)
{
People person = new People(dogOwnerRow.Owner_ID);
dogOwnerList.AddOwner(person);
}
gvOwners.DataSource = dogOwnerList.MyDogOwnerList;
gvOwners.DataBind();
}
dogList.SortDogList();
gvDogs.DataSource = dogList.MyDogList;
gvDogs.DataBind();
}
}
}
}
}
private bool ValidEntry()
{
bool valid = true;
Guid show_ID = new Guid(Show_ID);
Shows show = new Shows(show_ID);
List<DogClasses> tblDogClasses;
DogClasses dogClasses = new DogClasses();
Guid entrant_ID = new Guid(Entrant_ID);
tblDogClasses = dogClasses.GetDog_ClassesByEntrant_ID(entrant_ID);
short dogClassCount = 0;
if (string.IsNullOrEmpty(Handler_ID) && lstClasses.SelectedItem.Text != "NFC")
{
MessageLabel.Text = "You must select the Handler.";
valid = false;
}
if (!string.IsNullOrEmpty(Dog_ID) && lstClasses.SelectedItem.Text != "NFC")
{
Guid dog_ID = new Guid(Dog_ID);
Dogs dog = new Dogs(dog_ID);
if (!IsCorrectClassGender(dog))
{
MessageLabel.Text = "This dog is the wrong gender for this class.";
valid = false;
}
}
foreach (DogClasses row in tblDogClasses)
{
if (!row.IsShow_Entry_Class_IDNull && Dog_ID == row.Dog_ID.ToString())
{
if (Show_Entry_Class_ID == row.Show_Entry_Class_ID.ToString())
{
MessageLabel.Text = string.Format("You have already entered this dog in {0}.", GetClassName((Guid)row.Show_Entry_Class_ID));
valid = false;
}
else if (lstClasses.SelectedItem.Text == "NFC" && GetClassName((Guid)row.Show_Entry_Class_ID) != "NFC")
{
MessageLabel.Text = "This dog is already entered in other classes, so cannot be NFC";
valid = false;
}
else if (GetClassName((Guid)row.Show_Entry_Class_ID) == "NFC")
{
MessageLabel.Text = "This dog is entered NFC so cannot be entered in other classes.";
valid = false;
}
if (valid)
{
dogClassCount += 1;
if (dogClassCount >= show.MaxClassesPerDog)
{
MessageLabel.Text = string.Format("There is a maximum of {0} classes per dog for this show.", show.MaxClassesPerDog.ToString());
valid = false;
}
}
}
}
return valid;
}
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();
}
}
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 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();
}
}
}