//public static FiasOperatorXML fiasXMLDataSetConverter = new FiasOperatorXML(new DirectoryInfo(XML_Directory), connection, schemaname);
static void Main(string[] args)
{
try
{
var ct = new CancellationTokenSource();
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder()
{
DataSource = "BUSHMAKIN",
InitialCatalog = "UNS",
IntegratedSecurity = true,
ConnectTimeout = 0,
NetworkLibrary = "dbmssocn"
};
var serverTableType = ServerTableType.GlobalTemp;
FiasOperatorDBF fiasDBFDataSetConverter = new FiasOperatorDBF(new DirectoryInfo(DBF_Directory), builder.ConnectionString, schemaname);
var LoadTaskOld = Task.Factory.StartNew(() =>
{
fiasDBFDataSetConverter.SPLoad();
});
var DownloadTask = LoadTaskOld.ContinueWith(a => fiasDBFDataSetConverter.DownloadFromSite(false));
//var LoadTask = Task.Factory.StartNew(() => fiasDBFDataSetConverter.BulkLoad(serverTableType));/*DownloadTask*/
var LoadTask = DownloadTask.ContinueWith(a => fiasDBFDataSetConverter.SPLoad());
/*var MergeTask = LoadTask.ContinueWith(a =>
* {
* if (a.IsCompleted)
* {
* fiasDBFDataSetConverter.MergeDB(serverTableType);
* }
* });*/
LoadTask.Wait();
}
finally { }
}
public static void Load(SqlDateTime downloaded)
{
using (SqlConnection connection = new SqlConnection("context connection=true"))
{
var fias = new FiasOperatorDBF(new DirectoryInfo(Path.GetTempPath()), connection, "fias_tmp");
fias.DownloadFromSite(false, downloaded.Value);
}
}
