public void Put(string resourceKind, SyncDigestEntryInfo info)
{
if (null == resourceKind)
{
throw new ArgumentNullException("resourceKind");
}
if (resourceKind == String.Empty)
{
throw new ArgumentException("Parameter value is empty.", "resourceKind");
}
if (null == info)
{
throw new ArgumentNullException("info");
}
// TODO: Validate entry property values
// We set the priority on 'update'.
lock (lockObj)
{
try
{
_provider.Add(resourceKind, info);
}
catch (StoreException)
{
_provider.Update(resourceKind, info);
}
}
}
public void Add(string resourceKind, SyncDigestEntryInfo info)
{
ISyncDigestTableAdapter syncDigestTableAdapter = StoreEnvironment.Resolve <ISyncDigestTableAdapter>(_context);
IResourceKindTableAdapter resourceKindTableAdapter = StoreEnvironment.Resolve <IResourceKindTableAdapter>(_context);
using (IJetTransaction jetTransaction = _jetConnectionProvider.GetTransaction(false))
{
ResourceKindInfo resourceKindInfo = resourceKindTableAdapter.GetOrCreate(resourceKind, jetTransaction);
try
{
syncDigestTableAdapter.Insert(resourceKindInfo.Id, new SyncDigestEntryInfo[] { info }, jetTransaction);
}
catch (OleDbException exception)
{
if (exception.Errors.Count == 1 && exception.Errors[0].SQLState == "3022")
{
throw new StoreException(string.Format("An error occured while adding a new sync digest entry. A sync digest entry already exists for the resource kind '{0}' and EndPoint '{1}.", resourceKind, info.EndPoint), exception);
}
throw;
}
jetTransaction.Commit();
}
}
/*
* public void Put(string resourceKind, SyncDigestInfo info)
* {
* if (null == resourceKind)
* throw new ArgumentNullException("resourceKind");
* if (resourceKind == String.Empty)
* throw new ArgumentException("Parameter value is empty.", "resourceKind");
*
* if (null == info)
* throw new ArgumentNullException("info");
*
* // TODO: Validate entry property values
*
* // We set the priority on 'update'.
* lock (lockObj)
* {
* //try
* //{
* // _provider.Update(resourceKind, info);
* //}
* //catch (StoreException)
* //{
* // _provider.Add(resourceKind, info);
* //}
*
#warning WORKAROUND for bug in Update Method
* // WORKAROUND
* // Update method does not throw any exception if entry did not exist.
* try
* {
* _provider.Add(resourceKind, info);
* }
* catch (StoreException)
* {
* _provider.Update(resourceKind, info);
* }
* }
* }
* */
//public void PersistNewer(string resourceKind, SyncState syncState)
//{
// if (null == resourceKind)
// throw new ArgumentNullException("resourceKind");
// if (resourceKind == String.Empty)
// throw new ArgumentException("Parameter value is empty.", "resourceKind");
// if (null == syncState)
// throw new ArgumentNullException("syncState");
// lock (lockObj)
// {
// SyncDigestEntryInfo entry = _provider.Get(resourceKind, syncState.Endpoint);
// if (entry != null)
// {
// if (entry.Tick < syncState.Tick+1)
// {
// entry.Tick = syncState.Tick+1;
// _provider.Update(resourceKind, entry);
// }
// }
// else
// {
// entry = new SyncDigestEntryInfo(syncState.Endpoint, syncState.Tick+1, 0, DateTime.Now);
// _provider.Add(resourceKind, entry);
// }
// }
//}
public void PersistNewer(string resourceKind, ResSyncInfo resSyncInfo)
{
if (null == resourceKind)
{
throw new ArgumentNullException("resourceKind");
}
if (resourceKind == String.Empty)
{
throw new ArgumentException("Parameter value is empty.", "resourceKind");
}
if (null == resSyncInfo)
{
throw new ArgumentNullException("resSyncInfo");
}
lock (lockObj)
{
SyncDigestEntryInfo entry = _provider.Get(resourceKind, resSyncInfo.Endpoint);
if (entry != null)
{
if (entry.Tick < resSyncInfo.Tick + 1)
{
entry.Tick = resSyncInfo.Tick + 1;
_provider.Update(resourceKind, entry);
}
}
else
{
entry = new SyncDigestEntryInfo(resSyncInfo.Endpoint, resSyncInfo.Tick + 1, 0, DateTime.Now);
_provider.Add(resourceKind, entry);
}
}
}
/*
* public void Update(string resourceKind, SyncDigestInfo info)
* {
* ISyncDigestTableAdapter syncDigestTableAdapter = StoreEnvironment.Resolve<ISyncDigestTableAdapter>(_context);
* IResourceKindTableAdapter resourceKindTableAdapter = StoreEnvironment.Resolve<IResourceKindTableAdapter>(_context);
*
* using (IJetTransaction jetTransaction = _jetConnectionProvider.GetTransaction(false))
* {
* ResourceKindInfo resourceKindInfo = resourceKindTableAdapter.GetOrCreate(resourceKind, jetTransaction);
*
* try
* {
* syncDigestTableAdapter.Update(resourceKindInfo.Id, info.ToArray(), jetTransaction);
* }
* catch (StoreException exception)
* {
* throw new StoreException(string.Format("An error occured while updating a sync digest entry. No sync digest entry exists for the resource kind '{0}'.", resourceKind), exception);
* }
* jetTransaction.Commit();
* }
* }
*/
public bool Update(string resourceKind, SyncDigestEntryInfo info)
{
bool result = false;
ISyncDigestTableAdapter syncDigestTableAdapter = StoreEnvironment.Resolve <ISyncDigestTableAdapter>(_context);
IResourceKindTableAdapter resourceKindTableAdapter = StoreEnvironment.Resolve <IResourceKindTableAdapter>(_context);
using (IJetTransaction jetTransaction = _jetConnectionProvider.GetTransaction(false))
{
ResourceKindInfo resourceKindInfo = resourceKindTableAdapter.GetOrCreate(resourceKind, jetTransaction);
result = syncDigestTableAdapter.Update(resourceKindInfo.Id, info, jetTransaction);
jetTransaction.Commit();
}
return(result);
}
public SyncDigestEntryInfo Get(string resourceKind, string EndPoint)
{
SyncDigestEntryInfo resultInfo = null;
ISyncDigestTableAdapter syncDigestTableAdapter = StoreEnvironment.Resolve <ISyncDigestTableAdapter>(_context);
IResourceKindTableAdapter resourceKindTableAdapter = StoreEnvironment.Resolve <IResourceKindTableAdapter>(_context);
IEndPointTableAdapter EndPointTableAdapter = StoreEnvironment.Resolve <IEndPointTableAdapter>(_context);
using (IJetTransaction jetTransaction = _jetConnectionProvider.GetTransaction(false))
{
ResourceKindInfo resourceKindInfo = resourceKindTableAdapter.GetOrCreate(resourceKind, jetTransaction);
EndPointInfo EndPointInfo = EndPointTableAdapter.GetOrCreate(EndPoint, jetTransaction);
resultInfo = syncDigestTableAdapter.Get(resourceKindInfo.Id, EndPointInfo.Id, jetTransaction);
jetTransaction.Commit();
}
return(resultInfo);
}
public SyncDigestEntryInfo Get(int resourceKindId, int EndPointId, IJetTransaction jetTransaction)
{
SyncDigestEntryInfo resultInfo = null;
OleDbCommand oleDbCommand = jetTransaction.CreateOleCommand();
string sqlQuery = string.Empty;
sqlQuery = "SELECT {0}.Tick, {0}.ConflictPriority, {0}.Stamp, {1}.EndPoint FROM {1} INNER JOIN {0} ON {1}.ID={0}.FKEndPointId " +
"WHERE ({0}.FKResourceKindId)=@ResourceKindId " +
"AND ({0}.FKEndPointId)=@EndPointId;";
oleDbCommand.CommandText = string.Format(sqlQuery, _syncDigestTable.TableName, _syncDigestTable.EndPointTable.TableName);
oleDbCommand.Parameters.AddWithValue("@ResourceKindId", resourceKindId);
oleDbCommand.Parameters.AddWithValue("@EndPointId", EndPointId);
using (OleDbDataReader reader = oleDbCommand.ExecuteReader(CommandBehavior.Default))
{
if (reader.Read())
{
string EndPoint;
int tick;
int conflictPriority;
DateTime stamp;
EndPoint = Convert.ToString(reader["EndPoint"]);
tick = Convert.ToInt32(reader["tick"]);
conflictPriority = Convert.ToInt32(reader["ConflictPriority"]);
stamp = Convert.ToDateTime(reader["Stamp"]);
resultInfo = new SyncDigestEntryInfo(EndPoint, tick, conflictPriority, stamp);
}
}
return(resultInfo);
}
public bool Update(int resourceKindId, SyncDigestEntryInfo syncDigestEntryInfo, IJetTransaction jetTransaction)
{
IEndPointTableAdapter EndPointTableAdapter = StoreEnvironment.Resolve <IEndPointTableAdapter>(this.Context);
OleDbCommand oleDbCommand = jetTransaction.CreateOleCommand();
EndPointInfo tmpEndPointInfo;
string sqlQuery = string.Empty;
sqlQuery = "UPDATE [{0}] SET [tick]=@tick, [ConflictPriority]=@ConflictPriority, [Stamp]=@Stamp WHERE (FKResourceKindId=@ResourceKindId AND FKEndPointId=@EndPointId);";
oleDbCommand.CommandText = string.Format(sqlQuery, _syncDigestTable.TableName);
// TODO: Use prepared query
tmpEndPointInfo = EndPointTableAdapter.GetOrCreate(syncDigestEntryInfo.EndPoint, jetTransaction);
oleDbCommand.Parameters.AddWithValue("@tick", syncDigestEntryInfo.Tick);
oleDbCommand.Parameters.AddWithValue("@ConflictPriority", syncDigestEntryInfo.ConflictPriority);
oleDbCommand.Parameters.AddWithValue("@Stamp", syncDigestEntryInfo.Stamp.ToString());
oleDbCommand.Parameters.AddWithValue("@ResourceKindId", resourceKindId);
oleDbCommand.Parameters.AddWithValue("@EndPointId", tmpEndPointInfo.Id);
int count = oleDbCommand.ExecuteNonQuery();
return(count > 0);
}
