public override global::System.Data.DataTable Clone() { ListDataTable cln = ((ListDataTable)(base.Clone())); cln.InitVars(); return(cln); }
public void ProcessInboundAumFile() { try { using (var reader = new StreamReader(_path)) using (var csv = new CsvReader(reader)) { //Truncate inbound sales staging file var dal = new DapperDatabaseAccess <GenevaAumInbound>(_connectionString); dal.SqlExecute("dbo.prc_tbl_GenevaAum_Staging_Truncate", null); //Ingest sales into staging table List <GenevaAumInbound> inboundSales = csv.GetRecords <GenevaAumInbound>().ToList(); DbHandlers.BulkInsertToDatabase(ListDataTable.ListToDataTable(inboundSales), _connectionString, 1000, _metaData.stagingTable); //Transform from staging to production var parms = new DynamicParameters(); parms.Add("@ReportEndDate", _reportingDate); dal.SqlExecute("dbo.prc_GenevaAum_Transform", parms); } } catch (Exception e) { Console.WriteLine(e); throw; } }
private void InitClass() { this.DataSetName = "list"; this.Prefix = ""; this.Namespace = "http://tempuri.org/list.xsd"; this.EnforceConstraints = true; this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema; this.tableList = new ListDataTable(); base.Tables.Add(this.tableList); }
internal void InitVars(bool initTable) { this.tableList = ((ListDataTable)(base.Tables["List"])); if ((initTable == true)) { if ((this.tableList != null)) { this.tableList.InitVars(); } } }
internal ListRow(global::System.Data.DataRowBuilder rb) : base(rb) { this.tableList = ((ListDataTable)(this.Table)); }