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