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);
}
}
