/// <summary> /// This method populates the Senders and Receivers of a <see cref="IHeader"/> /// </summary> /// <param name="mappingStoreDb"> /// The <see cref="Database"/> instance for Mapping Store database /// </param> /// <param name="headerSysId"> /// The header system identifier. In the database the column HEADER.HEADER_ID /// </param> /// <param name="header"> /// The <see cref="IHeader"/> to be populated in terms of Senders and Receivers /// </param> private static void PoulateHeaderSendersAndReceivers(Database mappingStoreDb, long headerSysId, IHeader header) { string paramId = mappingStoreDb.BuildParameterName(ParameterNameConstants.IdParameter); var sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT PARTY.PARTY_ID, PARTY.ID, PARTY.HEADER_ID, PARTY.TYPE "); sqlCommand.Append("FROM PARTY "); sqlCommand.AppendFormat("WHERE PARTY.HEADER_ID = {0} ", paramId); using (DbCommand command = mappingStoreDb.GetSqlStringCommand(sqlCommand.ToString())) { mappingStoreDb.AddInParameter(command, ParameterNameConstants.IdParameter, DbType.Int64, headerSysId); using (IDataReader dataReader = mappingStoreDb.ExecuteReader(command)) { while (dataReader.Read()) { var id = DataReaderHelper.GetString(dataReader, "ID"); long partySysId = DataReaderHelper.GetInt64(dataReader, "PARTY_ID"); string partyType = DataReaderHelper.GetString(dataReader, "TYPE"); var names = new List <ITextTypeWrapper>(); PopulatePartyLocalisedStrings(mappingStoreDb, partySysId, names); var contacts = new List <IContact>(); PopulatePartyContacts(mappingStoreDb, partySysId, contacts); var party = new PartyCore(names, id, contacts, null); // is it a sender or a receiver? if (partyType.Equals(SenderText, StringComparison.OrdinalIgnoreCase)) { header.Sender = party; } else if (partyType.Equals(ReceiverText, StringComparison.OrdinalIgnoreCase)) { header.AddReciever(party); } } } } }
/// <summary> /// Populate the given headerbean object from the apllication settings /// </summary> /// <param name="header"> /// The headerBean to populate /// </param> public static void PopulateHeaderFromSettings(IHeader header) { header.Id = string.IsNullOrEmpty(HeaderSettings.Default.id) ? Resources.DefaultHeaderId : HeaderSettings.Default.id; header.Test = bool.Parse(HeaderSettings.Default.test); if (!string.IsNullOrEmpty(HeaderSettings.Default.name)) { header.AddName(new TextTypeWrapperImpl(HeaderSettings.Default.lang, HeaderSettings.Default.name, null)); } //TODO this propery has no setter - please add it // header.Prepared = DateTime.Now.ToString(Resources.SdmxHeaderPreparedDateTimeFormat, CultureInfo.InvariantCulture); IList <ITextTypeWrapper> textTypeWrapperSender = new List <ITextTypeWrapper>(); IContactMutableObject senderContact = new ContactMutableObjectCore(); if (!string.IsNullOrEmpty(HeaderSettings.Default.sendername)) { textTypeWrapperSender.Add(new TextTypeWrapperImpl(HeaderSettings.Default.lang, HeaderSettings.Default.sendername, null)); } if (!string.IsNullOrEmpty(HeaderSettings.Default.sendercontactname)) { senderContact.AddName(new TextTypeWrapperMutableCore(HeaderSettings.Default.lang, HeaderSettings.Default.sendercontactname)); if (!string.IsNullOrEmpty(HeaderSettings.Default.sendercontactdepartment)) { senderContact.AddDepartment(new TextTypeWrapperMutableCore(HeaderSettings.Default.lang, HeaderSettings.Default.sendercontactdepartment)); } if (!string.IsNullOrEmpty(HeaderSettings.Default.sendercontactrole)) { senderContact.AddRole(new TextTypeWrapperMutableCore(HeaderSettings.Default.lang, HeaderSettings.Default.sendercontactrole)); } if (!string.IsNullOrEmpty(HeaderSettings.Default.sendercontacttelephone)) { senderContact.AddTelephone(HeaderSettings.Default.sendercontacttelephone); } if (!string.IsNullOrEmpty(HeaderSettings.Default.sendercontactfax)) { senderContact.AddFax(HeaderSettings.Default.sendercontactfax); } if (!string.IsNullOrEmpty(HeaderSettings.Default.sendercontactx400)) { senderContact.AddX400(HeaderSettings.Default.sendercontactx400); } if (!string.IsNullOrEmpty(HeaderSettings.Default.sendercontacturi)) { senderContact.AddUri(HeaderSettings.Default.sendercontacturi); } if (!string.IsNullOrEmpty(HeaderSettings.Default.sendercontactemail)) { senderContact.AddEmail(HeaderSettings.Default.sendercontactemail); } } IContact contactImmutable = new ContactCore(senderContact); IList <IContact> contacts = new List <IContact>(); contacts.Add(contactImmutable); // SENDER var sender = new PartyCore(textTypeWrapperSender, HeaderSettings.Default.senderid, contacts, null); header.Sender = sender; IList <ITextTypeWrapper> textTypeWrapperReceiver = new List <ITextTypeWrapper>(); IContactMutableObject receiverContact = new ContactMutableObjectCore(); if (!string.IsNullOrEmpty(HeaderSettings.Default.receiverid)) { if (!string.IsNullOrEmpty(HeaderSettings.Default.receivername)) { textTypeWrapperReceiver.Add(new TextTypeWrapperImpl(HeaderSettings.Default.lang, HeaderSettings.Default.receivername, null)); } if (!string.IsNullOrEmpty(HeaderSettings.Default.receivercontactname)) { receiverContact.AddName(new TextTypeWrapperMutableCore(HeaderSettings.Default.lang, HeaderSettings.Default.receivercontactname)); if (!string.IsNullOrEmpty(HeaderSettings.Default.receivercontactdepartment)) { receiverContact.AddDepartment(new TextTypeWrapperMutableCore(HeaderSettings.Default.lang, HeaderSettings.Default.receivercontactdepartment)); } if (!string.IsNullOrEmpty(HeaderSettings.Default.receivercontactrole)) { receiverContact.AddRole(new TextTypeWrapperMutableCore(HeaderSettings.Default.lang, HeaderSettings.Default.receivercontactrole)); } if (!string.IsNullOrEmpty(HeaderSettings.Default.sendercontacttelephone)) { receiverContact.AddTelephone(HeaderSettings.Default.sendercontacttelephone); } if (!string.IsNullOrEmpty(HeaderSettings.Default.sendercontactfax)) { receiverContact.AddFax(HeaderSettings.Default.sendercontactfax); } if (!string.IsNullOrEmpty(HeaderSettings.Default.sendercontactx400)) { receiverContact.AddX400(HeaderSettings.Default.sendercontactx400); } if (!string.IsNullOrEmpty(HeaderSettings.Default.sendercontacturi)) { receiverContact.AddUri(HeaderSettings.Default.sendercontacturi); } if (!string.IsNullOrEmpty(HeaderSettings.Default.sendercontactemail)) { receiverContact.AddEmail(HeaderSettings.Default.sendercontactemail); } } // RECEIVER IContact contactImmutableReceiver = new ContactCore(receiverContact); IList <IContact> contactsReceiver = new List <IContact>(); contactsReceiver.Add(contactImmutableReceiver); IParty receiver = new PartyCore(textTypeWrapperReceiver, HeaderSettings.Default.receiverid, contactsReceiver, null); header.AddReciever(receiver); } if (!string.IsNullOrEmpty(HeaderSettings.Default.source)) { header.AddSource(new TextTypeWrapperImpl(HeaderSettings.Default.lang, HeaderSettings.Default.source, null)); } }
/// <summary> ///Create a Header /// </summary> private void InitialiseHeader() { try { IList <ITextTypeWrapper> name = new List <ITextTypeWrapper>(); name.Add(new TextTypeWrapperImpl(FindHeaderSetting("lang"), FindHeaderSetting("name"), null)); IList <ITextTypeWrapper> textTypeWrapperSender = new List <ITextTypeWrapper>(); textTypeWrapperSender.Add(new TextTypeWrapperImpl(FindHeaderSetting("lang"), FindHeaderSetting("sendername"), null)); IContactMutableObject senderContact = new ContactMutableObjectCore(); senderContact.AddName(new TextTypeWrapperMutableCore(FindHeaderSetting("lang"), FindHeaderSetting("sendercontactname"))); senderContact.AddDepartment(new TextTypeWrapperMutableCore(FindHeaderSetting("lang"), FindHeaderSetting("sendercontactdepartment"))); senderContact.AddRole(new TextTypeWrapperMutableCore(FindHeaderSetting("lang"), FindHeaderSetting("sendercontactrole"))); if (!string.IsNullOrEmpty(FindHeaderSetting("sendercontacttelephone"))) { senderContact.AddTelephone(FindHeaderSetting("sendercontacttelephone")); } if (!string.IsNullOrEmpty(FindHeaderSetting("sendercontactfax"))) { senderContact.AddFax(FindHeaderSetting("sendercontactfax")); } if (!string.IsNullOrEmpty(FindHeaderSetting("sendercontactx400"))) { senderContact.AddX400(FindHeaderSetting("sendercontactx400")); } if (!string.IsNullOrEmpty(FindHeaderSetting("sendercontacturi"))) { senderContact.AddUri(FindHeaderSetting("sendercontacturi")); } if (!string.IsNullOrEmpty(FindHeaderSetting("sendercontactemail"))) { senderContact.AddEmail(FindHeaderSetting("sendercontactemail")); } // SENDER IContact contactImmutableSender = new ContactCore(senderContact); IList <IContact> contactsSender = new List <IContact>(); contactsSender.Add(contactImmutableSender); IParty sender = new PartyCore(textTypeWrapperSender, FindHeaderSetting("senderid"), contactsSender, null); IList <ITextTypeWrapper> textTypeWrapperReceiver = new List <ITextTypeWrapper>(); textTypeWrapperReceiver.Add(new TextTypeWrapperImpl(FindHeaderSetting("lang"), FindHeaderSetting("receivername"), null)); IContactMutableObject receiverContact = new ContactMutableObjectCore(); receiverContact.AddName(new TextTypeWrapperMutableCore(FindHeaderSetting("lang"), FindHeaderSetting("receivercontactname"))); receiverContact.AddDepartment(new TextTypeWrapperMutableCore(FindHeaderSetting("lang"), FindHeaderSetting("receivercontactdepartment"))); receiverContact.AddRole(new TextTypeWrapperMutableCore(FindHeaderSetting("lang"), FindHeaderSetting("receivercontactrole"))); if (!string.IsNullOrEmpty(FindHeaderSetting("receivercontacttelephone"))) { receiverContact.AddTelephone(FindHeaderSetting("receivercontacttelephone")); } if (!string.IsNullOrEmpty(FindHeaderSetting("receivercontactfax"))) { receiverContact.AddFax(FindHeaderSetting("receivercontactfax")); } if (!string.IsNullOrEmpty(FindHeaderSetting("receivercontactx400"))) { receiverContact.AddX400(FindHeaderSetting("receivercontactx400")); } if (!string.IsNullOrEmpty(FindHeaderSetting("receivercontacturi"))) { receiverContact.AddUri(FindHeaderSetting("receivercontacturi")); } if (!string.IsNullOrEmpty(FindHeaderSetting("receivercontactemail"))) { receiverContact.AddEmail(FindHeaderSetting("receivercontactemail")); } // RECEIVER IContact contactImmutableReceiver = new ContactCore(receiverContact); IList <IContact> contactsReceiver = new List <IContact>(); contactsReceiver.Add(contactImmutableReceiver); IParty receiver = new PartyCore(textTypeWrapperReceiver, FindHeaderSetting("receiverid"), contactsReceiver, null); IList <IParty> receiverList = new List <IParty>(); receiverList.Add(receiver); IDictionary <string, string> additionalAttributes = new Dictionary <string, string>(); additionalAttributes.Add(NameTableCache.GetElementName(ElementNameTable.KeyFamilyRef), FindHeaderSetting("keyfamilyref")); additionalAttributes.Add(NameTableCache.GetElementName(ElementNameTable.KeyFamilyAgency), FindHeaderSetting("keyfamilyagency")); additionalAttributes.Add(NameTableCache.GetElementName(ElementNameTable.DataSetAgency), FindHeaderSetting("datasetagency")); DateTime extracted, prepared, reportingBegin, reportingEnd; bool isValid = DateTime.TryParse(FindHeaderSetting("extracted"), out extracted); if (!isValid) { extracted = DateTime.Now; } isValid = DateTime.TryParse(FindHeaderSetting("reportingbegin"), out reportingBegin); if (!isValid) { reportingBegin = DateTime.Now; } isValid = DateTime.TryParse(FindHeaderSetting("reportingend"), out reportingEnd); if (!isValid) { reportingEnd = DateTime.Now; } isValid = DateTime.TryParse(FindHeaderSetting("prepared"), out prepared); if (!isValid) { prepared = DateTime.Now; } IList <ITextTypeWrapper> source = new List <ITextTypeWrapper>(); if (!string.IsNullOrEmpty(FindHeaderSetting("source"))) { source.Add(new TextTypeWrapperImpl(FindHeaderSetting("lang"), FindHeaderSetting("source"), null)); } this._header = new HeaderImpl( additionalAttributes, null, null, DatasetAction.GetAction(FindHeaderSetting("datasetaction")), FindHeaderSetting("id"), FindHeaderSetting("datasetid"), null, extracted, prepared, reportingBegin, reportingEnd, name, source, receiverList, sender, bool.Parse(FindHeaderSetting("test"))); } catch (SdmxException) { throw; } catch (Exception ex) { throw new SdmxException(this, FlyExceptionObject.FlyExceptionTypeEnum.CreateHeader, ex); } }
/// <summary> /// This method initializes the log file name. /// The value for this property is configured in the web.config file in the "appSettings" section /// under the "logFileName" key. /// </summary> private void InitialiseHeader() { IList <ITextTypeWrapper> name = new List <ITextTypeWrapper>(); name.Add(new TextTypeWrapperImpl(HeaderSettings.Default.lang, HeaderSettings.Default.name, null)); IList <ITextTypeWrapper> textTypeWrapperSender = new List <ITextTypeWrapper>(); textTypeWrapperSender.Add(new TextTypeWrapperImpl(HeaderSettings.Default.lang, HeaderSettings.Default.sendername, null)); IContactMutableObject senderContact = new ContactMutableObjectCore(); senderContact.AddName(new TextTypeWrapperMutableCore(HeaderSettings.Default.lang, HeaderSettings.Default.sendercontactname)); senderContact.AddDepartment(new TextTypeWrapperMutableCore(HeaderSettings.Default.lang, HeaderSettings.Default.sendercontactdepartment)); senderContact.AddRole(new TextTypeWrapperMutableCore(HeaderSettings.Default.lang, HeaderSettings.Default.sendercontactrole)); if (!string.IsNullOrEmpty(HeaderSettings.Default.sendercontacttelephone)) { senderContact.AddTelephone(HeaderSettings.Default.sendercontacttelephone); } if (!string.IsNullOrEmpty(HeaderSettings.Default.sendercontactfax)) { senderContact.AddFax(HeaderSettings.Default.sendercontactfax); } if (!string.IsNullOrEmpty(HeaderSettings.Default.sendercontactx400)) { senderContact.AddX400(HeaderSettings.Default.sendercontactx400); } if (!string.IsNullOrEmpty(HeaderSettings.Default.sendercontacturi)) { senderContact.AddUri(HeaderSettings.Default.sendercontacturi); } if (!string.IsNullOrEmpty(HeaderSettings.Default.sendercontactemail)) { senderContact.AddEmail(HeaderSettings.Default.sendercontactemail); } // SENDER IContact contactImmutableSender = new ContactCore(senderContact); IList <IContact> contactsSender = new List <IContact>(); contactsSender.Add(contactImmutableSender); IParty sender = new PartyCore(textTypeWrapperSender, HeaderSettings.Default.senderid, contactsSender, null); IList <ITextTypeWrapper> textTypeWrapperReceiver = new List <ITextTypeWrapper>(); textTypeWrapperReceiver.Add(new TextTypeWrapperImpl(HeaderSettings.Default.lang, HeaderSettings.Default.receivername, null)); IContactMutableObject receiverContact = new ContactMutableObjectCore(); receiverContact.AddName(new TextTypeWrapperMutableCore(HeaderSettings.Default.lang, HeaderSettings.Default.receivercontactname)); receiverContact.AddDepartment(new TextTypeWrapperMutableCore(HeaderSettings.Default.lang, HeaderSettings.Default.receivercontactdepartment)); receiverContact.AddRole(new TextTypeWrapperMutableCore(HeaderSettings.Default.lang, HeaderSettings.Default.receivercontactrole)); if (!string.IsNullOrEmpty(HeaderSettings.Default.receivercontacttelephone)) { receiverContact.AddTelephone(HeaderSettings.Default.receivercontacttelephone); } if (!string.IsNullOrEmpty(HeaderSettings.Default.receivercontactfax)) { receiverContact.AddFax(HeaderSettings.Default.receivercontactfax); } if (!string.IsNullOrEmpty(HeaderSettings.Default.receivercontactx400)) { receiverContact.AddX400(HeaderSettings.Default.receivercontactx400); } if (!string.IsNullOrEmpty(HeaderSettings.Default.receivercontacturi)) { receiverContact.AddUri(HeaderSettings.Default.receivercontacturi); } if (!string.IsNullOrEmpty(HeaderSettings.Default.receivercontactemail)) { receiverContact.AddEmail(HeaderSettings.Default.receivercontactemail); } // RECEIVER IContact contactImmutableReceiver = new ContactCore(receiverContact); IList <IContact> contactsReceiver = new List <IContact>(); contactsReceiver.Add(contactImmutableReceiver); IParty receiver = new PartyCore(textTypeWrapperReceiver, HeaderSettings.Default.receiverid, contactsReceiver, null); IList <IParty> receiverList = new List <IParty>(); receiverList.Add(receiver); IDictionary <string, string> additionalAttributes = new Dictionary <string, string>(); additionalAttributes.Add(NameTableCache.GetElementName(ElementNameTable.KeyFamilyRef), HeaderSettings.Default.keyfamilyref); additionalAttributes.Add(NameTableCache.GetElementName(ElementNameTable.KeyFamilyAgency), HeaderSettings.Default.keyfamilyagency); additionalAttributes.Add(NameTableCache.GetElementName(ElementNameTable.DataSetAgency), HeaderSettings.Default.datasetagency); DateTime extracted, prepared, reportingBegin, reportingEnd; bool isValid = DateTime.TryParse(HeaderSettings.Default.extracted, out extracted); if (!isValid) { extracted = DateTime.Now; } isValid = DateTime.TryParse(HeaderSettings.Default.reportingbegin, out reportingBegin); if (!isValid) { reportingBegin = DateTime.Now; } isValid = DateTime.TryParse(HeaderSettings.Default.reportingend, out reportingEnd); if (!isValid) { reportingEnd = DateTime.Now; } isValid = DateTime.TryParse(HeaderSettings.Default.prepared, out prepared); if (!isValid) { prepared = DateTime.Now; } IList <ITextTypeWrapper> source = new List <ITextTypeWrapper>(); if (!string.IsNullOrEmpty(HeaderSettings.Default.source)) { source.Add(new TextTypeWrapperImpl(HeaderSettings.Default.lang, HeaderSettings.Default.source, null)); } this._header = new HeaderImpl( additionalAttributes, null, null, DatasetAction.GetAction(HeaderSettings.Default.datasetaction), HeaderSettings.Default.id, HeaderSettings.Default.datasetid, null, extracted, prepared, reportingBegin, reportingEnd, name, source, receiverList, sender, bool.Parse(HeaderSettings.Default.test)); }