/// <inheritdoc/> public string ToDelimitedString() { CultureInfo culture = CultureInfo.CurrentCulture; return(string.Format( culture, StringHelper.StringFormatSequence(0, 42, Configuration.FieldSeparator), Id, PrimaryKeyValueStf?.ToDelimitedString(), StaffIdentifierList != null ? string.Join(Configuration.FieldRepeatSeparator, StaffIdentifierList.Select(x => x.ToDelimitedString())) : null, StaffName != null ? string.Join(Configuration.FieldRepeatSeparator, StaffName.Select(x => x.ToDelimitedString())) : null, StaffType != null ? string.Join(Configuration.FieldRepeatSeparator, StaffType.Select(x => x.ToDelimitedString())) : null, AdministrativeSex?.ToDelimitedString(), DateTimeOfBirth.HasValue ? DateTimeOfBirth.Value.ToString(Consts.DateTimeFormatPrecisionSecond, culture) : null, ActiveInactiveFlag, Department != null ? string.Join(Configuration.FieldRepeatSeparator, Department.Select(x => x.ToDelimitedString())) : null, HospitalServiceStf != null ? string.Join(Configuration.FieldRepeatSeparator, HospitalServiceStf.Select(x => x.ToDelimitedString())) : null, Phone != null ? string.Join(Configuration.FieldRepeatSeparator, Phone.Select(x => x.ToDelimitedString())) : null, OfficeHomeAddressBirthplace != null ? string.Join(Configuration.FieldRepeatSeparator, OfficeHomeAddressBirthplace.Select(x => x.ToDelimitedString())) : null, InstitutionActivationDate != null ? string.Join(Configuration.FieldRepeatSeparator, InstitutionActivationDate.Select(x => x.ToDelimitedString())) : null, InstitutionInactivationDate != null ? string.Join(Configuration.FieldRepeatSeparator, InstitutionInactivationDate.Select(x => x.ToDelimitedString())) : null, BackupPersonId != null ? string.Join(Configuration.FieldRepeatSeparator, BackupPersonId.Select(x => x.ToDelimitedString())) : null, EmailAddress != null ? string.Join(Configuration.FieldRepeatSeparator, EmailAddress) : null, PreferredMethodOfContact?.ToDelimitedString(), MaritalStatus?.ToDelimitedString(), JobTitle, JobCodeClass?.ToDelimitedString(), EmploymentStatusCode?.ToDelimitedString(), AdditionalInsuredOnAuto, DriversLicenseNumberStaff?.ToDelimitedString(), CopyAutoIns, AutoInsExpires.HasValue ? AutoInsExpires.Value.ToString(Consts.DateFormatPrecisionDay, culture) : null, DateLastDmvReview.HasValue ? DateLastDmvReview.Value.ToString(Consts.DateFormatPrecisionDay, culture) : null, DateNextDmvReview.HasValue ? DateNextDmvReview.Value.ToString(Consts.DateFormatPrecisionDay, culture) : null, Race?.ToDelimitedString(), EthnicGroup?.ToDelimitedString(), ReactivationApprovalIndicator, Citizenship != null ? string.Join(Configuration.FieldRepeatSeparator, Citizenship.Select(x => x.ToDelimitedString())) : null, DateTimeOfDeath.HasValue ? DateTimeOfDeath.Value.ToString(Consts.DateTimeFormatPrecisionSecond, culture) : null, DeathIndicator, InstitutionRelationshipTypeCode?.ToDelimitedString(), InstitutionRelationshipPeriod?.ToDelimitedString(), ExpectedReturnDate.HasValue ? ExpectedReturnDate.Value.ToString(Consts.DateFormatPrecisionDay, culture) : null, CostCenterCode != null ? string.Join(Configuration.FieldRepeatSeparator, CostCenterCode.Select(x => x.ToDelimitedString())) : null, GenericClassificationIndicator, InactiveReasonCode?.ToDelimitedString(), GenericResourceTypeOrCategory != null ? string.Join(Configuration.FieldRepeatSeparator, GenericResourceTypeOrCategory.Select(x => x.ToDelimitedString())) : null, Religion?.ToDelimitedString(), Signature?.ToDelimitedString() ).TrimEnd(Configuration.FieldSeparator.ToCharArray())); }
public PartialViewResult Save(EthnicGroup model) { if (model.Id > 0) { var ethnicGroup = db.EthnicGroups.Where(i => i.Id == model.Id).FirstOrDefault(); ethnicGroup.Name = model.Name; ethnicGroup.NameFr = model.NameFr; ethnicGroup.IsActive = model.IsActive; db.SaveChanges(User.Identity.Name); } else { db.EthnicGroups.Add(model); db.SaveChanges(User.Identity.Name); } var result = db.EthnicGroups.ToList(); return(PartialView("_List", result)); }
private void InsUpdDelSetup(string value, char Event, int id) { var msg = ""; if ((value == "Dg") && (Event == 'I' || Event == 'U')) { var objDesignation = new Designation(id, txtDesignation.Text); msg = BL_Staff.InsUpdDelDesignation(Event, objDesignation, out id); } else if ((value == "Dp") && (Event == 'I' || Event == 'U')) { var objDepartment = new Department(id, txtDepartment.Text); msg = BL_Staff.InsUpdDelDepartment(Event, objDepartment, out id); } else if ((value == "Aq") && (Event == 'I' || Event == 'U')) { var objQualification = new AcedamicQualification(id, txtAcedamicQualification.Text); msg = BL_Staff.InsUpdDelAcedamicQualification(Event, objQualification, out id); } else if ((value == "St") && (Event == 'I' || Event == 'U')) { var objServiceType = new ServiceType(id, txtServiceType.Text); msg = BL_Staff.InsUpdDelService(Event, objServiceType, out id); } else if ((value == "Eg") && (Event == 'I' || Event == 'U')) { var objEthnicGroup = new EthnicGroup(id, txtEthnicGroup.Text, 1, "XX"); msg = BL_Staff.InsUpdDelEthnicGroup(Event, objEthnicGroup, out id); } if (DatabaseMessage.ContainMessage(msg)) { _msgbox.ShowSuccess(msg); } else { _msgbox.ShowWarning(msg); } // FillGridview(); // ClearAll(); }
public static string InsUpdDelEthnicGroup(char Event, EthnicGroup obj, out int returnId) { returnId = 0; try { var cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "USP_IUD_tbl_EthnicGroup"; cmd.Connection = DL_CCommon.ConnectionForCommonDb(); cmd.Parameters.AddWithValue("@EVENT", Event); cmd.Parameters.AddWithValue("@Id", obj.CatId); cmd.Parameters.AddWithValue("@CategoryName", obj.CategoryName); cmd.Parameters.AddWithValue("@parentid", 0); cmd.Parameters.AddWithValue("@Code", "XX"); var outparameter = new SqlParameter("@MSG", SqlDbType.NVarChar, 200) { Direction = ParameterDirection.Output }; cmd.Parameters.Add(outparameter); var outId = new SqlParameter("@RETURNOUTID", SqlDbType.NVarChar, 100) { Direction = ParameterDirection.Output }; cmd.Parameters.Add(outId); cmd.ExecuteNonQuery(); var msg = cmd.Parameters[outparameter.ParameterName].Value; returnId = Convert.ToInt32(cmd.Parameters[outId.ParameterName].Value); return(Convert.ToString(msg)); } catch (Exception ex) { throw new ArgumentException(ex.Message); } finally { DL_CCommon.ConnectionForCommonDb().Close(); } }
public Subject( int id, EthnicGroup eg, string oaID, char sex, DateTime?dob, DOBSource?dobSource, string ic, int?mother, int?father, string photo) { SubjectID = id; EthnicGroup = eg; OAHeLPID = oaID; Sex = sex; DOB = dob; DOBSource = dobSource; ICNumber = ic; MotherID = mother; FatherID = father; photoFileName = photo; }
/// <inheritdoc/> public string ToDelimitedString() { CultureInfo culture = CultureInfo.CurrentCulture; return(string.Format( culture, StringHelper.StringFormatSequence(0, 58, Configuration.FieldSeparator), Id, SetIdGt1.HasValue ? SetIdGt1.Value.ToString(culture) : null, GuarantorNumber != null ? string.Join(Configuration.FieldRepeatSeparator, GuarantorNumber.Select(x => x.ToDelimitedString())) : null, GuarantorName != null ? string.Join(Configuration.FieldRepeatSeparator, GuarantorName.Select(x => x.ToDelimitedString())) : null, GuarantorSpouseName != null ? string.Join(Configuration.FieldRepeatSeparator, GuarantorSpouseName.Select(x => x.ToDelimitedString())) : null, GuarantorAddress != null ? string.Join(Configuration.FieldRepeatSeparator, GuarantorAddress.Select(x => x.ToDelimitedString())) : null, GuarantorPhNumHome != null ? string.Join(Configuration.FieldRepeatSeparator, GuarantorPhNumHome.Select(x => x.ToDelimitedString())) : null, GuarantorPhNumBusiness != null ? string.Join(Configuration.FieldRepeatSeparator, GuarantorPhNumBusiness.Select(x => x.ToDelimitedString())) : null, GuarantorDateTimeOfBirth.HasValue ? GuarantorDateTimeOfBirth.Value.ToString(Consts.DateTimeFormatPrecisionSecond, culture) : null, GuarantorAdministrativeSex?.ToDelimitedString(), GuarantorType?.ToDelimitedString(), GuarantorRelationship?.ToDelimitedString(), GuarantorSsn, GuarantorDateBegin.HasValue ? GuarantorDateBegin.Value.ToString(Consts.DateFormatPrecisionDay, culture) : null, GuarantorDateEnd.HasValue ? GuarantorDateEnd.Value.ToString(Consts.DateFormatPrecisionDay, culture) : null, GuarantorPriority.HasValue ? GuarantorPriority.Value.ToString(Consts.NumericFormat, culture) : null, GuarantorEmployerName != null ? string.Join(Configuration.FieldRepeatSeparator, GuarantorEmployerName.Select(x => x.ToDelimitedString())) : null, GuarantorEmployerAddress != null ? string.Join(Configuration.FieldRepeatSeparator, GuarantorEmployerAddress.Select(x => x.ToDelimitedString())) : null, GuarantorEmployerPhoneNumber != null ? string.Join(Configuration.FieldRepeatSeparator, GuarantorEmployerPhoneNumber.Select(x => x.ToDelimitedString())) : null, GuarantorEmployeeIdNumber != null ? string.Join(Configuration.FieldRepeatSeparator, GuarantorEmployeeIdNumber.Select(x => x.ToDelimitedString())) : null, GuarantorEmploymentStatus?.ToDelimitedString(), GuarantorOrganizationName != null ? string.Join(Configuration.FieldRepeatSeparator, GuarantorOrganizationName.Select(x => x.ToDelimitedString())) : null, GuarantorBillingHoldFlag, GuarantorCreditRatingCode?.ToDelimitedString(), GuarantorDeathDateAndTime.HasValue ? GuarantorDeathDateAndTime.Value.ToString(Consts.DateTimeFormatPrecisionSecond, culture) : null, GuarantorDeathFlag, GuarantorChargeAdjustmentCode?.ToDelimitedString(), GuarantorHouseholdAnnualIncome?.ToDelimitedString(), GuarantorHouseholdSize.HasValue ? GuarantorHouseholdSize.Value.ToString(Consts.NumericFormat, culture) : null, GuarantorEmployerIdNumber != null ? string.Join(Configuration.FieldRepeatSeparator, GuarantorEmployerIdNumber.Select(x => x.ToDelimitedString())) : null, GuarantorMaritalStatusCode?.ToDelimitedString(), GuarantorHireEffectiveDate.HasValue ? GuarantorHireEffectiveDate.Value.ToString(Consts.DateFormatPrecisionDay, culture) : null, EmploymentStopDate.HasValue ? EmploymentStopDate.Value.ToString(Consts.DateFormatPrecisionDay, culture) : null, LivingDependency?.ToDelimitedString(), AmbulatoryStatus != null ? string.Join(Configuration.FieldRepeatSeparator, AmbulatoryStatus.Select(x => x.ToDelimitedString())) : null, Citizenship != null ? string.Join(Configuration.FieldRepeatSeparator, Citizenship.Select(x => x.ToDelimitedString())) : null, PrimaryLanguage?.ToDelimitedString(), LivingArrangement?.ToDelimitedString(), PublicityCode?.ToDelimitedString(), ProtectionIndicator, StudentIndicator?.ToDelimitedString(), Religion?.ToDelimitedString(), MothersMaidenName != null ? string.Join(Configuration.FieldRepeatSeparator, MothersMaidenName.Select(x => x.ToDelimitedString())) : null, Nationality?.ToDelimitedString(), EthnicGroup != null ? string.Join(Configuration.FieldRepeatSeparator, EthnicGroup.Select(x => x.ToDelimitedString())) : null, ContactPersonsName != null ? string.Join(Configuration.FieldRepeatSeparator, ContactPersonsName.Select(x => x.ToDelimitedString())) : null, ContactPersonsTelephoneNumber != null ? string.Join(Configuration.FieldRepeatSeparator, ContactPersonsTelephoneNumber.Select(x => x.ToDelimitedString())) : null, ContactReason?.ToDelimitedString(), ContactRelationship?.ToDelimitedString(), JobTitle, JobCodeClass?.ToDelimitedString(), GuarantorEmployersOrganizationName != null ? string.Join(Configuration.FieldRepeatSeparator, GuarantorEmployersOrganizationName.Select(x => x.ToDelimitedString())) : null, Handicap?.ToDelimitedString(), JobStatus?.ToDelimitedString(), GuarantorFinancialClass?.ToDelimitedString(), GuarantorRace != null ? string.Join(Configuration.FieldRepeatSeparator, GuarantorRace.Select(x => x.ToDelimitedString())) : null, GuarantorBirthPlace, VipIndicator?.ToDelimitedString() ).TrimEnd(Configuration.FieldSeparator.ToCharArray())); }
/// <inheritdoc/> public string ToDelimitedString() { CultureInfo culture = CultureInfo.CurrentCulture; return(string.Format( culture, StringHelper.StringFormatSequence(0, 73, Configuration.FieldSeparator), Id, InsuredsEmployeeId != null ? string.Join(Configuration.FieldRepeatSeparator, InsuredsEmployeeId.Select(x => x.ToDelimitedString())) : null, InsuredsSocialSecurityNumber, InsuredsEmployersNameAndId != null ? string.Join(Configuration.FieldRepeatSeparator, InsuredsEmployersNameAndId.Select(x => x.ToDelimitedString())) : null, EmployerInformationData?.ToDelimitedString(), MailClaimParty != null ? string.Join(Configuration.FieldRepeatSeparator, MailClaimParty.Select(x => x.ToDelimitedString())) : null, MedicareHealthInsCardNumber, MedicaidCaseName != null ? string.Join(Configuration.FieldRepeatSeparator, MedicaidCaseName.Select(x => x.ToDelimitedString())) : null, MedicaidCaseNumber, MilitarySponsorName != null ? string.Join(Configuration.FieldRepeatSeparator, MilitarySponsorName.Select(x => x.ToDelimitedString())) : null, MilitaryIdNumber, DependentOfMilitaryRecipient?.ToDelimitedString(), MilitaryOrganization, MilitaryStation, MilitaryService?.ToDelimitedString(), MilitaryRankGrade?.ToDelimitedString(), MilitaryStatus?.ToDelimitedString(), MilitaryRetireDate.HasValue ? MilitaryRetireDate.Value.ToString(Consts.DateFormatPrecisionDay, culture) : null, MilitaryNonAvailCertOnFile, BabyCoverage, CombineBabyBill, BloodDeductible, SpecialCoverageApprovalName != null ? string.Join(Configuration.FieldRepeatSeparator, SpecialCoverageApprovalName.Select(x => x.ToDelimitedString())) : null, SpecialCoverageApprovalTitle, NonCoveredInsuranceCode != null ? string.Join(Configuration.FieldRepeatSeparator, NonCoveredInsuranceCode.Select(x => x.ToDelimitedString())) : null, PayorId != null ? string.Join(Configuration.FieldRepeatSeparator, PayorId.Select(x => x.ToDelimitedString())) : null, PayorSubscriberId != null ? string.Join(Configuration.FieldRepeatSeparator, PayorSubscriberId.Select(x => x.ToDelimitedString())) : null, EligibilitySource?.ToDelimitedString(), RoomCoverageTypeAmount != null ? string.Join(Configuration.FieldRepeatSeparator, RoomCoverageTypeAmount.Select(x => x.ToDelimitedString())) : null, PolicyTypeAmount != null ? string.Join(Configuration.FieldRepeatSeparator, PolicyTypeAmount.Select(x => x.ToDelimitedString())) : null, DailyDeductible?.ToDelimitedString(), LivingDependency?.ToDelimitedString(), AmbulatoryStatus != null ? string.Join(Configuration.FieldRepeatSeparator, AmbulatoryStatus.Select(x => x.ToDelimitedString())) : null, Citizenship != null ? string.Join(Configuration.FieldRepeatSeparator, Citizenship.Select(x => x.ToDelimitedString())) : null, PrimaryLanguage?.ToDelimitedString(), LivingArrangement?.ToDelimitedString(), PublicityCode?.ToDelimitedString(), ProtectionIndicator, StudentIndicator?.ToDelimitedString(), Religion?.ToDelimitedString(), MothersMaidenName != null ? string.Join(Configuration.FieldRepeatSeparator, MothersMaidenName.Select(x => x.ToDelimitedString())) : null, Nationality?.ToDelimitedString(), EthnicGroup != null ? string.Join(Configuration.FieldRepeatSeparator, EthnicGroup.Select(x => x.ToDelimitedString())) : null, MaritalStatus != null ? string.Join(Configuration.FieldRepeatSeparator, MaritalStatus.Select(x => x.ToDelimitedString())) : null, InsuredsEmploymentStartDate.HasValue ? InsuredsEmploymentStartDate.Value.ToString(Consts.DateFormatPrecisionDay, culture) : null, EmploymentStopDate.HasValue ? EmploymentStopDate.Value.ToString(Consts.DateFormatPrecisionDay, culture) : null, JobTitle, JobCodeClass?.ToDelimitedString(), JobStatus?.ToDelimitedString(), EmployerContactPersonName != null ? string.Join(Configuration.FieldRepeatSeparator, EmployerContactPersonName.Select(x => x.ToDelimitedString())) : null, EmployerContactPersonPhoneNumber != null ? string.Join(Configuration.FieldRepeatSeparator, EmployerContactPersonPhoneNumber.Select(x => x.ToDelimitedString())) : null, EmployerContactReason?.ToDelimitedString(), InsuredsContactPersonsName != null ? string.Join(Configuration.FieldRepeatSeparator, InsuredsContactPersonsName.Select(x => x.ToDelimitedString())) : null, InsuredsContactPersonPhoneNumber != null ? string.Join(Configuration.FieldRepeatSeparator, InsuredsContactPersonPhoneNumber.Select(x => x.ToDelimitedString())) : null, InsuredsContactPersonReason != null ? string.Join(Configuration.FieldRepeatSeparator, InsuredsContactPersonReason.Select(x => x.ToDelimitedString())) : null, RelationshipToThePatientStartDate.HasValue ? RelationshipToThePatientStartDate.Value.ToString(Consts.DateFormatPrecisionDay, culture) : null, RelationshipToThePatientStopDate != null ? string.Join(Configuration.FieldRepeatSeparator, RelationshipToThePatientStopDate.Select(x => x.ToString(Consts.DateFormatPrecisionDay, culture))) : null, InsuranceCoContactReason?.ToDelimitedString(), InsuranceCoContactPhoneNumber != null ? string.Join(Configuration.FieldRepeatSeparator, InsuranceCoContactPhoneNumber.Select(x => x.ToDelimitedString())) : null, PolicyScope?.ToDelimitedString(), PolicySource?.ToDelimitedString(), PatientMemberNumber?.ToDelimitedString(), GuarantorsRelationshipToInsured?.ToDelimitedString(), InsuredsPhoneNumberHome != null ? string.Join(Configuration.FieldRepeatSeparator, InsuredsPhoneNumberHome.Select(x => x.ToDelimitedString())) : null, InsuredsEmployerPhoneNumber != null ? string.Join(Configuration.FieldRepeatSeparator, InsuredsEmployerPhoneNumber.Select(x => x.ToDelimitedString())) : null, MilitaryHandicappedProgram?.ToDelimitedString(), SuspendFlag, CopayLimitFlag, StoplossLimitFlag, InsuredOrganizationNameAndId != null ? string.Join(Configuration.FieldRepeatSeparator, InsuredOrganizationNameAndId.Select(x => x.ToDelimitedString())) : null, InsuredEmployerOrganizationNameAndId != null ? string.Join(Configuration.FieldRepeatSeparator, InsuredEmployerOrganizationNameAndId.Select(x => x.ToDelimitedString())) : null, Race != null ? string.Join(Configuration.FieldRepeatSeparator, Race.Select(x => x.ToDelimitedString())) : null, PatientsRelationshipToInsured?.ToDelimitedString() ).TrimEnd(Configuration.FieldSeparator.ToCharArray())); }
/// <inheritdoc/> public string ToDelimitedString() { CultureInfo culture = CultureInfo.CurrentCulture; return(string.Format( culture, StringHelper.StringFormatSequence(0, 31, Configuration.FieldSeparator), Id, SetIdPid.HasValue ? SetIdPid.Value.ToString(culture) : null, PatientId?.ToDelimitedString(), PatientIdentifierList != null ? string.Join(Configuration.FieldRepeatSeparator, PatientIdentifierList.Select(x => x.ToDelimitedString())) : null, AlternatePatientIdPid != null ? string.Join(Configuration.FieldRepeatSeparator, AlternatePatientIdPid.Select(x => x.ToDelimitedString())) : null, PatientName != null ? string.Join(Configuration.FieldRepeatSeparator, PatientName.Select(x => x.ToDelimitedString())) : null, MothersMaidenName != null ? string.Join(Configuration.FieldRepeatSeparator, MothersMaidenName.Select(x => x.ToDelimitedString())) : null, DateTimeOfBirth.HasValue ? DateTimeOfBirth.Value.ToString(Consts.DateTimeFormatPrecisionSecond, culture) : null, AdministrativeSex, PatientAlias != null ? string.Join(Configuration.FieldRepeatSeparator, PatientAlias.Select(x => x.ToDelimitedString())) : null, Race != null ? string.Join(Configuration.FieldRepeatSeparator, Race.Select(x => x.ToDelimitedString())) : null, PatientAddress != null ? string.Join(Configuration.FieldRepeatSeparator, PatientAddress.Select(x => x.ToDelimitedString())) : null, CountyCode, PhoneNumberHome != null ? string.Join(Configuration.FieldRepeatSeparator, PhoneNumberHome.Select(x => x.ToDelimitedString())) : null, PhoneNumberBusiness != null ? string.Join(Configuration.FieldRepeatSeparator, PhoneNumberBusiness.Select(x => x.ToDelimitedString())) : null, PrimaryLanguage?.ToDelimitedString(), MaritalStatus?.ToDelimitedString(), Religion?.ToDelimitedString(), PatientAccountNumber?.ToDelimitedString(), SsnNumberPatient, DriversLicenseNumberPatient?.ToDelimitedString(), MothersIdentifier != null ? string.Join(Configuration.FieldRepeatSeparator, MothersIdentifier.Select(x => x.ToDelimitedString())) : null, EthnicGroup != null ? string.Join(Configuration.FieldRepeatSeparator, EthnicGroup.Select(x => x.ToDelimitedString())) : null, BirthPlace, MultipleBirthIndicator, BirthOrder.HasValue ? BirthOrder.Value.ToString(Consts.NumericFormat, culture) : null, Citizenship != null ? string.Join(Configuration.FieldRepeatSeparator, Citizenship.Select(x => x.ToDelimitedString())) : null, VeteransMilitaryStatus?.ToDelimitedString(), Nationality?.ToDelimitedString(), PatientDeathDateAndTime.HasValue ? PatientDeathDateAndTime.Value.ToString(Consts.DateTimeFormatPrecisionSecond, culture) : null, PatientDeathIndicator ).TrimEnd(Configuration.FieldSeparator.ToCharArray())); }
/// <inheritdoc/> public string ToDelimitedString() { CultureInfo culture = CultureInfo.CurrentCulture; return(string.Format( culture, StringHelper.StringFormatSequence(0, 42, Configuration.FieldSeparator), Id, SetIdNk1.HasValue ? SetIdNk1.Value.ToString(culture) : null, Name != null ? string.Join(Configuration.FieldRepeatSeparator, Name.Select(x => x.ToDelimitedString())) : null, Relationship?.ToDelimitedString(), Address != null ? string.Join(Configuration.FieldRepeatSeparator, Address.Select(x => x.ToDelimitedString())) : null, PhoneNumber != null ? string.Join(Configuration.FieldRepeatSeparator, PhoneNumber.Select(x => x.ToDelimitedString())) : null, BusinessPhoneNumber != null ? string.Join(Configuration.FieldRepeatSeparator, BusinessPhoneNumber.Select(x => x.ToDelimitedString())) : null, ContactRole?.ToDelimitedString(), StartDate.HasValue ? StartDate.Value.ToString(Consts.DateFormatPrecisionDay, culture) : null, EndDate.HasValue ? EndDate.Value.ToString(Consts.DateFormatPrecisionDay, culture) : null, NextOfKinAssociatedPartiesJobTitle, NextOfKinAssociatedPartiesJobCodeClass?.ToDelimitedString(), NextOfKinAssociatedPartiesEmployeeNumber?.ToDelimitedString(), OrganizationNameNk1 != null ? string.Join(Configuration.FieldRepeatSeparator, OrganizationNameNk1.Select(x => x.ToDelimitedString())) : null, MaritalStatus?.ToDelimitedString(), AdministrativeSex?.ToDelimitedString(), DateTimeOfBirth.HasValue ? DateTimeOfBirth.Value.ToString(Consts.DateTimeFormatPrecisionSecond, culture) : null, LivingDependency != null ? string.Join(Configuration.FieldRepeatSeparator, LivingDependency.Select(x => x.ToDelimitedString())) : null, AmbulatoryStatus != null ? string.Join(Configuration.FieldRepeatSeparator, AmbulatoryStatus.Select(x => x.ToDelimitedString())) : null, Citizenship != null ? string.Join(Configuration.FieldRepeatSeparator, Citizenship.Select(x => x.ToDelimitedString())) : null, PrimaryLanguage?.ToDelimitedString(), LivingArrangement?.ToDelimitedString(), PublicityCode?.ToDelimitedString(), ProtectionIndicator, StudentIndicator?.ToDelimitedString(), Religion?.ToDelimitedString(), MothersMaidenName != null ? string.Join(Configuration.FieldRepeatSeparator, MothersMaidenName.Select(x => x.ToDelimitedString())) : null, Nationality?.ToDelimitedString(), EthnicGroup != null ? string.Join(Configuration.FieldRepeatSeparator, EthnicGroup.Select(x => x.ToDelimitedString())) : null, ContactReason != null ? string.Join(Configuration.FieldRepeatSeparator, ContactReason.Select(x => x.ToDelimitedString())) : null, ContactPersonsName != null ? string.Join(Configuration.FieldRepeatSeparator, ContactPersonsName.Select(x => x.ToDelimitedString())) : null, ContactPersonsTelephoneNumber != null ? string.Join(Configuration.FieldRepeatSeparator, ContactPersonsTelephoneNumber.Select(x => x.ToDelimitedString())) : null, ContactPersonsAddress != null ? string.Join(Configuration.FieldRepeatSeparator, ContactPersonsAddress.Select(x => x.ToDelimitedString())) : null, NextOfKinAssociatedPartysIdentifiers != null ? string.Join(Configuration.FieldRepeatSeparator, NextOfKinAssociatedPartysIdentifiers.Select(x => x.ToDelimitedString())) : null, JobStatus?.ToDelimitedString(), Race != null ? string.Join(Configuration.FieldRepeatSeparator, Race.Select(x => x.ToDelimitedString())) : null, Handicap?.ToDelimitedString(), ContactPersonSocialSecurityNumber, NextOfKinBirthPlace, VipIndicator?.ToDelimitedString(), NextOfKinTelecommunicationInformation?.ToDelimitedString(), ContactPersonsTelecommunicationInformation?.ToDelimitedString() ).TrimEnd(Configuration.FieldSeparator.ToCharArray())); }
public static string InsUpdDelEthnicGroup(char Event, EthnicGroup obj, out int id) { id = 0; return(DlStaffinfo.InsUpdDelEthnicGroup(Event, obj, out id)); }