I Need a Tissue …
I found more WTF worthy code! I have worked on some crappy maintenance projects, how did I survive the torture? This code is from an ASP.NET web form code-behind. Nice single-tier implementation and iteration through a data reader and writing JavaScript to client.
I do NOT make this stuff up. Enjoy peeps.
private void load_budget() // load and edit/continue existing budget
{
if (open_connection())
{
Response_Write("<_script>_\n");
try {
// IF load budget for editing or new budget, then lock it
com.CommandText = "update [qCase] set lock=1 where id=" + form("cid") + " and lock=0";
if (view==false)
ret = com.ExecuteNonQuery();
else
ret = 1; // only viewing so assume success
// if successful attempt to lock or just open for viewing then
if (ret == 0 ) // 0 records affected = error = non-existence
{
Response_Write(";_function exec() { Core.list_results(); _alert('This case is already opened.'); }");
}
else // load record and parse data with post_load()
{
// 1. Load the main case record
com.CommandText = "select id,number,fbu,last_n,first_n,[date],data,extra from [qCase] where id=" + form("cid");
dr = com.ExecuteReader();
if (dr.Read())
{
Response_Write(
"c_id=" + dr.GetValue(0) + ";" +
"c_num=\"" + dr.GetValue(1) + "\";" +
"c_fbu=\"" + dr.GetValue(2) + "\";" +
"c_lnm=\"" + dr.GetValue(3) + "\";" +
"c_fnm=\"" + dr.GetValue(4) + "\"; " +
"c_day=\"" + dr.GetValue(5) + "\";\n"
);
Response_Write( //.Replace("\r","\\n").Replace("\n","")
"c_d=\"" + dr.GetValue(6).ToString() + "\";\n" +
"c_e=\"" + dr.GetValue(7) + "\";"
);
dr.Close();
// 2. Load all expenses belonging to this case
com.CommandText = "select id,case_id,data from [qExpense] where case_id=" + form("cid");
dr = com.ExecuteReader();
str = ""; i = 0; ids = "";
while( dr.Read() )
{
if ( i++ > 0 ) { str += "~"; ids += "~"; }
str += dr.GetValue(2);
ids += dr.GetValue(0);
} // while
dr.Close();
Response_Write("\ne_i=\"" + ids + "\";\ne_d=\"" + str + "\";");
}
else
{
Response_Write("\ni_i=\"\";\ni_d=\"\";");
}
} // if read case
else
{
dr.Close();
// ERROR, READ case failed! - deal with later
}
if (view==true)
Response_Write("_\n_function exec() {" +
" Core.review_budget = 1; " +
" Core.post_load(self); }\n");
else
if (bypass==true)
Response_Write("_\n_function exec() { " +
" Core.temp.new_budget = 1; " +
" Core.post_load(self); }\n");
else
Response_Write("_\n_function exec() { Core.post_load(self); }\n");
}
} catch(Exception e) {
Response_Write("; _if (top.debug) _alert('Load Budget Error');");
} finally {
Response_Write("<_/script>");
}
}
else // error opening db connection
{
//Response_Write("DB connection error
");
}
Response_Write( "
" );
close_connection();
//Response_Write("DB connection closed
");
} // load_budget()