public static PostalAddressType GetPropertyLocationAddressType(FinancialEntities context) { PostalAddressType propertyLocationAddressType = new PostalAddressType(); propertyLocationAddressType = context.PostalAddressTypes.SingleOrDefault(entity => entity.Name == PostalAddressTypeEnums.PropertyLocation); InitialDatabaseValueChecker.ThrowIfNull<PostalAddressType>(propertyLocationAddressType); return propertyLocationAddressType; }
public static PostalAddress GetCurrentPostalAddress(FinancialEntities context, Party party, PostalAddressType type, Func<Address, bool> condition) { Address address = party.Addresses.SingleOrDefault(entity => entity.EndDate == null && entity.PostalAddress.PostalAddressTypeId == type.Id && condition(entity)); if (address != null) return address.PostalAddress; return null; }
public static PostalAddressType GetHomeAddressType(FinancialEntities context) { PostalAddressType homeAddressType = new PostalAddressType(); homeAddressType = context.PostalAddressTypes.SingleOrDefault(entity => entity.Name == PostalAddressTypeEnums.HomeAddress); InitialDatabaseValueChecker.ThrowIfNull<PostalAddressType>(homeAddressType); return homeAddressType; }
public static PostalAddressType GetBirthPlaceAddressType(FinancialEntities context) { PostalAddressType birthplaceType = new PostalAddressType(); birthplaceType = context.PostalAddressTypes.SingleOrDefault(entity => entity.Name == PostalAddressTypeEnums.Birthplace); InitialDatabaseValueChecker.ThrowIfNull<PostalAddressType>(birthplaceType); return birthplaceType; }
public static PostalAddress GetCurrentPostalAddressV2(FinancialEntities context, Party party, PostalAddressType type, Func<PostalAddress, bool> condition) { PostalAddress postalAddress = context.PostalAddresses.SingleOrDefault(entity =>entity.Address.PartyId == party.Id && entity.Address.EndDate == null && entity.PostalAddressTypeId == type.Id && condition(entity)); //Address address = party.Addresses.SingleOrDefault(entity => entity.EndDate == null && entity.PostalAddress.PostalAddressTypeId == type.Id && condition(entity)); //if (address != null) // return address.PostalAddress; return postalAddress; }
public static PostalAddress AddPostal(Address address, PostalAddressType type, bool isPrimary) { PostalAddress postalAddress = new PostalAddress(); postalAddress.Address = address; postalAddress.PostalAddressType = type; postalAddress.IsPrimary = isPrimary; return postalAddress; }
public static PostalAddress CreatePostalAddress(FinancialEntities context, Party party, PostalAddressType type, DateTime now) { Address address = new Address(); address.Party = party; address.AddressType = AddressTypeEnums.GetPostalAddressType(context); address.EffectiveDate = now; PostalAddress postalAddress = new PostalAddress(); postalAddress.Address = address; postalAddress.PostalAddressType = type; return postalAddress; }
public static void CreateOrUpdatePostalAddress(Party party, PostalAddress newPostalAddress, PostalAddressType addressType, DateTime now, bool isPrimary) { var address = party.Addresses.SingleOrDefault(entity => entity.EndDate == null && entity.AddressTypeId == AddressType.PostalAddressType.Id && entity.PostalAddress.PostalAddressTypeId == addressType.Id && entity.PartyId == party.Id && entity.PostalAddress.IsPrimary == isPrimary); newPostalAddress.Barangay = string.IsNullOrWhiteSpace(newPostalAddress.Barangay) ? null : newPostalAddress.Barangay; newPostalAddress.StreetAddress = string.IsNullOrWhiteSpace(newPostalAddress.StreetAddress) ? null : newPostalAddress.StreetAddress; newPostalAddress.City = string.IsNullOrWhiteSpace(newPostalAddress.City) ? null : newPostalAddress.City; newPostalAddress.Municipality = string.IsNullOrWhiteSpace(newPostalAddress.Municipality) ? null : newPostalAddress.Municipality; newPostalAddress.PostalCode = string.IsNullOrWhiteSpace(newPostalAddress.PostalCode) ? null : newPostalAddress.PostalCode; newPostalAddress.Province = string.IsNullOrWhiteSpace(newPostalAddress.Province) ? null : newPostalAddress.Province; newPostalAddress.State = string.IsNullOrWhiteSpace(newPostalAddress.State) ? null : newPostalAddress.State; bool isNull = true; isNull &= newPostalAddress.Barangay == null; isNull &= newPostalAddress.City == null; isNull &= newPostalAddress.Municipality == null; isNull &= newPostalAddress.PostalCode == null; isNull &= newPostalAddress.Province == null; isNull &= (newPostalAddress.CountryId == null || newPostalAddress.CountryId == 0); if (isNull) { if (newPostalAddress.EntityState == System.Data.EntityState.Added) Context.Detach(newPostalAddress); return; } bool isEqual = false; if (address != null) { isEqual = true; var currentPostalAddress = address.PostalAddress; isEqual = isEqual && currentPostalAddress.Barangay == newPostalAddress.Barangay; isEqual = isEqual && currentPostalAddress.StreetAddress == newPostalAddress.StreetAddress; isEqual = isEqual && currentPostalAddress.CountryId == newPostalAddress.CountryId; isEqual = isEqual && currentPostalAddress.City == newPostalAddress.City; isEqual = isEqual && currentPostalAddress.Municipality == newPostalAddress.Municipality; isEqual = isEqual && currentPostalAddress.PostalCode == newPostalAddress.PostalCode; isEqual = isEqual && currentPostalAddress.Province == newPostalAddress.Province; isEqual = isEqual && currentPostalAddress.State == newPostalAddress.State; if (isEqual == false) address.EndDate = now; } if (isEqual == false) { Address newAddress = new Address(); newAddress.Party = party; newAddress.AddressType = AddressType.PostalAddressType; newAddress.EffectiveDate = now; newPostalAddress.Address = newAddress; newPostalAddress.PostalAddressType = addressType; Context.PostalAddresses.AddObject(newPostalAddress); } else { if (newPostalAddress.EntityState == System.Data.EntityState.Added) Context.Detach(newPostalAddress); } }
public static PostalAddress GetCurrentPostalAddressV2(Party party, PostalAddressType type, Func<PostalAddress, bool> condition) { PostalAddress postalAddress = Context.PostalAddresses.SingleOrDefault(entity => entity.Address.PartyId == party.Id && entity.Address.EndDate == null && entity.PostalAddressTypeId == type.Id && condition(entity)); return postalAddress; }
public static PostalAddress GetCurrentPostalAddress(Party party, PostalAddressType type, bool IsPrimaryPostalAddress) { Address address = party.Addresses.SingleOrDefault(entity => entity.EndDate == null && entity.AddressTypeId == AddressType.PostalAddressType.Id && entity.PostalAddress.PostalAddressTypeId == type.Id && entity.PostalAddress.IsPrimary == IsPrimaryPostalAddress); if (address != null) return address.PostalAddress; return null; }
public static PostalAddress GetCurrentPostalAddress(Party party, PostalAddressType type, Asset asset) { Address address = party.Addresses.SingleOrDefault(entity => entity.EndDate == null && entity.AddressTypeId == AddressType.PostalAddressType.Id && entity.PostalAddress.PostalAddressTypeId == type.Id && entity.AssetId == asset.Id); if (address != null) return address.PostalAddress; return null; }
public static PostalAddress CreatePostalAddress(Party party, PostalAddressType type, DateTime now) { Address address = new Address(); address.Party = party; address.AddressType = AddressType.PostalAddressType; address.EffectiveDate = now; PostalAddress postalAddress = new PostalAddress(); postalAddress.Address = address; postalAddress.PostalAddressType = type; return postalAddress; }
//New Postal Address protected void CreatePostalAddress(Address Address, PostalAddressType PostalAddressType, Country Country, string StreetAddress, string Barangay, string Municipality, string City, string Province, string State, string PostalCode) { PostalAddress NewPostalAddress = new PostalAddress(); NewPostalAddress.Address = Address; NewPostalAddress.PostalAddressType = PostalAddressType; NewPostalAddress.Country = Country; if (string.IsNullOrWhiteSpace(StreetAddress)) NewPostalAddress.StreetAddress = null; else NewPostalAddress.StreetAddress = StreetAddress; NewPostalAddress.Barangay = Barangay; if (string.IsNullOrWhiteSpace(Municipality)) NewPostalAddress.Municipality = null; else NewPostalAddress.Municipality = Municipality; if (string.IsNullOrWhiteSpace(City)) NewPostalAddress.City = null; else NewPostalAddress.City = City; if (string.IsNullOrWhiteSpace(Province)) NewPostalAddress.Province = null; else NewPostalAddress.Province = Province; if (string.IsNullOrWhiteSpace(State)) NewPostalAddress.State = null; else NewPostalAddress.State = State; NewPostalAddress.PostalCode = PostalCode; NewPostalAddress.IsPrimary = true; ObjectContext.PostalAddresses.AddObject(NewPostalAddress); }