internal void DeleteFileFromSync(String guid)
{
using (MobeelizerDatabaseContext transaction = new MobeelizerDatabaseContext(this.ConnectionString))
{
var query = from f in transaction.Files where f.Guid == guid select f;
transaction.Files.DeleteAllOnSubmit(query);
transaction.SubmitChanges();
}
}
private void AddFile(String guid, String path, int modificationFlag)
{
using (MobeelizerDatabaseContext transaction = new MobeelizerDatabaseContext(this.ConnectionString))
{
MobeelizerFilesTableEntity entity = new MobeelizerFilesTableEntity();
entity.Guid = guid;
entity.Path = path;
entity.Modyfied = modificationFlag;
transaction.Files.InsertOnSubmit(entity);
transaction.SubmitChanges(ConflictMode.FailOnFirstConflict);
}
}
internal MobeelizerOperationError UpdateEntitiesFromSync(IEnumerable <MobeelizerJsonEntity> entities, bool isAllSynchronization)
{
MobeelizerOperationError transactionErrors = null;
using (MobeelizerDatabaseContext dataContext = new MobeelizerDatabaseContext(this.ConnectionString))
{
if (isAllSynchronization)
{
foreach (var model in models.Values)
{
var table = dataContext.GetTable(model.Type);
table.DeleteAllOnSubmit(from MobeelizerWp7Model record in table select record);
}
dataContext.ModelMetadata.DeleteAllOnSubmit(from m in dataContext.ModelMetadata select m);
// TODO: check it
//dataContext.Files.DeleteAllOnSubmit(from f in dataContext.Files select f);
dataContext.SubmitChanges();
}
foreach (MobeelizerJsonEntity entity in entities)
{
transactionErrors = models[entity.Model].UpdateFromSync(entity, dataContext);
if (transactionErrors != null)
{
break;
}
}
if (transactionErrors == null)
{
dataContext.SubmitChanges();
}
}
return(transactionErrors);
}
