Der er mange konstanter og efterhånden en del funktioner, jeg kan barbere det ned til ca 300:
using System;
using System.Collections;
using MySql.Data.MySqlClient;
using System.Text.RegularExpressions;
using System.Web;
using Microsoft.VisualBasic;
using System.Diagnostics;
using System.IO;
namespace webUtil
{
public class ConfigSingleton
{
private string configSingletonErr = "";
private string centreret;
private string farve1;
private static ConfigSingleton instance;
private ConfigSingleton()
{
Stream myFile = File.Create("Tracer.txt");
TextWriterTraceListener myTextListener = new TextWriterTraceListener(myFile);
Trace.Listeners.Add(myTextListener);
Trace.Write("++++++++++++++++++++++++++Start++++++++++++++++++++++++++");
Trace.Flush();
try
{
MySqlConnection MyConn = new MySqlConnection(Functions.GetConnStr().ToString());
string SQLStr = "SELECT * FROM konstanter WHERE kID = 1";
MySqlCommand cmd = new MySqlCommand(SQLStr, MyConn);
MyConn.Open();
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
egenTop = reader["egenTop"].ToString();
centreret = reader["centreret"].ToString();
farve1 = reader["farve1"].ToString();
..........
showcounter = reader["showcounter"].ToString();
reader.Close();
MyConn.Close();
}
catch(Exception ex)
{
configSingletonErr = "1\n" + ex.ToString();
}
try
{
MySqlConnection MyConn = new MySqlConnection(Functions.GetConnStr().ToString());
string SQLStr = SQLStr = "SELECT * FROM forretning WHERE fID = 1";
MySqlCommand cmd = new MySqlCommand(SQLStr, MyConn);
MyConn.Open();
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
aaben = reader["aaben"].ToString();
firmanavn1 = Regex.Replace(reader["firmanavn1"].ToString(), "'", "'");
.......
land = Convert.ToInt32(reader["land"]);
reader.Close();
if (firmanavn1 == null)
{
firmanavn1 = "24-7";
}
MyConn.Close();
}
catch(Exception ex)
{
configSingletonErr = "2\n" + ex.ToString();
}
try
{
string webID = Convert.ToString(GetWebID());
string SQLStr = "SELECT * FROM admin WHERE webID = " + webID.ToString();
MySqlConnection MySConn = new MySqlConnection(Functions.GetSConnStr().ToString());
testVar = SQLStr;
MySqlCommand cmd = new MySqlCommand(SQLStr, MySConn);
MySConn.Open();
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
.........
specialAdm = reader["specialAdm"].ToString();
reader.Close();
MySConn.Close();
if ((aaben == null || aaben == "off") || (open == null || open == "off"))
{
aaben = "off";
}
}
catch(Exception ex)
{
configSingletonErr = "3\n" + ex.ToString();
}
if (HttpContext.Current.Request.QueryString["lang"] != null) HttpContext.Current.Session["lang"] = HttpContext.Current.Request.QueryString["lang"];
else HttpContext.Current.Session["lang"] = priLang.ToString();
if (http_user_agent.IndexOf("opera") >= 0) layerWidth = 162;
if(wtype < 11)
{
layerWidth = 160;
}
else
{
try
{
MySqlConnection MyConn = new MySqlConnection(Functions.GetConnStr().ToString());
div1 = "<div id=\"layer1\">\n";
string SQLStr = "SELECT...";
MySqlCommand cmd = new MySqlCommand(SQLStr, MyConn);
MyConn.Open();
MySqlDataReader reader = cmd.ExecuteReader();
int antalUnder = 0;
if (reader.HasRows)
{
while(reader.Read())
{
antalUnder = antalUnder++;
div1 = div1 + "<a href=\"txt.aspx?tekstID=" + reader["tekstID"].ToString() + "\">" + reader["overskrift"].ToString() + "</a><br>\n";
menu1under = "txt.aspx?tekstID=" + reader["tekstID"].ToString();
}
}
else
{
div1 = div1 + "<a href=\"forside.aspx\">Ingen sider aktiveret!</a><br>";
}
div1 = div1 + "</div>";
if (antalUnder != 1) menu1under = "y";
reader.Close();
MyConn.Close();
}
catch(Exception ex)
{
configSingletonErr = "4\n" + ex.ToString();
}
}
try
{
MySqlConnection MyConn = new MySqlConnection(Functions.GetConnStr().ToString());
int antalUnder = 0;
string SQLStr = "SELECT tekstID, overskrift" + HttpContext.Current.Session["lang"] + " AS overskrift FROM tekster WHERE typen = 3 AND aktiv = 'on' AND place = 2 ORDER BY indeks, overskrift" + HttpContext.Current.Session["lang"];
MySqlCommand cmd = new MySqlCommand(SQLStr, MyConn);
MyConn.Open();
MySqlDataReader reader = cmd.ExecuteReader();
string egenDIV = "\n\n<div id=\"layer2\">\n";
while(reader.Read())
{
antalUnder = antalUnder++;
egenDIV = egenDIV + "<a href=\"txt.aspx?tekstID=" + reader["tekstID"].ToString() + "\">" + reader["overskrift"].ToString() + "</a><br>\n";
menu2under = "txt.aspx?tekstID=" + reader["tekstID"].ToString();
eDiv = 1;
}
if (antalUnder != 1) menu2under = "y";
reader.Close();
MyConn.Close();
}
catch(Exception ex)
{
configSingletonErr = "5\n" + ex.ToString();
}
try
{
MySqlConnection MyConn = new MySqlConnection(Functions.GetConnStr().ToString());
int antalUnder = 0;
int eDiv2 = 0;
string SQLStr = "SELECT tekstID, overskrift" + HttpContext.Current.Session["lang"] + " AS overskrift FROM tekster WHERE (typen = 5 AND aktiv = 'on' AND activated = 'y')";
if (specialPage == "y") SQLStr = SQLStr + " OR (typen = 6 AND aktiv = 'on' AND activated = 'y')";
SQLStr = SQLStr + " OR (typen = 3 AND place = 3 AND aktiv = 'on') ORDER BY indeks, overskrift" + HttpContext.Current.Session["lang"];
MySqlCommand cmd = new MySqlCommand(SQLStr, MyConn);
MyConn.Open();
MySqlDataReader reader = cmd.ExecuteReader();
string egenDIV2 = "\n\n<div id=\"layer5\">\n";
string pagename = "";
if (reader.HasRows)
{
while(reader.Read())
{
antalUnder = antalUnder++;
if (reader["tekstID"].ToString() != "") pagename = reader["tekstID"].ToString();
else pagename = "txt";
if (wtype < 11)//MENU 2 SHOP
{
egenDIV = egenDIV + "<a href=\"" + pagename + ".aspx?tekstID=" + reader["tekstID"].ToString() + "\">" + reader["overskrift"].ToString() + "</a><br>\n";
eDiv2 = 1;
}
egenDIV2 = egenDIV2 + "<a href=\"" + pagename + ".aspx?tekstID=" + reader["tekstID"].ToString() + "\">" + reader["overskrift"].ToString() + "</a><br>\n";
menu3under = "txt.aspx?tekstID=" + reader["tekstID"].ToString();
}
}
else
{
egenDIV2 = egenDIV2 + "<a href=\"forside.aspx\">Ingen sider aktiveret!</a><br>";
}
if (antalUnder != 1) menu3under = "y";
reader.Close();
egenDIV2 = egenDIV2 + "</div>";
if (eDiv == 0 && eDiv2 == 0) egenDIV = egenDIV + "<a href=\"forside.aspx\">Ingen sider aktiveret!</a><br>\n";
egenDIV = egenDIV + "</div>";
MyConn.Close();
}
catch(Exception ex)
{
configSingletonErr = "6\n" + ex.ToString();
}
//MENU 4
try
{
MySqlConnection MyConn = new MySqlConnection(Functions.GetConnStr().ToString());
int antalUnder = 0;
string SQLStr = "SELECT...";
MySqlCommand cmd = new MySqlCommand(SQLStr, MyConn);
MyConn.Open();
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while(reader.Read())
{
antalUnder = antalUnder++;
div4 = div4 + "<a href=\"" + reader["pagename"].ToString() + ".aspx?tekstID=" + reader["tekstID"].ToString() + "\">" + reader["overskrift"].ToString() + "</a><br>\n";
menu4under = reader["pagename"].ToString() + ".aspx?tekstID=" + reader["tekstID"].ToString();
}
}
reader.Close();
SQLStr = "SELECT...";
MySqlCommand cmd2 = new MySqlCommand(SQLStr, MyConn);
MySqlDataReader reader2 = cmd2.ExecuteReader();
if (reader2.HasRows)
{
while(reader2.Read())
{
antalUnder = antalUnder++;
div4 = div4 + "<a href=\"txt.aspx?tekstID=" + reader2["tekstID"].ToString() + "\">" + reader2["overskrift"].ToString() + "</a><br>\n";
menu4under = "txt.aspx?tekstID=" + reader2["tekstID"].ToString();
}
}
reader2.Close();
MyConn.Close();
}
catch(Exception ex)
{
configSingletonErr = "6\n" + ex.ToString();
}
try
{
menu = menu + "<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"" + width + "\">";
menu = menu + "...";
}
catch(Exception ex)
{
configSingletonErr = "7\n" + ex.ToString();
}
}
public static ConfigSingleton Instance()
{
// Uses "Lazy initialization"
if( instance == null )
{
instance = new ConfigSingleton();
}
return instance;
}
public string ConfigSingletonErr
{
get
{
return configSingletonErr;
}
}
}
}
