private void DeleteAnimalRequirement() { Animal animalTemp = null; Requirement requirementTemp = null; AnimalRequirement temp = null; try { animalTemp = (Animal)Session["animaTemporalObjec"]; string selectedRequirement = ddlAnimalRequirements.SelectedValue.ToString(); //Find Requirement by its Name requirementTemp = (from r in mdolEntities.Requirements where r.Name.ToLower().Equals(selectedRequirement.ToLower()) select r).FirstOrDefault(); } catch (Exception ex) { string str = "Exaption in the: {Animal_Requirements Class}: [Method: DeleteAnimalRequirement()]"; ExceptionsSaver(str); } try { //Find specific Animal Requirement record temp = (from ar in mdolEntities.AnimalRequirements where ar.AnimalID == animalTemp.AnimalID && ar.RequirementID == requirementTemp.RequirementID select ar).FirstOrDefault(); lblAnimalRequirementMessage.Text = null; } catch (Exception ex) { lblAnimalRequirementMessage.Text = "Oops, Requirement record cannot be found."; } //Remove record if (temp != null) { try { //Delete selected Requirement from selected Animal mdolEntities.AnimalRequirements.Remove(temp); mdolEntities.SaveChanges(); lblAnimalRequirementMessage.Text = null; LoadAnimaRequirements(); } catch (Exception ex) { lblAnimalRequirementMessage.Text = "Oops, Requirement record cannot be Deleted."; } } }
private void AddAnimalRequirement() { try { //Get previously selected Animal from Session //Later for this Animal will be added Requirements Animal animaTemp = (Animal)Session["animaTemporalObjec"]; //Get selected Requirement string selectedRequirement = ddlAvailableRequirements.SelectedValue.ToString(); //Find Requirement by its Name "selectedRequirement" Requirement requirementTemp = (from r in mdolEntities.Requirements where r.Name.ToLower().Equals(selectedRequirement.ToLower()) select r).FirstOrDefault(); if (animaTemp != null && requirementTemp != null) { //Get all Animal Requirements var animalReqTemp = from ar in mdolEntities.AnimalRequirements select ar; //Prevent adding duplicate requirements for the selected Animal int dCounter = 0; foreach (var r in animalReqTemp) { if (r.AnimalID == animaTemp.AnimalID) { if (r.RequirementID == requirementTemp.RequirementID) { dCounter++; } } } if (dCounter == 0) { //Add Requirement for the selected Animal AnimalRequirement temp = new AnimalRequirement(); temp.AnimalID = animaTemp.AnimalID; temp.RequirementID = requirementTemp.RequirementID; mdolEntities.AnimalRequirements.Add(temp); mdolEntities.SaveChanges(); } } LoadAnimaRequirements(); } catch (Exception ex) { string str = "Exaption in the: {Animal_Requirements Class}: [Method: AddAnimalRequirement()]"; ExceptionsSaver(str); } }
protected void ShowInfo() { string str = null; string species = null; string country = null; string state = null; string county = null; string type = null; string gender = null; string age = null; Origin originTemp = null; try { //Get Country, State and County from Drop Down Lists country = ddlCountry.SelectedValue.ToString(); state = ddlState.SelectedItem.ToString(); county = ddlCounty.SelectedItem.ToString(); //Find requirements based on the choosing data originTemp = (from o in mdolEntities.Origins where o.Country.CountryName.Equals(country) && o.State.StateName.Equals(state) && o.County.CountyName.Equals(county) select o).FirstOrDefault(); } catch (Exception ex) { } Animal animalTemp = null; try { //Get Specie, Type Gender and Age from Drop Down Lists species = ddlSpecies.SelectedItem.ToString(); type = ddlType.SelectedItem.ToString(); gender = ddlGender.SelectedItem.ToString(); age = ddlAge.SelectedItem.ToString(); //Find Animal in DB by Origin, Type, Gender etc. animalTemp = (from a in mdolEntities.Animals where a.OriginID == originTemp.OriginID && a.Species.SpeciesName.Equals(species) && a.Type.TypeName.Equals(type) && a.Gender.GenderName.Equals(gender) && a.Age.AgeRange.Equals(age) select a).FirstOrDefault(); } catch (Exception ex) { } if (originTemp != null && animalTemp != null) { try { AnimalRequirement animalReqTemp = null; //Get Animal Requirements only for selected Animal var animalReq = from a in mdolEntities.AnimalRequirements where a.AnimalID == animalTemp.AnimalID select a; //Get Requirement Description based on what information was //selected from Drop Down Lists if (animalReq.Any()) { foreach (var a in animalReq) { animalReqTemp = a; //Get data and save it string requirementType = a.Requirement.RequirementType.Type; string requirementName = a.Requirement.Name; string link = a.Requirement.Link; string text = a.Requirement.Text; string html = a.Requirement.HTML; string rType = null; string rName = null; string rLink = null; string rText = null; string rHTML = null; //If link, text or html is null or is "N/A" //use default values if (requirementType != null && !requirementType.Equals("N/A")) { rType = requirementType; } if (requirementName != null && !requirementName.Equals("N/A")) { rName = requirementName + "<br />"; } if (link != null && !link.Equals("N/A")) { rLink = "<div class='link' id='divLink'><a href='" + link + "'>" + requirementName + "</a></div>"; } else { rLink = "<div class='link' id='divLink'>" + requirementName + "<br />Link is unavailable.</div>"; } if (text != null && !text.Equals("N/A")) { rText = "<div class='text' id='divText'>" + requirementName + "<br />" + text + "</div>"; } else { rText = "<div class='text' id='divText'>" + requirementName + "<br />Information is unavailable.</div>"; } if (html != null && !html.Equals("N/A")) { rHTML = "<div class='html_inj' id='divHTML'>" + html + "</div>"; } str = rLink + rText + rHTML; //Call method that will inject data into web page htmlInjection(str); } } else { string emptyContentText = "Requirements are not defined for the selected animal."; string emptyContent = "<div class='empty_content' id='divEmptyContent'>" + emptyContentText + "</div>"; str = emptyContent; htmlInjection(str); } } catch (Exception ex) { //string emptyContentText = "Exception"; //string emptyContent = "<div class='empty_content' id='divEmptyContent'>" + emptyContentText + "</div>"; //str = emptyContent; //htmlInjection(str); } } else { string emptyContentText = "Requirements are not defined for the selected animal."; string emptyContent = "<div class='empty_content' id='divEmptyContent'>" + emptyContentText + "</div>"; str = emptyContent; htmlInjection(str); } }