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);
}
}
