public void Init()
{
_tReader = new TigerDataReader();
_iReader = _tReader;
}
private void LoadSql(string category, string uniqueFilename, string connectionString)
{
List <MCSystemParameter> spList = new List <MCSystemParameter>(SystemParameterRepository.GetAll());
int ConsFileKeyColumn = Convert.ToInt32(spList.Find(x => x.Name == "ConsFileKeyColumn").ParameterValue);
int ConsFileNameColumn = Convert.ToInt32(spList.Find(x => x.Name == "ConsFileNameColumn").ParameterValue);
int WardFileKeyColumn = Convert.ToInt32(spList.Find(x => x.Name == "WardFileKeyColumn").ParameterValue);
int WardFileNameColumn = Convert.ToInt32(spList.Find(x => x.Name == "WardFileNameColumn").ParameterValue);
int LAFileKeyColumn = Convert.ToInt32(spList.Find(x => x.Name == "LAFileKeyColumn").ParameterValue);
int LAFileNameColumn = Convert.ToInt32(spList.Find(x => x.Name == "LAFileNameColumn").ParameterValue);
int LEAFileKeyColumn = Convert.ToInt32(spList.Find(x => x.Name == "LEAFileKeyColumn").ParameterValue);
int LEAFileNameColumn = Convert.ToInt32(spList.Find(x => x.Name == "LEAFileNameColumn").ParameterValue);
int RegionFileKeyColumn = Convert.ToInt32(spList.Find(x => x.Name == "RegionFileKeyColumn").ParameterValue);
int RegionFileNameColumn = Convert.ToInt32(spList.Find(x => x.Name == "RegionFileNameColumn").ParameterValue);
int CountyFileKeyColumn = Convert.ToInt32(spList.Find(x => x.Name == "CountyFileKeyColumn").ParameterValue);
int CountyFileNameColumn = Convert.ToInt32(spList.Find(x => x.Name == "CountyFileNameColumn").ParameterValue);
int PostCode7Column = Convert.ToInt32(spList.Find(x => x.Name == "PostCode7Column").ParameterValue);
int PostCode8Column = Convert.ToInt32(spList.Find(x => x.Name == "PostCode8Column").ParameterValue);
int PostCodeCountyColumn = Convert.ToInt32(spList.Find(x => x.Name == "PostCodeCountyColumn").ParameterValue);
int PostCodeLAColumn = Convert.ToInt32(spList.Find(x => x.Name == "PostCodeLAColumn").ParameterValue);
int PostCodeWardColumn = Convert.ToInt32(spList.Find(x => x.Name == "PostCodeWardColumn").ParameterValue);
int PostCodeRegionColumn = Convert.ToInt32(spList.Find(x => x.Name == "PostCodeRegionColumn").ParameterValue);
int PostCodeConsColumn = Convert.ToInt32(spList.Find(x => x.Name == "PostCodeConsColumn").ParameterValue);
int PostCodeLEAColumn = Convert.ToInt32(spList.Find(x => x.Name == "PostCodeLEAColumn").ParameterValue);
int PostCodeEastingColumn = Convert.ToInt32(spList.Find(x => x.Name == "PostCodeEastingColumn").ParameterValue);
int PostCodeNorthingColumn = Convert.ToInt32(spList.Find(x => x.Name == "PostCodeNorthingColumn").ParameterValue);
reader = null;
SqlBulkCopy Copier = new SqlBulkCopy(connectionString);
string prefix = @"c:\MyUploads\";
switch (category)
{
//case "LEA":
// CurrentStep = this["BulkUploadLEA"];
// Copier.DestinationTableName = "dbo.ImportLookUp";
// reader = new LookUpDataReader(category,uniqueFilename,0,1);
// break;
//case "LA":
// CurrentStep = this["BulkUploadLA"];
// Copier.DestinationTableName = "dbo.ImportLookUp";
// reader = new LookUpDataReader(category,uniqueFilename,0,2);
// break;
//case "Ward":
// CurrentStep = this["BulkUploadWARD"];
// Copier.DestinationTableName = "dbo.ImportLookUp";
// reader = new LookUpDataReader(category,uniqueFilename,0,2);
// break;
//case "Constituency":
// CurrentStep = this["BulkUploadWPC"];
// Copier.DestinationTableName = "dbo.ImportLookUp";
// reader = new LookUpDataReader(category,uniqueFilename,0,2);
// break;
//case "Region":
// CurrentStep = this["BulkUploadRegion"];
// Copier.DestinationTableName = "dbo.ImportLookUp";
// reader = new LookUpDataReader(category,uniqueFilename,0,2);
// break;
//case "County":
// CurrentStep = this["BulkUploadCty"];
// Copier.DestinationTableName = "dbo.ImportLookUp";
// reader = new LookUpDataReader(category,uniqueFilename,0,2);
// break;
case "PostCode":
CurrentStep = this["BulkUploadPC"];
Copier.DestinationTableName = "dbo.ImportPostCode";
reader = new PostCodeDataReader(category, uniqueFilename, PostCodeLEAColumn, PostCodeWardColumn, PostCodeRegionColumn, PostCodeConsColumn,
PostCodeLAColumn, PostCodeCountyColumn, PostCode7Column, PostCode8Column, PostCodeEastingColumn, PostCodeNorthingColumn,
prefix + _uniqueFilename[1], LAFileKeyColumn, LAFileNameColumn, //LA
prefix + _uniqueFilename[3], LEAFileKeyColumn, LEAFileNameColumn, //LEA
prefix + _uniqueFilename[2], CountyFileKeyColumn, CountyFileNameColumn, //County
prefix + _uniqueFilename[5], WardFileKeyColumn, WardFileNameColumn, //Ward
prefix + _uniqueFilename[4], RegionFileKeyColumn, RegionFileNameColumn, //Region
prefix + _uniqueFilename[0], ConsFileKeyColumn, ConsFileNameColumn //Constituency
);
break;
}
CurrentStep.Start();
CurrentStep.UpdateProgress(0, "Bulk uploading");
Copier.BatchSize = 5000;
Copier.NotifyAfter = 1000;
Copier.BulkCopyTimeout = 60;
Copier.SqlRowsCopied += new SqlRowsCopiedEventHandler(Copier_SqlRowsCopied);
Copier.WriteToServer(reader);
CurrentStep.Finish(true);
}
