示例#1
0
 private void button1_Click(object sender, EventArgs e)
 {
     using (AddFilesForm dlg = new AddFilesForm())
     {
         if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
         {
             string[] fp   = dlg.FilePaths;
             string   cmnt = dlg.Comment;
             foreach (string f in fp)
             {
                 if ((from s in _activeAttachements where s.FilePath.ToLower() == f.ToLower() select s).FirstOrDefault() == null)
                 {
                     AttachementItem ai = new AttachementItem();
                     ai.FilePath     = f;
                     ai.Comment      = cmnt;
                     ai.GeocacheCode = Core.ActiveGeocache.Code;
                     _activeAttachements.Add(ai);
                     addAttachementItemToList(ai);
                     lock (Core.SettingsProvider)
                     {
                         try
                         {
                             Core.SettingsProvider.Database.Execute(string.Format("insert into {3} (code, filepath, comment) values ('{2}', '{0}', '{1}')", ai.FilePath.Replace("'", "''"), ai.Comment.Replace("'", "''"), ai.GeocacheCode.Replace("'", "''"), Core.SettingsProvider.GetFullTableName("attachements")));
                         }
                         catch
                         {
                         }
                     }
                 }
             }
         }
     }
 }
示例#2
0
 private void button1_Click(object sender, EventArgs e)
 {
     using (AddFilesForm dlg = new AddFilesForm())
     {
         if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
         {
             string[] fp = dlg.FilePaths;
             string cmnt = dlg.Comment;
             foreach (string f in fp)
             {
                 if ((from s in _activeAttachements where s.FilePath.ToLower() == f.ToLower() select s).FirstOrDefault() == null)
                 {
                     AttachementItem ai = new AttachementItem();
                     ai.FilePath = f;
                     ai.Comment = cmnt;
                     ai.GeocacheCode = Core.ActiveGeocache.Code;
                     _activeAttachements.Add(ai);
                     addAttachementItemToList(ai);
                     if (initDatabase() != null)
                     {
                         try
                         {
                             _dbcon.ExecuteNonQuery(string.Format("insert into attachements (code, filepath, comment) values ('{2}', '{0}', '{1}')", ai.FilePath.Replace("'", "''"), ai.Comment.Replace("'", "''"), ai.GeocacheCode.Replace("'", "''")));
                         }
                         catch
                         {
                         }
                     }
                 }
             }
         }
     }
 }