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