//======================================================================================== // GetUserErrors() //======================================================================================== public static MessageCollection GetUserErrors(DatabaseConnection dbase) { string CR = Environment.NewLine; var messages = new MessageCollection(); string sql = "SELECT name, line, position, text" + " FROM User_Errors" + " ORDER BY name, line, position"; try { OracleConnection con = dbase.OraConnection; using (var cmd = new OracleCommand(sql, con)) { using (var da = new OracleDataAdapter()) { da.SelectCommand = cmd; var ds = new DataSet(); if (con.State != ConnectionState.Open) { con.Open(); } int count = da.Fill(ds); if (count > 0) { var msg = new StringBuilder(); string divider = CR + "-".PadRight(15, '-') // name + " -".PadRight(8, '-') // line + " -".PadRight(7, '-') // position + " -".PadRight(80, '-'); // text msg.Append(CR + "Name".PadRight(15, ' ') + " Line".PadRight(8, ' ') + " Offset".PadRight(7, ' ') + " Text"); msg.Append(divider); DataRow row = null; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { row = ds.Tables[0].Rows[i]; msg.Append(CR + row["name"].ToString().PadRight(16, ' ') + row["line"].ToString().PadRight(8, ' ') + row["position"].ToString().PadRight(7, ' ') + row["text"].ToString() ); if (i < (ds.Tables[0].Rows.Count - 1)) { msg.Append(CR + divider); } } messages.Add( new Message(Message.MessageType.Error, msg.ToString())); } } } } catch (Exception exc) { if (exc.Message == String.Empty) { messages.Add( new Message(Message.MessageType.Error, exc.StackTrace)); } else { messages.Add( new Message(Message.MessageType.Error, exc.Message)); } } return(messages); }