public void DeleteTagItemMapping(TagItemMapping entity) {
base.DeleteItem<TagItemMapping>(entity);
}
public void AddTagItemMapping(TagItemMapping entity) {
base.AddItem<TagItemMapping>(entity);
}
public void DeleteTagItemMapping(TagItemMapping entity)
{
base.DeleteItem <TagItemMapping>(entity);
}
public void AddTagItemMapping(TagItemMapping entity)
{
base.AddItem <TagItemMapping>(entity);
}
/// <summary>
/// Gets all entities that were created/modified/deleted locally after the last sync.
/// </summary>
/// <param name="state">A unique identifier for the changes that are uploaded</param>
/// <returns>The set of incremental changes to send to the service.</returns>
public IEnumerable<SqlCeOfflineEntity> GetChanges(Guid state)
{
var changeList = new List<SqlCeOfflineEntity>();
using (GetSqlCeConnection())
{
SqlCeTransaction transaction = _connection.BeginTransaction();
try
{
using (var command = new SqlCeCommand(SELECT_ITEM_CHANGES, GetSqlCeConnection()))
{
var reader = command.ExecuteReader();
while (reader.Read())
{
var item = new Item
{
ID = (Guid)reader["ID"],
ListID = (Guid)reader["ListID"],
UserID = (Guid)reader["UserID"],
Name = reader["Name"] as string,
Description = reader["Description"] as string,
Priority = reader["Priority"] as int?,
Status = reader["Status"] as int?,
StartDate = reader["StartDate"] as DateTime?,
EndDate = reader["EndDate"] as DateTime?,
ServiceMetadata = new OfflineEntityMetadata()
{
IsTombstone = (bool)reader["IsTombstone"],
Id = reader["_MetadataID"] as string
}
};
changeList.Add(item);
}
}
using (var command = new SqlCeCommand(SELECT_LIST_CHANGES, GetSqlCeConnection()))
{
var reader = command.ExecuteReader();
while (reader.Read())
{
var listItem = new List
{
ID = (Guid)reader["ID"],
Name = reader["Name"] as string,
Description = reader["Description"] as string,
UserID = (Guid)reader["UserID"],
CreatedDate = (DateTime)reader["CreatedDate"],
ServiceMetadata = new OfflineEntityMetadata()
{
IsTombstone = (bool)reader["IsTombstone"],
Id = reader["_MetadataID"] as string
}
};
changeList.Add(listItem);
}
}
using (var command = new SqlCeCommand(SELECT_TAGITEMMAPPING_CHANGES, GetSqlCeConnection()))
{
var reader = command.ExecuteReader();
while (reader.Read())
{
var tagItemMapping = new TagItemMapping
{
TagID = (int)reader["TagID"],
ItemID = (Guid)reader["ItemID"],
UserID = (Guid)reader["UserID"],
ServiceMetadata = new OfflineEntityMetadata()
{
IsTombstone = (bool)reader["IsTombstone"],
Id = reader["_MetadataID"] as string
}
};
changeList.Add(tagItemMapping);
}
}
transaction.Commit();
}
catch
{
transaction.Rollback();
throw;
}
}
return changeList;
}
/// <summary>
/// Adds a new tag to item mapping.
/// </summary>
/// <param name="item">Item to which a tag is being mapped</param>
/// <param name="tag">Tag to which an item is being mapped</param>
public void AddTagMapping(Item item, Tag tag)
{
// Here we ensure that the referential integrity is correct.
// In the UI, there is no way to add a duplicate mapping, so
// uniqueness is insured. Other applications may have to do
// an explicit check here.
TagItemMapping tim = new TagItemMapping()
{
ItemID = item.ID,
TagID = tag.ID,
UserID = UserID
};
context.AddTagItemMapping(tim);
}
