public void OnlyOverrides() { var overrides = new Dictionary<string, string>(); overrides.Add("Name", "Brian"); overrides.Add("Id", "168337"); DataProxy d = new DataProxy(overrides); Assert.AreEqual("Brian", d["Name"]); Assert.AreEqual("168337", d["Id"]); }
public void NoOverrides() { var data = new { Name = "Brian", Id = 168337 }; DataProxy d = new DataProxy(new Dictionary<string, string>(), data); Assert.AreEqual("Brian", d["Name"]); Assert.AreEqual("168337", d["Id"]); }
public void KeyNotFound() { var data = new { Name = "Brian", Id = 168337 }; var overrides = new Dictionary<string, string>(); overrides.Add("Color", "Red"); DataProxy d = new DataProxy(overrides, data); string res = ""; Assert.Throws(typeof(KeyNotFoundException),() => res = d["Foobar"]); }
public void Dictionary() { var data = new Dictionary<string, object>(){ { "FirstName", "Bruce" }, { "LastName", "Wayne" }, { "Age", 42 } }; var overrides = new Dictionary<string, string>(); overrides.Add("FirstName", "Batman"); var d = new DataProxy(overrides, data); Assert.AreEqual("Batman", d["FirstName"]); Assert.AreEqual("Wayne", d["LastName"]); Assert.AreEqual("42", d["Age"]); }
public void Mixed() { var data = new { Name = "Brian", Id = 168337 }; var overrides = new Dictionary<string, string>(); overrides.Add("Color", "Red"); DataProxy d = new DataProxy(overrides, data); Assert.AreEqual("Brian", d["Name"]); Assert.AreEqual("168337", d["Id"]); Assert.AreEqual("Red", d["Color"]); // Now, name should be returned as Bjorn, even though the underlying // object still says Brian overrides.Add("Name", "Bjorn"); d = new DataProxy(overrides, data); Assert.AreEqual("Bjorn", d["Name"]); Assert.AreEqual("168337", d["Id"]); Assert.AreEqual("Red", d["Color"]); }
protected void Page_Load(object sender, EventArgs e) { if (Session["CurrentLanguage"] == null) { Session["CurrentLanguage"] = "English"; strCurrentLanguage = Session["CurrentLanguage"].ToString(); imgTop.ImageUrl = "images/CNA top banner EN.png"; imgBottom.ImageUrl = "images/CNA bottom banner EN.png"; lnkHelp.NavigateUrl = "~/Help/EN/Help.htm"; } else { strCurrentLanguage = Session["CurrentLanguage"].ToString(); if (strCurrentLanguage == "Spanish") { imgTop.ImageUrl = "images/CNA top banner ES.png"; imgBottom.ImageUrl = "images/CNA bottom banner ES.png"; lnkHelp.NavigateUrl = "~/Help/ES/Help.htm"; } if (strCurrentLanguage == "English") { imgTop.ImageUrl = "images/CNA top banner EN.png"; imgBottom.ImageUrl = "images/CNA bottom banner EN.png"; lnkHelp.NavigateUrl = "Help/EN/Help.htm"; } if (strCurrentLanguage == "French") { imgTop.ImageUrl = "images/CNA top banner FR.png"; imgBottom.ImageUrl = "images/CNA bottom banner FR.png"; lnkHelp.NavigateUrl = "Help/FR/Help.htm"; } } if (strCurrentLanguage == "Spanish") { lnkContact.HRef = "/Help/ES/ContactUs.htm"; } else { if (strCurrentLanguage == "English") { lnkContact.HRef = "/Help/EN/ContactUs.htm"; } else { //Code for French, etc. links goes here lnkContact.HRef = "/Help/FR/ContactUs.htm"; } } lblHome.Text = DataProxy.LoadString("HOMELINK", strCurrentLanguage); lblAssessmentSearch.Text = DataProxy.LoadString("ASESSMENTSEARCHALLNEW", strCurrentLanguage); lblContactUs.Text = DataProxy.LoadString("CONTACTUSLINK", strCurrentLanguage); lblLogin.Text = DataProxy.LoadString("LOGINLINK", strCurrentLanguage); lblSearch.Text = DataProxy.LoadString("ASESSMENTSEARCHNEW", strCurrentLanguage); lnkHelp.Text = DataProxy.LoadString("HELPLINK", strCurrentLanguage); lblDashboard.Text = DataProxy.LoadString("DASHBOARDLINK", strCurrentLanguage); lblReports.Text = DataProxy.LoadString("REPORTSLABEL", strCurrentLanguage); //lblAboutAssess.Text = DataProxy.LoadString("ABOUTASSESSMENTLINK", strCurrentLanguage); //lblLanguages.Text = DataProxy.LoadString("LANGUAGESLINK", strCurrentLanguage); //Don't show 'My Dashboard' menu link if there isn't a user logged in... if (Session["UserName"] == null) { lblDashboard.Visible = false; lblPipe.Visible = false; lblPipe2.Visible = false; lblAssessmentSearch.Visible = false; } else { string strUserRole = ""; if (Session["UserRole"] != null) { strUserRole = Session["UserRole"].ToString(); } if (strUserRole != "" && strUserRole != "Guest") { lblDashboard.Visible = true; } else { lblDashboard.Visible = false; } lblPipe.Visible = true; lblPipe2.Visible = true; lblAssessmentSearch.Visible = true; } }
protected void grdApproveCompletedAssess_RowDataBound(object sender, GridViewRowEventArgs e) { HyperLink hlDeny = null; HyperLink hlApprove = null; HyperLink hlEdit = null; HyperLink hlSpeciesResults = null; Label lblStatus = null; string strUserID = ""; string strApproved = ""; DataRowView dr = (DataRowView)e.Row.DataItem; if (e.Row.RowType == DataControlRowType.Header) { //Set first column/"Species" header e.Row.Cells[0].Text = DataProxy.LoadString("SPECIESLABEL", strCurrentLanguage); //Set second column/"Country" header e.Row.Cells[1].Text = DataProxy.LoadString("COUNTRYLABEL", strCurrentLanguage); //Set third column/"User Name" header e.Row.Cells[2].Text = DataProxy.LoadString("ASSESSEDBYLABEL", strCurrentLanguage); //Set fifth column/"Date" header e.Row.Cells[4].Text = DataProxy.LoadString("DATELABEL", strCurrentLanguage); //Set fourth column/"Status" header //e.Row.Cells[3].Text = DataProxy.LoadString("STATUS", strCurrentLanguage); } if (e.Row.RowType == DataControlRowType.DataRow) { string strAssessmentID = ""; if (dr["AssessmentID"] != null) { strAssessmentID = dr["AssessmentID"].ToString(); } if (dr["UserID"] != null) { strUserID = dr["UserID"].ToString(); } if (dr["Status"] != null) { if (e.Row.FindControl("lblStatus") != null) { lblStatus = (Label)e.Row.FindControl("lblStatus"); if (dr["Status"].ToString() == "False") { lblStatus.Text = DataProxy.LoadString("NOTAPPROVEDLABEL", strCurrentLanguage); } else { lblStatus.Text = DataProxy.LoadString("APPROVEDLABEL", strCurrentLanguage); } } } if (dr["Approved"] != null) { strApproved = dr["Approved"].ToString(); } if (e.Row.FindControl("hlApprove") != null) { hlApprove = (HyperLink)e.Row.FindControl("hlApprove"); hlApprove.Text = DataProxy.LoadString("APPROVETEXT", strCurrentLanguage); hlApprove.NavigateUrl = "FacilitatorDashboard.aspx?ApproveAssessment=1&AssessmentID=" + strAssessmentID; if (strApproved == "True") { hlApprove.Visible = false; } else { hlApprove.Visible = true; } } if (e.Row.FindControl("hlDeny") != null) { hlDeny = (HyperLink)e.Row.FindControl("hlDeny"); if (strApproved == "True") { hlDeny.Text = DataProxy.LoadString("UNAPPROVELABEL", strCurrentLanguage); } else { hlDeny.Text = DataProxy.LoadString("DENYTEXT", strCurrentLanguage); } hlDeny.NavigateUrl = "FacilitatorDashboard.aspx?ApproveAssessment=0&AssessmentID=" + strAssessmentID; } if (e.Row.FindControl("hlEdit") != null) { string strURL = "EditAssessment.aspx?FEdit=Y&AssessmentID=" + strAssessmentID + "&CountryID=" + dr["CountryID"].ToString() + "&SpeciesID=" + dr["SpeciesID"].ToString(); hlEdit = (HyperLink)e.Row.FindControl("hlEdit"); hlEdit.Text = DataProxy.LoadString("EDITTEXT", strCurrentLanguage); hlEdit.NavigateUrl = strURL; } if (e.Row.FindControl("hlSpeciesResults") != null) { hlSpeciesResults = (HyperLink)e.Row.FindControl("hlSpeciesResults"); string strURL = ""; if (strAssessmentID != "0") { strURL = "AssessmentResults.aspx?AssessmentID=" + strAssessmentID + "&SpeciesID=" + dr["SpeciesID"].ToString() + "&CountryID=" + dr["CountryID"].ToString(); } hlSpeciesResults.NavigateUrl = strURL; } } }
protected void btnLogin_Click(object sender, EventArgs e) { try { string strURL = ""; string strUID = txtLoginName.Text.Trim(); string strPwd = txtPassword.Text.Trim(); lblError.ForeColor = System.Drawing.Color.Black; DataTable dtResults = DataProxy.GetUserInfo(strUID, strPwd); if (dtResults != null) { if (dtResults.Rows.Count > 0) { if (DataProxy.CheckUserApproved(strUID)) { Session["UserName"] = strUID; //Figure out where they should go? Main dashboard? if (strSpeciesID != "") { //User was brought in here by Search Results and tried to add a new assessment... strURL = "CreateAssessment.aspx?SpeciesID=" + strSpeciesID + "&CountryID=" + strCountryID; } else { //Check user's role and redirect to appropriate dashboard... string strUserRole = DataProxy.GetUserType(strUID); Session["UserRole"] = strUserRole; if (strUserRole.ToUpper() == "ASSESSOR") { strURL = "AssessorDashboard.aspx?UID=" + strUID; } else { if (strUserRole.ToUpper() == "GUEST") { strURL = "Default.aspx?UID=" + strUID; } else { if (strUserRole.ToUpper() == "FACILITATOR") { strURL = "FacilitatorDashboard.aspx?UID=" + strUID; } else { strURL = "AdminDashboard.aspx?UID=" + strUID; } } } } Response.Redirect(strURL); } else { lblError.ForeColor = System.Drawing.Color.Red; lblError.Text = DataProxy.LoadString("NOTAPPROVEDTEXT", strCurrentLanguage); } } else { lblError.ForeColor = System.Drawing.Color.Red; lblError.Text = DataProxy.LoadString("INVALIDLOGINERRORTEXT", strCurrentLanguage); } } } catch (Exception ex) { //Session["UserName"] = null; lblError.Text = ex.Message; } }
protected void grdResults_RowDataBound(object sender, GridViewRowEventArgs e) { HyperLink hlEdit = null; HyperLink hlArchive = null; HyperLink hlSpeciesResults = null; HyperLink hlAdd = null; LinkButton lnkDelete = null; Label lblDelete = null; Label lblCurStatus = null; Label lblDateAssessed = null; string strUserName = ""; string strPreviousRow = ""; DataRowView dr = (DataRowView)e.Row.DataItem; if (Session["UserName"] != null) { strUserName = Session["UserName"].ToString(); } int intCurrentUserID = DataProxy.GetUserID(strUserName); //JK: No idea why I was doing this - maybe to prevent dups with a previous query's dataset, but causing rows to be hidden in error - commenting out. //if (Session["PreviousRow"] != null) // strPreviousRow = Session["PreviousRow"].ToString(); if (e.Row.RowType == DataControlRowType.Header) { //Set first column/"Country" header e.Row.Cells[0].Text = DataProxy.LoadString("COUNTRYLABEL", strCurrentLanguage); //Set second column/"Species" header e.Row.Cells[1].Text = DataProxy.LoadString("SPECIESLABEL", strCurrentLanguage); //Set third column/"Common Name" header e.Row.Cells[2].Text = DataProxy.LoadString("COMMONNAMELABEL", strCurrentLanguage); //Set fourth column/"Local Common Name" header e.Row.Cells[3].Text = DataProxy.LoadString("LOCALCOMMONNAMELABEL", strCurrentLanguage); //Set fifth column/"User Name" header e.Row.Cells[4].Text = DataProxy.LoadString("ASSESSEDBYLABEL", strCurrentLanguage); //Set sixth column/"Date Assessed" header e.Row.Cells[5].Text = DataProxy.LoadString("ASSESSMENTDATELABEL", strCurrentLanguage); //Set seventh column/"Status" header string strStatus = DataProxy.LoadString("ASSESSMENTSTATUSLABEL", strCurrentLanguage); strStatus = strStatus.Replace(":", ""); e.Row.Cells[6].Text = strStatus; } if (e.Row.RowType == DataControlRowType.DataRow) { string strAssessmentID = ""; int intSpeciesID = 0; int intCountryID = 0; int intAssessUserID = 0; int intUserID = 0; int intAssessmentID = 0; string strCurStatus = ""; if (dr["SpeciesID"] != null) { int.TryParse(dr["SpeciesID"].ToString(), out intSpeciesID); } if (dr["UserID"] != null) { int.TryParse(dr["UserID"].ToString(), out intAssessUserID); } if (dr["CountryID"] != null) { int.TryParse(dr["CountryID"].ToString(), out intCountryID); } if (dr["AssessmentID"] != null) { strAssessmentID = dr["AssessmentID"].ToString(); } if (e.Row.FindControl("lblDateAssessed") != null) { DateTime dtDate; string strDate; lblDateAssessed = (Label)e.Row.FindControl("lblDateAssessed"); if (dr["DateCreated"] != null) { if (dr["DateCreated"] != DBNull.Value) { dtDate = Convert.ToDateTime(dr["DateCreated"]); strDate = dtDate.ToString("dd MMM yyyy"); lblDateAssessed.Text = strDate; } } } if (e.Row.FindControl("lblCurStatus") != null) { lblCurStatus = (Label)e.Row.FindControl("lblCurStatus"); if (dr["CurStatus"] != null) { strCurStatus = dr["CurStatus"].ToString(); } if (strCurStatus != "") { if (strCurStatus == "Draft") { strCurStatus = DataProxy.LoadString("INCOMPLETELABEL", strCurrentLanguage); } else { strCurStatus = DataProxy.LoadString("COMPLETEDLABEL", strCurrentLanguage); } } lblCurStatus.Text = strCurStatus; } if (e.Row.FindControl("hlAdd") != null) { hlAdd = (HyperLink)e.Row.FindControl("hlAdd"); string strURL = "CreateAssessment.aspx?AssessmentID=0" + "&SpeciesID=" + intSpeciesID.ToString() + "&CountryID=" + intCountryID.ToString(); hlAdd.NavigateUrl = strURL; hlAdd.Text = DataProxy.LoadString("ADDASSESSMENTLABEL", strCurrentLanguage); //Only allow user to add an assessment if they haven't already created one for that country/species combo if (intCurrentUserID == 0) { hlAdd.Visible = true; } else { //Check here if user has an assessment if (intAssessUserID != intCurrentUserID) { if (strAssessmentID != "") { intAssessmentID = Convert.ToInt32(strAssessmentID); } intUserID = DataProxy.GetUserIDForAssessment(intCurrentUserID, intCountryID, intSpeciesID); if (strUserRole == "Guest") { hlAdd.Enabled = false; } if (intUserID > 0) { hlAdd.Visible = false; } else { hlAdd.Visible = true; } } else { hlAdd.Visible = false; } } } if (e.Row.FindControl("lnkDelete") != null) { lnkDelete = (LinkButton)e.Row.FindControl("lnkDelete"); if (intCurrentUserID != 0) { //jan 2018 - add Delete option for Admin users logged in as well... if (intAssessUserID == intCurrentUserID || (strUserRole == "Admin" && intAssessUserID != 0)) { lnkDelete.Visible = true; if (strUserRole == "Guest") { lnkDelete.Enabled = false; } int intAssessID = Convert.ToInt32(strAssessmentID); lnkDelete.CommandArgument = intAssessID.ToString(); lblDelete = (Label)e.Row.FindControl("lblDelete"); if (lblDelete != null) { lblDelete.Text = DataProxy.LoadString("DELETETEXT", strCurrentLanguage); } } else { lnkDelete.Visible = false; } } else { lnkDelete.Visible = false; } } if (e.Row.FindControl("hlEdit") != null) { hlEdit = (HyperLink)e.Row.FindControl("hlEdit"); string strURL = "EditAssessment.aspx?AssessmentID=" + strAssessmentID + "&SpeciesID=" + intSpeciesID.ToString() + "&CountryID=" + intCountryID.ToString(); bool isFacilitator = false; int intAssessID = Convert.ToInt32(strAssessmentID); if (intCurrentUserID != 0) { //Add logic to this for Facilitators who can now edit the assessment DataTable dtCurUser = DataProxy.GetUserInfo(intCurrentUserID); if (dtCurUser != null) { if (dtCurUser.Rows.Count > 0) { DataRow drUser = dtCurUser.Rows[0]; int intUserTypeID = Convert.ToInt16(drUser["UserTypeID"]); string userType = DataProxy.GetUserType(intUserTypeID); if (userType.ToUpper() == "FACILITATOR") { isFacilitator = true; } } } if (intAssessUserID == intCurrentUserID || isFacilitator) { hlEdit.Visible = true; if (strUserRole == "Guest") { hlEdit.Enabled = false; } if (isFacilitator) { hlEdit.Text = DataProxy.LoadString("EDITTEXT", strCurrentLanguage); strURL += "&FEdit=Y"; if (strAssessmentID == "0") { hlEdit.Visible = false; } //Set Archive assessments hlArchive = (HyperLink)e.Row.FindControl("hlArchive"); if (DataProxy.CheckAssessmentComplete(intAssessID)) { hlArchive.Visible = true; string strMessage = ""; if (DataProxy.CheckAssessmentArchived(intAssessID)) { strMessage = DataProxy.LoadString("CONFIRMUNARCHIVE", strCurrentLanguage); hlArchive.Text = DataProxy.LoadString("ARCHIVETEXT", strCurrentLanguage); hlArchive.Attributes["onclick"] = String.Format("return confirm('{0}');", strMessage); hlArchive.NavigateUrl = "SearchAll.aspx?ArchiveAssessID=" + strAssessmentID + "&Archive=N"; } else { //Assessment not set to Archived - show icon strMessage = DataProxy.LoadString("CONFIRMARCHIVE", strCurrentLanguage); hlArchive.ImageUrl = @"\images\Archive icon.png"; hlArchive.Attributes["onclick"] = String.Format("return confirm('{0}');", strMessage); hlArchive.NavigateUrl = "SearchAll.aspx?ArchiveAssessID=" + strAssessmentID + "&Archive=Y"; } } } else { //Check if assessment has been marked 'Completed' and flag appropriately for user if (DataProxy.CheckAssessmentComplete(intAssessID)) { hlEdit.Text = DataProxy.LoadString("EDITASSESSMENTLABEL", strCurrentLanguage); } else { hlEdit.Text = DataProxy.LoadString("EDITINCOMPLETEASSESSMENTLABEL", strCurrentLanguage); } } hlEdit.NavigateUrl = strURL; } } else { hlEdit.Visible = false; } //OLD LOGIC //if (strUserName != "") // //strAssessmentID = DataProxy.GetAssessmentIDForUser(Convert.ToInt32(dr["SpeciesID"]), Convert.ToInt32(dr["CountryID"]), strUserName); // strAssessmentID = dr["AssessmentIDUser"].ToString(); //if (strUserName != "") //{ // if (strUserName.ToUpper() == dr["UserName"].ToString().ToUpper() && strAssessmentID != "0") // { // hlEdit.Visible = true; // hlEdit.NavigateUrl = strURL; // hlEdit.Text = DataProxy.LoadString("EDITASSESSMENTLABEL", strCurrentLanguage); // } //} //else // hlEdit.Visible = false; //END OLD LOGIC } if (e.Row.FindControl("hlSpeciesResults") != null) { hlSpeciesResults = (HyperLink)e.Row.FindControl("hlSpeciesResults"); string strURL = ""; if (strAssessmentID != "0") { strURL = "AssessmentResults.aspx?AssessmentID=" + strAssessmentID + "&SpeciesID=" + dr["SpeciesID"].ToString() + "&CountryID=" + dr["CountryID"].ToString(); } hlSpeciesResults.NavigateUrl = strURL; } //JK: No idea why I was doing this - maybe to prevent dups with a previous query's dataset, but causing rows to be hidden in error - commenting out. //Session["PreviousRow"] = dr["SpeciesID"].ToString() + "-" + dr["CountryID"].ToString(); //if (strPreviousRow == Session["PreviousRow"].ToString()) // e.Row.Visible = false; } }
private void ResultPage_Loaded(object sender, RoutedEventArgs e) { if (Data == null) { MessageBox.Show("Opps! Something go wrong. Please try again"); return; } var dataProxy = new DataProxy(); var currentDirectory = Directory.GetCurrentDirectory(); var resultsDirectory = System.IO.Path.Combine(currentDirectory, "Results"); Directory.CreateDirectory(resultsDirectory); _ = Task.Run(async() => { try { var greedyAlgorithm = await dataProxy.GetData(Config.GreedyAlgorithm, Data); Application.Current.Dispatcher.Invoke(() => { lock (locker) { Results.Children.Add(new Controls.Result() { AlgorithmName = "Greedy", AlgorithmTime = greedyAlgorithm.AlgorithmTime, SumTime = greedyAlgorithm.SumTime, Sequence = ConvertToSequence(greedyAlgorithm.StudentSequence) }); } }); var json = JsonConvert.SerializeObject(new SaveFile() { InputData = Data, OutputData = greedyAlgorithm, Name = "Greedy algorithm" }); File.WriteAllText(System.IO.Path.Combine(resultsDirectory, $"{Guid.NewGuid().ToString()}.json"), json); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine($"Can't get data from greedy with error : {ex.Message}"); } }); _ = Task.Run(async() => { try { var antColonyAlgorithm = await dataProxy.GetData(Config.AntColonyAlgorithm, Data); Application.Current.Dispatcher.Invoke(() => { Results.Children.Add(new Controls.Result() { AlgorithmName = "Ant Colony", AlgorithmTime = antColonyAlgorithm.AlgorithmTime, SumTime = antColonyAlgorithm.SumTime, Sequence = ConvertToSequence(antColonyAlgorithm.StudentSequence) }); }); var json = JsonConvert.SerializeObject(new SaveFile() { InputData = Data, OutputData = antColonyAlgorithm, Name = "Ant colony algorithm" }); File.WriteAllText(System.IO.Path.Combine(resultsDirectory, $"{Guid.NewGuid().ToString()}.json"), json); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine($"Can't get data from ant colony with error : {ex.Message}"); } }); _ = Task.Run(async() => { try { var beesAlgorithm = await dataProxy.GetData(Config.BeesAlgorithm, Data); Application.Current.Dispatcher.Invoke(() => { lock (locker) { Results.Children.Add(new Controls.Result() { AlgorithmName = "Bees", AlgorithmTime = beesAlgorithm.AlgorithmTime, SumTime = beesAlgorithm.SumTime, Sequence = ConvertToSequence(beesAlgorithm.StudentSequence) }); } }); var json = JsonConvert.SerializeObject(new SaveFile() { InputData = Data, OutputData = beesAlgorithm, Name = "Bees algorithm" }); File.WriteAllText(System.IO.Path.Combine(resultsDirectory, $"{Guid.NewGuid().ToString()}.json"), json); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine($"Can't get data from bees with error : {ex.Message}"); } }); }
protected void Page_Load(object sender, EventArgs e) { if (Session["CurrentLanguage"] == null) { Session["CurrentLanguage"] = "English"; strCurrentLanguage = Session["CurrentLanguage"].ToString(); } else { strCurrentLanguage = Session["CurrentLanguage"].ToString(); } intLanguageID = DataProxy.GetLanguageID(strCurrentLanguage); //Set global variables based on URL values. if (Request.QueryString["AssessmentID"] != null) { intAssessmentID = Convert.ToInt32(Request.QueryString["AssessmentID"]); } if (Request.QueryString["SpeciesID"] != null) { intSpeciesID = Convert.ToInt32(Request.QueryString["SpeciesID"]); } if (strCurrentLanguage == "Spanish") { imgRLMap.ImageUrl = "images/world map_bw ES.jpg"; } else { if (strCurrentLanguage == "French") { imgRLMap.ImageUrl = "images/world map_bw FR.jpg"; } else { imgRLMap.ImageUrl = "images/world map_bw EN.jpg"; } } lnkAWeb.Text = DataProxy.LoadString("AWEBLABEL", strCurrentLanguage); //Set standard label values based on current language. lblPageTitle.Text = DataProxy.LoadString("ASSESSMENTRESULTSLINK", strCurrentLanguage); lblOrder.Text = DataProxy.LoadString("ORDERLABEL", strCurrentLanguage); lblFamily.Text = DataProxy.LoadString("FAMILYLABEL", strCurrentLanguage); lblGlobalRLC.Text = DataProxy.LoadString("GLOBALRLCLABEL", strCurrentLanguage); lblNationalRLC.Text = DataProxy.LoadString("NATIONALRLCLABEL", strCurrentLanguage); lblEDScore.Text = DataProxy.LoadString("EDSCORELABEL", strCurrentLanguage); lblDistribution.Text = DataProxy.LoadString("DISTRIBUTIONLABEL", strCurrentLanguage); //lblRLMap.Text = DataProxy.LoadString("REDLISTMAPLABEL", strCurrentLanguage); //lblAddMap.Text = DataProxy.LoadString("ADDOBSERVATIONINATURALISTLABEL", strCurrentLanguage); lblAssessedFor.Text = DataProxy.LoadString("ASSESSMENTRESULTSCOUNTRYLABEL", strCurrentLanguage); lblAssessedBy.Text = DataProxy.LoadString("ASSESSMENTRESULTSBYLABEL", strCurrentLanguage); lblAssessedOn.Text = DataProxy.LoadString("ASSESSMENTRESULTSONLABEL", strCurrentLanguage); lblTriggerRec.Text = DataProxy.LoadString("RECOMMENDEDCONSERVATIONACTIONS", strCurrentLanguage); lblAssessmentStatus.Text = DataProxy.LoadString("ASSESSMENTSTATUSLABEL", strCurrentLanguage); lblAdditionalComments.Text = DataProxy.LoadString("ADDCOMMENTSLABEL", strCurrentLanguage); btnPrint.Text = DataProxy.LoadString("PRINTLABEL", strCurrentLanguage); btnExport.Text = DataProxy.LoadString("EXPORTLABEL", strCurrentLanguage); //btnPrint.Attributes.Add("onclick", "javascript:CallPrint('divPrint');"); lblReportTitle.Text = DataProxy.LoadString("ASSESSMENTRESULTSLABEL", strCurrentLanguage); grdAssess.EmptyDataText = DataProxy.LoadString("NORECORDSFOUND", strCurrentLanguage); SetAmphibiaWebValues(); PopulateAssessmentValues(); PopulateQuestionsGrid(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["CurrentLanguage"] == null) { Session["CurrentLanguage"] = "English"; strCurrentLanguage = Session["CurrentLanguage"].ToString(); } else { strCurrentLanguage = Session["CurrentLanguage"].ToString(); } if (Session["UserName"] != null) { strUserName = Session["UserName"].ToString(); } if (Session["UserRole"] != null) { strUserRole = Session["UserRole"].ToString(); } lblPageTitle.Text = DataProxy.LoadString("SEARCHALLTITLE", strCurrentLanguage); lblReportTitle.Text = DataProxy.LoadString("ASSESSMENTSLABEL", strCurrentLanguage); btnPrint.Text = DataProxy.LoadString("PRINTLABEL", strCurrentLanguage); btnExport.Text = DataProxy.LoadString("EXPORTLABEL", strCurrentLanguage); lblContent.Text = DataProxy.LoadString("SEARCHALLMAIN", strCurrentLanguage); lblCountry.Text = DataProxy.LoadString("COUNTRYLABEL", strCurrentLanguage); btnSearch.Text = DataProxy.LoadString("SEARCHLINK", strCurrentLanguage); lblSpecies.Text = DataProxy.LoadString("SPECIESLABEL", strCurrentLanguage); lblAssessments.Text = DataProxy.LoadString("INCLUDEASSESSMENTLABEL", strCurrentLanguage); chkUserResultsOnly.Text = DataProxy.LoadString("CHECKBOXRESULTSTEXT", strCurrentLanguage); grdResults.EmptyDataText = DataProxy.LoadString("NORECORDSFOUND", strCurrentLanguage); if (!Page.IsPostBack) { PopulateCountriesList(); PopulateAssessmentsList(); } if (Request.QueryString["ArchiveAssessID"] != null && Request.QueryString["Archive"] != null) { lblError.Text = ""; if (Session["ArchiveAssessment"] == null) { ArchiveAssessment(); } else { if (Session["ArchiveAssessment"].ToString() != Request.QueryString["ArchiveAssessID"] || (Session["ArchiveAssessment"].ToString() == Request.QueryString["ArchiveAssessID"] && Session["ArchiveType"].ToString() != Request.QueryString["Archive"])) { ArchiveAssessment(); } } } }
/// <summary> /// Gets the Mortgage Import statement Id's /// </summary> /// <returns> The dataset containing the list of Mortgage Import statementids.</returns> public static DataSet GetMortgageImportStatementIds() { return(DataProxy.FetchDataSet("pclst_MortgageImportID")); }
private async Task <List <Model.Data> > GetProblems(Model.ExperimentsSettings settings) { var dataProxy = new DataProxy(); return(await dataProxy.GetProblems(Config.GenerateRequest, settings)); }
protected void grdAssessUser_RowDataBound(object sender, GridViewRowEventArgs e) { DataRowView dr = (DataRowView)e.Row.DataItem; Literal ltlRecs = null; string strCurrentCountry = ""; string strCurrentSpecies = ""; Label lblGridCountry = null; int intTotalAssessments = 0; string strAssessmentID = "0"; HyperLink lblSpecies = null; if (e.Row.RowType == DataControlRowType.Header) { //Set "Species" header e.Row.Cells[0].Text = DataProxy.LoadString("SPECIESLABEL", strCurrentLanguage); //Set "Country" header e.Row.Cells[1].Text = DataProxy.LoadString("COUNTRYLABEL", strCurrentLanguage); //Set "Recommendations" header string strHeader = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT7LINK", strCurrentLanguage); if (strHeader != "" && strHeader != null) { e.Row.Cells[2].Text = strHeader.Substring(0, 1).ToUpper() + strHeader.Substring(1, strHeader.Length - 2); } } if (e.Row.RowType == DataControlRowType.DataRow) { if (dr["Total"] != null) { intTotalAssessments = Convert.ToInt32(dr["Total"]); } if (e.Row.FindControl("lblGridCountry") != null) { lblGridCountry = (Label)e.Row.FindControl("lblGridCountry"); } if (e.Row.FindControl("lblSpecies") != null) { lblSpecies = (HyperLink)e.Row.FindControl("lblSpecies"); } strCurrentCountry = dr["CountryID"].ToString(); strCurrentSpecies = dr["SpeciesID"].ToString(); if (strOldSpecies == strCurrentSpecies && strOldCountry == strCurrentCountry) { lblGridCountry.Visible = false; lblSpecies.Visible = false; foreach (TableCell tc in e.Row.Cells) { tc.BorderStyle = BorderStyle.None; tc.BorderWidth = 0; } } else { string strURL = ""; int intSpeciesID = 0; int intCountryID = 0; lblGridCountry.Visible = true; lblSpecies.Visible = true; if (dr["SpeciesID"] != null) { intSpeciesID = Convert.ToInt32(dr["SpeciesID"]); } if (dr["CountryID"] != null) { intCountryID = Convert.ToInt32(dr["CountryID"]); } //Set URL for Species - if 1 - AssessmentResults, if > 1 assessment - ConsolidatedSpeciesAssessment.aspx. if (intTotalAssessments > 1) { strURL = "ConsolidatedSpeciesAssessment.aspx?SpeciesID=" + intSpeciesID.ToString() + "&CountryID=" + intCountryID.ToString(); } else { strAssessmentID = DataProxy.GetAssessmentIDForSpeciesCountry(intSpeciesID, intCountryID); strURL = ConfigurationManager.AppSettings["URLPath"] + "AssessmentResults.aspx?AssessmentID=" + strAssessmentID + "&SpeciesID=" + intSpeciesID.ToString() + "&CountryID=" + intCountryID.ToString(); // strURL = @"~/AssessmentResults.aspx?AssessmentID=" + strAssessmentID + "&SpeciesID=" + // intSpeciesID.ToString() + "&CountryID=" + intCountryID.ToString(); lblSpecies.NavigateUrl = strURL; } } if (e.Row.FindControl("ltlRecs") != null) { ltlRecs = (Literal)e.Row.FindControl("ltlRecs"); double intPct = 0; if (dr["PctTotal"] != null) { intPct = Convert.ToDouble(dr["PctTotal"]); } string strLiteral = ""; strLiteral = dr["TriggerShortName"].ToString() + " (n=" + dr["Total"].ToString() + ", " + intPct.ToString("#.##") + "%)<br>"; ltlRecs.Text = strLiteral; } strOldCountry = strCurrentCountry; strOldSpecies = strCurrentSpecies; } }
protected void grdResults_RowDataBound(object sender, GridViewRowEventArgs e) { HyperLink hlEdit = null; HyperLink hlSpeciesResults = null; HyperLink hlAdd = null; LinkButton lnkDelete = null; Label lblDelete = null; string strUserName = ""; DataRowView dr = (DataRowView)e.Row.DataItem; if (Session["UserName"] != null) { strUserName = Session["UserName"].ToString(); } int intCurrentUserID = DataProxy.GetUserID(strUserName); //JK: No idea why I was doing this - maybe to prevent dups with a previous query's dataset, but causing rows to be hidden in error - commenting out. //if (Session["PreviousRow"] != null) // strPreviousRow = Session["PreviousRow"].ToString(); if (e.Row.RowType == DataControlRowType.Header) { //Set first column/"Country" header e.Row.Cells[0].Text = DataProxy.LoadString("COUNTRYLABEL", strCurrentLanguage); //Set second column/"Species" header e.Row.Cells[1].Text = DataProxy.LoadString("SPECIESLABEL", strCurrentLanguage); //Set third column/"Common Name" header e.Row.Cells[2].Text = DataProxy.LoadString("COMMONNAMELABEL", strCurrentLanguage); //Set fourth column/"Local Common Name" header e.Row.Cells[3].Text = DataProxy.LoadString("LOCALCOMMONNAMELABEL", strCurrentLanguage); //Set fifth column/"User Name" header e.Row.Cells[4].Text = DataProxy.LoadString("ASSESSEDBYLABEL", strCurrentLanguage); //Set fourth column/"Total Assessments" header //e.Row.Cells[3].Text = DataProxy.LoadString("TOTALASSESSMENTSLABEL", strCurrentLanguage); } if (e.Row.RowType == DataControlRowType.DataRow) { string strAssessmentID = ""; int intSpeciesID = 0; int intCountryID = 0; int intAssessUserID = 0; int intUserID = 0; int intAssessmentID = 0; if (dr["SpeciesID"] != null) { int.TryParse(dr["SpeciesID"].ToString(), out intSpeciesID); } if (dr["UserID"] != null) { int.TryParse(dr["UserID"].ToString(), out intAssessUserID); } if (dr["CountryID"] != null) { int.TryParse(dr["CountryID"].ToString(), out intCountryID); } if (dr["AssessmentID"] != null) { strAssessmentID = dr["AssessmentID"].ToString(); } if (e.Row.FindControl("hlAdd") != null) { hlAdd = (HyperLink)e.Row.FindControl("hlAdd"); string strURL = "CreateAssessment.aspx?AssessmentID=0" + "&SpeciesID=" + intSpeciesID.ToString() + "&CountryID=" + intCountryID.ToString(); hlAdd.NavigateUrl = strURL; hlAdd.Text = DataProxy.LoadString("ADDASSESSMENTLABEL", strCurrentLanguage); //Only allow user to add an assessment if they haven't already created one for that country/species combo if (intCurrentUserID == 0) { hlAdd.Visible = true; } else { //Check here if user has an assessment if (intAssessUserID != intCurrentUserID) { if (strAssessmentID != "") { intAssessmentID = Convert.ToInt32(strAssessmentID); } intUserID = DataProxy.GetUserIDForAssessment(intCurrentUserID, intCountryID, intSpeciesID); if (intUserID > 0) { hlAdd.Visible = false; } else { hlAdd.Visible = true; } } else { hlAdd.Visible = false; } } } if (e.Row.FindControl("lnkDelete") != null) { lnkDelete = (LinkButton)e.Row.FindControl("lnkDelete"); if (intCurrentUserID != 0) { if (intAssessUserID == intCurrentUserID) { lnkDelete.Visible = true; int intAssessID = Convert.ToInt32(strAssessmentID); lnkDelete.CommandArgument = intAssessID.ToString(); lblDelete = (Label)e.Row.FindControl("lblDelete"); if (lblDelete != null) { lblDelete.Text = DataProxy.LoadString("DELETETEXT", strCurrentLanguage); } } else { lnkDelete.Visible = false; } } else { lnkDelete.Visible = false; } } if (e.Row.FindControl("hlEdit") != null) { hlEdit = (HyperLink)e.Row.FindControl("hlEdit"); string strURL = "EditAssessment.aspx?AssessmentID=" + strAssessmentID + "&SpeciesID=" + intSpeciesID.ToString() + "&CountryID=" + intCountryID.ToString(); if (intCurrentUserID != 0) { if (intAssessUserID == intCurrentUserID) { hlEdit.Visible = true; hlEdit.NavigateUrl = strURL; //Check if assessment has been marked 'Completed' and flag appropriately for user int intAssessID = Convert.ToInt32(strAssessmentID); if (DataProxy.CheckAssessmentComplete(intAssessID)) { hlEdit.Text = DataProxy.LoadString("EDITASSESSMENTLABEL", strCurrentLanguage); } else { hlEdit.Text = DataProxy.LoadString("EDITINCOMPLETEASSESSMENTLABEL", strCurrentLanguage); } } } else { hlEdit.Visible = false; } } if (e.Row.FindControl("hlSpeciesResults") != null) { hlSpeciesResults = (HyperLink)e.Row.FindControl("hlSpeciesResults"); string strURL = ""; if (strAssessmentID != "0") { strURL = "AssessmentResults.aspx?AssessmentID=" + strAssessmentID + "&SpeciesID=" + dr["SpeciesID"].ToString() + "&CountryID=" + dr["CountryID"].ToString(); } hlSpeciesResults.NavigateUrl = strURL; } } }
protected void SetReportTitle(string strTriggerShortName) { string strTotals = ""; string strReportTitleText = lblReportTitle.Text; if (ddlCountries.SelectedValue != "") { if (strCurrentLanguage == "English") { strReportTitleText += " in " + ddlCountries.SelectedItem.Text + " "; } else { if (strCurrentLanguage == "Spanish") { strReportTitleText += " para " + ddlTriggers.SelectedItem.Text + " "; } else { strReportTitleText += " - " + ddlTriggers.SelectedItem.Text + " "; } } } if (strCurrentLanguage == "English") { strReportTitleText += " for " + ddlTriggers.SelectedItem.Text + " "; } else { if (strCurrentLanguage == "Spanish") { strReportTitleText += " en " + ddlCountries.SelectedItem.Text + " "; } else { strReportTitleText += " - " + ddlTriggers.SelectedItem.Text + " "; } } if (ddlCountries.SelectedValue != "") { strReportTitleText += "<br>"; DataTable dt = DataProxy.GetTriggerCounts(intLanguageID, Convert.ToInt32(ddlCountries.SelectedValue)); if (dt != null) { DataView dv = dt.DefaultView; string strFilter = "1=1 "; if (strTriggerShortName.Trim() != "") { strFilter += " AND TriggerShortName = '" + strTriggerShortName.Trim() + "'"; } dv.RowFilter = strFilter; int icount = dv.Count; for (int i = 0; i < icount; i++) { if (Convert.ToInt32(dv[i]["TriggerTotal"]) > 0) { if (strTriggerShortName.Trim() == "") { strTotals += dv[i]["TriggerTotal"].ToString() + " " + DataProxy.LoadString("RECOMMENDATIONCOUNTLABEL", strCurrentLanguage) + " " + dv[i]["TriggerShortName"].ToString() + "<br>"; } else { strTotals += " " + dv[i]["TriggerTotal"].ToString() + " " + DataProxy.LoadString("RECLABEL", strCurrentLanguage); } } } } } strReportTitleText += strTotals; lblReportTitle.Text = strReportTitleText; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Tab1.CssClass = "Clicked"; MainView.ActiveViewIndex = 0; } if (Session["CurrentLanguage"] == null) { Session["CurrentLanguage"] = "English"; strCurrentLanguage = Session["CurrentLanguage"].ToString(); } else { strCurrentLanguage = Session["CurrentLanguage"].ToString(); } lblPageTitle.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWTITLE", strCurrentLanguage); lblContent1Hdr.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT1HEADER", strCurrentLanguage); lblContent1.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT1", strCurrentLanguage); lblContent2.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT2", strCurrentLanguage); lblContent2Link.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT2LINK", strCurrentLanguage); lblContent2b.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT2B", strCurrentLanguage); lblContent3.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT3", strCurrentLanguage); lblContent4.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT4", strCurrentLanguage); lblContent4Link.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT4LINK", strCurrentLanguage); lblContent4b.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT4B", strCurrentLanguage); lblContent5.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT5", strCurrentLanguage); lblContent5Link.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT5LINK", strCurrentLanguage); lblContent5b.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT5B", strCurrentLanguage); lblContent6.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT6", strCurrentLanguage); lblContent7.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT7", strCurrentLanguage); lblContent7Link.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT7LINK", strCurrentLanguage); lblContent7b.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT7B", strCurrentLanguage); lblContent7Link2.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT7LINK2", strCurrentLanguage); lblContent7c.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT7C", strCurrentLanguage); lblContent8Hdr.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT8HEADER", strCurrentLanguage); lblContent8.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT8", strCurrentLanguage); lblContent8Link.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT8LINK", strCurrentLanguage); lblContent8b.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT8B", strCurrentLanguage); lblContent9Hdr.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT9HEADER", strCurrentLanguage); lblContent9.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT9", strCurrentLanguage); lblContent10.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT10", strCurrentLanguage); lblContent11.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT11", strCurrentLanguage); lblContent12.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT12", strCurrentLanguage); lblContent12Link.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT12LINK", strCurrentLanguage); lblContent12B.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT12BLINK", strCurrentLanguage); lblContent13.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT13", strCurrentLanguage); lblContent14.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT14", strCurrentLanguage); lblContent15.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT15", strCurrentLanguage); lblContent15B.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT15B", strCurrentLanguage); lblContent15C.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT15C", strCurrentLanguage); lblContent15D.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT15D", strCurrentLanguage); lblContent15E.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT15E", strCurrentLanguage); lblContent15Link.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT15LINK", strCurrentLanguage); lblContent15Link2.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT15LINK2", strCurrentLanguage); lblContent15Link3.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT15LINK3", strCurrentLanguage); lblContent15Link4.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT15LINK4", strCurrentLanguage); lblContent15Link5.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT15LINK5", strCurrentLanguage); lblContent15Link6.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT15LINK6", strCurrentLanguage); lblContent16.Text = DataProxy.LoadString("ASSESSMENTOVERVIEWCONTENT16", strCurrentLanguage); }
protected void PopulateAssessmentValues() { try { string s = DataProxy.EvaluateAssessmentTriggers(intAssessmentID); string strValue = DataProxy.GetConsolidatedRecommendations(intLanguageID, intSpeciesID, intCountryID); lblTriggerRecValue.Text = strValue; DataTable dtAssess = DataProxy.GetConsolidatedReportResults(intCountryID, intSpeciesID, 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 = ""; 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); lblAdditionalCommentsValue.Text = dr["Comments"].ToString(); 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(); //For consolidated reports - concatenate all values: lblAssessedByValue.Text = DataProxy.GetConcatAssessedOnValues(dtAssess);//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 { if (strCurrentLanguage.ToUpper() == "FRENCH") { strURL = "~/images/No map data FR.jpg"; } else { strURL = "~/images/No map data EN.jpg"; } } imgRLMapOnly.ImageUrl = strURL; } } } } catch (Exception ex) { lblError.Text = ex.Message; } }
protected void grdAssess_RowDataBound(object sender, GridViewRowEventArgs e) { string strUserName = ""; string strPreviousRow = ""; HyperLink hlQuestion = null; DataRowView dr = (DataRowView)e.Row.DataItem; if (Session["UserName"] != null) { strUserName = Session["UserName"].ToString(); } if (Session["PreviousRow"] != null) { strPreviousRow = Session["PreviousRow"].ToString(); } if (e.Row.RowType == DataControlRowType.Header) { //Set first column/"Question #" header e.Row.Cells[0].Text = DataProxy.LoadString("QUESTIONNUMBERLABEL", strCurrentLanguage); //Set first column/"Short Name" header e.Row.Cells[1].Text = DataProxy.LoadString("SHORTNAMELABEL", strCurrentLanguage); //Set second column/"Question Text" header e.Row.Cells[2].Text = DataProxy.LoadString("QUESTIONTEXTLABEL", strCurrentLanguage); //Set third column/"Response" header e.Row.Cells[3].Text = DataProxy.LoadString("RESPONSELABEL", strCurrentLanguage); //Set fourth column/"Comments" header string strComments = DataProxy.LoadString("COMMENTSLABEL", strCurrentLanguage); if (strComments.IndexOf(":") > 0) { strComments = strComments.Substring(0, strComments.IndexOf(":")); } e.Row.Cells[4].Text = strComments; } if (e.Row.RowType == DataControlRowType.DataRow) { string strQuestionID = ""; if (dr["QuestionID"] != null) { strQuestionID = dr["QuestionNumber"].ToString(); } if (e.Row.FindControl("hlQuestion") != null) { hlQuestion = (HyperLink)e.Row.FindControl("hlQuestion"); string strURL = ""; if (strCurrentLanguage == "English") { strURL = "/Help/EN/QuestionsAnswers.htm#q" + strQuestionID; } else { if (strCurrentLanguage == "Spanish") { strURL = "/Help/ES/QuestionsAnswers.htm#q" + strQuestionID; } else { strURL = "/Help/FR/QuestionsAnswers.htm#q"; } } hlQuestion.NavigateUrl = strURL; hlQuestion.Text = strQuestionID; hlQuestion.Visible = true; } } }
private async Task <List <Model.ExperimentResult> > GetExperimentResults(string apiUrl, List <Model.Data> expData) { var dataProxy = new DataProxy(); return(await dataProxy.GetExperimentResult(apiUrl, expData)); }
protected void PopulateAssessmentValues() { try { string s = DataProxy.EvaluateAssessmentTriggers(intAssessmentID); string strValue = DataProxy.GetAssessmentTriggers(intAssessmentID, intLanguageID, "R", intSpeciesID, 0, Page.ResolveUrl("~/images/Question_mark%2025%20px.png")); 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 { if (strCurrentLanguage.ToUpper() == "FRENCH") { strURL = "~/images/No map data FR.jpg"; } else { strURL = "~/images/No map data EN.jpg"; } } imgRLMapOnly.ImageUrl = strURL; } } } } catch (Exception ex) { lblError.Text = ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Section1.CssClass = "Clicked"; MainView.ActiveViewIndex = 0; } if (Session["CurrentLanguage"] == null) { Session["CurrentLanguage"] = "English"; strCurrentLanguage = Session["CurrentLanguage"].ToString(); } else { strCurrentLanguage = Session["CurrentLanguage"].ToString(); } //Set global variables based on URL values. if (Request.QueryString["AssessmentID"] != null) { intAssessmentID = Convert.ToInt32(Request.QueryString["AssessmentID"].ToString()); } if (Request.QueryString["SpeciesID"] != null) { intSpeciesID = Convert.ToInt32(Request.QueryString["SpeciesID"].ToString()); } if (Request.QueryString["CountryID"] != null) { intCountryID = Convert.ToInt32(Request.QueryString["CountryID"].ToString()); } if (Session["UserName"] == null) { //Force user to login to create an assessment... string strURL = "Login.aspx?SpeciesID=" + intSpeciesID.ToString() + "&CountryID=" + intCountryID.ToString(); Response.Redirect(strURL); } else { //Set UserID string strUserName = Session["UserName"].ToString(); intUserID = DataProxy.GetUserID(strUserName); } //Set standard label values based on current language. lblPageTitle.Text = DataProxy.LoadString("CREATEASSESSMENTTITLE", strCurrentLanguage); lblCountry.Text = DataProxy.LoadString("COUNTRYLABEL", strCurrentLanguage); lblPA1Definition.Text = DataProxy.LoadString("POSSIBLEANSWERLABEL", strCurrentLanguage); lblPA7Definition.Text = DataProxy.LoadString("POSSIBLEANSWERLABEL", strCurrentLanguage); //lblPA19Definition.Text = DataProxy.LoadString("POSSIBLEANSWERLABEL", strCurrentLanguage); //lblPA20Definition.Text = DataProxy.LoadString("POSSIBLEANSWERLABEL", strCurrentLanguage); lblOrder.Text = DataProxy.LoadString("ORDERLABEL", strCurrentLanguage); lblFamily.Text = DataProxy.LoadString("FAMILYLABEL", strCurrentLanguage); lblGlobalRLC.Text = DataProxy.LoadString("GLOBALRLCLABEL", strCurrentLanguage); lblNationalRLC.Text = DataProxy.LoadString("NATIONALRLCLABEL", strCurrentLanguage); lblEDScore.Text = DataProxy.LoadString("EDSCORELABEL", strCurrentLanguage); lblDistribution.Text = DataProxy.LoadString("DISTRIBUTIONLABEL", strCurrentLanguage); lblComments1.Text = DataProxy.LoadString("COMMENTSLABEL", strCurrentLanguage); lblComments2.Text = DataProxy.LoadString("COMMENTSLABEL", strCurrentLanguage); lblComments3.Text = DataProxy.LoadString("COMMENTSLABEL", strCurrentLanguage); lblComments4.Text = DataProxy.LoadString("COMMENTSLABEL", strCurrentLanguage); lblComments5.Text = DataProxy.LoadString("COMMENTSLABEL", strCurrentLanguage); lblComments6.Text = DataProxy.LoadString("COMMENTSLABEL", strCurrentLanguage); lblComments7.Text = DataProxy.LoadString("COMMENTSLABEL", strCurrentLanguage); lblComments8.Text = DataProxy.LoadString("COMMENTSLABEL", strCurrentLanguage); lblComments9.Text = DataProxy.LoadString("COMMENTSLABEL", strCurrentLanguage); lblComments10.Text = DataProxy.LoadString("COMMENTSLABEL", strCurrentLanguage); lblComments11.Text = DataProxy.LoadString("COMMENTSLABEL", strCurrentLanguage); lblComments12.Text = DataProxy.LoadString("COMMENTSLABEL", strCurrentLanguage); lblComments13.Text = DataProxy.LoadString("COMMENTSLABEL", strCurrentLanguage); lblComments14.Text = DataProxy.LoadString("COMMENTSLABEL", strCurrentLanguage); lblComments15.Text = DataProxy.LoadString("COMMENTSLABEL", strCurrentLanguage); lblComments16.Text = DataProxy.LoadString("COMMENTSLABEL", strCurrentLanguage); lblComments17.Text = DataProxy.LoadString("COMMENTSLABEL", strCurrentLanguage); lblComments18.Text = DataProxy.LoadString("COMMENTSLABEL", strCurrentLanguage); lblComments19.Text = DataProxy.LoadString("COMMENTSLABEL", strCurrentLanguage); lblComments20.Text = DataProxy.LoadString("COMMENTSLABEL", strCurrentLanguage); chkComplete.Text = DataProxy.LoadString("MARKASSESSMENTCOMPLETETEXT", strCurrentLanguage); lblError.Text = ""; SetSectionHeaderLabels(); if (!Page.IsPostBack) { PopulateCountriesList(); PopulateAssessmentValues(); Intialize_Sections(); } /*lblOrder.Text = DataProxy.LoadString("ORDERLABEL", strCurrentLanguage); * lblFamily.Text = DataProxy.LoadString("FAMILYLABEL", strCurrentLanguage); * lblGlobalRLC.Text = DataProxy.LoadString("GLOBALRLCLABEL", strCurrentLanguage); * lblNationalRLC.Text = DataProxy.LoadString("NATIONALRLCLABEL", strCurrentLanguage); * lblEDScore.Text = DataProxy.LoadString("EDSCORELABEL", strCurrentLanguage); * lblDistribution.Text = DataProxy.LoadString("DISTRIBUTIONLABEL", strCurrentLanguage); * //lblRLMap.Text = DataProxy.LoadString("REDLISTMAPLABEL", strCurrentLanguage); * lblAddMap.Text = DataProxy.LoadString("ADDOBSERVATIONINATURALISTLABEL", strCurrentLanguage); * lblAssessedFor.Text = DataProxy.LoadString("ASSESSMENTRESULTSCOUNTRYLABEL", strCurrentLanguage); * lblAssessedBy.Text = DataProxy.LoadString("ASSESSMENTRESULTSBYLABEL", strCurrentLanguage); * lblAssessedOn.Text = DataProxy.LoadString("ASSESSMENTRESULTSONLABEL", strCurrentLanguage); * PopulateAssessmentValues(); * if (strCurrentLanguage == "Spanish") * imgRLMap.ImageUrl = "images/world map_bw ES.jpg"; * else * imgRLMap.ImageUrl = "images/world map_bw EN.jpg"; */ }
protected void PopulateAssessmentsList() { ddlAssessments.Items.Add(DataProxy.LoadString("ASSESSMENTSDDLLVALUE1", strCurrentLanguage)); ddlAssessments.Items.Add(DataProxy.LoadString("ASSESSMENTSDDLLVALUE2", strCurrentLanguage)); ddlAssessments.Items.Add(DataProxy.LoadString("ASSESSMENTSDDLLVALUE3", strCurrentLanguage)); }
protected void grdApproveUser_RowDataBound(object sender, GridViewRowEventArgs e) { HyperLink hlDeny = null; HyperLink hlApprove = null; Label lblASGMember = null; Label lblStatus = null; Label lblUserID = null; string strUserID = ""; string strApproved = ""; DataRowView dr = (DataRowView)e.Row.DataItem; if (e.Row.RowType == DataControlRowType.Header) { //Set first column/"Last Name" header e.Row.Cells[0].Text = DataProxy.LoadString("LASTNAMELABEL", strCurrentLanguage); //Set second column/"First Name" header e.Row.Cells[1].Text = DataProxy.LoadString("FIRSTNAMELABEL", strCurrentLanguage); //Set third column/"Organization" header e.Row.Cells[2].Text = DataProxy.LoadString("ORGANIZATIONLABEL", strCurrentLanguage); //Set fourth column/"Email" header e.Row.Cells[3].Text = DataProxy.LoadString("EMAILLABEL", strCurrentLanguage); //Set fifth column/"Country" header e.Row.Cells[4].Text = DataProxy.LoadString("COUNTRYLABEL", strCurrentLanguage); //Set sixth column/"Expertise" header e.Row.Cells[5].Text = DataProxy.LoadString("USERCOUNTRIESTEXT", strCurrentLanguage); //Set seventh column/"ASGMember" header e.Row.Cells[6].Text = DataProxy.LoadString("ASGMEMBERLABEL", strCurrentLanguage); //Set eighth column/"Status" header //e.Row.Cells[7].Text = DataProxy.LoadString("STATUS", strCurrentLanguage); } if (e.Row.RowType == DataControlRowType.DataRow) { if (dr["AmphibianSpecialistGroupMember"] != null) { if (e.Row.FindControl("lblASGMember") != null) { lblASGMember = (Label)e.Row.FindControl("lblASGMember"); if (dr["AmphibianSpecialistGroupMember"].ToString() == "False") { lblASGMember.Text = "No"; } else { lblASGMember.Text = "Yes"; } } } if (dr["UserID"] != null) { strUserID = dr["UserID"].ToString(); } if (dr["Status"] != null) { if (e.Row.FindControl("lblStatus") != null) { lblStatus = (Label)e.Row.FindControl("lblStatus"); if (dr["Status"].ToString() == "False") { lblStatus.Text = DataProxy.LoadString("NOTAPPROVEDLABEL", strCurrentLanguage); } else { lblStatus.Text = DataProxy.LoadString("APPROVEDLABEL", strCurrentLanguage); } } } if (dr["Approved"] != null) { strApproved = dr["Approved"].ToString(); } if (e.Row.FindControl("hlApprove") != null) { hlApprove = (HyperLink)e.Row.FindControl("hlApprove"); hlApprove.Text = DataProxy.LoadString("APPROVETEXT", strCurrentLanguage); hlApprove.NavigateUrl = "FacilitatorDashboard.aspx?Approve=1&UserID=" + strUserID; if (strApproved == "True") { hlApprove.Visible = false; } else { hlApprove.Visible = true; } } if (e.Row.FindControl("hlDeny") != null) { hlDeny = (HyperLink)e.Row.FindControl("hlDeny"); if (strApproved == "True") { hlDeny.Text = DataProxy.LoadString("UNAPPROVELABEL", strCurrentLanguage); } else { hlDeny.Text = DataProxy.LoadString("DENYTEXT", strCurrentLanguage); } hlDeny.NavigateUrl = "FacilitatorDashboard.aspx?Approve=0&UserID=" + strUserID; } } }
public static string Unarchive(int assessID) { string dummy = DataProxy.UnarchiveAssessment(assessID); return(dummy); }
protected void Page_Load(object sender, EventArgs e) { if (Session["CurrentLanguage"] == null) { Session["CurrentLanguage"] = "English"; strCurrentLanguage = Session["CurrentLanguage"].ToString(); } else { strCurrentLanguage = Session["CurrentLanguage"].ToString(); } if (Request.QueryString["UID"] != null) { strUserName = Request.QueryString["UID"].ToString(); strAssessorUID = Request.QueryString["UID"].ToString(); intUserID = DataProxy.GetUserID(strAssessorUID); Session["AssessorUserID"] = intUserID; Session["AssessorUserName"] = strAssessorUID; hlProfile.NavigateUrl = "EditUser.aspx?UserID=" + Session["AssessorUserID"].ToString(); hlProfile.Text = DataProxy.LoadString("EDITUSERPROFILELABEL", strCurrentLanguage); lblEditUserInfo.Text = DataProxy.LoadString("EDITUSERPROFILEINSTRUCTIONS", strCurrentLanguage); } else { if (Session["AssessorUserID"] != null) { hlProfile.NavigateUrl = "EditUser.aspx?UserID=" + Session["AssessorUserID"].ToString(); hlProfile.Text = DataProxy.LoadString("EDITUSERPROFILELABEL", strCurrentLanguage); lblEditUserInfo.Text = DataProxy.LoadString("EDITUSERPROFILEINSTRUCTIONS", strCurrentLanguage); } } btnPrint.Text = DataProxy.LoadString("PRINTLABEL", strCurrentLanguage); btnExport.Text = DataProxy.LoadString("EXPORTLABEL", strCurrentLanguage); btnPrintApproveCA.Text = DataProxy.LoadString("PRINTLABEL", strCurrentLanguage); btnExportApproveCA.Text = DataProxy.LoadString("EXPORTLABEL", strCurrentLanguage); btnPrintIncomplete.Text = DataProxy.LoadString("PRINTLABEL", strCurrentLanguage); btnExportIncomplete.Text = DataProxy.LoadString("EXPORTLABEL", strCurrentLanguage); lblIncompleteTitle.Text = DataProxy.LoadString("INCOMPLETEASSESSMENTS", strCurrentLanguage); lblReportTitle.Text = DataProxy.LoadString("APPROVEUSERREQUEST", strCurrentLanguage); lblApproveCATitle.Text = DataProxy.LoadString("APPROVECOMPLETEDASSESSMENTS", strCurrentLanguage); btnSearch.Text = DataProxy.LoadString("SEARCHLINK", strCurrentLanguage); intLanguageID = DataProxy.GetLanguageID(strCurrentLanguage); lblPageTitle.Text = DataProxy.LoadString("DASHBOARDLINK", strCurrentLanguage); lblIncompleteAssessments.Text = DataProxy.LoadString("INCOMPLETEASSESSMENTS", strCurrentLanguage); lblTextParagraph.Text = DataProxy.LoadString("ASSESSORPARAGRAPHTEXT", strCurrentLanguage); lblApproveUserRequest.Text = DataProxy.LoadString("APPROVEUSERREQUEST", strCurrentLanguage); lblApproveUserTextParagraph.Text = DataProxy.LoadString("APPROVEASSESSORPARAGRAPHTEXT", strCurrentLanguage); lblApproveCompleteAssessments.Text = DataProxy.LoadString("APPROVECOMPLETEDASSESSMENTS", strCurrentLanguage); lblApproveCompleteAssessmentsParagraph.Text = DataProxy.LoadString("APPROVECOMPLETEDASSESSMENTSPARAGRAPHTEXT", strCurrentLanguage); lblCountry.Text = DataProxy.LoadString("COUNTRYLABEL", strCurrentLanguage); rbSort.Items[0].Text = DataProxy.LoadString("DATELABEL", strCurrentLanguage); rbSort.Items[1].Text = DataProxy.LoadString("COUNTRYLABEL", strCurrentLanguage); rbSort.Items[2].Text = DataProxy.LoadString("ASSESSORLABEL", strCurrentLanguage); if (Request.QueryString["CountryID"] != null || ddlCountries.SelectedValue != "") { if (Request.QueryString["CountryID"] != null) { intCountryID = Convert.ToInt32(Request.QueryString["CountryID"]); } else { intCountryID = Convert.ToInt32(ddlCountries.SelectedValue); } } else { PopulateCountriesList(); } GetUserRequests(); GetCompletedAssessments(); GetSearchResults(); grdApproveCompletedAssess.EmptyDataText = DataProxy.LoadString("NORECORDSFOUND", strCurrentLanguage); grdApproveUser.EmptyDataText = DataProxy.LoadString("NORECORDSFOUND", strCurrentLanguage); grdResults.EmptyDataText = DataProxy.LoadString("NORECORDSFOUND", strCurrentLanguage); //See which option was picked for various functions if (Request.QueryString["Approve"] != null) { string strApproved = Request.QueryString["Approve"].ToString(); CompleteUserRequest(strApproved); } if (Request.QueryString["ApproveAssessment"] != null) { string strApproved = Request.QueryString["ApproveAssessment"].ToString(); CompleteAssessmentRequest(strApproved); } if (Request.QueryString["EditAssessment"] != null) { //Allow Facilitator to edit assessment } }
protected void GetSearchResults() { bool bCountrySearch = false; bool bSpeciesSearch = false; //can't verify string value in case it's not English, so we're going to assume positions do NOT change in drop-down: int assessmentSearch = ddlAssessments.SelectedIndex; string assessmentFilter = "ALL"; //adding this variable to make it more memorable / readable in logic switch (assessmentSearch) { case 0: assessmentFilter = "ALL"; break; case 1: assessmentFilter = "WITH"; break; case 2: assessmentFilter = "WITHOUT"; break; } bool bUserOnly = chkUserResultsOnly.Checked; DataTable dtResults = null; string strWrappedText = ""; if (txtSpecies.Text.Trim() != "") { strWrappedText = DataProxy.WrapSearchText(txtSpecies.Text.Trim()); } else { if (Session["txtSpeciesValue"] != null) { strWrappedText = DataProxy.WrapSearchText(Session["txtSpeciesValue"].ToString()); } } if (ddlCountries.SelectedIndex > 0) //|| Session["ddlCountriesValue"] != null) { bCountrySearch = true; } if (txtSpecies.Text.Trim() != "") // || Session["txtSpeciesValue"] != null) { bSpeciesSearch = true; } int intUserID = DataProxy.GetUserID(strUserName); int intCountryID = 0; if (ddlCountries.SelectedValue != "") { intCountryID = Convert.ToInt32(ddlCountries.SelectedValue); } //else //{ // if (Session["ddlCountriesValue"] != null) // { // intCountryID = Convert.ToInt32(Session["ddlCountriesValue"]); // } //} if (strUserName == "" && chkUserResultsOnly.Checked) { lblError.Text = DataProxy.LoadString("SEARCHRESULTSNOCURRENTUSER", strCurrentLanguage); } if (assessmentFilter == "ALL") { dtResults = DataProxy.GetAssessmentSearchResults(intCountryID, strWrappedText, intUserID); } else { dtResults = DataProxy.GetFilteredAssessmentSearchResults(intCountryID, strWrappedText, intUserID, assessmentFilter); } if (chkUserResultsOnly.Checked) //Limit results to current User's ID... { if (dtResults != null && intUserID != 0) { dtResults.DefaultView.RowFilter = "UserID = " + intUserID.ToString(); } } /*OLD LOGIC * if (bCountrySearch && bSpeciesSearch) * { * if (chkUserResultsOnly.Checked || strUserName != "") * dtResults = DataProxy.GetSearchResultsCountryandSpecies(strWrappedText, ddlCountries.SelectedValue, true); * else * dtResults = DataProxy.GetSearchResultsCountryandSpecies(strWrappedText, ddlCountries.SelectedValue, false); * } * * if (bCountrySearch && !bSpeciesSearch) * { * if (chkUserResultsOnly.Checked || strUserName != "") * dtResults = DataProxy.GetSearchResultsCountry(ddlCountries.SelectedValue, true); * else * dtResults = DataProxy.GetSearchResultsCountry(ddlCountries.SelectedValue, false); * } * * if (bSpeciesSearch && !bCountrySearch || * (!bSpeciesSearch && !bCountrySearch)) //Neither one checked - just get all with 'blank' species filter * { * if (chkUserResultsOnly.Checked || strUserName != "") * dtResults = DataProxy.GetSearchResultsSpecies(strWrappedText, true); * else * dtResults = DataProxy.GetSearchResultsSpecies(strWrappedText, false); * } * */ grdResults.DataSource = dtResults; grdResults.DataBind(); grdResults.Visible = true; Session["dvResults"] = dtResults.DefaultView; if (txtSpecies.Text.Trim() == "" && ddlCountries.SelectedValue == "") { lblReportTitle.Text = DataProxy.LoadString("ASSESSMENTSLABEL", strCurrentLanguage); } else { if (ddlCountries.SelectedValue != "") { if (txtSpecies.Text.Trim() != "") { lblReportTitle.Text = txtSpecies.Text.Trim().ToUpper() + " " + DataProxy.LoadString("ASSESSMENTSLABELFILTER", strCurrentLanguage) + " " + ddlCountries.SelectedItem.Text; } else { lblReportTitle.Text += " " + ddlCountries.SelectedItem.Text; } } else { if (txtSpecies.Text.Trim() != "") { lblReportTitle.Text = txtSpecies.Text.Trim().ToUpper() + " " + DataProxy.LoadString("ASSESSMENTSLABELFILTERNC", strCurrentLanguage); } } } //Put it all together: if (ddlAssessments.SelectedIndex > 0) { lblReportTitle.Text = dtResults.Rows.Count.ToString() + " " + ddlAssessments.SelectedValue.ToLower() + " " + lblReportTitle.Text; } else { lblReportTitle.Text = dtResults.Rows.Count.ToString() + " " + lblReportTitle.Text; } }
protected void ddlQ20_SelectedIndexChanged(object sender, EventArgs e) { string strDefinition = DataProxy.GetPossibleAnswerDefinition(ddlQ20.SelectedValue); //lblPA20DefinitionValue.Text = strDefinition; }
/// <summary> /// Put the soft delete back in so other tests won't be affected /// </summary> /// <param name="request">UpdateSoftDeleteRequestDC contains the id and table</param> /// <returns>StatusReplyDC contains information about the database command execution</returns> public StatusReplyDC UpdateSoftDelete(DataProxy.UpdateSoftDeleteRequestDC request) { return DAL.DAL.UpdateSoftDelete(request); }
protected void SaveAssessmentResponses(int intAssessmentID) { //Identify if a response was selected for each question and insert the response given for the current user. int intResponseID = 0; int intAssessID = DataProxy.UpdateAssessment(intAssessmentID, intUserID, intCountryID, chkComplete.Checked, false); if (ddlQ1.SelectedIndex != 0 && ddlQ1.SelectedIndex != -1) { intResponseID = DataProxy.InsertResponse(intAssessmentID, Convert.ToInt32(ddlQ1.SelectedValue), txtComments1.Text.Trim()); } if (ddlQ2.SelectedIndex != 0 && ddlQ2.SelectedIndex != -1) { intResponseID = DataProxy.InsertResponse(intAssessmentID, Convert.ToInt32(ddlQ2.SelectedValue), txtComments2.Text.Trim()); } if (ddlQ3.SelectedIndex != 0 && ddlQ3.SelectedIndex != -1) { intResponseID = DataProxy.InsertResponse(intAssessmentID, Convert.ToInt32(ddlQ3.SelectedValue), txtComments3.Text.Trim()); } if (ddlQ4.SelectedIndex != 0 && ddlQ4.SelectedIndex != -1) { intResponseID = DataProxy.InsertResponse(intAssessmentID, Convert.ToInt32(ddlQ4.SelectedValue), txtComments4.Text.Trim()); } if (ddlQ5.SelectedIndex != 0 && ddlQ5.SelectedIndex != -1) { intResponseID = DataProxy.InsertResponse(intAssessmentID, Convert.ToInt32(ddlQ5.SelectedValue), txtComments5.Text.Trim()); } if (ddlQ6.SelectedIndex != 0 && ddlQ6.SelectedIndex != -1) { intResponseID = DataProxy.InsertResponse(intAssessmentID, Convert.ToInt32(ddlQ6.SelectedValue), txtComments6.Text.Trim()); } if (ddlQ7.SelectedIndex != 0 && ddlQ7.SelectedIndex != -1) { intResponseID = DataProxy.InsertResponse(intAssessmentID, Convert.ToInt32(ddlQ7.SelectedValue), txtComments7.Text.Trim()); } if (ddlQ8.SelectedIndex != 0 && ddlQ8.SelectedIndex != -1) { intResponseID = DataProxy.InsertResponse(intAssessmentID, Convert.ToInt32(ddlQ8.SelectedValue), txtComments8.Text.Trim()); } if (ddlQ9.SelectedIndex != 0 && ddlQ9.SelectedIndex != -1) { intResponseID = DataProxy.InsertResponse(intAssessmentID, Convert.ToInt32(ddlQ9.SelectedValue), txtComments9.Text.Trim()); } if (ddlQ10.SelectedIndex != 0 && ddlQ10.SelectedIndex != -1) { intResponseID = DataProxy.InsertResponse(intAssessmentID, Convert.ToInt32(ddlQ10.SelectedValue), txtComments10.Text.Trim()); } if (ddlQ11.SelectedIndex != 0 && ddlQ11.SelectedIndex != -1) { intResponseID = DataProxy.InsertResponse(intAssessmentID, Convert.ToInt32(ddlQ11.SelectedValue), txtComments11.Text.Trim()); } if (ddlQ12.SelectedIndex != 0 && ddlQ12.SelectedIndex != -1) { intResponseID = DataProxy.InsertResponse(intAssessmentID, Convert.ToInt32(ddlQ12.SelectedValue), txtComments12.Text.Trim()); } if (ddlQ13.SelectedIndex != 0 && ddlQ13.SelectedIndex != -1) { intResponseID = DataProxy.InsertResponse(intAssessmentID, Convert.ToInt32(ddlQ13.SelectedValue), txtComments13.Text.Trim()); } if (ddlQ14.SelectedIndex != 0 && ddlQ14.SelectedIndex != -1) { intResponseID = DataProxy.InsertResponse(intAssessmentID, Convert.ToInt32(ddlQ14.SelectedValue), txtComments14.Text.Trim()); } if (ddlQ15.SelectedIndex != 0 && ddlQ15.SelectedIndex != -1) { intResponseID = DataProxy.InsertResponse(intAssessmentID, Convert.ToInt32(ddlQ15.SelectedValue), txtComments15.Text.Trim()); } if (ddlQ16.SelectedIndex != 0 && ddlQ16.SelectedIndex != -1) { intResponseID = DataProxy.InsertResponse(intAssessmentID, Convert.ToInt32(ddlQ16.SelectedValue), txtComments16.Text.Trim()); } if (ddlQ17.SelectedIndex != 0 && ddlQ17.SelectedIndex != -1) { intResponseID = DataProxy.InsertResponse(intAssessmentID, Convert.ToInt32(ddlQ17.SelectedValue), txtComments17.Text.Trim()); } if (ddlQ18.SelectedIndex != 0 && ddlQ18.SelectedIndex != -1) { intResponseID = DataProxy.InsertResponse(intAssessmentID, Convert.ToInt32(ddlQ18.SelectedValue), txtComments18.Text.Trim()); } if (ddlQ19.SelectedIndex != 0 && ddlQ19.SelectedIndex != -1) { intResponseID = DataProxy.InsertResponse(intAssessmentID, Convert.ToInt32(ddlQ19.SelectedValue), txtComments19.Text.Trim()); } if (ddlQ20.SelectedIndex != 0 && ddlQ20.SelectedIndex != -1) { intResponseID = DataProxy.InsertResponse(intAssessmentID, Convert.ToInt32(ddlQ20.SelectedValue), txtComments20.Text.Trim()); } }
protected void PopulateQuestionsForSection(int intSectionID, string strCurLanguage) { try { int intLanguageID = DataProxy.GetLanguageID(strCurLanguage); DataTable dtQuestions = DataProxy.GetQuestionsForSection(intSectionID, intLanguageID); int intQuestionID = 0; //Loop through Questions and populate the controls as necessary... for (int i = 0; i < dtQuestions.Rows.Count; i++) { DataRow dr = dtQuestions.Rows[i]; intQuestionID = Convert.ToInt32(dr["QuestionID"].ToString()); switch (intQuestionID) { case 1: lblQ1.Text = "1. " + dr["QuestionText"].ToString(); break; case 2: lblQ2.Text = "2. " + dr["QuestionText"].ToString(); break; case 3: lblQ3.Text = "3. " + dr["QuestionText"].ToString(); break; case 4: lblQ4.Text = "4. " + dr["QuestionText"].ToString(); break; case 5: lblQ5.Text = "5. " + dr["QuestionText"].ToString(); break; case 6: lblQ6.Text = "6. " + dr["QuestionText"].ToString(); break; case 7: lblQ7.Text = "7. " + dr["QuestionText"].ToString(); break; case 8: lblQ8.Text = "8. " + dr["QuestionText"].ToString(); break; case 9: lblQ9.Text = "9. " + dr["QuestionText"].ToString(); break; case 10: lblQ10.Text = "10. " + dr["QuestionText"].ToString(); break; case 11: lblQ11.Text = "11. " + dr["QuestionText"].ToString(); break; case 12: lblQ12.Text = "12. " + dr["QuestionText"].ToString(); break; case 13: lblQ13.Text = "13. " + dr["QuestionText"].ToString(); break; case 14: lblQ14.Text = "14. " + dr["QuestionText"].ToString(); break; case 15: lblQ15.Text = "15. " + dr["QuestionText"].ToString(); break; case 16: lblQ16.Text = "16. " + dr["QuestionText"].ToString(); break; case 17: lblQ17.Text = "17. " + dr["QuestionText"].ToString(); break; case 18: lblQ18.Text = "18. " + dr["QuestionText"].ToString(); break; case 19: lblQ19.Text = "19. " + dr["QuestionText"].ToString(); break; case 20: lblQ20.Text = "20. " + dr["QuestionText"].ToString(); break; } PopulatePossibleAnswers(intQuestionID, intLanguageID); } } catch (Exception ex) { lblError.Text = ex.Message; } }
protected TProxy GetFieldProxy <TProxy>(StructField <TProxy> field, bool polymorphic = true) where TProxy : IDataProxy { return(DataProxy.Create <TProxy>(Process, Address.OffsetBy(field.Offset), polymorphic)); }
protected void PopulatePossibleAnswers(int intQuestionID, int intLanguageID) { try { DataTable dtPossibleAnswers = DataProxy.GetPossibleResponsesForQuestion(intQuestionID, intLanguageID); if (dtPossibleAnswers != null) { if (intQuestionID == 1) { ddlQ1.Items.Add(new ListItem(" ", "0")); for (int i = 0; i < dtPossibleAnswers.Rows.Count; i++) { DataRow dr = dtPossibleAnswers.Rows[i]; ddlQ1.Items.Add(new ListItem(dr["PossibleAnswerText"].ToString(), dr["PossibleAnswerID"].ToString())); } ddlQ1.SelectedIndex = 0; } if (intQuestionID == 2) { ddlQ2.Items.Add(new ListItem(" ", "0")); for (int i = 0; i < dtPossibleAnswers.Rows.Count; i++) { DataRow dr = dtPossibleAnswers.Rows[i]; ddlQ2.Items.Add(new ListItem(dr["PossibleAnswerText"].ToString(), dr["PossibleAnswerID"].ToString())); } ddlQ2.SelectedIndex = 0; } if (intQuestionID == 3) { ddlQ3.Items.Add(new ListItem(" ", "0")); for (int i = 0; i < dtPossibleAnswers.Rows.Count; i++) { DataRow dr = dtPossibleAnswers.Rows[i]; ddlQ3.Items.Add(new ListItem(dr["PossibleAnswerText"].ToString(), dr["PossibleAnswerID"].ToString())); } ddlQ3.SelectedIndex = 0; } if (intQuestionID == 4) { ddlQ4.Items.Add(new ListItem(" ", "0")); for (int i = 0; i < dtPossibleAnswers.Rows.Count; i++) { DataRow dr = dtPossibleAnswers.Rows[i]; ddlQ4.Items.Add(new ListItem(dr["PossibleAnswerText"].ToString(), dr["PossibleAnswerID"].ToString())); } ddlQ4.SelectedIndex = 0; } if (intQuestionID == 5) { ddlQ5.Items.Add(new ListItem(" ", "0")); for (int i = 0; i < dtPossibleAnswers.Rows.Count; i++) { DataRow dr = dtPossibleAnswers.Rows[i]; ddlQ5.Items.Add(new ListItem(dr["PossibleAnswerText"].ToString(), dr["PossibleAnswerID"].ToString())); } ddlQ5.SelectedIndex = 0; } if (intQuestionID == 6) { ddlQ6.Items.Add(new ListItem(" ", "0")); for (int i = 0; i < dtPossibleAnswers.Rows.Count; i++) { DataRow dr = dtPossibleAnswers.Rows[i]; ddlQ6.Items.Add(new ListItem(dr["PossibleAnswerText"].ToString(), dr["PossibleAnswerID"].ToString())); } ddlQ6.SelectedIndex = 0; } if (intQuestionID == 7) { ddlQ7.Items.Add(new ListItem(" ", "0")); for (int i = 0; i < dtPossibleAnswers.Rows.Count; i++) { DataRow dr = dtPossibleAnswers.Rows[i]; ddlQ7.Items.Add(new ListItem(dr["PossibleAnswerText"].ToString(), dr["PossibleAnswerID"].ToString())); } ddlQ7.SelectedIndex = 0; } if (intQuestionID == 8) { ddlQ8.Items.Add(new ListItem(" ", "0")); for (int i = 0; i < dtPossibleAnswers.Rows.Count; i++) { DataRow dr = dtPossibleAnswers.Rows[i]; ddlQ8.Items.Add(new ListItem(dr["PossibleAnswerText"].ToString(), dr["PossibleAnswerID"].ToString())); } ddlQ8.SelectedIndex = 0; } if (intQuestionID == 9) { ddlQ9.Items.Add(new ListItem(" ", "0")); for (int i = 0; i < dtPossibleAnswers.Rows.Count; i++) { DataRow dr = dtPossibleAnswers.Rows[i]; ddlQ9.Items.Add(new ListItem(dr["PossibleAnswerText"].ToString(), dr["PossibleAnswerID"].ToString())); } ddlQ9.SelectedIndex = 0; } if (intQuestionID == 10) { ddlQ10.Items.Add(new ListItem(" ", "0")); for (int i = 0; i < dtPossibleAnswers.Rows.Count; i++) { DataRow dr = dtPossibleAnswers.Rows[i]; ddlQ10.Items.Add(new ListItem(dr["PossibleAnswerText"].ToString(), dr["PossibleAnswerID"].ToString())); } ddlQ10.SelectedIndex = 0; } if (intQuestionID == 11) { ddlQ11.Items.Add(new ListItem(" ", "0")); for (int i = 0; i < dtPossibleAnswers.Rows.Count; i++) { DataRow dr = dtPossibleAnswers.Rows[i]; ddlQ11.Items.Add(new ListItem(dr["PossibleAnswerText"].ToString(), dr["PossibleAnswerID"].ToString())); } ddlQ11.SelectedIndex = 0; } if (intQuestionID == 12) { ddlQ12.Items.Add(new ListItem(" ", "0")); for (int i = 0; i < dtPossibleAnswers.Rows.Count; i++) { DataRow dr = dtPossibleAnswers.Rows[i]; ddlQ12.Items.Add(new ListItem(dr["PossibleAnswerText"].ToString(), dr["PossibleAnswerID"].ToString())); } ddlQ12.SelectedIndex = 0; } if (intQuestionID == 13) { ddlQ13.Items.Add(new ListItem(" ", "0")); for (int i = 0; i < dtPossibleAnswers.Rows.Count; i++) { DataRow dr = dtPossibleAnswers.Rows[i]; ddlQ13.Items.Add(new ListItem(dr["PossibleAnswerText"].ToString(), dr["PossibleAnswerID"].ToString())); } ddlQ13.SelectedIndex = 0; } if (intQuestionID == 14) { ddlQ14.Items.Add(new ListItem(" ", "0")); for (int i = 0; i < dtPossibleAnswers.Rows.Count; i++) { DataRow dr = dtPossibleAnswers.Rows[i]; ddlQ14.Items.Add(new ListItem(dr["PossibleAnswerText"].ToString(), dr["PossibleAnswerID"].ToString())); } ddlQ14.SelectedIndex = 0; } if (intQuestionID == 15) { ddlQ15.Items.Add(new ListItem(" ", "0")); for (int i = 0; i < dtPossibleAnswers.Rows.Count; i++) { DataRow dr = dtPossibleAnswers.Rows[i]; ddlQ15.Items.Add(new ListItem(dr["PossibleAnswerText"].ToString(), dr["PossibleAnswerID"].ToString())); } ddlQ15.SelectedIndex = 0; } if (intQuestionID == 16) { ddlQ16.Items.Add(new ListItem(" ", "0")); for (int i = 0; i < dtPossibleAnswers.Rows.Count; i++) { DataRow dr = dtPossibleAnswers.Rows[i]; ddlQ16.Items.Add(new ListItem(dr["PossibleAnswerText"].ToString(), dr["PossibleAnswerID"].ToString())); } ddlQ16.SelectedIndex = 0; } if (intQuestionID == 17) { ddlQ17.Items.Add(new ListItem(" ", "0")); for (int i = 0; i < dtPossibleAnswers.Rows.Count; i++) { DataRow dr = dtPossibleAnswers.Rows[i]; ddlQ17.Items.Add(new ListItem(dr["PossibleAnswerText"].ToString(), dr["PossibleAnswerID"].ToString())); } ddlQ17.SelectedIndex = 0; } if (intQuestionID == 18) { ddlQ18.Items.Add(new ListItem(" ", "0")); for (int i = 0; i < dtPossibleAnswers.Rows.Count; i++) { DataRow dr = dtPossibleAnswers.Rows[i]; ddlQ18.Items.Add(new ListItem(dr["PossibleAnswerText"].ToString(), dr["PossibleAnswerID"].ToString())); } ddlQ18.SelectedIndex = 0; } if (intQuestionID == 19) { ddlQ19.Items.Add(new ListItem(" ", "0")); for (int i = 0; i < dtPossibleAnswers.Rows.Count; i++) { DataRow dr = dtPossibleAnswers.Rows[i]; ddlQ19.Items.Add(new ListItem(dr["PossibleAnswerText"].ToString(), dr["PossibleAnswerID"].ToString())); } ddlQ19.SelectedIndex = 0; } if (intQuestionID == 20) { ddlQ20.Items.Add(new ListItem(" ", "0")); for (int i = 0; i < dtPossibleAnswers.Rows.Count; i++) { DataRow dr = dtPossibleAnswers.Rows[i]; ddlQ20.Items.Add(new ListItem(dr["PossibleAnswerText"].ToString(), dr["PossibleAnswerID"].ToString())); } ddlQ20.SelectedIndex = 0; } } } catch (Exception ex) { lblError.Text = ex.Message; } }
protected void grdAssessUser_RowDataBound(object sender, GridViewRowEventArgs e) { DataRowView dr = (DataRowView)e.Row.DataItem; Literal ltlRecs = null; string strCurrentCountry = ""; string strCurrentSpecies = ""; Label lblGridCountry = null; int intTotalAssessments = 0; string strAssessmentID = "0"; HyperLink lblSpecies = null; HyperLink hlSpeciesResults = null; if (e.Row.RowType == DataControlRowType.Header) { //Set "Country" header e.Row.Cells[0].Text = DataProxy.LoadString("COUNTRYLABEL", strCurrentLanguage); //Set "Species" header e.Row.Cells[1].Text = DataProxy.LoadString("SPECIESLABEL", strCurrentLanguage); //Set "Consolidated" header e.Row.Cells[2].Text = DataProxy.LoadString("CONSOLIDATEDHEADER", strCurrentLanguage); //Set "Common Name" header e.Row.Cells[3].Text = DataProxy.LoadString("COMMONNAMELABEL", strCurrentLanguage); //Set "Captive Breeding" header e.Row.Cells[4].Text = DataProxy.LoadString("CAPTIVEBREEDINGLABEL", strCurrentLanguage); //Set "Assessed By" header e.Row.Cells[5].Text = DataProxy.LoadString("ASSESSEDBYLABEL", strCurrentLanguage); //Set "Assessed Date" header e.Row.Cells[6].Text = DataProxy.LoadString("ASSESSMENTDATELABEL", strCurrentLanguage); } if (e.Row.RowType == DataControlRowType.DataRow) { if (e.Row.FindControl("lblGridCountry") != null) { lblGridCountry = (Label)e.Row.FindControl("lblGridCountry"); } if (e.Row.FindControl("lblSpecies") != null) { lblSpecies = (HyperLink)e.Row.FindControl("lblSpecies"); } strCurrentCountry = dr["CountryID"].ToString(); strCurrentSpecies = dr["SpeciesID"].ToString(); if (dr["AssessmentID"] != null) { strAssessmentID = dr["AssessmentID"].ToString(); } if (e.Row.FindControl("hlSpeciesResults") != null) { hlSpeciesResults = (HyperLink)e.Row.FindControl("hlSpeciesResults"); string strURL = ""; if (strAssessmentID != "0") { strURL = "AssessmentResults.aspx?AssessmentID=" + strAssessmentID + "&SpeciesID=" + dr["SpeciesID"].ToString() + "&CountryID=" + dr["CountryID"].ToString(); } hlSpeciesResults.NavigateUrl = strURL; } } }