public static string[] GetSites(string OrgID)
{
db_Ref.InsertT_OE_SYS_LOG("Public Map", OrgID);
List <string> myCollection = new List <string>();
List <T_WQX_MONLOC> ms = db_WQX.GetWQX_MONLOC(true, null, false);
if (!string.IsNullOrEmpty(OrgID))
{
ms = db_WQX.GetWQX_MONLOC_ByOrgID(OrgID);
}
if (ms != null)
{
foreach (T_WQX_MONLOC m in ms)
{
string samps = "";
string comments = "";
V_WQX_ACTIVITY_LATEST l = db_WQX.GetV_WQX_ACTIVITY_LATESTByMonLocID(m.MONLOC_IDX);
if (l != null)
{
samps = "<br/><u><b>Most recent sampling results:</b></u><br/>Alkalinity: " + l.Alkalinity__total + "<br/>Ammonia: " + l.Ammonia + "<br/>E coli: " + l.Escherichia_coli +
"<br/>Nitrate: " + l.Nitrate +
"<br/>Nitrite: " + l.Nitrite +
"<br/>pH: " + l.pH +
"<br/>Phosphorus: " + l.Phosphorus +
"<br/>Salinity: " + l.Salinity +
"<br/>Water Temp: " + l.Temperature__water +
"<br/>Turbidity: " + l.Turbidity;
if (l.ACT_COMMENT != null)
{
comments = "<br/><i>" + l.ACT_COMMENT + "</i><br/>";
}
}
myCollection.Add(m.LATITUDE_MSR + "|" +
m.LONGITUDE_MSR + "|" +
m.MONLOC_NAME + " - " + m.MONLOC_TYPE + "|" +
m.MONLOC_DESC + "<br/>" + comments + samps + "|" +
m.MONLOC_ID + "|" +
m.STATE_CODE + "|" +
m.ORG_ID + "|" +
"test2");
}
}
return(myCollection.ToArray());
}
public static string[] GetSites()
{
string _org = HttpContext.Current.Session["OrgID"].ConvertOrDefault <string>();
List <string> myCollection = new List <string>();
List <T_WQX_MONLOC> ms = db_WQX.GetWQX_MONLOC(true, _org, false);
if (ms != null)
{
foreach (T_WQX_MONLOC m in ms)
{
string samps = "";
string comments = "";
V_WQX_ACTIVITY_LATEST l = db_WQX.GetV_WQX_ACTIVITY_LATESTByMonLocID(m.MONLOC_IDX);
if (l != null)
{
samps = "<br/><u><b>Most recent sampling results:</b></u><br/>Alkalinity: " + l.Alkalinity__total + "<br/>Ammonia: " + l.Ammonia + "<br/>E coli: " + l.Escherichia_coli +
"<br/>Nitrate: " + l.Nitrate +
"<br/>Nitrite: " + l.Nitrite +
"<br/>pH: " + l.pH +
"<br/>Phosphorus: " + l.Phosphorus +
"<br/>Salinity: " + l.Salinity +
"<br/>Water Temp: " + l.Temperature__water +
"<br/>Turbidity: " + l.Turbidity;
if (l.ACT_COMMENT != null)
{
comments = "<br/><i>" + l.ACT_COMMENT + "</i><br/>";
}
}
myCollection.Add(m.LATITUDE_MSR + "|" + m.LONGITUDE_MSR + "|" + m.MONLOC_NAME + " - " + m.MONLOC_TYPE + "|" + m.MONLOC_DESC + "<br/>" + comments + samps + "|" + m.MONLOC_ID + "|" + m.STATE_CODE + "|" + "test" + "|" + "test2");
}
}
return(myCollection.ToArray());;
}
