/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of ColorProperty</returns>
public static QueryFilters <ColorProperty> GetChanges(Color original, Color changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <ColorProperty>(5);
#region Detect Changes
if (original.ColorID != changed.ColorID)
{
changes.Add(QueryFilter.New(ColorProperty.ColorID, FilterConditions.Equals, changed.ColorID));
}
if (string.CompareOrdinal(original.ColorName, changed.ColorName) != 0)
{
changes.Add(QueryFilter.New(ColorProperty.ColorName, FilterConditions.Equals, changed.ColorName));
}
if (original.LastEditedBy != changed.LastEditedBy)
{
changes.Add(QueryFilter.New(ColorProperty.LastEditedBy, FilterConditions.Equals, changed.LastEditedBy));
}
if (original.ValidFrom != changed.ValidFrom)
{
changes.Add(QueryFilter.New(ColorProperty.ValidFrom, FilterConditions.Equals, changed.ValidFrom));
}
if (original.ValidTo != changed.ValidTo)
{
changes.Add(QueryFilter.New(ColorProperty.ValidTo, FilterConditions.Equals, changed.ValidTo));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of StockItemStockGroupProperty</returns>
public static QueryFilters <StockItemStockGroupProperty> GetChanges(StockItemStockGroup original, StockItemStockGroup changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <StockItemStockGroupProperty>(5);
#region Detect Changes
if (original.StockItemStockGroupID != changed.StockItemStockGroupID)
{
changes.Add(QueryFilter.New(StockItemStockGroupProperty.StockItemStockGroupID, FilterConditions.Equals, changed.StockItemStockGroupID));
}
if (original.StockItemID != changed.StockItemID)
{
changes.Add(QueryFilter.New(StockItemStockGroupProperty.StockItemID, FilterConditions.Equals, changed.StockItemID));
}
if (original.StockGroupID != changed.StockGroupID)
{
changes.Add(QueryFilter.New(StockItemStockGroupProperty.StockGroupID, FilterConditions.Equals, changed.StockGroupID));
}
if (original.LastEditedBy != changed.LastEditedBy)
{
changes.Add(QueryFilter.New(StockItemStockGroupProperty.LastEditedBy, FilterConditions.Equals, changed.LastEditedBy));
}
if (original.LastEditedWhen != changed.LastEditedWhen)
{
changes.Add(QueryFilter.New(StockItemStockGroupProperty.LastEditedWhen, FilterConditions.Equals, changed.LastEditedWhen));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of InvoiceLineProperty</returns>
public static QueryFilters <InvoiceLineProperty> GetChanges(InvoiceLine original, InvoiceLine changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <InvoiceLineProperty>(5);
#region Detect Changes
if (original.InvoiceLineId != changed.InvoiceLineId)
{
changes.Add(QueryFilter.New(InvoiceLineProperty.InvoiceLineId, FilterConditions.Equals, changed.InvoiceLineId));
}
if (original.InvoiceId != changed.InvoiceId)
{
changes.Add(QueryFilter.New(InvoiceLineProperty.InvoiceId, FilterConditions.Equals, changed.InvoiceId));
}
if (original.TrackId != changed.TrackId)
{
changes.Add(QueryFilter.New(InvoiceLineProperty.TrackId, FilterConditions.Equals, changed.TrackId));
}
if (original.UnitPrice != changed.UnitPrice)
{
changes.Add(QueryFilter.New(InvoiceLineProperty.UnitPrice, FilterConditions.Equals, changed.UnitPrice));
}
if (original.Quantity != changed.Quantity)
{
changes.Add(QueryFilter.New(InvoiceLineProperty.Quantity, FilterConditions.Equals, changed.Quantity));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of StateProvinces_ArchiveProperty</returns>
public static QueryFilters <StateProvinces_ArchiveProperty> GetChanges(StateProvinces_Archive original, StateProvinces_Archive changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <StateProvinces_ArchiveProperty>(10);
#region Detect Changes
if (original.StateProvinceID != changed.StateProvinceID)
{
changes.Add(QueryFilter.New(StateProvinces_ArchiveProperty.StateProvinceID, FilterConditions.Equals, changed.StateProvinceID));
}
if (string.CompareOrdinal(original.StateProvinceCode, changed.StateProvinceCode) != 0)
{
changes.Add(QueryFilter.New(StateProvinces_ArchiveProperty.StateProvinceCode, FilterConditions.Equals, changed.StateProvinceCode));
}
if (string.CompareOrdinal(original.StateProvinceName, changed.StateProvinceName) != 0)
{
changes.Add(QueryFilter.New(StateProvinces_ArchiveProperty.StateProvinceName, FilterConditions.Equals, changed.StateProvinceName));
}
if (original.CountryID != changed.CountryID)
{
changes.Add(QueryFilter.New(StateProvinces_ArchiveProperty.CountryID, FilterConditions.Equals, changed.CountryID));
}
if (string.CompareOrdinal(original.SalesTerritory, changed.SalesTerritory) != 0)
{
changes.Add(QueryFilter.New(StateProvinces_ArchiveProperty.SalesTerritory, FilterConditions.Equals, changed.SalesTerritory));
}
if (original.Border != changed.Border)
{
changes.Add(QueryFilter.New(StateProvinces_ArchiveProperty.Border, FilterConditions.Equals, changed.Border));
}
if (original.LatestRecordedPopulation != changed.LatestRecordedPopulation)
{
changes.Add(QueryFilter.New(StateProvinces_ArchiveProperty.LatestRecordedPopulation, FilterConditions.Equals, changed.LatestRecordedPopulation));
}
if (original.LastEditedBy != changed.LastEditedBy)
{
changes.Add(QueryFilter.New(StateProvinces_ArchiveProperty.LastEditedBy, FilterConditions.Equals, changed.LastEditedBy));
}
if (original.ValidFrom != changed.ValidFrom)
{
changes.Add(QueryFilter.New(StateProvinces_ArchiveProperty.ValidFrom, FilterConditions.Equals, changed.ValidFrom));
}
if (original.ValidTo != changed.ValidTo)
{
changes.Add(QueryFilter.New(StateProvinces_ArchiveProperty.ValidTo, FilterConditions.Equals, changed.ValidTo));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of PlaylistTrackProperty</returns>
public static QueryFilters <PlaylistTrackProperty> GetChanges(PlaylistTrack original, PlaylistTrack changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <PlaylistTrackProperty>(2);
#region Detect Changes
if (original.PlaylistId != changed.PlaylistId)
{
changes.Add(QueryFilter.New(PlaylistTrackProperty.PlaylistId, FilterConditions.Equals, changed.PlaylistId));
}
if (original.TrackId != changed.TrackId)
{
changes.Add(QueryFilter.New(PlaylistTrackProperty.TrackId, FilterConditions.Equals, changed.TrackId));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of ArtistProperty</returns>
public static QueryFilters <ArtistProperty> GetChanges(Artist original, Artist changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <ArtistProperty>(2);
#region Detect Changes
if (original.ArtistId != changed.ArtistId)
{
changes.Add(QueryFilter.New(ArtistProperty.ArtistId, FilterConditions.Equals, changed.ArtistId));
}
if (string.CompareOrdinal(original.Name, changed.Name) != 0)
{
changes.Add(QueryFilter.New(ArtistProperty.Name, FilterConditions.Equals, changed.Name));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of OrderDetailProperty</returns>
public static QueryFilters <OrderDetailProperty> GetChanges(OrderDetail original, OrderDetail changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <OrderDetailProperty>(3);
#region Detect Changes
if (original.Id != changed.Id)
{
changes.Add(QueryFilter.New(OrderDetailProperty.Id, FilterConditions.Equals, changed.Id));
}
if (string.CompareOrdinal(original.SubId, changed.SubId) != 0)
{
changes.Add(QueryFilter.New(OrderDetailProperty.SubId, FilterConditions.Equals, changed.SubId));
}
if (string.CompareOrdinal(original.Name, changed.Name) != 0)
{
changes.Add(QueryFilter.New(OrderDetailProperty.Name, FilterConditions.Equals, changed.Name));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of StockItemHoldingProperty</returns>
public static QueryFilters <StockItemHoldingProperty> GetChanges(StockItemHolding original, StockItemHolding changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <StockItemHoldingProperty>(9);
#region Detect Changes
if (original.StockItemID != changed.StockItemID)
{
changes.Add(QueryFilter.New(StockItemHoldingProperty.StockItemID, FilterConditions.Equals, changed.StockItemID));
}
if (original.QuantityOnHand != changed.QuantityOnHand)
{
changes.Add(QueryFilter.New(StockItemHoldingProperty.QuantityOnHand, FilterConditions.Equals, changed.QuantityOnHand));
}
if (string.CompareOrdinal(original.BinLocation, changed.BinLocation) != 0)
{
changes.Add(QueryFilter.New(StockItemHoldingProperty.BinLocation, FilterConditions.Equals, changed.BinLocation));
}
if (original.LastStocktakeQuantity != changed.LastStocktakeQuantity)
{
changes.Add(QueryFilter.New(StockItemHoldingProperty.LastStocktakeQuantity, FilterConditions.Equals, changed.LastStocktakeQuantity));
}
if (original.LastCostPrice != changed.LastCostPrice)
{
changes.Add(QueryFilter.New(StockItemHoldingProperty.LastCostPrice, FilterConditions.Equals, changed.LastCostPrice));
}
if (original.ReorderLevel != changed.ReorderLevel)
{
changes.Add(QueryFilter.New(StockItemHoldingProperty.ReorderLevel, FilterConditions.Equals, changed.ReorderLevel));
}
if (original.TargetStockLevel != changed.TargetStockLevel)
{
changes.Add(QueryFilter.New(StockItemHoldingProperty.TargetStockLevel, FilterConditions.Equals, changed.TargetStockLevel));
}
if (original.LastEditedBy != changed.LastEditedBy)
{
changes.Add(QueryFilter.New(StockItemHoldingProperty.LastEditedBy, FilterConditions.Equals, changed.LastEditedBy));
}
if (original.LastEditedWhen != changed.LastEditedWhen)
{
changes.Add(QueryFilter.New(StockItemHoldingProperty.LastEditedWhen, FilterConditions.Equals, changed.LastEditedWhen));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of TrackProperty</returns>
public static QueryFilters <TrackProperty> GetChanges(Track original, Track changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <TrackProperty>(9);
#region Detect Changes
if (original.TrackId != changed.TrackId)
{
changes.Add(QueryFilter.New(TrackProperty.TrackId, FilterConditions.Equals, changed.TrackId));
}
if (string.CompareOrdinal(original.Name, changed.Name) != 0)
{
changes.Add(QueryFilter.New(TrackProperty.Name, FilterConditions.Equals, changed.Name));
}
if (original.AlbumId != changed.AlbumId)
{
changes.Add(QueryFilter.New(TrackProperty.AlbumId, FilterConditions.Equals, changed.AlbumId));
}
if (original.MediaTypeId != changed.MediaTypeId)
{
changes.Add(QueryFilter.New(TrackProperty.MediaTypeId, FilterConditions.Equals, changed.MediaTypeId));
}
if (original.GenreId != changed.GenreId)
{
changes.Add(QueryFilter.New(TrackProperty.GenreId, FilterConditions.Equals, changed.GenreId));
}
if (string.CompareOrdinal(original.Composer, changed.Composer) != 0)
{
changes.Add(QueryFilter.New(TrackProperty.Composer, FilterConditions.Equals, changed.Composer));
}
if (original.Milliseconds != changed.Milliseconds)
{
changes.Add(QueryFilter.New(TrackProperty.Milliseconds, FilterConditions.Equals, changed.Milliseconds));
}
if (original.Bytes != changed.Bytes)
{
changes.Add(QueryFilter.New(TrackProperty.Bytes, FilterConditions.Equals, changed.Bytes));
}
if (original.UnitPrice != changed.UnitPrice)
{
changes.Add(QueryFilter.New(TrackProperty.UnitPrice, FilterConditions.Equals, changed.UnitPrice));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of ColdRoomTemperatures_ArchiveProperty</returns>
public static QueryFilters <ColdRoomTemperatures_ArchiveProperty> GetChanges(ColdRoomTemperatures_Archive original, ColdRoomTemperatures_Archive changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <ColdRoomTemperatures_ArchiveProperty>(6);
#region Detect Changes
if (original.ColdRoomTemperatureID != changed.ColdRoomTemperatureID)
{
changes.Add(QueryFilter.New(ColdRoomTemperatures_ArchiveProperty.ColdRoomTemperatureID, FilterConditions.Equals, changed.ColdRoomTemperatureID));
}
if (original.ColdRoomSensorNumber != changed.ColdRoomSensorNumber)
{
changes.Add(QueryFilter.New(ColdRoomTemperatures_ArchiveProperty.ColdRoomSensorNumber, FilterConditions.Equals, changed.ColdRoomSensorNumber));
}
if (original.RecordedWhen != changed.RecordedWhen)
{
changes.Add(QueryFilter.New(ColdRoomTemperatures_ArchiveProperty.RecordedWhen, FilterConditions.Equals, changed.RecordedWhen));
}
if (original.Temperature != changed.Temperature)
{
changes.Add(QueryFilter.New(ColdRoomTemperatures_ArchiveProperty.Temperature, FilterConditions.Equals, changed.Temperature));
}
if (original.ValidFrom != changed.ValidFrom)
{
changes.Add(QueryFilter.New(ColdRoomTemperatures_ArchiveProperty.ValidFrom, FilterConditions.Equals, changed.ValidFrom));
}
if (original.ValidTo != changed.ValidTo)
{
changes.Add(QueryFilter.New(ColdRoomTemperatures_ArchiveProperty.ValidTo, FilterConditions.Equals, changed.ValidTo));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of InvoiceProperty</returns>
public static QueryFilters <InvoiceProperty> GetChanges(Invoice original, Invoice changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <InvoiceProperty>(9);
#region Detect Changes
if (original.InvoiceId != changed.InvoiceId)
{
changes.Add(QueryFilter.New(InvoiceProperty.InvoiceId, FilterConditions.Equals, changed.InvoiceId));
}
if (original.CustomerId != changed.CustomerId)
{
changes.Add(QueryFilter.New(InvoiceProperty.CustomerId, FilterConditions.Equals, changed.CustomerId));
}
if (original.InvoiceDate != changed.InvoiceDate)
{
changes.Add(QueryFilter.New(InvoiceProperty.InvoiceDate, FilterConditions.Equals, changed.InvoiceDate));
}
if (string.CompareOrdinal(original.BillingAddress, changed.BillingAddress) != 0)
{
changes.Add(QueryFilter.New(InvoiceProperty.BillingAddress, FilterConditions.Equals, changed.BillingAddress));
}
if (string.CompareOrdinal(original.BillingCity, changed.BillingCity) != 0)
{
changes.Add(QueryFilter.New(InvoiceProperty.BillingCity, FilterConditions.Equals, changed.BillingCity));
}
if (string.CompareOrdinal(original.BillingState, changed.BillingState) != 0)
{
changes.Add(QueryFilter.New(InvoiceProperty.BillingState, FilterConditions.Equals, changed.BillingState));
}
if (string.CompareOrdinal(original.BillingCountry, changed.BillingCountry) != 0)
{
changes.Add(QueryFilter.New(InvoiceProperty.BillingCountry, FilterConditions.Equals, changed.BillingCountry));
}
if (string.CompareOrdinal(original.BillingPostalCode, changed.BillingPostalCode) != 0)
{
changes.Add(QueryFilter.New(InvoiceProperty.BillingPostalCode, FilterConditions.Equals, changed.BillingPostalCode));
}
if (original.Total != changed.Total)
{
changes.Add(QueryFilter.New(InvoiceProperty.Total, FilterConditions.Equals, changed.Total));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of CityProperty</returns>
public static QueryFilters <CityProperty> GetChanges(City original, City changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <CityProperty>(8);
#region Detect Changes
if (original.CityID != changed.CityID)
{
changes.Add(QueryFilter.New(CityProperty.CityID, FilterConditions.Equals, changed.CityID));
}
if (string.CompareOrdinal(original.CityName, changed.CityName) != 0)
{
changes.Add(QueryFilter.New(CityProperty.CityName, FilterConditions.Equals, changed.CityName));
}
if (original.StateProvinceID != changed.StateProvinceID)
{
changes.Add(QueryFilter.New(CityProperty.StateProvinceID, FilterConditions.Equals, changed.StateProvinceID));
}
if (original.Location != changed.Location)
{
changes.Add(QueryFilter.New(CityProperty.Location, FilterConditions.Equals, changed.Location));
}
if (original.LatestRecordedPopulation != changed.LatestRecordedPopulation)
{
changes.Add(QueryFilter.New(CityProperty.LatestRecordedPopulation, FilterConditions.Equals, changed.LatestRecordedPopulation));
}
if (original.LastEditedBy != changed.LastEditedBy)
{
changes.Add(QueryFilter.New(CityProperty.LastEditedBy, FilterConditions.Equals, changed.LastEditedBy));
}
if (original.ValidFrom != changed.ValidFrom)
{
changes.Add(QueryFilter.New(CityProperty.ValidFrom, FilterConditions.Equals, changed.ValidFrom));
}
if (original.ValidTo != changed.ValidTo)
{
changes.Add(QueryFilter.New(CityProperty.ValidTo, FilterConditions.Equals, changed.ValidTo));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of VehicleTemperatureProperty</returns>
public static QueryFilters <VehicleTemperatureProperty> GetChanges(VehicleTemperature original, VehicleTemperature changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <VehicleTemperatureProperty>(8);
#region Detect Changes
if (original.VehicleTemperatureID != changed.VehicleTemperatureID)
{
changes.Add(QueryFilter.New(VehicleTemperatureProperty.VehicleTemperatureID, FilterConditions.Equals, changed.VehicleTemperatureID));
}
if (string.CompareOrdinal(original.VehicleRegistration, changed.VehicleRegistration) != 0)
{
changes.Add(QueryFilter.New(VehicleTemperatureProperty.VehicleRegistration, FilterConditions.Equals, changed.VehicleRegistration));
}
if (original.ChillerSensorNumber != changed.ChillerSensorNumber)
{
changes.Add(QueryFilter.New(VehicleTemperatureProperty.ChillerSensorNumber, FilterConditions.Equals, changed.ChillerSensorNumber));
}
if (original.RecordedWhen != changed.RecordedWhen)
{
changes.Add(QueryFilter.New(VehicleTemperatureProperty.RecordedWhen, FilterConditions.Equals, changed.RecordedWhen));
}
if (original.Temperature != changed.Temperature)
{
changes.Add(QueryFilter.New(VehicleTemperatureProperty.Temperature, FilterConditions.Equals, changed.Temperature));
}
if (string.CompareOrdinal(original.FullSensorData, changed.FullSensorData) != 0)
{
changes.Add(QueryFilter.New(VehicleTemperatureProperty.FullSensorData, FilterConditions.Equals, changed.FullSensorData));
}
if (original.IsCompressed != changed.IsCompressed)
{
changes.Add(QueryFilter.New(VehicleTemperatureProperty.IsCompressed, FilterConditions.Equals, changed.IsCompressed));
}
if (!Compare.ByteArrays(original.CompressedSensorData, changed.CompressedSensorData))
{
changes.Add(QueryFilter.New(VehicleTemperatureProperty.CompressedSensorData, FilterConditions.Equals, changed.CompressedSensorData));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of SystemParameterProperty</returns>
public static QueryFilters <SystemParameterProperty> GetChanges(SystemParameter original, SystemParameter changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <SystemParameterProperty>(13);
#region Detect Changes
if (original.SystemParameterID != changed.SystemParameterID)
{
changes.Add(QueryFilter.New(SystemParameterProperty.SystemParameterID, FilterConditions.Equals, changed.SystemParameterID));
}
if (string.CompareOrdinal(original.DeliveryAddressLine1, changed.DeliveryAddressLine1) != 0)
{
changes.Add(QueryFilter.New(SystemParameterProperty.DeliveryAddressLine1, FilterConditions.Equals, changed.DeliveryAddressLine1));
}
if (string.CompareOrdinal(original.DeliveryAddressLine2, changed.DeliveryAddressLine2) != 0)
{
changes.Add(QueryFilter.New(SystemParameterProperty.DeliveryAddressLine2, FilterConditions.Equals, changed.DeliveryAddressLine2));
}
if (original.DeliveryCityID != changed.DeliveryCityID)
{
changes.Add(QueryFilter.New(SystemParameterProperty.DeliveryCityID, FilterConditions.Equals, changed.DeliveryCityID));
}
if (string.CompareOrdinal(original.DeliveryPostalCode, changed.DeliveryPostalCode) != 0)
{
changes.Add(QueryFilter.New(SystemParameterProperty.DeliveryPostalCode, FilterConditions.Equals, changed.DeliveryPostalCode));
}
if (original.DeliveryLocation != changed.DeliveryLocation)
{
changes.Add(QueryFilter.New(SystemParameterProperty.DeliveryLocation, FilterConditions.Equals, changed.DeliveryLocation));
}
if (string.CompareOrdinal(original.PostalAddressLine1, changed.PostalAddressLine1) != 0)
{
changes.Add(QueryFilter.New(SystemParameterProperty.PostalAddressLine1, FilterConditions.Equals, changed.PostalAddressLine1));
}
if (string.CompareOrdinal(original.PostalAddressLine2, changed.PostalAddressLine2) != 0)
{
changes.Add(QueryFilter.New(SystemParameterProperty.PostalAddressLine2, FilterConditions.Equals, changed.PostalAddressLine2));
}
if (original.PostalCityID != changed.PostalCityID)
{
changes.Add(QueryFilter.New(SystemParameterProperty.PostalCityID, FilterConditions.Equals, changed.PostalCityID));
}
if (string.CompareOrdinal(original.PostalPostalCode, changed.PostalPostalCode) != 0)
{
changes.Add(QueryFilter.New(SystemParameterProperty.PostalPostalCode, FilterConditions.Equals, changed.PostalPostalCode));
}
if (string.CompareOrdinal(original.ApplicationSettings, changed.ApplicationSettings) != 0)
{
changes.Add(QueryFilter.New(SystemParameterProperty.ApplicationSettings, FilterConditions.Equals, changed.ApplicationSettings));
}
if (original.LastEditedBy != changed.LastEditedBy)
{
changes.Add(QueryFilter.New(SystemParameterProperty.LastEditedBy, FilterConditions.Equals, changed.LastEditedBy));
}
if (original.LastEditedWhen != changed.LastEditedWhen)
{
changes.Add(QueryFilter.New(SystemParameterProperty.LastEditedWhen, FilterConditions.Equals, changed.LastEditedWhen));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of PurchaseOrderProperty</returns>
public static QueryFilters <PurchaseOrderProperty> GetChanges(PurchaseOrder original, PurchaseOrder changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <PurchaseOrderProperty>(12);
#region Detect Changes
if (original.PurchaseOrderID != changed.PurchaseOrderID)
{
changes.Add(QueryFilter.New(PurchaseOrderProperty.PurchaseOrderID, FilterConditions.Equals, changed.PurchaseOrderID));
}
if (original.SupplierID != changed.SupplierID)
{
changes.Add(QueryFilter.New(PurchaseOrderProperty.SupplierID, FilterConditions.Equals, changed.SupplierID));
}
if (original.OrderDate != changed.OrderDate)
{
changes.Add(QueryFilter.New(PurchaseOrderProperty.OrderDate, FilterConditions.Equals, changed.OrderDate));
}
if (original.DeliveryMethodID != changed.DeliveryMethodID)
{
changes.Add(QueryFilter.New(PurchaseOrderProperty.DeliveryMethodID, FilterConditions.Equals, changed.DeliveryMethodID));
}
if (original.ContactPersonID != changed.ContactPersonID)
{
changes.Add(QueryFilter.New(PurchaseOrderProperty.ContactPersonID, FilterConditions.Equals, changed.ContactPersonID));
}
if (original.ExpectedDeliveryDate != changed.ExpectedDeliveryDate)
{
changes.Add(QueryFilter.New(PurchaseOrderProperty.ExpectedDeliveryDate, FilterConditions.Equals, changed.ExpectedDeliveryDate));
}
if (string.CompareOrdinal(original.SupplierReference, changed.SupplierReference) != 0)
{
changes.Add(QueryFilter.New(PurchaseOrderProperty.SupplierReference, FilterConditions.Equals, changed.SupplierReference));
}
if (original.IsOrderFinalized != changed.IsOrderFinalized)
{
changes.Add(QueryFilter.New(PurchaseOrderProperty.IsOrderFinalized, FilterConditions.Equals, changed.IsOrderFinalized));
}
if (string.CompareOrdinal(original.Comments, changed.Comments) != 0)
{
changes.Add(QueryFilter.New(PurchaseOrderProperty.Comments, FilterConditions.Equals, changed.Comments));
}
if (string.CompareOrdinal(original.InternalComments, changed.InternalComments) != 0)
{
changes.Add(QueryFilter.New(PurchaseOrderProperty.InternalComments, FilterConditions.Equals, changed.InternalComments));
}
if (original.LastEditedBy != changed.LastEditedBy)
{
changes.Add(QueryFilter.New(PurchaseOrderProperty.LastEditedBy, FilterConditions.Equals, changed.LastEditedBy));
}
if (original.LastEditedWhen != changed.LastEditedWhen)
{
changes.Add(QueryFilter.New(PurchaseOrderProperty.LastEditedWhen, FilterConditions.Equals, changed.LastEditedWhen));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of PersonProperty</returns>
public static QueryFilters <PersonProperty> GetChanges(Person original, Person changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <PersonProperty>(21);
#region Detect Changes
if (original.PersonID != changed.PersonID)
{
changes.Add(QueryFilter.New(PersonProperty.PersonID, FilterConditions.Equals, changed.PersonID));
}
if (string.CompareOrdinal(original.FullName, changed.FullName) != 0)
{
changes.Add(QueryFilter.New(PersonProperty.FullName, FilterConditions.Equals, changed.FullName));
}
if (string.CompareOrdinal(original.PreferredName, changed.PreferredName) != 0)
{
changes.Add(QueryFilter.New(PersonProperty.PreferredName, FilterConditions.Equals, changed.PreferredName));
}
if (string.CompareOrdinal(original.SearchName, changed.SearchName) != 0)
{
changes.Add(QueryFilter.New(PersonProperty.SearchName, FilterConditions.Equals, changed.SearchName));
}
if (original.IsPermittedToLogon != changed.IsPermittedToLogon)
{
changes.Add(QueryFilter.New(PersonProperty.IsPermittedToLogon, FilterConditions.Equals, changed.IsPermittedToLogon));
}
if (string.CompareOrdinal(original.LogonName, changed.LogonName) != 0)
{
changes.Add(QueryFilter.New(PersonProperty.LogonName, FilterConditions.Equals, changed.LogonName));
}
if (original.IsExternalLogonProvider != changed.IsExternalLogonProvider)
{
changes.Add(QueryFilter.New(PersonProperty.IsExternalLogonProvider, FilterConditions.Equals, changed.IsExternalLogonProvider));
}
if (!Compare.ByteArrays(original.HashedPassword, changed.HashedPassword))
{
changes.Add(QueryFilter.New(PersonProperty.HashedPassword, FilterConditions.Equals, changed.HashedPassword));
}
if (original.IsSystemUser != changed.IsSystemUser)
{
changes.Add(QueryFilter.New(PersonProperty.IsSystemUser, FilterConditions.Equals, changed.IsSystemUser));
}
if (original.IsEmployee != changed.IsEmployee)
{
changes.Add(QueryFilter.New(PersonProperty.IsEmployee, FilterConditions.Equals, changed.IsEmployee));
}
if (original.IsSalesperson != changed.IsSalesperson)
{
changes.Add(QueryFilter.New(PersonProperty.IsSalesperson, FilterConditions.Equals, changed.IsSalesperson));
}
if (string.CompareOrdinal(original.UserPreferences, changed.UserPreferences) != 0)
{
changes.Add(QueryFilter.New(PersonProperty.UserPreferences, FilterConditions.Equals, changed.UserPreferences));
}
if (string.CompareOrdinal(original.PhoneNumber, changed.PhoneNumber) != 0)
{
changes.Add(QueryFilter.New(PersonProperty.PhoneNumber, FilterConditions.Equals, changed.PhoneNumber));
}
if (string.CompareOrdinal(original.FaxNumber, changed.FaxNumber) != 0)
{
changes.Add(QueryFilter.New(PersonProperty.FaxNumber, FilterConditions.Equals, changed.FaxNumber));
}
if (string.CompareOrdinal(original.EmailAddress, changed.EmailAddress) != 0)
{
changes.Add(QueryFilter.New(PersonProperty.EmailAddress, FilterConditions.Equals, changed.EmailAddress));
}
if (!Compare.ByteArrays(original.Photo, changed.Photo))
{
changes.Add(QueryFilter.New(PersonProperty.Photo, FilterConditions.Equals, changed.Photo));
}
if (string.CompareOrdinal(original.CustomFields, changed.CustomFields) != 0)
{
changes.Add(QueryFilter.New(PersonProperty.CustomFields, FilterConditions.Equals, changed.CustomFields));
}
if (string.CompareOrdinal(original.OtherLanguages, changed.OtherLanguages) != 0)
{
changes.Add(QueryFilter.New(PersonProperty.OtherLanguages, FilterConditions.Equals, changed.OtherLanguages));
}
if (original.LastEditedBy != changed.LastEditedBy)
{
changes.Add(QueryFilter.New(PersonProperty.LastEditedBy, FilterConditions.Equals, changed.LastEditedBy));
}
if (original.ValidFrom != changed.ValidFrom)
{
changes.Add(QueryFilter.New(PersonProperty.ValidFrom, FilterConditions.Equals, changed.ValidFrom));
}
if (original.ValidTo != changed.ValidTo)
{
changes.Add(QueryFilter.New(PersonProperty.ValidTo, FilterConditions.Equals, changed.ValidTo));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of StockItems_ArchiveProperty</returns>
public static QueryFilters <StockItems_ArchiveProperty> GetChanges(StockItems_Archive original, StockItems_Archive changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <StockItems_ArchiveProperty>(25);
#region Detect Changes
if (original.StockItemID != changed.StockItemID)
{
changes.Add(QueryFilter.New(StockItems_ArchiveProperty.StockItemID, FilterConditions.Equals, changed.StockItemID));
}
if (string.CompareOrdinal(original.StockItemName, changed.StockItemName) != 0)
{
changes.Add(QueryFilter.New(StockItems_ArchiveProperty.StockItemName, FilterConditions.Equals, changed.StockItemName));
}
if (original.SupplierID != changed.SupplierID)
{
changes.Add(QueryFilter.New(StockItems_ArchiveProperty.SupplierID, FilterConditions.Equals, changed.SupplierID));
}
if (original.ColorID != changed.ColorID)
{
changes.Add(QueryFilter.New(StockItems_ArchiveProperty.ColorID, FilterConditions.Equals, changed.ColorID));
}
if (original.UnitPackageID != changed.UnitPackageID)
{
changes.Add(QueryFilter.New(StockItems_ArchiveProperty.UnitPackageID, FilterConditions.Equals, changed.UnitPackageID));
}
if (original.OuterPackageID != changed.OuterPackageID)
{
changes.Add(QueryFilter.New(StockItems_ArchiveProperty.OuterPackageID, FilterConditions.Equals, changed.OuterPackageID));
}
if (string.CompareOrdinal(original.Brand, changed.Brand) != 0)
{
changes.Add(QueryFilter.New(StockItems_ArchiveProperty.Brand, FilterConditions.Equals, changed.Brand));
}
if (string.CompareOrdinal(original.Size, changed.Size) != 0)
{
changes.Add(QueryFilter.New(StockItems_ArchiveProperty.Size, FilterConditions.Equals, changed.Size));
}
if (original.LeadTimeDays != changed.LeadTimeDays)
{
changes.Add(QueryFilter.New(StockItems_ArchiveProperty.LeadTimeDays, FilterConditions.Equals, changed.LeadTimeDays));
}
if (original.QuantityPerOuter != changed.QuantityPerOuter)
{
changes.Add(QueryFilter.New(StockItems_ArchiveProperty.QuantityPerOuter, FilterConditions.Equals, changed.QuantityPerOuter));
}
if (original.IsChillerStock != changed.IsChillerStock)
{
changes.Add(QueryFilter.New(StockItems_ArchiveProperty.IsChillerStock, FilterConditions.Equals, changed.IsChillerStock));
}
if (string.CompareOrdinal(original.Barcode, changed.Barcode) != 0)
{
changes.Add(QueryFilter.New(StockItems_ArchiveProperty.Barcode, FilterConditions.Equals, changed.Barcode));
}
if (original.TaxRate != changed.TaxRate)
{
changes.Add(QueryFilter.New(StockItems_ArchiveProperty.TaxRate, FilterConditions.Equals, changed.TaxRate));
}
if (original.UnitPrice != changed.UnitPrice)
{
changes.Add(QueryFilter.New(StockItems_ArchiveProperty.UnitPrice, FilterConditions.Equals, changed.UnitPrice));
}
if (original.RecommendedRetailPrice != changed.RecommendedRetailPrice)
{
changes.Add(QueryFilter.New(StockItems_ArchiveProperty.RecommendedRetailPrice, FilterConditions.Equals, changed.RecommendedRetailPrice));
}
if (original.TypicalWeightPerUnit != changed.TypicalWeightPerUnit)
{
changes.Add(QueryFilter.New(StockItems_ArchiveProperty.TypicalWeightPerUnit, FilterConditions.Equals, changed.TypicalWeightPerUnit));
}
if (string.CompareOrdinal(original.MarketingComments, changed.MarketingComments) != 0)
{
changes.Add(QueryFilter.New(StockItems_ArchiveProperty.MarketingComments, FilterConditions.Equals, changed.MarketingComments));
}
if (string.CompareOrdinal(original.InternalComments, changed.InternalComments) != 0)
{
changes.Add(QueryFilter.New(StockItems_ArchiveProperty.InternalComments, FilterConditions.Equals, changed.InternalComments));
}
if (!Compare.ByteArrays(original.Photo, changed.Photo))
{
changes.Add(QueryFilter.New(StockItems_ArchiveProperty.Photo, FilterConditions.Equals, changed.Photo));
}
if (string.CompareOrdinal(original.CustomFields, changed.CustomFields) != 0)
{
changes.Add(QueryFilter.New(StockItems_ArchiveProperty.CustomFields, FilterConditions.Equals, changed.CustomFields));
}
if (string.CompareOrdinal(original.Tags, changed.Tags) != 0)
{
changes.Add(QueryFilter.New(StockItems_ArchiveProperty.Tags, FilterConditions.Equals, changed.Tags));
}
if (string.CompareOrdinal(original.SearchDetails, changed.SearchDetails) != 0)
{
changes.Add(QueryFilter.New(StockItems_ArchiveProperty.SearchDetails, FilterConditions.Equals, changed.SearchDetails));
}
if (original.LastEditedBy != changed.LastEditedBy)
{
changes.Add(QueryFilter.New(StockItems_ArchiveProperty.LastEditedBy, FilterConditions.Equals, changed.LastEditedBy));
}
if (original.ValidFrom != changed.ValidFrom)
{
changes.Add(QueryFilter.New(StockItems_ArchiveProperty.ValidFrom, FilterConditions.Equals, changed.ValidFrom));
}
if (original.ValidTo != changed.ValidTo)
{
changes.Add(QueryFilter.New(StockItems_ArchiveProperty.ValidTo, FilterConditions.Equals, changed.ValidTo));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of CustomerTransactionProperty</returns>
public static QueryFilters <CustomerTransactionProperty> GetChanges(CustomerTransaction original, CustomerTransaction changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <CustomerTransactionProperty>(14);
#region Detect Changes
if (original.CustomerTransactionID != changed.CustomerTransactionID)
{
changes.Add(QueryFilter.New(CustomerTransactionProperty.CustomerTransactionID, FilterConditions.Equals, changed.CustomerTransactionID));
}
if (original.CustomerID != changed.CustomerID)
{
changes.Add(QueryFilter.New(CustomerTransactionProperty.CustomerID, FilterConditions.Equals, changed.CustomerID));
}
if (original.TransactionTypeID != changed.TransactionTypeID)
{
changes.Add(QueryFilter.New(CustomerTransactionProperty.TransactionTypeID, FilterConditions.Equals, changed.TransactionTypeID));
}
if (original.InvoiceID != changed.InvoiceID)
{
changes.Add(QueryFilter.New(CustomerTransactionProperty.InvoiceID, FilterConditions.Equals, changed.InvoiceID));
}
if (original.PaymentMethodID != changed.PaymentMethodID)
{
changes.Add(QueryFilter.New(CustomerTransactionProperty.PaymentMethodID, FilterConditions.Equals, changed.PaymentMethodID));
}
if (original.TransactionDate != changed.TransactionDate)
{
changes.Add(QueryFilter.New(CustomerTransactionProperty.TransactionDate, FilterConditions.Equals, changed.TransactionDate));
}
if (original.AmountExcludingTax != changed.AmountExcludingTax)
{
changes.Add(QueryFilter.New(CustomerTransactionProperty.AmountExcludingTax, FilterConditions.Equals, changed.AmountExcludingTax));
}
if (original.TaxAmount != changed.TaxAmount)
{
changes.Add(QueryFilter.New(CustomerTransactionProperty.TaxAmount, FilterConditions.Equals, changed.TaxAmount));
}
if (original.TransactionAmount != changed.TransactionAmount)
{
changes.Add(QueryFilter.New(CustomerTransactionProperty.TransactionAmount, FilterConditions.Equals, changed.TransactionAmount));
}
if (original.OutstandingBalance != changed.OutstandingBalance)
{
changes.Add(QueryFilter.New(CustomerTransactionProperty.OutstandingBalance, FilterConditions.Equals, changed.OutstandingBalance));
}
if (original.FinalizationDate != changed.FinalizationDate)
{
changes.Add(QueryFilter.New(CustomerTransactionProperty.FinalizationDate, FilterConditions.Equals, changed.FinalizationDate));
}
if (original.IsFinalized != changed.IsFinalized)
{
changes.Add(QueryFilter.New(CustomerTransactionProperty.IsFinalized, FilterConditions.Equals, changed.IsFinalized));
}
if (original.LastEditedBy != changed.LastEditedBy)
{
changes.Add(QueryFilter.New(CustomerTransactionProperty.LastEditedBy, FilterConditions.Equals, changed.LastEditedBy));
}
if (original.LastEditedWhen != changed.LastEditedWhen)
{
changes.Add(QueryFilter.New(CustomerTransactionProperty.LastEditedWhen, FilterConditions.Equals, changed.LastEditedWhen));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of CountryProperty</returns>
public static QueryFilters <CountryProperty> GetChanges(Country original, Country changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <CountryProperty>(14);
#region Detect Changes
if (original.CountryID != changed.CountryID)
{
changes.Add(QueryFilter.New(CountryProperty.CountryID, FilterConditions.Equals, changed.CountryID));
}
if (string.CompareOrdinal(original.CountryName, changed.CountryName) != 0)
{
changes.Add(QueryFilter.New(CountryProperty.CountryName, FilterConditions.Equals, changed.CountryName));
}
if (string.CompareOrdinal(original.FormalName, changed.FormalName) != 0)
{
changes.Add(QueryFilter.New(CountryProperty.FormalName, FilterConditions.Equals, changed.FormalName));
}
if (string.CompareOrdinal(original.IsoAlpha3Code, changed.IsoAlpha3Code) != 0)
{
changes.Add(QueryFilter.New(CountryProperty.IsoAlpha3Code, FilterConditions.Equals, changed.IsoAlpha3Code));
}
if (original.IsoNumericCode != changed.IsoNumericCode)
{
changes.Add(QueryFilter.New(CountryProperty.IsoNumericCode, FilterConditions.Equals, changed.IsoNumericCode));
}
if (string.CompareOrdinal(original.CountryType, changed.CountryType) != 0)
{
changes.Add(QueryFilter.New(CountryProperty.CountryType, FilterConditions.Equals, changed.CountryType));
}
if (original.LatestRecordedPopulation != changed.LatestRecordedPopulation)
{
changes.Add(QueryFilter.New(CountryProperty.LatestRecordedPopulation, FilterConditions.Equals, changed.LatestRecordedPopulation));
}
if (string.CompareOrdinal(original.Continent, changed.Continent) != 0)
{
changes.Add(QueryFilter.New(CountryProperty.Continent, FilterConditions.Equals, changed.Continent));
}
if (string.CompareOrdinal(original.Region, changed.Region) != 0)
{
changes.Add(QueryFilter.New(CountryProperty.Region, FilterConditions.Equals, changed.Region));
}
if (string.CompareOrdinal(original.Subregion, changed.Subregion) != 0)
{
changes.Add(QueryFilter.New(CountryProperty.Subregion, FilterConditions.Equals, changed.Subregion));
}
if (original.Border != changed.Border)
{
changes.Add(QueryFilter.New(CountryProperty.Border, FilterConditions.Equals, changed.Border));
}
if (original.LastEditedBy != changed.LastEditedBy)
{
changes.Add(QueryFilter.New(CountryProperty.LastEditedBy, FilterConditions.Equals, changed.LastEditedBy));
}
if (original.ValidFrom != changed.ValidFrom)
{
changes.Add(QueryFilter.New(CountryProperty.ValidFrom, FilterConditions.Equals, changed.ValidFrom));
}
if (original.ValidTo != changed.ValidTo)
{
changes.Add(QueryFilter.New(CountryProperty.ValidTo, FilterConditions.Equals, changed.ValidTo));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of Suppliers_ArchiveProperty</returns>
public static QueryFilters <Suppliers_ArchiveProperty> GetChanges(Suppliers_Archive original, Suppliers_Archive changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <Suppliers_ArchiveProperty>(29);
#region Detect Changes
if (original.SupplierID != changed.SupplierID)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.SupplierID, FilterConditions.Equals, changed.SupplierID));
}
if (string.CompareOrdinal(original.SupplierName, changed.SupplierName) != 0)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.SupplierName, FilterConditions.Equals, changed.SupplierName));
}
if (original.SupplierCategoryID != changed.SupplierCategoryID)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.SupplierCategoryID, FilterConditions.Equals, changed.SupplierCategoryID));
}
if (original.PrimaryContactPersonID != changed.PrimaryContactPersonID)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.PrimaryContactPersonID, FilterConditions.Equals, changed.PrimaryContactPersonID));
}
if (original.AlternateContactPersonID != changed.AlternateContactPersonID)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.AlternateContactPersonID, FilterConditions.Equals, changed.AlternateContactPersonID));
}
if (original.DeliveryMethodID != changed.DeliveryMethodID)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.DeliveryMethodID, FilterConditions.Equals, changed.DeliveryMethodID));
}
if (original.DeliveryCityID != changed.DeliveryCityID)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.DeliveryCityID, FilterConditions.Equals, changed.DeliveryCityID));
}
if (original.PostalCityID != changed.PostalCityID)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.PostalCityID, FilterConditions.Equals, changed.PostalCityID));
}
if (string.CompareOrdinal(original.SupplierReference, changed.SupplierReference) != 0)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.SupplierReference, FilterConditions.Equals, changed.SupplierReference));
}
if (string.CompareOrdinal(original.BankAccountName, changed.BankAccountName) != 0)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.BankAccountName, FilterConditions.Equals, changed.BankAccountName));
}
if (string.CompareOrdinal(original.BankAccountBranch, changed.BankAccountBranch) != 0)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.BankAccountBranch, FilterConditions.Equals, changed.BankAccountBranch));
}
if (string.CompareOrdinal(original.BankAccountCode, changed.BankAccountCode) != 0)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.BankAccountCode, FilterConditions.Equals, changed.BankAccountCode));
}
if (string.CompareOrdinal(original.BankAccountNumber, changed.BankAccountNumber) != 0)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.BankAccountNumber, FilterConditions.Equals, changed.BankAccountNumber));
}
if (string.CompareOrdinal(original.BankInternationalCode, changed.BankInternationalCode) != 0)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.BankInternationalCode, FilterConditions.Equals, changed.BankInternationalCode));
}
if (original.PaymentDays != changed.PaymentDays)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.PaymentDays, FilterConditions.Equals, changed.PaymentDays));
}
if (string.CompareOrdinal(original.InternalComments, changed.InternalComments) != 0)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.InternalComments, FilterConditions.Equals, changed.InternalComments));
}
if (string.CompareOrdinal(original.PhoneNumber, changed.PhoneNumber) != 0)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.PhoneNumber, FilterConditions.Equals, changed.PhoneNumber));
}
if (string.CompareOrdinal(original.FaxNumber, changed.FaxNumber) != 0)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.FaxNumber, FilterConditions.Equals, changed.FaxNumber));
}
if (string.CompareOrdinal(original.WebsiteURL, changed.WebsiteURL) != 0)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.WebsiteURL, FilterConditions.Equals, changed.WebsiteURL));
}
if (string.CompareOrdinal(original.DeliveryAddressLine1, changed.DeliveryAddressLine1) != 0)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.DeliveryAddressLine1, FilterConditions.Equals, changed.DeliveryAddressLine1));
}
if (string.CompareOrdinal(original.DeliveryAddressLine2, changed.DeliveryAddressLine2) != 0)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.DeliveryAddressLine2, FilterConditions.Equals, changed.DeliveryAddressLine2));
}
if (string.CompareOrdinal(original.DeliveryPostalCode, changed.DeliveryPostalCode) != 0)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.DeliveryPostalCode, FilterConditions.Equals, changed.DeliveryPostalCode));
}
if (original.DeliveryLocation != changed.DeliveryLocation)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.DeliveryLocation, FilterConditions.Equals, changed.DeliveryLocation));
}
if (string.CompareOrdinal(original.PostalAddressLine1, changed.PostalAddressLine1) != 0)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.PostalAddressLine1, FilterConditions.Equals, changed.PostalAddressLine1));
}
if (string.CompareOrdinal(original.PostalAddressLine2, changed.PostalAddressLine2) != 0)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.PostalAddressLine2, FilterConditions.Equals, changed.PostalAddressLine2));
}
if (string.CompareOrdinal(original.PostalPostalCode, changed.PostalPostalCode) != 0)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.PostalPostalCode, FilterConditions.Equals, changed.PostalPostalCode));
}
if (original.LastEditedBy != changed.LastEditedBy)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.LastEditedBy, FilterConditions.Equals, changed.LastEditedBy));
}
if (original.ValidFrom != changed.ValidFrom)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.ValidFrom, FilterConditions.Equals, changed.ValidFrom));
}
if (original.ValidTo != changed.ValidTo)
{
changes.Add(QueryFilter.New(Suppliers_ArchiveProperty.ValidTo, FilterConditions.Equals, changed.ValidTo));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of CustomerProperty</returns>
public static QueryFilters <CustomerProperty> GetChanges(Customer original, Customer changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <CustomerProperty>(13);
#region Detect Changes
if (original.CustomerId != changed.CustomerId)
{
changes.Add(QueryFilter.New(CustomerProperty.CustomerId, FilterConditions.Equals, changed.CustomerId));
}
if (string.CompareOrdinal(original.FirstName, changed.FirstName) != 0)
{
changes.Add(QueryFilter.New(CustomerProperty.FirstName, FilterConditions.Equals, changed.FirstName));
}
if (string.CompareOrdinal(original.LastName, changed.LastName) != 0)
{
changes.Add(QueryFilter.New(CustomerProperty.LastName, FilterConditions.Equals, changed.LastName));
}
if (string.CompareOrdinal(original.Company, changed.Company) != 0)
{
changes.Add(QueryFilter.New(CustomerProperty.Company, FilterConditions.Equals, changed.Company));
}
if (string.CompareOrdinal(original.Address, changed.Address) != 0)
{
changes.Add(QueryFilter.New(CustomerProperty.Address, FilterConditions.Equals, changed.Address));
}
if (string.CompareOrdinal(original.City, changed.City) != 0)
{
changes.Add(QueryFilter.New(CustomerProperty.City, FilterConditions.Equals, changed.City));
}
if (string.CompareOrdinal(original.State, changed.State) != 0)
{
changes.Add(QueryFilter.New(CustomerProperty.State, FilterConditions.Equals, changed.State));
}
if (string.CompareOrdinal(original.Country, changed.Country) != 0)
{
changes.Add(QueryFilter.New(CustomerProperty.Country, FilterConditions.Equals, changed.Country));
}
if (string.CompareOrdinal(original.PostalCode, changed.PostalCode) != 0)
{
changes.Add(QueryFilter.New(CustomerProperty.PostalCode, FilterConditions.Equals, changed.PostalCode));
}
if (string.CompareOrdinal(original.Phone, changed.Phone) != 0)
{
changes.Add(QueryFilter.New(CustomerProperty.Phone, FilterConditions.Equals, changed.Phone));
}
if (string.CompareOrdinal(original.Fax, changed.Fax) != 0)
{
changes.Add(QueryFilter.New(CustomerProperty.Fax, FilterConditions.Equals, changed.Fax));
}
if (string.CompareOrdinal(original.Email, changed.Email) != 0)
{
changes.Add(QueryFilter.New(CustomerProperty.Email, FilterConditions.Equals, changed.Email));
}
if (original.SupportRepId != changed.SupportRepId)
{
changes.Add(QueryFilter.New(CustomerProperty.SupportRepId, FilterConditions.Equals, changed.SupportRepId));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of SpecialDealProperty</returns>
public static QueryFilters <SpecialDealProperty> GetChanges(SpecialDeal original, SpecialDeal changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <SpecialDealProperty>(14);
#region Detect Changes
if (original.SpecialDealID != changed.SpecialDealID)
{
changes.Add(QueryFilter.New(SpecialDealProperty.SpecialDealID, FilterConditions.Equals, changed.SpecialDealID));
}
if (original.StockItemID != changed.StockItemID)
{
changes.Add(QueryFilter.New(SpecialDealProperty.StockItemID, FilterConditions.Equals, changed.StockItemID));
}
if (original.CustomerID != changed.CustomerID)
{
changes.Add(QueryFilter.New(SpecialDealProperty.CustomerID, FilterConditions.Equals, changed.CustomerID));
}
if (original.BuyingGroupID != changed.BuyingGroupID)
{
changes.Add(QueryFilter.New(SpecialDealProperty.BuyingGroupID, FilterConditions.Equals, changed.BuyingGroupID));
}
if (original.CustomerCategoryID != changed.CustomerCategoryID)
{
changes.Add(QueryFilter.New(SpecialDealProperty.CustomerCategoryID, FilterConditions.Equals, changed.CustomerCategoryID));
}
if (original.StockGroupID != changed.StockGroupID)
{
changes.Add(QueryFilter.New(SpecialDealProperty.StockGroupID, FilterConditions.Equals, changed.StockGroupID));
}
if (string.CompareOrdinal(original.DealDescription, changed.DealDescription) != 0)
{
changes.Add(QueryFilter.New(SpecialDealProperty.DealDescription, FilterConditions.Equals, changed.DealDescription));
}
if (original.StartDate != changed.StartDate)
{
changes.Add(QueryFilter.New(SpecialDealProperty.StartDate, FilterConditions.Equals, changed.StartDate));
}
if (original.EndDate != changed.EndDate)
{
changes.Add(QueryFilter.New(SpecialDealProperty.EndDate, FilterConditions.Equals, changed.EndDate));
}
if (original.DiscountAmount != changed.DiscountAmount)
{
changes.Add(QueryFilter.New(SpecialDealProperty.DiscountAmount, FilterConditions.Equals, changed.DiscountAmount));
}
if (original.DiscountPercentage != changed.DiscountPercentage)
{
changes.Add(QueryFilter.New(SpecialDealProperty.DiscountPercentage, FilterConditions.Equals, changed.DiscountPercentage));
}
if (original.UnitPrice != changed.UnitPrice)
{
changes.Add(QueryFilter.New(SpecialDealProperty.UnitPrice, FilterConditions.Equals, changed.UnitPrice));
}
if (original.LastEditedBy != changed.LastEditedBy)
{
changes.Add(QueryFilter.New(SpecialDealProperty.LastEditedBy, FilterConditions.Equals, changed.LastEditedBy));
}
if (original.LastEditedWhen != changed.LastEditedWhen)
{
changes.Add(QueryFilter.New(SpecialDealProperty.LastEditedWhen, FilterConditions.Equals, changed.LastEditedWhen));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of OrderProperty</returns>
public static QueryFilters <OrderProperty> GetChanges(Order original, Order changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <OrderProperty>(16);
#region Detect Changes
if (original.OrderID != changed.OrderID)
{
changes.Add(QueryFilter.New(OrderProperty.OrderID, FilterConditions.Equals, changed.OrderID));
}
if (original.CustomerID != changed.CustomerID)
{
changes.Add(QueryFilter.New(OrderProperty.CustomerID, FilterConditions.Equals, changed.CustomerID));
}
if (original.SalespersonPersonID != changed.SalespersonPersonID)
{
changes.Add(QueryFilter.New(OrderProperty.SalespersonPersonID, FilterConditions.Equals, changed.SalespersonPersonID));
}
if (original.PickedByPersonID != changed.PickedByPersonID)
{
changes.Add(QueryFilter.New(OrderProperty.PickedByPersonID, FilterConditions.Equals, changed.PickedByPersonID));
}
if (original.ContactPersonID != changed.ContactPersonID)
{
changes.Add(QueryFilter.New(OrderProperty.ContactPersonID, FilterConditions.Equals, changed.ContactPersonID));
}
if (original.BackorderOrderID != changed.BackorderOrderID)
{
changes.Add(QueryFilter.New(OrderProperty.BackorderOrderID, FilterConditions.Equals, changed.BackorderOrderID));
}
if (original.OrderDate != changed.OrderDate)
{
changes.Add(QueryFilter.New(OrderProperty.OrderDate, FilterConditions.Equals, changed.OrderDate));
}
if (original.ExpectedDeliveryDate != changed.ExpectedDeliveryDate)
{
changes.Add(QueryFilter.New(OrderProperty.ExpectedDeliveryDate, FilterConditions.Equals, changed.ExpectedDeliveryDate));
}
if (string.CompareOrdinal(original.CustomerPurchaseOrderNumber, changed.CustomerPurchaseOrderNumber) != 0)
{
changes.Add(QueryFilter.New(OrderProperty.CustomerPurchaseOrderNumber, FilterConditions.Equals, changed.CustomerPurchaseOrderNumber));
}
if (original.IsUndersupplyBackordered != changed.IsUndersupplyBackordered)
{
changes.Add(QueryFilter.New(OrderProperty.IsUndersupplyBackordered, FilterConditions.Equals, changed.IsUndersupplyBackordered));
}
if (string.CompareOrdinal(original.Comments, changed.Comments) != 0)
{
changes.Add(QueryFilter.New(OrderProperty.Comments, FilterConditions.Equals, changed.Comments));
}
if (string.CompareOrdinal(original.DeliveryInstructions, changed.DeliveryInstructions) != 0)
{
changes.Add(QueryFilter.New(OrderProperty.DeliveryInstructions, FilterConditions.Equals, changed.DeliveryInstructions));
}
if (string.CompareOrdinal(original.InternalComments, changed.InternalComments) != 0)
{
changes.Add(QueryFilter.New(OrderProperty.InternalComments, FilterConditions.Equals, changed.InternalComments));
}
if (original.PickingCompletedWhen != changed.PickingCompletedWhen)
{
changes.Add(QueryFilter.New(OrderProperty.PickingCompletedWhen, FilterConditions.Equals, changed.PickingCompletedWhen));
}
if (original.LastEditedBy != changed.LastEditedBy)
{
changes.Add(QueryFilter.New(OrderProperty.LastEditedBy, FilterConditions.Equals, changed.LastEditedBy));
}
if (original.LastEditedWhen != changed.LastEditedWhen)
{
changes.Add(QueryFilter.New(OrderProperty.LastEditedWhen, FilterConditions.Equals, changed.LastEditedWhen));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of StockItemTransactionProperty</returns>
public static QueryFilters <StockItemTransactionProperty> GetChanges(StockItemTransaction original, StockItemTransaction changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <StockItemTransactionProperty>(11);
#region Detect Changes
if (original.StockItemTransactionID != changed.StockItemTransactionID)
{
changes.Add(QueryFilter.New(StockItemTransactionProperty.StockItemTransactionID, FilterConditions.Equals, changed.StockItemTransactionID));
}
if (original.StockItemID != changed.StockItemID)
{
changes.Add(QueryFilter.New(StockItemTransactionProperty.StockItemID, FilterConditions.Equals, changed.StockItemID));
}
if (original.TransactionTypeID != changed.TransactionTypeID)
{
changes.Add(QueryFilter.New(StockItemTransactionProperty.TransactionTypeID, FilterConditions.Equals, changed.TransactionTypeID));
}
if (original.CustomerID != changed.CustomerID)
{
changes.Add(QueryFilter.New(StockItemTransactionProperty.CustomerID, FilterConditions.Equals, changed.CustomerID));
}
if (original.InvoiceID != changed.InvoiceID)
{
changes.Add(QueryFilter.New(StockItemTransactionProperty.InvoiceID, FilterConditions.Equals, changed.InvoiceID));
}
if (original.SupplierID != changed.SupplierID)
{
changes.Add(QueryFilter.New(StockItemTransactionProperty.SupplierID, FilterConditions.Equals, changed.SupplierID));
}
if (original.PurchaseOrderID != changed.PurchaseOrderID)
{
changes.Add(QueryFilter.New(StockItemTransactionProperty.PurchaseOrderID, FilterConditions.Equals, changed.PurchaseOrderID));
}
if (original.TransactionOccurredWhen != changed.TransactionOccurredWhen)
{
changes.Add(QueryFilter.New(StockItemTransactionProperty.TransactionOccurredWhen, FilterConditions.Equals, changed.TransactionOccurredWhen));
}
if (original.Quantity != changed.Quantity)
{
changes.Add(QueryFilter.New(StockItemTransactionProperty.Quantity, FilterConditions.Equals, changed.Quantity));
}
if (original.LastEditedBy != changed.LastEditedBy)
{
changes.Add(QueryFilter.New(StockItemTransactionProperty.LastEditedBy, FilterConditions.Equals, changed.LastEditedBy));
}
if (original.LastEditedWhen != changed.LastEditedWhen)
{
changes.Add(QueryFilter.New(StockItemTransactionProperty.LastEditedWhen, FilterConditions.Equals, changed.LastEditedWhen));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of InvoiceLineProperty</returns>
public static QueryFilters <InvoiceLineProperty> GetChanges(InvoiceLine original, InvoiceLine changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <InvoiceLineProperty>(13);
#region Detect Changes
if (original.InvoiceLineID != changed.InvoiceLineID)
{
changes.Add(QueryFilter.New(InvoiceLineProperty.InvoiceLineID, FilterConditions.Equals, changed.InvoiceLineID));
}
if (original.InvoiceID != changed.InvoiceID)
{
changes.Add(QueryFilter.New(InvoiceLineProperty.InvoiceID, FilterConditions.Equals, changed.InvoiceID));
}
if (original.StockItemID != changed.StockItemID)
{
changes.Add(QueryFilter.New(InvoiceLineProperty.StockItemID, FilterConditions.Equals, changed.StockItemID));
}
if (string.CompareOrdinal(original.Description, changed.Description) != 0)
{
changes.Add(QueryFilter.New(InvoiceLineProperty.Description, FilterConditions.Equals, changed.Description));
}
if (original.PackageTypeID != changed.PackageTypeID)
{
changes.Add(QueryFilter.New(InvoiceLineProperty.PackageTypeID, FilterConditions.Equals, changed.PackageTypeID));
}
if (original.Quantity != changed.Quantity)
{
changes.Add(QueryFilter.New(InvoiceLineProperty.Quantity, FilterConditions.Equals, changed.Quantity));
}
if (original.UnitPrice != changed.UnitPrice)
{
changes.Add(QueryFilter.New(InvoiceLineProperty.UnitPrice, FilterConditions.Equals, changed.UnitPrice));
}
if (original.TaxRate != changed.TaxRate)
{
changes.Add(QueryFilter.New(InvoiceLineProperty.TaxRate, FilterConditions.Equals, changed.TaxRate));
}
if (original.TaxAmount != changed.TaxAmount)
{
changes.Add(QueryFilter.New(InvoiceLineProperty.TaxAmount, FilterConditions.Equals, changed.TaxAmount));
}
if (original.LineProfit != changed.LineProfit)
{
changes.Add(QueryFilter.New(InvoiceLineProperty.LineProfit, FilterConditions.Equals, changed.LineProfit));
}
if (original.ExtendedPrice != changed.ExtendedPrice)
{
changes.Add(QueryFilter.New(InvoiceLineProperty.ExtendedPrice, FilterConditions.Equals, changed.ExtendedPrice));
}
if (original.LastEditedBy != changed.LastEditedBy)
{
changes.Add(QueryFilter.New(InvoiceLineProperty.LastEditedBy, FilterConditions.Equals, changed.LastEditedBy));
}
if (original.LastEditedWhen != changed.LastEditedWhen)
{
changes.Add(QueryFilter.New(InvoiceLineProperty.LastEditedWhen, FilterConditions.Equals, changed.LastEditedWhen));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of CustomerProperty</returns>
public static QueryFilters <CustomerProperty> GetChanges(Customer original, Customer changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <CustomerProperty>(31);
#region Detect Changes
if (original.CustomerID != changed.CustomerID)
{
changes.Add(QueryFilter.New(CustomerProperty.CustomerID, FilterConditions.Equals, changed.CustomerID));
}
if (string.CompareOrdinal(original.CustomerName, changed.CustomerName) != 0)
{
changes.Add(QueryFilter.New(CustomerProperty.CustomerName, FilterConditions.Equals, changed.CustomerName));
}
if (original.BillToCustomerID != changed.BillToCustomerID)
{
changes.Add(QueryFilter.New(CustomerProperty.BillToCustomerID, FilterConditions.Equals, changed.BillToCustomerID));
}
if (original.CustomerCategoryID != changed.CustomerCategoryID)
{
changes.Add(QueryFilter.New(CustomerProperty.CustomerCategoryID, FilterConditions.Equals, changed.CustomerCategoryID));
}
if (original.BuyingGroupID != changed.BuyingGroupID)
{
changes.Add(QueryFilter.New(CustomerProperty.BuyingGroupID, FilterConditions.Equals, changed.BuyingGroupID));
}
if (original.PrimaryContactPersonID != changed.PrimaryContactPersonID)
{
changes.Add(QueryFilter.New(CustomerProperty.PrimaryContactPersonID, FilterConditions.Equals, changed.PrimaryContactPersonID));
}
if (original.AlternateContactPersonID != changed.AlternateContactPersonID)
{
changes.Add(QueryFilter.New(CustomerProperty.AlternateContactPersonID, FilterConditions.Equals, changed.AlternateContactPersonID));
}
if (original.DeliveryMethodID != changed.DeliveryMethodID)
{
changes.Add(QueryFilter.New(CustomerProperty.DeliveryMethodID, FilterConditions.Equals, changed.DeliveryMethodID));
}
if (original.DeliveryCityID != changed.DeliveryCityID)
{
changes.Add(QueryFilter.New(CustomerProperty.DeliveryCityID, FilterConditions.Equals, changed.DeliveryCityID));
}
if (original.PostalCityID != changed.PostalCityID)
{
changes.Add(QueryFilter.New(CustomerProperty.PostalCityID, FilterConditions.Equals, changed.PostalCityID));
}
if (original.CreditLimit != changed.CreditLimit)
{
changes.Add(QueryFilter.New(CustomerProperty.CreditLimit, FilterConditions.Equals, changed.CreditLimit));
}
if (original.AccountOpenedDate != changed.AccountOpenedDate)
{
changes.Add(QueryFilter.New(CustomerProperty.AccountOpenedDate, FilterConditions.Equals, changed.AccountOpenedDate));
}
if (original.StandardDiscountPercentage != changed.StandardDiscountPercentage)
{
changes.Add(QueryFilter.New(CustomerProperty.StandardDiscountPercentage, FilterConditions.Equals, changed.StandardDiscountPercentage));
}
if (original.IsStatementSent != changed.IsStatementSent)
{
changes.Add(QueryFilter.New(CustomerProperty.IsStatementSent, FilterConditions.Equals, changed.IsStatementSent));
}
if (original.IsOnCreditHold != changed.IsOnCreditHold)
{
changes.Add(QueryFilter.New(CustomerProperty.IsOnCreditHold, FilterConditions.Equals, changed.IsOnCreditHold));
}
if (original.PaymentDays != changed.PaymentDays)
{
changes.Add(QueryFilter.New(CustomerProperty.PaymentDays, FilterConditions.Equals, changed.PaymentDays));
}
if (string.CompareOrdinal(original.PhoneNumber, changed.PhoneNumber) != 0)
{
changes.Add(QueryFilter.New(CustomerProperty.PhoneNumber, FilterConditions.Equals, changed.PhoneNumber));
}
if (string.CompareOrdinal(original.FaxNumber, changed.FaxNumber) != 0)
{
changes.Add(QueryFilter.New(CustomerProperty.FaxNumber, FilterConditions.Equals, changed.FaxNumber));
}
if (string.CompareOrdinal(original.DeliveryRun, changed.DeliveryRun) != 0)
{
changes.Add(QueryFilter.New(CustomerProperty.DeliveryRun, FilterConditions.Equals, changed.DeliveryRun));
}
if (string.CompareOrdinal(original.RunPosition, changed.RunPosition) != 0)
{
changes.Add(QueryFilter.New(CustomerProperty.RunPosition, FilterConditions.Equals, changed.RunPosition));
}
if (string.CompareOrdinal(original.WebsiteURL, changed.WebsiteURL) != 0)
{
changes.Add(QueryFilter.New(CustomerProperty.WebsiteURL, FilterConditions.Equals, changed.WebsiteURL));
}
if (string.CompareOrdinal(original.DeliveryAddressLine1, changed.DeliveryAddressLine1) != 0)
{
changes.Add(QueryFilter.New(CustomerProperty.DeliveryAddressLine1, FilterConditions.Equals, changed.DeliveryAddressLine1));
}
if (string.CompareOrdinal(original.DeliveryAddressLine2, changed.DeliveryAddressLine2) != 0)
{
changes.Add(QueryFilter.New(CustomerProperty.DeliveryAddressLine2, FilterConditions.Equals, changed.DeliveryAddressLine2));
}
if (string.CompareOrdinal(original.DeliveryPostalCode, changed.DeliveryPostalCode) != 0)
{
changes.Add(QueryFilter.New(CustomerProperty.DeliveryPostalCode, FilterConditions.Equals, changed.DeliveryPostalCode));
}
if (original.DeliveryLocation != changed.DeliveryLocation)
{
changes.Add(QueryFilter.New(CustomerProperty.DeliveryLocation, FilterConditions.Equals, changed.DeliveryLocation));
}
if (string.CompareOrdinal(original.PostalAddressLine1, changed.PostalAddressLine1) != 0)
{
changes.Add(QueryFilter.New(CustomerProperty.PostalAddressLine1, FilterConditions.Equals, changed.PostalAddressLine1));
}
if (string.CompareOrdinal(original.PostalAddressLine2, changed.PostalAddressLine2) != 0)
{
changes.Add(QueryFilter.New(CustomerProperty.PostalAddressLine2, FilterConditions.Equals, changed.PostalAddressLine2));
}
if (string.CompareOrdinal(original.PostalPostalCode, changed.PostalPostalCode) != 0)
{
changes.Add(QueryFilter.New(CustomerProperty.PostalPostalCode, FilterConditions.Equals, changed.PostalPostalCode));
}
if (original.LastEditedBy != changed.LastEditedBy)
{
changes.Add(QueryFilter.New(CustomerProperty.LastEditedBy, FilterConditions.Equals, changed.LastEditedBy));
}
if (original.ValidFrom != changed.ValidFrom)
{
changes.Add(QueryFilter.New(CustomerProperty.ValidFrom, FilterConditions.Equals, changed.ValidFrom));
}
if (original.ValidTo != changed.ValidTo)
{
changes.Add(QueryFilter.New(CustomerProperty.ValidTo, FilterConditions.Equals, changed.ValidTo));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of InvoiceProperty</returns>
public static QueryFilters <InvoiceProperty> GetChanges(Invoice original, Invoice changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <InvoiceProperty>(25);
#region Detect Changes
if (original.InvoiceID != changed.InvoiceID)
{
changes.Add(QueryFilter.New(InvoiceProperty.InvoiceID, FilterConditions.Equals, changed.InvoiceID));
}
if (original.CustomerID != changed.CustomerID)
{
changes.Add(QueryFilter.New(InvoiceProperty.CustomerID, FilterConditions.Equals, changed.CustomerID));
}
if (original.BillToCustomerID != changed.BillToCustomerID)
{
changes.Add(QueryFilter.New(InvoiceProperty.BillToCustomerID, FilterConditions.Equals, changed.BillToCustomerID));
}
if (original.OrderID != changed.OrderID)
{
changes.Add(QueryFilter.New(InvoiceProperty.OrderID, FilterConditions.Equals, changed.OrderID));
}
if (original.DeliveryMethodID != changed.DeliveryMethodID)
{
changes.Add(QueryFilter.New(InvoiceProperty.DeliveryMethodID, FilterConditions.Equals, changed.DeliveryMethodID));
}
if (original.ContactPersonID != changed.ContactPersonID)
{
changes.Add(QueryFilter.New(InvoiceProperty.ContactPersonID, FilterConditions.Equals, changed.ContactPersonID));
}
if (original.AccountsPersonID != changed.AccountsPersonID)
{
changes.Add(QueryFilter.New(InvoiceProperty.AccountsPersonID, FilterConditions.Equals, changed.AccountsPersonID));
}
if (original.SalespersonPersonID != changed.SalespersonPersonID)
{
changes.Add(QueryFilter.New(InvoiceProperty.SalespersonPersonID, FilterConditions.Equals, changed.SalespersonPersonID));
}
if (original.PackedByPersonID != changed.PackedByPersonID)
{
changes.Add(QueryFilter.New(InvoiceProperty.PackedByPersonID, FilterConditions.Equals, changed.PackedByPersonID));
}
if (original.InvoiceDate != changed.InvoiceDate)
{
changes.Add(QueryFilter.New(InvoiceProperty.InvoiceDate, FilterConditions.Equals, changed.InvoiceDate));
}
if (string.CompareOrdinal(original.CustomerPurchaseOrderNumber, changed.CustomerPurchaseOrderNumber) != 0)
{
changes.Add(QueryFilter.New(InvoiceProperty.CustomerPurchaseOrderNumber, FilterConditions.Equals, changed.CustomerPurchaseOrderNumber));
}
if (original.IsCreditNote != changed.IsCreditNote)
{
changes.Add(QueryFilter.New(InvoiceProperty.IsCreditNote, FilterConditions.Equals, changed.IsCreditNote));
}
if (string.CompareOrdinal(original.CreditNoteReason, changed.CreditNoteReason) != 0)
{
changes.Add(QueryFilter.New(InvoiceProperty.CreditNoteReason, FilterConditions.Equals, changed.CreditNoteReason));
}
if (string.CompareOrdinal(original.Comments, changed.Comments) != 0)
{
changes.Add(QueryFilter.New(InvoiceProperty.Comments, FilterConditions.Equals, changed.Comments));
}
if (string.CompareOrdinal(original.DeliveryInstructions, changed.DeliveryInstructions) != 0)
{
changes.Add(QueryFilter.New(InvoiceProperty.DeliveryInstructions, FilterConditions.Equals, changed.DeliveryInstructions));
}
if (string.CompareOrdinal(original.InternalComments, changed.InternalComments) != 0)
{
changes.Add(QueryFilter.New(InvoiceProperty.InternalComments, FilterConditions.Equals, changed.InternalComments));
}
if (original.TotalDryItems != changed.TotalDryItems)
{
changes.Add(QueryFilter.New(InvoiceProperty.TotalDryItems, FilterConditions.Equals, changed.TotalDryItems));
}
if (original.TotalChillerItems != changed.TotalChillerItems)
{
changes.Add(QueryFilter.New(InvoiceProperty.TotalChillerItems, FilterConditions.Equals, changed.TotalChillerItems));
}
if (string.CompareOrdinal(original.DeliveryRun, changed.DeliveryRun) != 0)
{
changes.Add(QueryFilter.New(InvoiceProperty.DeliveryRun, FilterConditions.Equals, changed.DeliveryRun));
}
if (string.CompareOrdinal(original.RunPosition, changed.RunPosition) != 0)
{
changes.Add(QueryFilter.New(InvoiceProperty.RunPosition, FilterConditions.Equals, changed.RunPosition));
}
if (string.CompareOrdinal(original.ReturnedDeliveryData, changed.ReturnedDeliveryData) != 0)
{
changes.Add(QueryFilter.New(InvoiceProperty.ReturnedDeliveryData, FilterConditions.Equals, changed.ReturnedDeliveryData));
}
if (original.ConfirmedDeliveryTime != changed.ConfirmedDeliveryTime)
{
changes.Add(QueryFilter.New(InvoiceProperty.ConfirmedDeliveryTime, FilterConditions.Equals, changed.ConfirmedDeliveryTime));
}
if (string.CompareOrdinal(original.ConfirmedReceivedBy, changed.ConfirmedReceivedBy) != 0)
{
changes.Add(QueryFilter.New(InvoiceProperty.ConfirmedReceivedBy, FilterConditions.Equals, changed.ConfirmedReceivedBy));
}
if (original.LastEditedBy != changed.LastEditedBy)
{
changes.Add(QueryFilter.New(InvoiceProperty.LastEditedBy, FilterConditions.Equals, changed.LastEditedBy));
}
if (original.LastEditedWhen != changed.LastEditedWhen)
{
changes.Add(QueryFilter.New(InvoiceProperty.LastEditedWhen, FilterConditions.Equals, changed.LastEditedWhen));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of EmployeeProperty</returns>
public static QueryFilters <EmployeeProperty> GetChanges(Employee original, Employee changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <EmployeeProperty>(15);
#region Detect Changes
if (original.EmployeeId != changed.EmployeeId)
{
changes.Add(QueryFilter.New(EmployeeProperty.EmployeeId, FilterConditions.Equals, changed.EmployeeId));
}
if (string.CompareOrdinal(original.LastName, changed.LastName) != 0)
{
changes.Add(QueryFilter.New(EmployeeProperty.LastName, FilterConditions.Equals, changed.LastName));
}
if (string.CompareOrdinal(original.FirstName, changed.FirstName) != 0)
{
changes.Add(QueryFilter.New(EmployeeProperty.FirstName, FilterConditions.Equals, changed.FirstName));
}
if (string.CompareOrdinal(original.Title, changed.Title) != 0)
{
changes.Add(QueryFilter.New(EmployeeProperty.Title, FilterConditions.Equals, changed.Title));
}
if (original.ReportsTo != changed.ReportsTo)
{
changes.Add(QueryFilter.New(EmployeeProperty.ReportsTo, FilterConditions.Equals, changed.ReportsTo));
}
if (original.BirthDate != changed.BirthDate)
{
changes.Add(QueryFilter.New(EmployeeProperty.BirthDate, FilterConditions.Equals, changed.BirthDate));
}
if (original.HireDate != changed.HireDate)
{
changes.Add(QueryFilter.New(EmployeeProperty.HireDate, FilterConditions.Equals, changed.HireDate));
}
if (string.CompareOrdinal(original.Address, changed.Address) != 0)
{
changes.Add(QueryFilter.New(EmployeeProperty.Address, FilterConditions.Equals, changed.Address));
}
if (string.CompareOrdinal(original.City, changed.City) != 0)
{
changes.Add(QueryFilter.New(EmployeeProperty.City, FilterConditions.Equals, changed.City));
}
if (string.CompareOrdinal(original.State, changed.State) != 0)
{
changes.Add(QueryFilter.New(EmployeeProperty.State, FilterConditions.Equals, changed.State));
}
if (string.CompareOrdinal(original.Country, changed.Country) != 0)
{
changes.Add(QueryFilter.New(EmployeeProperty.Country, FilterConditions.Equals, changed.Country));
}
if (string.CompareOrdinal(original.PostalCode, changed.PostalCode) != 0)
{
changes.Add(QueryFilter.New(EmployeeProperty.PostalCode, FilterConditions.Equals, changed.PostalCode));
}
if (string.CompareOrdinal(original.Phone, changed.Phone) != 0)
{
changes.Add(QueryFilter.New(EmployeeProperty.Phone, FilterConditions.Equals, changed.Phone));
}
if (string.CompareOrdinal(original.Fax, changed.Fax) != 0)
{
changes.Add(QueryFilter.New(EmployeeProperty.Fax, FilterConditions.Equals, changed.Fax));
}
if (string.CompareOrdinal(original.Email, changed.Email) != 0)
{
changes.Add(QueryFilter.New(EmployeeProperty.Email, FilterConditions.Equals, changed.Email));
}
#endregion
return(changes.Count > 0 ? changes : null);
}
/// <summary>
/// Get a list of QueryFilter that represent changed fields.
/// </summary>
/// <param name="original">Original Entity. The unchanged entity.</param>
/// <param name="changed">Changed Entity. The entity holding the changed fields.</param>
/// <returns>QueryFilters of PurchaseOrderLineProperty</returns>
public static QueryFilters <PurchaseOrderLineProperty> GetChanges(PurchaseOrderLine original, PurchaseOrderLine changed)
{
// this method returns a list of changes.
var changes = new QueryFilters <PurchaseOrderLineProperty>(12);
#region Detect Changes
if (original.PurchaseOrderLineID != changed.PurchaseOrderLineID)
{
changes.Add(QueryFilter.New(PurchaseOrderLineProperty.PurchaseOrderLineID, FilterConditions.Equals, changed.PurchaseOrderLineID));
}
if (original.PurchaseOrderID != changed.PurchaseOrderID)
{
changes.Add(QueryFilter.New(PurchaseOrderLineProperty.PurchaseOrderID, FilterConditions.Equals, changed.PurchaseOrderID));
}
if (original.StockItemID != changed.StockItemID)
{
changes.Add(QueryFilter.New(PurchaseOrderLineProperty.StockItemID, FilterConditions.Equals, changed.StockItemID));
}
if (original.OrderedOuters != changed.OrderedOuters)
{
changes.Add(QueryFilter.New(PurchaseOrderLineProperty.OrderedOuters, FilterConditions.Equals, changed.OrderedOuters));
}
if (string.CompareOrdinal(original.Description, changed.Description) != 0)
{
changes.Add(QueryFilter.New(PurchaseOrderLineProperty.Description, FilterConditions.Equals, changed.Description));
}
if (original.ReceivedOuters != changed.ReceivedOuters)
{
changes.Add(QueryFilter.New(PurchaseOrderLineProperty.ReceivedOuters, FilterConditions.Equals, changed.ReceivedOuters));
}
if (original.PackageTypeID != changed.PackageTypeID)
{
changes.Add(QueryFilter.New(PurchaseOrderLineProperty.PackageTypeID, FilterConditions.Equals, changed.PackageTypeID));
}
if (original.ExpectedUnitPricePerOuter != changed.ExpectedUnitPricePerOuter)
{
changes.Add(QueryFilter.New(PurchaseOrderLineProperty.ExpectedUnitPricePerOuter, FilterConditions.Equals, changed.ExpectedUnitPricePerOuter));
}
if (original.LastReceiptDate != changed.LastReceiptDate)
{
changes.Add(QueryFilter.New(PurchaseOrderLineProperty.LastReceiptDate, FilterConditions.Equals, changed.LastReceiptDate));
}
if (original.IsOrderLineFinalized != changed.IsOrderLineFinalized)
{
changes.Add(QueryFilter.New(PurchaseOrderLineProperty.IsOrderLineFinalized, FilterConditions.Equals, changed.IsOrderLineFinalized));
}
if (original.LastEditedBy != changed.LastEditedBy)
{
changes.Add(QueryFilter.New(PurchaseOrderLineProperty.LastEditedBy, FilterConditions.Equals, changed.LastEditedBy));
}
if (original.LastEditedWhen != changed.LastEditedWhen)
{
changes.Add(QueryFilter.New(PurchaseOrderLineProperty.LastEditedWhen, FilterConditions.Equals, changed.LastEditedWhen));
}
#endregion
return(changes.Count > 0 ? changes : null);
}