public void insertNotebook(Notebook notebook)
{
String sql;
if (notebook.getId() > 0)
{
sql = "UPDATE notebook " +
"SET name = @name, description = @description " +
"WHERE notebookId = @notebookId";
}
else
{
sql = "INSERT INTO notebook (userId, name, description)" +
"VALUES (@userId, @name, @description)";
}
SqlCommand query = new SqlCommand(sql, con);
SqlParameter parName = new SqlParameter("@name", SqlDbType.VarChar);
SqlParameter parUserId = new SqlParameter("@userId", SqlDbType.Int);
SqlParameter parDescription = new SqlParameter("@description", SqlDbType.VarChar);
SqlParameter parNotebookId = new SqlParameter("@notebookId", SqlDbType.Int);
parNotebookId.Value = notebook.getId();
parUserId.Value = notebook.getUserId();
parName.Value = notebook.getName();
parDescription.Value = notebook.getDescription();
query.Parameters.Add(parNotebookId);
query.Parameters.Add(parUserId);
query.Parameters.Add(parName);
query.Parameters.Add(parDescription);
try
{
this.openCon();
query.ExecuteScalar();
this.closeCon();
}
catch (Exception e)
{
Console.WriteLine("Adding note failed");
Console.WriteLine(e.Message);
this.closeCon();
}
}
