Pastebin

private void receivedata(object sender, EventArgs eventArgs)
        {
            try
            {
                if (mPort.BytesToRead < 1)
                    return;

                string data;
                data = mPort.ReadLine();
                char[] split = { ';' };
                string[] info;
                info = data.Split(split);

                float temp1, temp2;
                int a, b, H, L;
                char digi;

                temp1 = System.Convert.ToSingle(info[0]);
                temp2 = System.Convert.ToSingle(info[1]);

                a = System.Convert.ToInt32(info[2]);
                //if (a == 1) checkBoxTemp.Checked = true;
                //else checkBoxTemp.Checked = true;
                b = System.Convert.ToInt32(info[3]);
                H = System.Convert.ToInt32(info[4]);
                L = System.Convert.ToInt32(info[5]);
                digi = System.Convert.ToChar(info[6]);

                //Todo insert into database


                /*command.CommandText = "INSERT INTO Home (kolonne, a, b) VALUES (@kolonne, @a, @b)";
                command.Parameters.Clear();
                command.Parameters.AddWithValue("@kolonne", temp);
                //......*/
                //conn.Open();
                //command.ExecuteNonQuery();
                //conn.Close();

                
                SqlParameter paramTid = new SqlParameter();
                paramTid.ParameterName = "@Tid";
                paramTid.Value = System.DateTime.Now.ToLongTimeString();

                SqlParameter paramTEMP1 = new SqlParameter();
                paramTEMP1.ParameterName = "@Temp1";
                paramTEMP1.Value = temp1;

                SqlParameter paramTEMP2 = new SqlParameter();
                paramTEMP2.ParameterName = "@Temp2";
                paramTEMP2.Value = temp2;

                SqlParameter paramAlarm = new SqlParameter();
                paramAlarm.ParameterName = "@Alarm";
                paramAlarm.Value = a;

                SqlParameter paramBatteri = new SqlParameter();
                paramBatteri.ParameterName = "@Batteri";
                paramBatteri.Value = b;

                SqlParameter paramMax = new SqlParameter();
                paramMax.ParameterName = "@MaxTemp";
                paramMax.Value = H;

                SqlParameter paramMin = new SqlParameter();
                paramMin.ParameterName = "@MinTemp";
                paramMin.Value = L;

                SqlParameter paramDigi = new SqlParameter();
                paramDigi.ParameterName = "@Digi";
                paramDigi.Value = digi;

                SqlConnection conn = new SqlConnection(ConnString);

                string InsertStr = @"Insert into Home (Tid, Temp1, Temp2, Alarm, Batteri, MaxTemp, MinTemp, Digi) Values(@Tid, @Temp1, @Temp2, @Alarm, @Batteri, @MaxTemp, @MinTemp, @Digi)";

                SqlCommand cmdInsert = new SqlCommand(InsertStr, conn);

                conn.Open();
                cmdInsert.ExecuteNonQuery();
                conn.Close();

                SqlCommand cmd = new SqlCommand("SELECT AVG(Temp1) FROM Home WHERE Alarm = 0", conn);

                conn.Open();
                decimal averageTemp = Convert.ToDecimal(cmd.ExecuteScalar());
                conn.Close();

                
                cmd.Parameters.Add(paramTid);
                cmd.Parameters.Add(paramTEMP1);
                cmd.Parameters.Add(paramTEMP2);
                cmd.Parameters.Add(paramAlarm);
                cmd.Parameters.Add(paramBatteri);
                cmd.Parameters.Add(paramMax);
                cmd.Parameters.Add(paramMin);
                cmd.Parameters.Add(paramDigi);

                logmessage(averageTemp.ToString());


                //logmessage(data);
                logmessage(info[0] + ";" + info[1] + ";" + info[2] + ";" + info[3] + ";" + info[4] + ";" + info[5] + ";" + printBinary(digi));
            }