protected void checkEmployerNames()
{
var today = DateTime.Now;
var personName = txtPersonName.Text;
//bool res = true;
var sameName = ObjectContext.EmployersViewLists.SingleOrDefault(entity => entity.Name == personName);
if (sameName != null)
{
int id = sameName.EmployerID;
X.Msg.Confirm("Message", "An employer record with the same name already exists in the list. Do you want to create another employer record with the same name?", new JFunction("Employer.AddSameEmployer(result, id);", "result")).Show();
}
else
{
Party party = new Party();
Person person = new Person();
Organization org = new Organization();
PersonName employerFName = new PersonName();
PersonName employerLName = new PersonName();
PersonName employerMName = new PersonName();
PersonName employerNiName = new PersonName();
PersonName employerNaName = new PersonName();
PersonName employerTName = new PersonName();
PersonName employerMMName = new PersonName();
if (this.txtEmployerPartyType.Text == "Person")
{
party.PartyType = PartyType.PersonType;
person.Party = party;
employerFName.Person = person;
employerFName.PersonNameType = PersonNameType.FirstNameType;
employerFName.Name = txtPersonFirstName.Text;
employerFName.EffectiveDate = today;
employerLName.Person = person;
employerLName.PersonNameType = PersonNameType.LastNameType;
employerLName.Name = txtPersonLastName.Text;
employerLName.EffectiveDate = today;
employerMMName.Person = person;
employerMMName.PersonNameType = PersonNameType.MothersMaidenNameType;
employerMMName.Name = txtPersonMothersMaidenName.Text;
employerMMName.EffectiveDate = today;
employerMName.Person = person;
employerMName.PersonNameType = PersonNameType.MiddleNameType;
employerMName.Name = txtPersonMiddleName.Text;
employerMName.EffectiveDate = today;
employerNaName.Person = person;
employerNaName.PersonNameType = PersonNameType.NameSuffixType;
employerNaName.Name = txtPersonNameSuffix.Text;
employerNaName.EffectiveDate = today;
employerNiName.Person = person;
employerNiName.PersonNameType = PersonNameType.NickNameType;
employerNiName.Name = txtPersonNickName.Text;
employerNiName.EffectiveDate = today;
}
else
{
party.PartyType = PartyType.OrganizationType;
org.OrganizationName = txtOrganizationName.Text;
org.Party = party;
}
PartyRole partyRole = new PartyRole();
partyRole.Party = party;
partyRole.PartyRoleType.RoleType = RoleType.EmployerType;
var res = Person.CheckEmployerName(partyRole);
if(res != null)
X.Msg.Confirm("Message", "A party record with the same name already exists. Do you want to use this record to create the new employer record?", new JFunction("Employer.AddSameName(result, res);", "result")).Show();
}
}
public int checkEmployerName()
{
var result = 0;
var today = DateTime.Now;
var personName = this.PersonName;
Party party = new Party();
Person person = new Person();
Organization org = new Organization();
PersonName employerFName = new PersonName();
PersonName employerLName = new PersonName();
PersonName employerMName = new PersonName();
PersonName employerNiName = new PersonName();
PersonName employerNaName = new PersonName();
PersonName employerTName = new PersonName();
PersonName employerMMName = new PersonName();
party.PartyType = PartyType.PersonType;
person.Party = party;
if (this.txtEmployerPartyType.Text == "Person")
{
party.PartyType = PartyType.PersonType;
person.Party = party;
employerFName.Person = person;
employerFName.PersonNameType = PersonNameType.FirstNameType;
employerFName.Name = txtPersonFirstName.Text;
employerFName.EffectiveDate = today;
employerLName.Person = person;
employerLName.PersonNameType = PersonNameType.LastNameType;
employerLName.Name = txtPersonLastName.Text;
employerLName.EffectiveDate = today;
employerMMName.Person = person;
employerMMName.PersonNameType = PersonNameType.MothersMaidenNameType;
employerMMName.Name = txtPersonMothersMaidenName.Text;
employerMMName.EffectiveDate = today;
employerMName.Person = person;
employerMName.PersonNameType = PersonNameType.MiddleNameType;
employerMName.Name = txtPersonMiddleName.Text;
employerMName.EffectiveDate = today;
employerNaName.Person = person;
employerNaName.PersonNameType = PersonNameType.NameSuffixType;
employerNaName.Name = txtPersonNameSuffix.Text;
employerNaName.EffectiveDate = today;
employerNiName.Person = person;
employerNiName.PersonNameType = PersonNameType.NickNameType;
employerNiName.Name = txtPersonNickName.Text;
employerNiName.EffectiveDate = today;
employerTName.Person = person;
employerTName.PersonNameType = PersonNameType.TitleType;
employerTName.Name = txtPersonTitle.Text;
employerTName.EffectiveDate = today;
}
else
{
party.PartyType = PartyType.OrganizationType;
org.OrganizationName = txtOrganizationName.Text;
org.Party = party;
}
PartyRole partyRole = new PartyRole();
partyRole.Party = party;
partyRole.RoleTypeId = RoleType.EmployerType.Id;
//bool res = true;
var sameName = Person.CheckEmployerPersonName(partyRole);
if (sameName != null)
{
int id = sameName.Id;
//X.Msg.Confirm("Message", "An employer record with the same name already exists in the list. Do you want to create another employer record with the same name?", new JFunction("Employer.AddSameEmployer(result, id);", "result")).Show();
this.hiddenID.Value = id;
result = 1;
}
else
{
var res = Person.CheckEmployerName(partyRole);
if (res != null)
{
//X.Msg.Confirm("Message", "A party record with the same name already exists. Do you want to use this record to create the new employer record?", new JFunction("Employer.AddSameName(result, res);", "result")).Show();
result = 2;
hiddenID.Value = res.Id;
hiddenExistingParty.Value = res.PartyId;
hiddenExistingPartyRole.Value = res.Id;
}
}
return result;
}
private Party CreateOrRetrieveParty(FinancialEntities ctx, DateTime today)
{
Party party;
int organizationTypeId = int.Parse(cmbOrganizationType.SelectedItem.Value.ToString());
if (string.IsNullOrWhiteSpace(HiddenPartyId.Text))
{
var partyType = ctx.PartyTypes.First(x => x.Name.Equals("Organization"));
party = new Party();
party.PartyTypeId = partyType.Id;
var roleType = ctx.RoleTypes.SingleOrDefault(entity => entity.Name.Equals("Lending Institution"));
PartyRole newPartyRole = new PartyRole();
newPartyRole.Party = party;
newPartyRole.PartyRoleType = roleType.PartyRoleType;
newPartyRole.EffectiveDate = today;
Organization organization = new Organization();
organization.Party = party;//
organization.OrganizationTypeId = organizationTypeId;
organization.OrganizationName = txtName.Text;
organization.DateEstablished = Convert.ToDateTime(dfDateEstablished.Text);
ctx.Parties.AddObject(party);
}
else
{
int partyId = int.Parse(HiddenPartyId.Text);
party = ctx.Parties.SingleOrDefault(entity => entity.Id == partyId);
Organization organization = party.Organization;
organization.OrganizationTypeId = organizationTypeId;
organization.OrganizationName = txtName.Text;
organization.DateEstablished = Convert.ToDateTime(dfDateEstablished.Text);
}
return party;
}
protected void btnSave_Click(object sender, DirectEventArgs e)
{
using (var context = new FinancialEntities())
{
var today = DateTime.Now;
Bank bank = new Bank();
Organization org = null;
Party party = null;
if (string.IsNullOrWhiteSpace(hiddenPartyId.Text) != false)
{
party = new Party();
org = new Organization();
org.Party = party;
org.OrganizationName = txtName.Text;
}
else
{
int partyId = Convert.ToInt32(hiddenPartyId.Text);
party = context.Parties.FirstOrDefault(entity => entity.Id == partyId);
org = context.Organizations.FirstOrDefault(entity => entity.PartyId == partyId);
org.OrganizationName = txtName.Text;
hiddenPartyId.Value = "";
}
BankStatu bankStatus = new BankStatu();
var bankRoleType = context.RoleTypes.SingleOrDefault(entity => entity.Name == RoleTypeEnums.Bank);
var orgPartyType = context.PartyTypes.SingleOrDefault(entity => entity.Name == PartyTypeEnums.Organization);
var bankStatusType = context.BankStatusTypes.SingleOrDefault(entity => entity.Name == BankStatusTypeEnum.Active);
InitialDatabaseValueChecker.ThrowIfNull<RoleType>(bankRoleType);
InitialDatabaseValueChecker.ThrowIfNull<PartyType>(orgPartyType);
InitialDatabaseValueChecker.ThrowIfNull<BankStatusType>(bankStatusType);
party.PartyType = orgPartyType;
PartyRole partyRole = new PartyRole();
partyRole.Party = party;
partyRole.PartyRoleType = bankRoleType.PartyRoleType;
partyRole.EffectiveDate = today;
bankStatus.BankStatusType = bankStatusType;
bankStatus.PartyRoleId = partyRole.Id;
bankStatus.EffectiveDate = today;
bank.Branch = this.txtBranch.Text;
if (string.IsNullOrWhiteSpace(this.txtAcronym.Text)) bank.Acronym = bank.PartyRole.Party.Organization.OrganizationName;
else bank.Acronym = this.txtAcronym.Text;
var addressType = context.AddressTypes.SingleOrDefault(entity => entity.Name == AddressTypeEnums.PostalAddress);
Address postalAdd = AddressBusinessUtility.AddAddress(party, addressType, today);
var postalAddressType = context.PostalAddressTypes.SingleOrDefault(entity => entity.Name == PostalAddressTypeEnums.BusinessAddress);
InitialDatabaseValueChecker.ThrowIfNull<PostalAddressType>(postalAddressType);
PostalAddress specificPostalAddress2 = AddressBusinessUtility.AddPostal(postalAdd, postalAddressType, true);
int countryId = int.Parse(cmbCountry.Value.ToString());
var country = context.Countries.FirstOrDefault(entity => entity.Id == countryId);
InitialDatabaseValueChecker.ThrowIfNull<Country>(country);
if(string.IsNullOrWhiteSpace(hiddenStreetName.Text)==false)specificPostalAddress2.StreetAddress = hiddenStreetName.Text;
specificPostalAddress2.Barangay = hiddenBarangay.Text;
specificPostalAddress2.PostalCode = hiddenPostalCode.Text;
specificPostalAddress2.Country = country;
if (string.IsNullOrWhiteSpace(hiddenCity.Text) == false) specificPostalAddress2.City = hiddenCity.Text;
if (string.IsNullOrWhiteSpace(hiddenMunicipality.Text) == false) specificPostalAddress2.Municipality = hiddenMunicipality.Text;
if (string.IsNullOrWhiteSpace(hiddenProvince.Text) == false) specificPostalAddress2.Province = hiddenProvince.Text;
var telAddressType = context.AddressTypes.SingleOrDefault(entity => entity.Name == AddressTypeEnums.TelecommunicationNumber);
if (string.IsNullOrWhiteSpace(txtAreaCode.Text) ==false)
{
Address telephoneAddress = AddressBusinessUtility.AddAddress(party, telAddressType, today);
var telType = context.TelecommunicationsNumberTypes.SingleOrDefault(entity => entity.Name == TelecommunicationsNumberTypeEnums.BusinessPhoneNumber);
TelecommunicationsNumber specificTelephoneAddress = AddressBusinessUtility.AddTelNum(telephoneAddress, telType, true);
specificTelephoneAddress.AreaCode = txtAreaCode.Text;
specificTelephoneAddress.PhoneNumber = txtPhoneNum.Text;
}
if (string.IsNullOrWhiteSpace(txtFaxAreaCode.Text)== false)
{
Address faxAddress = AddressBusinessUtility.AddAddress(party, telAddressType, today);
var faxType = context.TelecommunicationsNumberTypes.SingleOrDefault(entity => entity.Name == TelecommunicationsNumberTypeEnums.BusinessFaxNumber);
TelecommunicationsNumber specificTelephoneAddress1 = AddressBusinessUtility.AddTelNum(faxAddress, faxType, false);
specificTelephoneAddress1.AreaCode = txtFaxAreaCode.Text;
specificTelephoneAddress1.PhoneNumber = txtFaxNum.Text;
}
if (string.IsNullOrWhiteSpace(txtEmailAdd.Text) == false)
{
var emailAddType = context.AddressTypes.SingleOrDefault(entity => entity.Name == AddressTypeEnums.ElectronicAddress);
var emailType = context.ElectronicAddressTypes.SingleOrDefault(entity => entity.Name == ElectronicAddressTypeEnums.BusinessEmailAddress);
Address email = AddressBusinessUtility.AddAddress(party, emailAddType, today);
ElectronicAddress specificEmail = AddressBusinessUtility.AddEmail(email, emailType, true);
specificEmail.ElectronicAddressString = txtEmailAdd.Text;
}
context.Banks.AddObject(bank);
context.SaveChanges();
}
X.Msg.Alert("Message", "Bank record successfully created").Show();
}
private void SaveBasicOrganizationContactInformation()
{
var today = DateTime.Now;
//insert partyTypeId to Party
PartyType partyType = ObjectContext.PartyTypes.SingleOrDefault(entity => entity.Name == PartyTypeEnums.Organization);
Party party = new Party();
party.PartyType = partyType;
//insert organizationType, organizationName and dateEstablished to Organization
OrganizationType internalOrganization = ObjectContext.OrganizationTypes.SingleOrDefault(entity => entity.Name == OrganizationTypeEnums.Internal);
OrganizationType externalOrganization = ObjectContext.OrganizationTypes.SingleOrDefault(entity => entity.Name == OrganizationTypeEnums.External);
Organization organization = new Organization();
organization.OrganizationName = txtName.Text;
if (!string.IsNullOrWhiteSpace(cmbOrganizationType.SelectedItem.Text))
{
int organizationTypeId = int.Parse(cmbOrganizationType.Value.ToString());
var organizationType = ObjectContext.OrganizationTypes.SingleOrDefault(entity => entity.Id == organizationTypeId);
organization.OrganizationType = organizationType;
}
else
{
organization.OrganizationTypeId = null;
}
if (dtDateEstablished.SelectedValue != null)
organization.DateEstablished = dtDateEstablished.SelectedDate;
else
organization.DateEstablished = null;
//retirieve contactRoleType from Role Type where name = "Contact"
var contactRoleType = ObjectContext.RoleTypes.SingleOrDefault(entity => entity.Name == RoleTypeEnums.Contact);
//insert partyId, contactRoleType and effectiveDate to Party Role
PartyRole partyRole = new PartyRole();
partyRole.Party = party;
partyRole.PartyRoleType = contactRoleType.PartyRoleType;
partyRole.EffectiveDate = today;
//insert firstPartyRoleId, secondPartyRoleId and EffectiveDate to PartyRelationship
var contactRelationshipType = ObjectContext.PartyRelTypes.SingleOrDefault(entity => entity.Name == PartyRelationTypesEnums.ContactRelationship);
RoleType lendingInstitution = ObjectContext.RoleTypes.SingleOrDefault(entity => entity.Name == RoleTypeEnums.LendingInstitution);
PartyRole lendingInstitutionPartyRole = ObjectContext.PartyRoles.SingleOrDefault(entity => entity.RoleTypeId == lendingInstitution.Id);
PartyRelationship partyRelationship = new PartyRelationship();
partyRelationship.PartyRole = partyRole;
partyRelationship.PartyRole1 = lendingInstitutionPartyRole;
partyRelationship.PartyRelType = contactRelationshipType;
partyRelationship.EffectiveDate = today;
//retrieve postalAddressCategoryType from AddressType where name = "Postal Address"
var postalAddressCategoryType = ObjectContext.AddressTypes.SingleOrDefault(entity => entity.Name == AddressTypeEnums.PostalAddress);
//retrieve businessAddressCategory from Address where addressType = postalAddressCategoryType and name = "Business Address"
var primaryBusinessAddress = ObjectContext.PostalAddressTypes.SingleOrDefault(entity => entity.Name == PostalAddressTypeEnums.BusinessAddress);
//insert address
int countryId = int.Parse(cmbCountry.Value.ToString());
var country = ObjectContext.Countries.SingleOrDefault(entity => entity.Id == countryId);
AddressType addressType = AddressType.PostalAddressType;
PostalAddressType postalAddressType = PostalAddressType.BusinessAddressType;
//Create an Address with AddressType as Postal Address
PostalAddress newPostalAddress = new PostalAddress();
newPostalAddress.Country = country;
newPostalAddress.Barangay = hiddenBarangay.Text;
newPostalAddress.PostalCode = hiddenPostalCode.Text;
newPostalAddress.Province = hiddenProvince.Text;
newPostalAddress.City = hiddenCity.Text;
newPostalAddress.Municipality = hiddenMunicipality.Text;
newPostalAddress.StreetAddress = hiddenStreet.Text;
newPostalAddress.IsPrimary = true;
PostalAddress.CreateOrUpdatePostalAddress(party, newPostalAddress, postalAddressType, today, true);
//retrieve telecommunicationNumberType
if (!string.IsNullOrWhiteSpace(txtFaxNumber.Text))
{
TelecommunicationsNumber specificCellphoneNumber = TelecommunicationsNumber.CreateTelecommNumberAddress(party, TelecommunicationsNumberType.BusinessFaxNumberType, today);
specificCellphoneNumber.AreaCode = txtFaxAreaCode.Text;
specificCellphoneNumber.PhoneNumber = txtFaxNumber.Text;
specificCellphoneNumber.IsPrimary = true;
}
if (!string.IsNullOrWhiteSpace(txtTelephoneNumber.Text))
{
TelecommunicationsNumber specificTelephoneNumber = TelecommunicationsNumber.CreateTelecommNumberAddress(party, TelecommunicationsNumberType.BusinessPhoneNumberType, today);
specificTelephoneNumber.AreaCode = txtTelephoneAreaCode.Text;
specificTelephoneNumber.PhoneNumber = txtTelephoneNumber.Text;
specificTelephoneNumber.IsPrimary = true;
}
if (!string.IsNullOrWhiteSpace(txtEmailAddress.Text))
{
ElectronicAddress specificEmailAddress = ElectronicAddress.CreateElectronicAddress(party, ElectronicAddressType.BusinessEmailAddressType, today);
specificEmailAddress.ElectronicAddressString = txtEmailAddress.Text;
specificEmailAddress.IsPrimary = true;
}
ObjectContext.Parties.AddObject(party);
}