protected void PopulateAssessmentValues() { try { string s = DataProxy.EvaluateAssessmentTriggers(intAssessmentID); string strValue = DataProxy.GetAssessmentTriggers(intAssessmentID, intLanguageID); lblTriggerRecValue.Text = strValue; /*DON'T NEED TO DO ALL THIS ANYMORE - ALL UPDATES ARE WITHIN EVAL PROCEDURE NOW. * int intTriggerValue = 0; * Int32.TryParse(strValue, out intTriggerValue); * * if (intTriggerValue == 0) //Not enough information saved yet / no triggers evaluated to true. * intTriggerValue = 10; * * int intAssessmentTriggerID = DataProxy.GetAssessmentTriggerID(intAssessmentID); * * if (intAssessmentTriggerID > 0) //Record exists - update with new evaluation * DataProxy.UpdateAssessmentTriggers(intAssessmentTriggerID, intTriggerValue); * else * //Trigger record doesn't exist for Assessment - insert a new record. * DataProxy.InsertAssessmentTriggers(intAssessmentID, intTriggerValue); * * * DataTable dtTrigger = DataProxy.GetTriggerInfo(intAssessmentID); * if (dtTrigger != null) * { * if (dtTrigger.Rows.Count > 0) * { * DataRow drT = dtTrigger.Rows[0]; * lblTriggerRecValue.Text = drT["DisplayTriggers"].ToString(); * } * } */ DataTable dtAssess = DataProxy.GetAssessmentInfo(intAssessmentID, intLanguageID); DataRow dr = null; string strRLURL = "http://www.iucnredlist.org/apps/redlist/details/"; string strRLMap = "http://maps.iucnredlist.org/map.html?id="; string strRLID = ""; if (dtAssess != null) { if (dtAssess.Rows.Count > 0) { //Set page control values based on returned values in dataset. dr = dtAssess.Rows[0]; string strCommonName = ""; ARKIVESpeciesName = DataProxy.GetArkiveName(dr["GenusName"].ToString(), dr["SpeciesName"].ToString()); lblOrderValue.Text = dr["SpeciesOrder"].ToString(); lblFamilyValue.Text = dr["SpeciesFamily"].ToString(); lblNationalRLCValue.Text = dr["NationalRedListCategory"].ToString(); lblGlobalRLCValue.Text = dr["GlobalRedListCategory"].ToString(); strCommonName = dr["SpeciesAssessmentDisplayName"].ToString().Trim(); strRLID = dr["RedListID"].ToString().Trim(); strRLURL += strRLID; strRLMap += strRLID; lblAdditionalCommentsValue.Text = DataProxy.GetAdditionalComments(intAssessmentID); if (strCommonName != "") { lblSpeciesDisplayName.Text = dr["SpeciesDisplayName"].ToString() + ","; } else { lblSpeciesDisplayName.Text = dr["SpeciesDisplayName"].ToString(); } if (dr["Completed"] != null) { if (dr["Completed"].ToString().ToUpper() == "TRUE") { lblAssessmentStatusValue.Text = DataProxy.LoadString("COMPLETEDLABEL", strCurrentLanguage); } else { lblAssessmentStatusValue.Text = DataProxy.LoadString("INCOMPLETELABEL", strCurrentLanguage); } } else { lblAssessmentStatusValue.Text = DataProxy.LoadString("INCOMPLETELABEL", strCurrentLanguage); } lblSpeciesAssessmentDisplayName.Text = strCommonName; lblEDScoreValue.Text = dr["EDScore"].ToString(); lblDistributionValue.Text = DataProxy.GetSpeciesDistribution(intSpeciesID); lblAssessedForValue.Text = dr["CountryName"].ToString(); lblAssessedByValue.Text = dr["UserFullName"].ToString(); lblAssessedOnValue.Text = dr["DateCreatedDate"].ToString(); lnkRedList.NavigateUrl = strRLURL; lnkRedList.Text = DataProxy.LoadString("REDLISTMAPLABEL", strCurrentLanguage); lnkRLMap.HRef = strRLMap; if (strRLID == "" || strRLID == "0") { lnkRedList.Visible = false; lnkRLMap.Visible = false; imgRLMapOnly.Visible = true; string strURL = ""; if (strCurrentLanguage.ToUpper() == "SPANISH") { strURL = "~/images/No map data ES.jpg"; } else { strURL = "~/images/No map data EN.jpg"; } imgRLMapOnly.ImageUrl = strURL; } } } } catch (Exception ex) { lblError.Text = ex.Message; } }