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