private void EditBreed() { int selectedBreed = -1; cboNewValue = new ComboBox(); cboNewValue.Width = panel1.Width; panel1.Controls.Add(cboNewValue); dog = new Dogs(_connString, new Guid(_dogID)); DogBreeds db = new DogBreeds(_connString); List <DogBreeds> breedList = db.GetDog_Breeds(); foreach (DogBreeds breed in breedList) { ComboBoxItem item = new ComboBoxItem(); item.Text = breed.Description; item.Value = breed.Dog_Breed_ID; cboNewValue.Items.Add(item); if (dog.Dog_Breed_ID == breed.Dog_Breed_ID) { selectedBreed = breed.Dog_Breed_ID; lblCurrentValue.Text = breed.Description; lblCurrentValue.Visible = true; } } }
private void PopulateBreedList() { DogBreeds dogBreeds = new DogBreeds(_connString); List <DogBreeds> lkpDog_Breeds = dogBreeds.GetDog_Breeds(); lstDogBreeds.DataSource = lkpDog_Breeds; lstDogBreeds.DataBind(); }
private int?GetBreedIDFromBreedName(string breedName) { if (string.IsNullOrEmpty(breedName)) { breedName = "Not Specified"; } DogBreeds breed = new DogBreeds(Utils.ConnectionString()); List <DogBreeds> breedList = breed.GetDog_BreedsByDog_Breed_Description(breedName); if (breedList.Count > 0) { return(breedList[0].Dog_Breed_ID); } //Create New Dog Breed if not empty int?breed_ID = breed.Insert_Dog_Breed(breedName); return(breed_ID); }
protected void btnDogSearch_Click(object sender, EventArgs e) { //ResetPage(); //ClearEntryFields(); string searchValue = txtDogFilter.Text; Dogs dog = new Dogs(_connString); List <Dogs> tblDogs = null; if (DogSearchType.SelectedValue == "c") { searchValue = string.Format("%{0}", searchValue); } switch (DogFilterBy.SelectedValue) { case "KC_Name": tblDogs = dog.GetDogsLikeDog_KC_Name(searchValue); break; case "Pet_Name": tblDogs = dog.GetDogsLikeDog_Pet_Name(searchValue); break; case "Breed_ID": DogBreeds dogBreeds = new DogBreeds(_connString); List <DogBreeds> lkpDogBreeds = null; lkpDogBreeds = dogBreeds.GetDog_BreedsByDog_Breed_Description(searchValue); tblDogs = dog.GetDogsByDog_Breed_ID(lkpDogBreeds); break; default: tblDogs = dog.GetDogs(); break; } Common.Dog_GridViewData = tblDogs; PopulateDogGridView(Common.Dog_GridViewData, 1); txtDogFilter.Text = string.Empty; DogFilterBy.SelectedIndex = -1; DogSearchType.SelectedIndex = -1; }
protected void btnAddBreed_Click(object sender, EventArgs e) { string strDogBreed = txtNewBreed.Text; if (!string.IsNullOrEmpty(strDogBreed)) { DogBreeds dogBreeds = new DogBreeds(_connString); int? newDogBreedID = dogBreeds.Insert_Dog_Breed(strDogBreed); if (newDogBreedID != null && newDogBreedID > 0) { MessageLabel.Text = string.Format("{0} was added to the Dog Breed Table", strDogBreed); } else { MessageLabel.Text = "Error inserting the record"; } } else { MessageLabel.Text = "Nothing Entered!"; } }
private void PopulateSire() { Guid sire_ID = new Guid(Sire_ID); Dogs dog = new Dogs(_connString, sire_ID); txtSireKCName.Text = dog.Dog_KC_Name; txtSirePetName.Text = dog.Dog_Pet_Name; if (dog.Dog_Breed_ID != null && dog.Dog_Breed_ID != 1) { int dog_Breed_ID = Int32.Parse(dog.Dog_Breed_ID.ToString()); DogBreeds dogBreeds = new DogBreeds(_connString, dog_Breed_ID); txtSireBreed.Text = dogBreeds.Description; } if (dog.Dog_Gender_ID != null && dog.Dog_Gender_ID != 1) { int dog_Gender_ID = Int32.Parse(dog.Dog_Gender_ID.ToString()); DogGender dogGender = new DogGender(_connString, dog_Gender_ID); txtSireGender.Text = dogGender.Description; } divGetSire.Visible = false; divChangeSire.Visible = true; divSireDetails.Visible = true; }
private void PopulateDam() { Guid dam_ID = new Guid(Dam_ID); Dogs dog = new Dogs(_connString, dam_ID); txtDamKCName.Text = dog.Dog_KC_Name; txtDamPetName.Text = dog.Dog_Pet_Name; if (dog.Dog_Breed_ID != null && dog.Dog_Breed_ID != 1) { int dog_Breed_ID = Int32.Parse(dog.Dog_Breed_ID.ToString()); DogBreeds dogBreeds = new DogBreeds(_connString, dog_Breed_ID); txtDamBreed.Text = dogBreeds.Description; } if (dog.Dog_Gender_ID != null && dog.Dog_Gender_ID != 1) { int dog_Gender_ID = Int32.Parse(dog.Dog_Gender_ID.ToString()); DogGender dogGender = new DogGender(_connString, dog_Gender_ID); txtDamGender.Text = dogGender.Description; } divGetDam.Visible = false; divChangeDam.Visible = true; divDamDetails.Visible = true; }
public ShelterDogs(DogBreeds b) { Breed = b; }
private void PopulateDogClassesGrid(string entrantID) { string connString = Utils.ConnectionString(); Guid entrant_ID = new Guid(entrantID); DogClasses dogClasses = new DogClasses(connString); List <DogClasses> dcList = dogClasses.GetDog_ClassesByEntrant_ID(entrant_ID); DataTable dt = new DataTable(); DataColumn dcDogClassID = new DataColumn("DogClassID"); DataColumn dcEntrantID = new DataColumn("EntrantID"); DataColumn dcDogID = new DataColumn("DogID"); DataColumn dcKCName = new DataColumn("KCName"); DataColumn dcBreed = new DataColumn("Breed"); DataColumn dcGender = new DataColumn("Gender"); DataColumn dcRegNo = new DataColumn("RegNo"); DataColumn dcDOB = new DataColumn("DOB"); DataColumn dcMeritPoints = new DataColumn("MeritPoints"); DataColumn dcBreeder = new DataColumn("Breeder"); DataColumn dcSire = new DataColumn("Sire"); DataColumn dcDam = new DataColumn("Dam"); DataColumn dcEntryClassName = new DataColumn("EntryClassName"); DataColumn dcPreferredPart = new DataColumn("PreferredPart"); DataColumn dcFinalClassName = new DataColumn("FinalClassName"); DataColumn dcHandler = new DataColumn("Handler"); DataColumn dcRingNo = new DataColumn("RingNo"); DataColumn dcRunningOrder = new DataColumn("RunningOrder"); DataColumn dcSpecialRequest = new DataColumn("SpecialRequest"); dt.Columns.Add(dcDogClassID); dt.Columns.Add(dcEntrantID); dt.Columns.Add(dcDogID); dt.Columns.Add(dcKCName); dt.Columns.Add(dcBreed); dt.Columns.Add(dcGender); dt.Columns.Add(dcRegNo); dt.Columns.Add(dcDOB); dt.Columns.Add(dcMeritPoints); dt.Columns.Add(dcBreeder); dt.Columns.Add(dcSire); dt.Columns.Add(dcDam); dt.Columns.Add(dcEntryClassName); dt.Columns.Add(dcPreferredPart); dt.Columns.Add(dcFinalClassName); dt.Columns.Add(dcHandler); dt.Columns.Add(dcRingNo); dt.Columns.Add(dcRunningOrder); dt.Columns.Add(dcSpecialRequest); object[] dogRow = new object[19]; foreach (DogClasses dc in dcList) { Dogs dog = new Dogs(connString, (Guid)dc.Dog_ID); ShowEntryClasses sec = new ShowEntryClasses(connString, (Guid)dc.Show_Entry_Class_ID); ClassNames cn = new ClassNames(connString, (int)sec.Class_Name_ID); DogBreeds db = new DogBreeds(connString, (int)dog.Dog_Breed_ID); DogGender dg = new DogGender(connString, (int)dog.Dog_Gender_ID); dogRow[0] = dc.Dog_Class_ID; dogRow[1] = entrant_ID; dogRow[2] = dog.Dog_ID; dogRow[3] = dog.Dog_KC_Name; dogRow[4] = db.Description; dogRow[5] = dg.Description; dogRow[6] = dog.Reg_No; DateTime DOB = (DateTime)dog.Date_Of_Birth; dogRow[7] = string.Format("{0}/{1}/{2}", DOB.Day, DOB.Month, DOB.Year); dogRow[8] = dog.Merit_Points; dogRow[9] = dog.Breeder; dogRow[10] = dog.Sire; dogRow[11] = dog.Dam; dogRow[12] = string.Concat(sec.Class_No, " - ", cn.Class_Name_Description); dogRow[13] = dc.Preferred_Part.ToString(); if (dc.Show_Final_Class_ID != null && dc.Show_Final_Class_ID != new Guid()) { ShowFinalClasses sfc = new ShowFinalClasses(connString, (Guid)dc.Show_Final_Class_ID); dogRow[14] = sfc.Show_Final_Class_Description; } else { dogRow[14] = "Not Yet Assigned"; } People handler = new People(connString, (Guid)dc.Handler_ID); dogRow[15] = handler.Person_FullName; dogRow[16] = string.IsNullOrWhiteSpace(dc.Ring_No.ToString()) ? "Not Yet Assigned" : dc.Ring_No.ToString(); dogRow[17] = string.IsNullOrWhiteSpace(dc.Running_Order.ToString()) ? "Not Yet Assigned" : dc.Running_Order.ToString(); dogRow[18] = dc.Special_Request; dt.Rows.Add(dogRow); } dgvDogClasses.DataSource = dt; dgvDogClasses.Columns["DogClassID"].Visible = false; dgvDogClasses.Columns["EntrantID"].Visible = false; dgvDogClasses.Columns["DogID"].Visible = false; //dgvDogClasses.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; //dgvDogClasses.AutoSize = true; }
private void PopulateDogGridView(List <Dogs> tblDogs, int pageNo) { if (tblDogs == null) { tblDogs = Common.Dog_GridViewData; } List <Dogs> newDogs = new List <Dogs>(); int itemsperPage = Int32.Parse(WebConfigurationManager.AppSettings["GridItemsPerPage"]); int startRowIndex = (pageNo - 1) * itemsperPage; int currentIndex = 0; int itemsRead = 0; int totalRecords = tblDogs.Count; foreach (Dogs row in tblDogs) { if (itemsRead < itemsperPage && currentIndex < totalRecords && currentIndex >= startRowIndex) { Dogs newDog = new Dogs(_connString); newDog.Dog_ID = row.Dog_ID; newDog.Dog_KC_Name = row.Dog_KC_Name; newDog.Dog_Pet_Name = row.Dog_Pet_Name; if (!row.IsReg_NoNull) { newDog.Reg_No = row.Reg_No; } DogBreeds dogBreeds = new DogBreeds(_connString, Convert.ToInt32(row.Dog_Breed_ID)); newDog.Dog_Breed_Description = dogBreeds.Description; DogGender dogGender = new DogGender(_connString, Convert.ToInt32(row.Dog_Gender_ID)); newDog.Dog_Gender = dogGender.Description; newDogs.Add(newDog); itemsRead++; } currentIndex++; } lblTotalPages.Text = CalculateTotalPages(totalRecords).ToString(); lblCurrentPage.Text = CurrentPage.ToString(); if (CurrentPage == 1) { Btn_Previous.Enabled = false; if (Int32.Parse(lblTotalPages.Text) > 0) { Btn_Next.Enabled = true; } else { Btn_Next.Enabled = false; } } else { Btn_Previous.Enabled = true; if (CurrentPage == Int32.Parse(lblTotalPages.Text)) { Btn_Next.Enabled = false; } else { Btn_Next.Enabled = true; } } DogGridView.DataSource = newDogs; DogGridView.DataBind(); }
private void PopulateDog() { Guid current_dog_ID = new Guid(Current_Dog_ID); Dogs dog = new Dogs(_connString, current_dog_ID); txtKCName.Text = dog.Dog_KC_Name; txtPetName.Text = dog.Dog_Pet_Name; lblNLWU.Text = string.Format("Tick this box if {0} is no longer with us.", dog.Dog_Pet_Name); if (dog.Dog_Breed_ID != null) { int dog_Breed_ID = Int32.Parse(dog.Dog_Breed_ID.ToString()); DogBreeds dogBreeds = new DogBreeds(_connString, dog_Breed_ID); txtDogBreed.Text = dogBreeds.Description; } if (dog.Dog_Gender_ID != null) { int dog_Gender_ID = Int32.Parse(dog.Dog_Gender_ID.ToString()); DogGender dogGender = new DogGender(_connString, dog_Gender_ID); txtDogGender.Text = dogGender.Description; } if (dog.Reg_No != null) { Reg_No = dog.Reg_No.ToString(); Common.Reg_No = Reg_No; txtRegNo.Text = Reg_No; } if (dog.Date_Of_Birth != null) { string format = "yyyy-MM-dd"; Date_Of_Birth = DateTime.Parse(dog.Date_Of_Birth.ToString()).ToString(format); Common.Date_Of_Birth = Date_Of_Birth; txtDogDOB.Text = Date_Of_Birth; } if (dog.Merit_Points != null) { Merit_Points = dog.Merit_Points.ToString(); Common.Merit_Points = Merit_Points; txtMeritPoints.Text = Merit_Points; } else { Merit_Points = "0"; Common.Merit_Points = Merit_Points; txtMeritPoints.Text = Merit_Points; } if (dog.NLWU != null) { NLWU = (bool)dog.NLWU; Common.NLWU = NLWU; chkNLWU.Checked = NLWU; } DogDams dogDams = new DogDams(_connString); List <DogDams> lnkDogDams; lnkDogDams = dogDams.GetDogDamsByDog_ID(dog.Dog_ID); if (lnkDogDams.Count != 0) { Dam_ID = lnkDogDams[0].Dam_ID.ToString(); Common.Dam_ID = Dam_ID; PopulateDam(); } DogSires dogSires = new DogSires(_connString); List <DogSires> lnkDogSires; lnkDogSires = dogSires.GetDogSiresByDog_ID(dog.Dog_ID); if (lnkDogSires.Count != 0) { Sire_ID = lnkDogSires[0].Sire_ID.ToString(); Common.Sire_ID = Sire_ID; PopulateSire(); } }
/// <summary> /// Get an array of dogs sub-breeds via <see cref="DogBreeds"/> /// </summary> /// <param name="index"></param> /// <returns></returns> public string[] this[DogBreeds index] { get { return(index switch { DogBreeds.affenpinscher => affenpinscher, DogBreeds.african => african, DogBreeds.airedale => airedale, DogBreeds.akita => akita, DogBreeds.appenzeller => appenzeller, DogBreeds.australian => australian, DogBreeds.basenji => basenji, DogBreeds.beagle => beagle, DogBreeds.bluetick => bluetick, DogBreeds.borzoi => borzoi, DogBreeds.bouvier => bouvier, DogBreeds.boxer => boxer, DogBreeds.brabancon => brabancon, DogBreeds.briard => briard, DogBreeds.bulldog => bulldog, DogBreeds.bullterrier => bullterrier, DogBreeds.cairn => cairn, DogBreeds.cattledog => cattledog, DogBreeds.chihuahua => chihuahua, DogBreeds.chow => chow, DogBreeds.clumber => clumber, DogBreeds.cockapoo => cockapoo, DogBreeds.collie => collie, DogBreeds.coonhound => coonhound, DogBreeds.corgi => corgi, DogBreeds.cotondetulear => cotondetulear, DogBreeds.dachshund => dachshund, DogBreeds.dalmatian => dalmatian, DogBreeds.dane => dane, DogBreeds.deerhound => deerhound, DogBreeds.dhole => dhole, DogBreeds.dingo => dingo, DogBreeds.doberman => doberman, DogBreeds.elkhound => elkhound, DogBreeds.entlebucher => entlebucher, DogBreeds.eskimo => eskimo, DogBreeds.finnish => finnish, DogBreeds.frise => frise, DogBreeds.germanshepherd => germanshepherd, DogBreeds.greyhound => greyhound, DogBreeds.groenendael => groenendael, DogBreeds.havanese => havanese, DogBreeds.hound => hound, DogBreeds.husky => husky, DogBreeds.keeshond => keeshond, DogBreeds.kelpie => kelpie, DogBreeds.komondor => komondor, DogBreeds.kuvasz => kuvasz, DogBreeds.labradoodle => labradoodle, DogBreeds.labrador => labrador, DogBreeds.leonberg => leonberg, DogBreeds.lhasa => lhasa, DogBreeds.malamute => malamute, DogBreeds.malinois => malinois, DogBreeds.maltese => maltese, DogBreeds.mastiff => mastiff, DogBreeds.mexicanhairless => mexicanhairless, DogBreeds.mix => mix, DogBreeds.mountain => mountain, DogBreeds.newfoundland => newfoundland, DogBreeds.otterhound => otterhound, DogBreeds.ovcharka => ovcharka, DogBreeds.papillon => papillon, DogBreeds.pekinese => pekinese, DogBreeds.pembroke => pembroke, DogBreeds.pinscher => pinscher, DogBreeds.pitbull => pitbull, DogBreeds.pointer => pointer, DogBreeds.pomeranian => pomeranian, DogBreeds.poodle => poodle, DogBreeds.pug => pug, DogBreeds.puggle => puggle, DogBreeds.pyrenees => pyrenees, DogBreeds.redbone => redbone, DogBreeds.retriever => retriever, DogBreeds.ridgeback => ridgeback, DogBreeds.rottweiler => rottweiler, DogBreeds.saluki => saluki, DogBreeds.samoyed => samoyed, DogBreeds.schipperke => schipperke, DogBreeds.schnauzer => schnauzer, DogBreeds.setter => setter, DogBreeds.sheepdog => sheepdog, DogBreeds.shiba => shiba, DogBreeds.shihtzu => shihtzu, DogBreeds.spaniel => spaniel, DogBreeds.springer => springer, DogBreeds.stbernard => stbernard, DogBreeds.terrier => terrier, DogBreeds.vizsla => vizsla, DogBreeds.waterdog => waterdog, DogBreeds.weimaraner => weimaraner, DogBreeds.whippet => whippet, DogBreeds.wolfhound => wolfhound, _ => Array.Empty <string>(), });