and then later use it as follows:<\/p>\n
\/\/ Read the last saved Article filter … this.filter.Remove(e.Item.Key); <\/p>\n We had this situation in my last project where we wanted to have some of our objects to get easily serialized into a specific table. Therefor we had to add up to the Serializer an new generic class that uses the Serializer to get the sream to put into a table.In this example we have … Continue reading “Persistor of a Serializer”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"post-thumbnail":false},"uagb_author_info":{"display_name":"Pouya Panahy","author_link":"http:\/\/www.panahy.nl\/index.php\/author\/pouya\/"},"uagb_comment_info":0,"uagb_excerpt":"We had this situation in my last project where we wanted to have some of our objects to get easily serialized into a specific table. Therefor we had to add up to the Serializer an new generic class that uses the Serializer to get the sream to put into a table.In this example we have…","_links":{"self":[{"href":"http:\/\/www.panahy.nl\/index.php\/wp-json\/wp\/v2\/posts\/94"}],"collection":[{"href":"http:\/\/www.panahy.nl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.panahy.nl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.panahy.nl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.panahy.nl\/index.php\/wp-json\/wp\/v2\/comments?post=94"}],"version-history":[{"count":0,"href":"http:\/\/www.panahy.nl\/index.php\/wp-json\/wp\/v2\/posts\/94\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.panahy.nl\/index.php\/wp-json\/wp\/v2\/media?parent=94"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.panahy.nl\/index.php\/wp-json\/wp\/v2\/categories?post=94"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.panahy.nl\/index.php\/wp-json\/wp\/v2\/tags?post=94"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
private Article filter = Article.Load();<\/p>\n
\/\/ and do something with it and finally save it back to Database<\/p>\n
…
this.filter.Save();
<\/span>
Well, to achive that we implemented the Persistor class as follows:<\/p>\n
using<\/span> System;
<\/span>using<\/span> System.Collections.Generic;
<\/span>\/\/\/<\/span> <\/span><summary><\/span>
<\/span>\/\/\/<\/span> Provides the persistance methods for the filter classes.
<\/span>\/\/\/<\/span> It reads and writes the content in an xml format into the Filter table
<\/span>\/\/\/<\/span> <\/span><\/summary><\/span>
<\/span>\/\/\/<\/span> <\/span><typeparam name=\"T\"><\/span>The type of the filter. This type should derive from Persistor<T> and have an empty constructor<\/span><\/typeparam><\/span>
<\/span>[Serializable]
<\/span>public<\/span> <\/span>class<\/span> Persistor<\/span><<\/span>T<\/span>><\/span>
where T : Persistor<\/span><<\/span>T<\/span>><\/span>, <\/span>new<\/span>()
{
<\/span>\/\/\/<\/span> <\/span><summary><\/span>
<\/span>\/\/\/<\/span> Saves this filter as the default filter for the current user.
<\/span>\/\/\/<\/span> <\/span><\/summary><\/span>
<\/span> <\/span>public<\/span> <\/span>void<\/span> Save()
{
<\/span>\/\/<\/span> Serialize the current filter instance<\/span>
<\/span> Serializer<\/span><<\/span>T<\/span>><\/span> serializer <\/span>=<\/span> <\/span>new<\/span> Serializer<\/span><<\/span>T<\/span>><\/span>();
<\/span>string<\/span> xml <\/span>=<\/span> serializer.Serialize(<\/span>this<\/span> <\/span>as<\/span> T);
<\/span>\/\/<\/span> The filter class is a data class that handles the saveing of a record<\/span>
<\/span> Data.Tables.Filter filter <\/span>=<\/span> Persistor<\/span><<\/span>T<\/span>><\/span>.LoadFilter(<\/span>true<\/span>);
<\/span>\/\/<\/span> Actual save to database<\/span>
<\/span> filter.Value <\/span>=<\/span> xml;
filter.Save();
}
<\/span>\/\/\/<\/span> <\/span><summary><\/span>
<\/span>\/\/\/<\/span> Loads the default filter for the current table and user.
<\/span>\/\/\/<\/span> <\/span><\/summary><\/span>
<\/span> <\/span>public<\/span> <\/span>static<\/span> T Load()
{
Tables.Filter filter <\/span>=<\/span> Persistor<\/span><<\/span>T<\/span>><\/span>.LoadFilter(<\/span>false<\/span>);
<\/span>\/\/<\/span> Deserialize<\/span>
<\/span> T currentFilter <\/span>=<\/span> <\/span>null<\/span>;
<\/span>if<\/span> (filter <\/span>!=<\/span> <\/span>null<\/span> <\/span>&&<\/span> <\/span>!<\/span>string<\/span>.IsNullOrEmpty(filter.Value))
{
Serializer<\/span><<\/span>T<\/span>><\/span> serializer <\/span>=<\/span> <\/span>new<\/span> Serializer<\/span><<\/span>T<\/span>><\/span>();
currentFilter <\/span>=<\/span> serializer.Deserialize(filter.Value);
}
<\/span>else<\/span>
{
currentFilter <\/span>=<\/span> <\/span>new<\/span> T();
}
<\/span>return<\/span> currentFilter;
}
<\/span>\/\/\/<\/span> <\/span><summary><\/span>
<\/span>\/\/\/<\/span> Loads the Filter for the current user and table from the database.
<\/span>\/\/\/<\/span> <\/span><\/summary><\/span>
<\/span> <\/span>protected<\/span> <\/span>static<\/span> Tables.Filter LoadFilter(<\/span>bool<\/span> createNew)
{
<\/span>string<\/span> tableId <\/span>=<\/span> <\/span>typeof<\/span>(T).Name;
<\/span>int<\/span> userId <\/span>=<\/span> UserContext.Current.User.ID;
<\/span>\/\/<\/span> Load current filter, if available, otherwise create a new filter instance.<\/span>
<\/span> Tables.Filter filter <\/span>=<\/span> Tables.Filter.GetForUserTable(userId, tableId);
<\/span>if<\/span> (filter <\/span>==<\/span> <\/span>null<\/span> <\/span>&&<\/span> createNew)
{
filter <\/span>=<\/span> <\/span>new<\/span> Data.Tables.Filter();
filter.UserID <\/span>=<\/span> userId;
filter.TableID <\/span>=<\/span> tableId;
}
<\/span>return<\/span> filter;
}
}<\/span><\/pre>\n","protected":false},"excerpt":{"rendered":"