private void bindData(int id, string type)
{
using (var sd = new SecureData(false, UserManager.GetLoginToken()))
{
DataTable dt = null;
switch (type)
{
case "taxonomy":
dt = sd.GetData("web_image", ":inven_imageid=" + 0 + ";:taxon_imageid=" + id + ";:cta_imageid=" + 0, 0, 0).Tables["web_image"];
break;
case "cta":
dt = sd.GetData("web_image", ":inven_imageid=" + 0 + ";:taxon_imageid=" + 0 + ";:cta_imageid=" + id, 0, 0).Tables["web_image"];
break;
case "":
default:
dt = sd.GetData("web_image", ":inven_imageid=" + id + ";:taxon_imageid=" + 0 + ";:cta_imageid=" + 0, 0, 0).Tables["web_image"];
break;
}
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
string virtual_path = dr["virtual_path"].ToString();
string title = dr["title"].ToString();
string description = dr["description"].ToString();
string taken_by = dr["taken_by"].ToString();
string coop_id = dr["cooperator_id"].ToString();
string taken_date = Toolkit.ToDateTime(dr["created_date"]).ToString("dd-MMM-yyyy");
string pi_number = dr["pi_number"].ToString();
string inv_number = dr["inv_number"].ToString();
string copyright = dr["copyright"].ToString();
string note = dr["note"].ToString();
image1.Src = Resolve(virtual_path);
lblInformation.Visible = true;
if (!string.IsNullOrEmpty(note))
{
note = " Comment: " + note;
}
if (!string.IsNullOrEmpty(taken_by))
{
taken_by = "Taken by: <a href='cooperator.aspx?id=" + coop_id + "' target='_blank'>" + taken_by + "</a>";
}
switch (type)
{
case "taxonomy":
lblInformation.Text = "Image for: " + description + "<br />"
+ "Taken on: " + taken_date + "<br />"
+ copyright + " " + note + "<br /><br />";
break;
case "cta":
lblInformation.Text = "Image for: " + description + "<br />"
+ note + "<br /><br />";
break;
case "":
default:
string attachDate = dr["attach_date"].ToString();
string attachDateCode = dr["attach_date_code"].ToString();
taken_date = Utils.DisplayDate(attachDate, attachDateCode);
if (!string.IsNullOrEmpty(taken_date))
{
taken_date = " on " + taken_date;
}
lblInformation.Text = "Image for: " + pi_number + " - " + description + "<br />"
+ taken_by + taken_date + "<br />"
+ " Inventory sample: " + inv_number + "<br />"
+ copyright + " " + note + "<br /><br />";
break;
}
}
}
}
}
