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