public static FichierDAOSQLServer getInstance() { if (instance == null) { instance = new FichierDAOSQLServer(); } return(instance); }
public int ajouterNotification(Model.Notification notification) { if (FichierDAOSQLServer.getInstance().getFichierById(notification.idFichier) != null) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(ConnectionHelper.conVal("CalendrierDatabase"))) { String query = $"INSERT INTO Notification(textNotification,DateNotification,IdFichier) values('{notification.textNotification}','{notification.dateNotification}','{notification.idFichier}');" + $"SELECT CAST(SCOPE_IDENTITY() as int)"; int id = connection.Query <int>(query).Single(); return(id); } } else { return(-1); } }