//
// List companies
//
public void loadMetadataList(int iUID)
{
elementSourceDataTable.Clear();
int rts = -1;
int cnt = 0;
var metaList = new ReportMetadataList();
if (string.IsNullOrEmpty(listType))
{
listType = "DEFAULT";
}
// List metadata for a client
if (listType == "CLIENT")
{
metaList.ListMetadataForClient(Utils.ClientID);
}
else
{
metaList.ListDefault();
}
foreach (ReportMetadata metadata in metaList.reportMetadataList)
{
DataRow elementRow = elementSourceDataTable.NewRow();
elementRow["UID"] = metadata.UID;
elementRow["RecordType"] = metadata.RecordType;
elementRow["FieldCode"] = metadata.FieldCode;
elementRow["Description"] = metadata.Description;
elementRow["ClientType"] = metadata.ClientType;
elementRow["ClientUID"] = metadata.ClientUID;
elementRow["InformationType"] = metadata.InformationType;
elementRow["Condition"] = metadata.Condition;
elementRow["CompareWith"] = metadata.CompareWith;
elementRow["Enabled"] = metadata.Enabled;
elementRow["UseAsLabel"] = metadata.UseAsLabel;
elementSourceDataTable.Rows.Add(elementRow);
if (metadata.UID == iUID)
{
rts = cnt;
}
cnt++;
}
if (rts >= 0)
{
dgvClientMetadata.Rows[rts].Selected = true;
}
}
private void loadList()
{
elementSourceDataTable.Rows.Clear();
dtAvailableMetadata.Rows.Clear();
// Load client metadata
ReportMetadataList rmd = new ReportMetadataList();
rmd.ListMetadataForClient(Utils.ClientID);
foreach (ReportMetadata metadata in rmd.reportMetadataList)
{
DataRow elementRow = elementSourceDataTable.NewRow();
elementRow["UID"] = metadata.UID;
elementRow["RecordType"] = metadata.RecordType;
elementRow["FieldCode"] = metadata.FieldCode;
elementRow["Description"] = metadata.Description;
elementRow["ClientType"] = metadata.ClientType;
elementRow["ClientUID"] = metadata.ClientUID;
elementRow["InformationType"] = metadata.InformationType;
elementRow["Condition"] = metadata.Condition;
elementRow["CompareWith"] = metadata.CompareWith;
elementSourceDataTable.Rows.Add(elementRow);
}
// Load available metadata
ReportMetadataList rmdavailable = new ReportMetadataList();
rmdavailable.ListAvailableForClient(Utils.ClientID);
foreach (ReportMetadata metadata in rmdavailable.reportMetadataList)
{
DataRow elementRow = dtAvailableMetadata.NewRow();
elementRow["UID"] = metadata.UID;
elementRow["RecordType"] = metadata.RecordType;
elementRow["FieldCode"] = metadata.FieldCode;
elementRow["Description"] = metadata.Description;
elementRow["ClientType"] = metadata.ClientType;
elementRow["ClientUID"] = metadata.ClientUID;
elementRow["InformationType"] = metadata.InformationType;
elementRow["Condition"] = metadata.Condition;
elementRow["CompareWith"] = metadata.CompareWith;
dtAvailableMetadata.Rows.Add(elementRow);
}
}
//
// List companies
//
public void loadMetadataList(int iUID)
{
elementSourceDataTable.Clear();
int rts = 0;
int cnt = 0;
var metaList = new ReportMetadataList(_userID);
metaList.List();
foreach (ReportMetadata metadata in metaList.reportMetadataList)
{
DataRow elementRow = elementSourceDataTable.NewRow();
elementRow["UID"] = metadata.UID;
elementRow["RecordType"] = metadata.RecordType;
elementRow["FieldCode"] = metadata.FieldCode;
elementRow["Description"] = metadata.Description;
elementRow["ClientType"] = metadata.ClientType;
elementRow["ClientUID"] = metadata.ClientUID;
elementRow["InformationType"] = metadata.InformationType;
elementRow["TableName"] = metadata.TableName;
elementRow["FieldName"] = metadata.FieldName;
elementRow["FilePath"] = metadata.FilePath;
elementRow["FileName"] = metadata.FileName;
elementSourceDataTable.Rows.Add(elementRow);
if (metadata.UID == iUID)
{
rts = cnt;
}
cnt++;
}
dgvClientMetadata.Rows[rts].Selected = true;
}
public WordReport(int ClientID, int ClientDocSetID, IOutputMessage UIoutput = null,
string OverrideDocuments = null)
{
row = 1;
// Set private attributes
clientID = ClientID;
clientDocSetID = ClientDocSetID;
uioutput = UIoutput;
// Instantiate Word
//
vkFalse = false;
vkWordApp = new Word.Application();
// Make it not visible
vkWordApp.Visible = false;
vkExcelApp = new Excel.Application();
// Make it not visible
vkExcelApp.Visible = false;
// Make it not visible
oApplication = new Application();
oApplication.Visible = false;
// Get Metadata for client
clientMetadata = new ReportMetadataList();
clientMetadata.ListMetadataForClient(clientID);
ts = new List <WordDocumentTasks.TagStructure>();
// Load variables/ metadata into memory
//
#region ClientMetadata
foreach (ReportMetadata metadata in clientMetadata.reportMetadataList)
{
// Retrieve value for the field selected
//
string value = metadata.GetValue();
// If the field is not enabled, the program has to replace the value with spaces.
//
var valueOfTag = metadata.Enabled == 'Y' ? value : string.Empty;
// When the field is an image and it is not enable, do not include the "No image" icon in the list
//
if (metadata.InformationType == MackkadoITFramework.Helper.Utils.InformationType.IMAGE && metadata.Enabled == 'N')
{
continue;
}
ts.Add(new WordDocumentTasks.TagStructure()
{
TagType = metadata.InformationType,
Tag = metadata.FieldCode,
TagValue = valueOfTag
});
}
#endregion ClientMetadata
// Get Client Document Set Details
// To get the source and destination folders
cds = new ClientDocumentSet();
cds.Get(clientID, clientDocSetID);
valueForProgressBar = 0;
startTime = System.DateTime.Now.ToString();
client = new Client();
ClientReadRequest crr = new ClientReadRequest();
crr.clientUID = clientID;
var response = BUSClient.ClientRead(crr);
client = response.client;
}
