/// <summary>
/// Gets all QBEntities
/// </summary>
/// <param name="entityType">Entity type or null</param>
/// <param name="synState">Synchronization state or null</param>
/// <param name="count">Number of records to return</param>
/// <returns>QBEntity collection</returns>
public List<QBEntity> GetAllQBEntities(EntityTypeEnum? entityType, SynStateEnum? synState, int count)
{
if (count <= 0)
{
return new List<QBEntity>();
}
var query = (IQueryable<QBEntity>)_context.QBEntities;
if (entityType.HasValue)
{
int entityTypeId = (int)entityType.Value;
query = query.Where(qbe => qbe.EntityTypeId == entityTypeId);
}
if (synState.HasValue)
{
int synStateId = (int)synState.Value;
query = query.Where(qbe => qbe.SynStateId == synStateId);
}
query = query.OrderBy(qbe => qbe.UpdatedOn);
return query.Take(count).ToList();
}
/// <summary>
/// Updates QBEntity
/// </summary>
/// <param name="entityId">Entity ID</param>
/// <param name="qbEntityId">QuickBooks entity ID</param>
/// <param name="entityType">Entity type</param>
/// <param name="nopEntityId">nopCommerce entity ID</param>
/// <param name="synState">Synchronization state</param>
/// <param name="seqNum">Edit sequence number</param>
/// <returns>QBEntity</returns>
public static QBEntity UpdateQBEntity(int entityId, string qbEntityId, EntityTypeEnum entityType, int nopEntityId, SynStateEnum synState, string seqNum)
{
QBEntity entity = GetQBEntityById(entityId);
if (entity == null)
{
return null;
}
NopObjectContext context = ObjectContextHelper.CurrentObjectContext;
if (!context.IsAttached(entity))
{
context.QBEntities.Attach(entity);
}
entity.QBEntityId = CommonHelper.EnsureMaximumLength(qbEntityId, 50);
entity.EntityType = entityType;
entity.NopEntityId = nopEntityId;
entity.SynState = synState;
entity.SeqNum = CommonHelper.EnsureMaximumLength(seqNum, 20);
entity.CreatedOn = entity.CreatedOn;
entity.UpdatedOn = DateTime.UtcNow;
context.SaveChanges();
return entity;
}
/// <summary>
/// Updates QBEntity
/// </summary>
/// <param name="entityId">Entity ID</param>
/// <param name="qbEntityId">QuickBooks entity ID</param>
/// <param name="entityType">Entity type</param>
/// <param name="nopEntityId">nopCommerce entity ID</param>
/// <param name="synState">Synchronization state</param>
/// <param name="seqNum">Edit sequence number</param>
/// <returns>QBEntity</returns>
public static QBEntity UpdateQBEntity(int entityId, string qbEntityId, EntityTypeEnum entityType, int nopEntityId, SynStateEnum synState, string seqNum)
{
QBEntity entity = GetQBEntityById(entityId);
if (entity == null)
{
return(null);
}
NopObjectContext context = ObjectContextHelper.CurrentObjectContext;
if (!context.IsAttached(entity))
{
context.QBEntities.Attach(entity);
}
entity.QBEntityId = CommonHelper.EnsureMaximumLength(qbEntityId, 50);
entity.EntityType = entityType;
entity.NopEntityId = nopEntityId;
entity.SynState = synState;
entity.SeqNum = CommonHelper.EnsureMaximumLength(seqNum, 20);
entity.CreatedOn = entity.CreatedOn;
entity.UpdatedOn = DateTime.UtcNow;
context.SaveChanges();
return(entity);
}
/// <summary>
/// Creates a new QBEntity
/// </summary>
/// <param name="qbEntityId">QBEntity ID</param>
/// <param name="entityType">Entity type</param>
/// <param name="nopEntityId">nopCommerce entity ID</param>
/// <param name="synState">Synchronization state</param>
/// <param name="seqNum">Edit sequence number</param>
/// <returns>QBEntity</returns>
public static QBEntity CreateQBEntity(string qbEntityId, EntityTypeEnum entityType, int nopEntityId, SynStateEnum synState, string seqNum)
{
NopObjectContext context = ObjectContextHelper.CurrentObjectContext;
QBEntity entity = context.QBEntities.CreateObject();
entity.QBEntityId = CommonHelper.EnsureMaximumLength(qbEntityId, 50);
entity.EntityType = entityType;
entity.NopEntityId = nopEntityId;
entity.SynState = synState;
entity.SeqNum = CommonHelper.EnsureMaximumLength(seqNum, 20);
entity.CreatedOn = DateTime.UtcNow;
entity.UpdatedOn = DateTime.UtcNow;
context.QBEntities.AddObject(entity);
context.SaveChanges();
return entity;
}
/// <summary>
/// Creates a new QBEntity
/// </summary>
/// <param name="qbEntityId">QBEntity ID</param>
/// <param name="entityType">Entity type</param>
/// <param name="nopEntityId">nopCommerce entity ID</param>
/// <param name="synState">Synchronization state</param>
/// <param name="seqNum">Edit sequence number</param>
/// <returns>QBEntity</returns>
public static QBEntity CreateQBEntity(string qbEntityId, EntityTypeEnum entityType, int nopEntityId, SynStateEnum synState, string seqNum)
{
NopObjectContext context = ObjectContextHelper.CurrentObjectContext;
QBEntity entity = context.QBEntities.CreateObject();
entity.QBEntityId = CommonHelper.EnsureMaximumLength(qbEntityId, 50);
entity.EntityType = entityType;
entity.NopEntityId = nopEntityId;
entity.SynState = synState;
entity.SeqNum = CommonHelper.EnsureMaximumLength(seqNum, 20);
entity.CreatedOn = DateTime.UtcNow;
entity.UpdatedOn = DateTime.UtcNow;
context.QBEntities.AddObject(entity);
context.SaveChanges();
return(entity);
}
