HYTOS

        public static bool InsertDrawingInfo()

        {

            Project_Info projectInfo = Project_Info.GetInstance();

            using (SQLiteConnection connection = new SQLiteConnection(string.Format(CultureInfo.CurrentCulture, "Data Source = {0}", projectInfo.DBFilePath)))

            {

                try

                {

                    connection.Open();

                    using (SQLiteTransaction transaction = connection.BeginTransaction())

                    {

                        try

                        {

                            //using (SQLiteCommand cmd = connection.CreateCommand())

                            //{

                            //    cmd.CommandText = string.Format("INSERT OR REPLACE INTO {0} (UID, LOCATION, LEADERLINE) VALUES (@UID, @LOCATION, @LEADERLINE)", SPPID_LABEL_INFO_TABLE);

                            //    cmd.Parameters.AddWithValue("@UID", item.Item1);

                            //    cmd.Parameters.AddWithValue("@LOCATION", item.Item2);

                            //    cmd.Parameters.AddWithValue("@LEADERLINE", item.Item3);

                            //    cmd.ExecuteNonQuery();

                            //}

                            //transaction.Commit();

                            //connection.Close();

                        }

                        catch (Exception ex)

                        {

                            transaction.Rollback();

                        }

                        finally

                        {

                            transaction.Dispose();

                        }

                    }

                }

                catch (Exception ex)

                {

                    return false;

                }

                finally

                {

                    connection.Dispose();

                }

            }

            return true;

        }