IList <int> IOperationStore.GetOperationIds(int maxAge, bool onlyNonAcknowledged, int limitAmount)
{
lock (Lock)
{
List <int> operations = new List <int>();
using (SQLCEDatabaseEntities entities = Helpers.CreateContext <SQLCEDatabaseEntities>())
{
foreach (OperationData data in entities.Operations.OrderByDescending(o => o.Timestamp))
{
// If we only want non-acknowledged ones
if (onlyNonAcknowledged && data.IsAcknowledged)
{
continue;
}
// If we shall ignore the age, or obey the maximum age...
if (maxAge > 0 && (DateTime.Now - data.Timestamp).TotalMinutes > maxAge)
{
continue;
}
operations.Add(data.OperationId);
// If we need to limit operations
if (limitAmount > 0 && operations.Count >= limitAmount)
{
break;
}
}
}
return(operations);
}
}
Operation IOperationStore.GetOperationById(int operationId)
{
lock (Lock)
{
List <Operation> operations = new List <Operation>();
using (SQLCEDatabaseEntities entities = Helpers.CreateContext <SQLCEDatabaseEntities>())
{
OperationData data = entities.Operations.FirstOrDefault(d => d.OperationId == operationId);
if (data == null)
{
return(null);
}
return(new Operation()
{
Id = data.OperationId,
Timestamp = data.Timestamp,
City = data.City,
IsAcknowledged = data.IsAcknowledged,
Keyword = data.Keyword,
Comment = data.Comment,
Location = data.Location,
Messenger = data.Messenger,
OperationNumber = data.OperationNumber,
Property = data.Building,
Street = data.Street,
StreetNumber = data.StreetNumber,
ZipCode = data.ZipCode,
CustomData = Utilities.Deserialize <IDictionary <string, object> >(data.CustomData),
RouteImage = data.RouteImage,
});
}
}
}
int IOperationStore.GetNextOperationId()
{
lock (Lock)
{
using (SQLCEDatabaseEntities entities = Helpers.CreateContext <SQLCEDatabaseEntities>())
{
if (entities.Operations.Any())
{
return(entities.Operations.Max(o => o.OperationId) + 1);
}
return(1);
}
}
}
void IJob.DoJob(Operation operation)
{
try
{
using (SQLCEDatabaseEntities entities = Helpers.CreateContext <SQLCEDatabaseEntities>())
{
int oid = operation.Id;
if (operation.Id == 0)
{
oid = entities.Operations.Any() ? entities.Operations.Max(o => o.OperationId) + 1 : 1;
}
// We need to see if the timestamp could be parsed. It will cause a Overflow in SQL Server if we allow DateTime.MinValue!
DateTime timestamp = (operation.Timestamp != DateTime.MinValue) ? operation.Timestamp : DateTime.Now;
OperationData data = new OperationData()
{
OperationId = oid,
Timestamp = Helpers.EnsureSaneTimestamp(timestamp),
City = operation.City,
ZipCode = operation.ZipCode,
Location = operation.Location,
OperationNumber = operation.OperationNumber,
Keyword = operation.Keyword,
Comment = operation.Comment,
IsAcknowledged = operation.IsAcknowledged,
Messenger = operation.Messenger,
Building = operation.Property,
Street = operation.Street,
StreetNumber = operation.StreetNumber,
CustomData = Utilities.Serialize(operation.CustomData),
// TODO: Compress route image!?
RouteImage = operation.RouteImage,
};
entities.Operations.AddObject(data);
entities.SaveChanges();
}
}
catch (Exception ex)
{
Logger.Instance.LogFormat(LogType.Error, this, "An error occurred while trying to write the operation to the database!");
Logger.Instance.LogException(this, ex);
}
}
void IOperationStore.AcknowledgeOperation(int operationId)
{
lock (Lock)
{
using (SQLCEDatabaseEntities entities = Helpers.CreateContext <SQLCEDatabaseEntities>())
{
OperationData data = entities.Operations.FirstOrDefault(d => d.OperationId == operationId);
// If either there is no operation by this id, or the operation exists and is already acknowledged, do nothing
if (data == null || data.IsAcknowledged)
{
return;
}
// Acknowledge this operation and save changes
data.IsAcknowledged = true;
entities.SaveChanges();
}
}
}