private void saveBut_Click(object sender, EventArgs e)
{
this.lien = new Link(titreBox.Text, pathBox.Text);
this.DialogResult = DialogResult.OK;
}
// Insertion d'un nouveau lien en base
public String insertLink(Link lien)
{
String EncID = "";
String titre = "'" + lien.Titre.Replace("'", "''") + "'";
using (SQLiteConnection SQLC = new SQLiteConnection(this._connectionString))
{
if (File.Exists(this.path))
SQLC.Open();
else
throw new Exception("Base inaccessible");
using (SQLiteTransaction mytransaction = SQLC.BeginTransaction())
{
using (SQLiteCommand SQLCmd = new SQLiteCommand(SQLC))
{
// Insertion du mail
SQLCmd.CommandText = "INSERT INTO Links (Titre,Path) ";
SQLCmd.CommandText += "VALUES(" + titre + "," + lien.urlSQL + ");";
SQLCmd.ExecuteNonQuery();
// Récupération du EncID
SQLCmd.CommandText = "SELECT max(id) FROM Links;";
EncID = SQLCmd.ExecuteScalar().ToString();
}
mytransaction.Commit();
}
}
return EncID;
}