CURELab.SignLanguage.HandDetector.DBManager.UpdateMogData C# (CSharp) 메소드

        public void UpdateMogData(int frame, float[] mog, bool isRight)
        {
            try
            {
                 SQLiteCommand updateCommand = new SQLiteCommand(connection);
                 string updateFrame;
                 if (isRight)
                 {
                     updateFrame =
                      @"UPDATE Framedata SET mogRight = @mog
                         where index_id = @frame";
                 }
                 else
                 {
                     updateFrame =
                     @"UPDATE Framedata SET mogLeft = @mog
                        where index_id = @frame";
                 }

                updateCommand.CommandText = updateFrame;
                updateCommand.Parameters.AddWithValue("@frame", frame);
                updateCommand.Parameters.Add("@mog", DbType.Binary, mog.Length*sizeof(float)).Value = mog.ToByteArray();
                updateCommand.ExecuteNonQuery();
            }
            catch (Exception e)
            {

                throw;
            }
        }

        private void MenuItem_Test_Click(object sender, RoutedEventArgs e)
        {
            #region mog txt to database
            StreamReader sr       = new StreamReader(File.Open(@"J:\Kinect data\mog141-180.txt", FileMode.Open));
            string       dataPath = @"J:\Kinect data\database141-181.db";
            m_DBmanager = DBManager.GetSingleton(dataPath);
            m_DBmanager.BeginTrans();

            string line  = sr.ReadLine();
            int    count = 1;
            while (line != null && line != "")
            {
                string[] cell    = line.Split();
                int      frame   = Convert.ToInt32(cell[1]);
                bool     isRight = cell[2] == "r";
                if (cell.Count() >= 27)
                {
                    float[] Mog = cell.Skip(3).Take(24).Select(x => Convert.ToSingle(x)).ToArray();
                    m_DBmanager.UpdateMogData(frame, Mog, isRight);
                }
                Console.WriteLine(count++);
                line = sr.ReadLine();
            }
            m_DBmanager.Commit();
            m_DBmanager.Close();
            sr.Close();
            #endregion

            #region kmeans

            #endregion
        }