/// <summary> /// Load all form info /// </summary> public override void Reload() { UIMethods.FillListControl(cmbClass, "Class", "ClassID", LoadFormData.ClassNames()); UIMethods.FillListControl(cmbPrimary, "Colour", "ColourID", LoadFormData.ColourNames()); UIMethods.FillListControl(cmbSecondary, "Colour", "ColourID", LoadFormData.ColourNames(), true); UIMethods.FillListControl(lstBreeds, "Breed", "BreedID", LoadFormData.BreedNames()); }
/// <summary> /// Load all form info /// </summary> public override void Reload() { UIMethods.FillListControl(cmbSelectOwner, "OwnerName", "OwnerID", LoadFormData.OwnerNamesCombined()); currentID = Convert.ToInt32(OwnerNavigation()["FirstID"]); LoadOwnerDetails(); UIMethods.DisplayStatusMessage(((MDIParent)MdiParent).GetStatusLabel(), "Owners loaded"); }
/// <summary> /// Fill the dogs list with the dogs that competed in the selected dog show /// </summary> private void LoadDogShowDetails() { GetUserData(); cmbDogs.SelectedIndex = 0; UIMethods.FillListControl(lstDogs, "Dog", "DogID", LoadFormData.DogShowDogs(dogShowID)); LoadDogShowDogsCount(); }
/// <summary> /// Search the dogs using any of the provided search terms. /// If a search term is blank will filter that field by all possiblites /// </summary> private void QueryDogs() { string dogName = DatabaseHelper.SanitizeUserInput(txtSearchName.Text); // If no breed is selected set to a wild card string breedID = cmbSearchBreed.SelectedIndex <= 0 ? "%%" : cmbSearchBreed.SelectedValue.ToString(); // If the rdo male is check set a 1 if rdo female is checked set to 0 else set to 1, 0 which will show both string sex = rdoSearchMale.Checked ? "1" : rdoSearchFemale.Checked ? "0" : "1, 0"; string ownerName = DatabaseHelper.SanitizeUserInput(txtSearchOwner.Text); // If max weight is 0 set to filter max by 999 decimal maxWeight = nudMaxWeight.Value == 0 ? 999 : nudMaxWeight.Value; decimal minWeight = nudMinWeight.Value; // If max height is 0 set to filter max by 999 decimal maxHeight = nudMaxHeight.Value == 0 ? 999 : nudMaxHeight.Value; decimal minHeight = nudMinHeight.Value; string sql = $@"SELECT DISTINCT Dogs.DogID, [Name] FROM Dogs LEFT JOIN DogOwnership ON Dogs.DogID = DogOwnership.DogID LEFT JOIN Owners ON DogOwnership.OwnerID = Owners.OwnerID WHERE Dogs.[Name] LIKE '%{dogName}%' AND Breed LIKE '{breedID}' AND SEX IN({sex}) AND FirstName + ' ' + COALESCE(MiddleName + ' ', '') + LastName LIKE '%{ownerName}%' AND {minHeight} < Height AND Height < {maxHeight} AND {minWeight} < [Weight] AND [Weight] < {maxWeight} ORDER BY [Name];"; DataTable dt = DatabaseHelper.GetDataTable(sql); UIMethods.FillListControl(lstDogs, "Name", "DogID", dt); }
/// <summary> /// Load all form info /// </summary> public override void Reload() { UIMethods.FillListControl(cmbClass, "Class", "ClassID", LoadFormData.ClassNames()); UIMethods.FillListControl(cmbPrimary, "Colour", "ColourID", LoadFormData.ColourNames()); UIMethods.FillListControl(cmbSecondary, "Colour", "ColourID", LoadFormData.ColourNames(), true); UIMethods.FillListControl(lstBreeds, "Breed", "BreedID", LoadFormData.BreedNames()); UIMethods.DisplayStatusMessage(((frmMDIParent)MdiParent).GetStatusLabel(), "Breeds info loaded"); }
/// <summary> /// Load all form info /// </summary> public override void Reload() { UIMethods.FillListControl(cmbBreed, "Breed", "BreedID", LoadFormData.BreedNames()); UIMethods.FillListControl(cmbSearchBreed, "Breed", "BreedID", LoadFormData.BreedNames(), true); UIMethods.FillListControl(cmbOwner, "OwnerName", "OwnerID", LoadFormData.OwnerNamesCombined()); UIMethods.FillListControl(lstDogs, "Name", "DogID", LoadFormData.DogNames()); UIMethods.DisplayStatusMessage(((frmMDIParent)MdiParent).GetStatusLabel(), "Dogs info loaded"); }
private void LoadOwnership() { ownerID = Convert.ToInt32(cmbOwners.SelectedValue); string sql = $@"SELECT Dogs.DogID, [Name] FROM DogOwnership LEFT JOIN Dogs ON Dogs.DogID = DogOwnership.DogID WHERE OwnerID = {ownerID};" ; UIMethods.FillListControl(lstOwnership, "Name", "DogID", DatabaseHelper.GetDataTable(sql)); }
/// <summary> /// The selected owner ownership records /// </summary> private void LoadOwnership() { errorProvider.Clear(); ownerID = Convert.ToInt32(cmbOwners.SelectedValue); string sql = $@"SELECT CAST(StartOfOwnership AS VARCHAR) + ':' + CAST(Dogs.DogID AS VARCHAR) AS ID, CAST(StartOfOwnership AS VARCHAR) + ' ' + CHAR(151) + ' ' + CAST(Dogs.[Name] AS VARCHAR) AS Dog FROM DogOwnership LEFT JOIN Dogs ON Dogs.DogID = DogOwnership.DogID WHERE OwnerID = {ownerID} ORDER BY StartOfOwnership;"; DataTable dt = DatabaseHelper.GetDataTable(sql); UIMethods.FillListControl(lstOwnership, "Dog", "ID", dt); }
/// <summary> /// Load form data /// </summary> public override void Reload() { UIMethods.FillListControl(lstOwners, "OwnerName", "OwnerID", LoadFormData.OwnerNamesCombined()); }
/// <summary> /// Load Form data /// </summary> public override void Reload() { UIMethods.FillListControl(cmbDogs, "Name", "DogID", LoadFormData.DogNames()); UIMethods.FillListControl(cmbOwners, "OwnerName", "OwnerID", LoadFormData.OwnerNamesCombined()); }
/// <summary> /// Fill the dogs list with the dogs that competed in the selected dog show /// </summary> private void GetDogs() { int id = Convert.ToInt32(cmbDogShows.SelectedValue); UIMethods.FillListControl(lstDogs, "Dog", "DogID", LoadFormData.DogShowDogs(id)); }
/// <summary> /// Load all of the form data /// </summary> public override void Reload() { UIMethods.FillListControl(cmbSelectedDogShow, "Name", "DogShowID", LoadFormData.DogShowNames()); }
/// <summary> /// Load the form info /// </summary> public override void Reload() { UIMethods.FillListControl(cmbDogToUpdate, "Name", "DogID", LoadFormData.DogNames()); UIMethods.FillListControl(cmbBreed, "Breed", "BreedID", LoadFormData.BreedNames()); }
/// <summary> /// Fill the breed and search breed comboboxes /// </summary> private void PopulateBreedsList() { UIMethods.FillListControl(cmbBreed, "Breed", "BreedID", LoadFormData.BreedNames(), true); }
/// <summary> /// Load all of the form data /// </summary> public override void Reload() { UIMethods.FillListControl(cmbDogs, "Name", "DogID", LoadFormData.DogNames(), true); UIMethods.FillListControl(cmbDogShow, "Name", "DogShowID", LoadFormData.DogShowNames()); }
/// <summary> /// Load form Data /// </summary> public override void Reload() { UIMethods.FillListControl(lstClasses, "Class", "ClassID", LoadFormData.ClassNames()); UIMethods.DisplayStatusMessage(((frmMDIParent)MdiParent).GetStatusLabel(), "Classes loaded"); }
/// <summary> /// Load all form info /// </summary> public override void Reload() { UIMethods.FillListControl(cmbDogShows, "Name", "DogShowID", LoadFormData.DogShowNames()); UIMethods.DisplayStatusMessage(((frmMDIParent)MdiParent).GetStatusLabel(), "Dog shows loaded"); }