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