private DataTable ConvertToFilingDataTable(List <FilingRecord> records) { DataTable dtFilingData = DataAccessTypes.CreateFilingDataTable(); foreach (var r in records) { DataRow rowFilingData = dtFilingData.NewRow(); rowFilingData["Code"] = r.Code; if (r.Value != null) { rowFilingData["Value"] = (decimal)r.Value; } else { rowFilingData["Value"] = DBNull.Value; } if (r.Value_Str != null) { rowFilingData["Value_Str"] = r.Value_Str; } else { rowFilingData["Value_Str"] = DBNull.Value; } if (r.Value_Dttm != null) { rowFilingData["Value_Dttm"] = r.Value_Dttm; } else { rowFilingData["Value_Dttm"] = DBNull.Value; } rowFilingData["UnitName"] = r.Unit; rowFilingData["PeriodStart"] = r.PeriodStart != DateTime.MinValue ? r.PeriodStart : r.Instant; rowFilingData["PeriodEnd"] = r.PeriodEnd != DateTime.MinValue ? r.PeriodEnd : r.Instant; rowFilingData["SourceFactId"] = r.SourceFactId; rowFilingData["MultivalueFactId"] = r.FactId; dtFilingData.Rows.Add(rowFilingData); } return(dtFilingData); }
private DataTable ConverToMetadataTable(List <InsertFilingDetailsParams.FilingMetadaRecord> records) { DataTable dtMetadata = DataAccessTypes.CreateFilingMetadataTable(); foreach (var r in records) { DataRow rowMetadata = dtMetadata.NewRow(); rowMetadata["Name"] = r.Name; rowMetadata["Value"] = r.Value; rowMetadata["DataType"] = r.Type; dtMetadata.Rows.Add(rowMetadata); } return(dtMetadata); }