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