/// <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); }