GmapEZ

public partial class Pages_mapPanel : System.Web.UI.UserControl
{
    #region Page Props
 
    public String defaultGmapPage = "http://maps.google.com/maps";
    public String defaultPage = ConfigurationSettings.AppSettings["defaultPage"];
 
    #endregion
 
    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            string mapPlaceHolder = this.loadMapData();
            this.ctlPlaceHolder.Controls.Add(new LiteralControl(mapPlaceHolder)); 
        }
        catch (Exception ex)
        {
            throw (ex);
        }
    }
 
    #region loadMapData()
    public String loadMapData()
    {
        try
        {
            OracleConnection conn = new OracleConnection();
            String mainConn = ConfigurationManager.ConnectionStrings["MainConnStr"].ConnectionString;
            conn.ConnectionString = mainConn;
            conn.Open();
            OracleCommand cmd = new OracleCommand();
            cmd.CommandType = CommandType.Text;
 
            String query = "SELECT * FROM MYTABLE ORDER BY DATEIN DESC";
            cmd.CommandText = query;
            cmd.Connection = conn;
 
            cmd.ExecuteReader();
            OracleDataReader dr = cmd.ExecuteReader();
            StringBuilder map = new StringBuilder();
            QueryString qs = new QueryString();
 
            while (dr.Read())
            {
                qs.Add("fid", "ms");
                qs.Add("id", dr["ID"].ToString());
 
                    map.Append("<a id=\"" + dr["ID"].ToString() + "\" href=\"" + defaultGmapPage + "?ll=" + dr["LATITUDE"].ToString() + "," + dr["LONGITUDE"].ToString() + "&amp;t=k&amp;hl=en\">GREEN MINI</a>");
                    map.Append("<div title=\"Event\"><font size=\"1\" face=\"Arial, Helvetica, sans-serif\">");
                    map.Append("<strong>Name:</strong> " + dr["NAME"].ToString() + "<br />");
                    map.Append("<strong>Type:</strong> " + dr["TYPE"].ToString() + "<br />");
                    map.Append("<strong>Description:</strong> " + dr["DESC"].ToString() + "<br />");
                    map.Append("<a href=\"" + defaultPage + qs + "\">Go To Main Page...</a>");
                    map.Append("</font></div>");
                    map.Append("<div title=\"Dates\"><font size=\"1\" face=\"Arial, Helvetica, sans-serif\">");
                    map.Append("<strong>Date In:</strong> " + dr["DATEIN"].ToString() + "<br />");
                    map.Append("<strong>Date Out:</strong> " + dr["DATEOUT"].ToString() + "<br />");
                    map.Append("<a href=\"" + defaultPage + qs + "\">Go To Main Page...</a>");
                    map.Append("</font></div>");
                }
            }
 
            conn.Close();
            return map.ToString();
        }
        catch (Exception ex)
        {
            Zekiah.Logging.LoggingManager.WebApplication.Error("A Fatal Error has occured in the Map Control", ex);
            redirectToFailure();
            return null;
        }
    }
    #endregion
 
	#region Failure Notice 
    private void redirectToFailure()
    {
        QueryString qs = new QueryString();
        qs.Add("fid", "ERROR");
        Response.Redirect(defaultPage + qs, false);
    }    
    #endregion 
}