C#

string now = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");<br />
MySqlCommand cmd = new MySqlCommand("INSERT INTO log (datelogged, logentry) VALUES ('" + now + "', '" + tmp + "')");

J4amieC wrote:

make Visual display line numbers: Tools/Options/TextEditor/...

J4amieC wrote:

where are you from

System.ArgumentOutOfRangeException: Non-negative number required.<br />
Parameter name: count<br />
   at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)<br />
   at MySql.Data.MySqlClient.MySqlStream.Read(Byte[] buffer, Int32 offset, Int32 count)<br />
   at MySql.Data.MySqlClient.MySqlStream.ReadString(Int64 length)<br />
   at MySql.Data.MySqlClient.NativeDriver.GetFieldMetaData41()<br />
   at MySql.Data.MySqlClient.NativeDriver.GetFieldMetaData()<br />
   at MySql.Data.MySqlClient.NativeDriver.ReadColumnMetadata(Int32 count)<br />
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()<br />
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)<br />
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()<br />
   at Cisco2Mysql.Form1.serialPort1_DataReceived(Object sender, SerialDataReceivedEventArgs e)<br />

        private void serialPort1_DataReceived(object sender, System.IO.Ports.SerialDataReceivedEventArgs e) {<br />
            try {<br />
                // Read out existing chars into _buffer<br />
                _buffer += serialPort1.ReadExisting();<br />
<br />
                // If there is a complete line availiable process it<br />
                int posofbreak = _buffer.IndexOf('\n');<br />
                if (posofbreak > -1) {<br />
                    // Get the line<br />
                    string tmp = _buffer.Substring(0, posofbreak).Trim();<br />
<br />
                    // If there is more code than this line put it back into the buffer<br />
                    if (posofbreak < _buffer.Length - 1)<br />
                        _buffer = _buffer.Substring(posofbreak + 1);<br />
<br />
                    // If there is a command-prompt before the log-text remove it<br />
                    while (tmp.IndexOf('>') > -1)<br />
                        tmp = tmp.Substring(tmp.IndexOf('>') + 1).Trim();<br />
<br />
                    // Get a database-readable date<br />
                    string now = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");<br />
<br />
                    // Create insert-command for the database<br />
                    MySqlCommand cmd = new MySqlCommand("INSERT INTO cisco_log (datelogged, logentry) VALUES ('" + now + "', '" + tmp + "')");<br />
<br />
                    // If the textbox with every logoutput is too long shorten it<br />
                    if(box.Text.Length > 5000) <br />
                        box.Text = box.Text.Substring(0, 5000);<br />
<br />
                    // Add the new line before the old logtext<br />
                    box.Text = tmp + "\r\n" + box.Text;<br />
<br />
                    // If there is a call with both lines connected free one line for that call<br />
                    if (tmp.Contains("L11  0")) {<br />
                        serialPort1.WriteLine("CD EWE");<br />
                        serialPort1.WriteLine("DISCO 2");<br />
                        LogWrite("Call detected, disconnecting second line.");<br />
                    }<br />
<br />
                    // If there is a line error reconnect the line<br />
                    if (tmp.Contains("L67  2")) {<br />
                        Thread.Sleep(2000);<br />
                        serialPort1.WriteLine("CD EWE");<br />
                        serialPort1.WriteLine("CALL 2");<br />
                        LogWrite("Line Integrity Violation detected, reconnecting second line.");<br />
                    }<br />
<br />
                    // Check whether the second line is connected, if not connect it and execute the insert-command<br />
                    if (tmp.Length > 0) {<br />
                        while (_conn.State != ConnectionState.Open) {<br />
                            _conn.Open();<br />
                            Thread.Sleep(100);<br />
                        }<br />
                        cmd.Connection = _conn;<br />
                        // MARKER<br />
                        cmd.ExecuteNonQuery();<br />
                    }<br />
<br />
                }<br />
<br />
                // Write the content of _buffer to a textbox for debug view<br />
                buff.Text = _buffer;<br />
            }<br />
            catch (Exception ex) {<br />
                LogWrite("Exception at serialPort1_DataReceived: "+ex.ToString());<br />
            }<br />
        }

<br />
Content of tmp: """Connection 2 Add     Link 2 Channel 2"""<br />
MySQL-Command: """INSERT INTO cisco_log (datelogged, logentry) VALUES ('2007-08-17 11:47:38', 'Connection 2 Add  Link 2 Channel 2')"""<br />
Buffer-Content: """CISCO:EWE> """<br />
PosOfBreak: 50<br />
<br />
Exception: System.ArgumentOutOfRangeException: Non-negative number required.<br />
Parameter name: count<br />
   at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)<br />
   at MySql.Data.MySqlClient.MySqlStream.Read(Byte[] buffer, Int32 offset, Int32 count)<br />
   at MySql.Data.MySqlClient.MySqlStream.ReadString(Int64 length)<br />
   at MySql.Data.MySqlClient.NativeDriver.GetFieldMetaData41()<br />
   at MySql.Data.MySqlClient.NativeDriver.GetFieldMetaData()<br />
   at MySql.Data.MySqlClient.NativeDriver.ReadColumnMetadata(Int32 count)<br />
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()<br />
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)<br />
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()<br />
   at Cisco2Mysql.Form1.serialPort1_DataReceived(Object sender, SerialDataReceivedEventArgs e)<br />

private static void doPrint(string executable, string fileFullPath, string printerName)
{
// Print PDF file using Acrobat Reader.
// "/h" - hidden mode
// "/t" - print command following by the file name and printer name
System.Diagnostics.ProcessStartInfo startInfo = new ProcessStartInfo();
startInfo.Arguments = "/h /t \"" + fileFullPath + "\" \"" + printerName + "\"";
startInfo.FileName = executable;
startInfo.UseShellExecute = true;
startInfo.WindowStyle = ProcessWindowStyle.Hidden;
System.Diagnostics .Process process = new Process() ;
try {
process = Process.Start(startInfo);
}
catch (Exception ex)
{
}
finally
{
process.WaitForExit(20000);
if (process.HasExited == false)
{
process.Kill();
}
}
} 

Hessam Jalali wrote:

There is always the way to do it, but I don't know

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.