public override bool Sync()
{
try
{
foreach (var tableName in OneCv77CatalogColumns.Select(s => s.tableName).Distinct())
{
if (!equalCatalogTableDescribe(tableName))
{
_sqlAdaptor.recreateTable(tableName, OneCv77CatalogColumns.Where(t => t.tableName.Equals(tableName)).ToList());
}
}
foreach (var tableName in OneCv77DocumentsColumns.Select(s => s.tableName).Distinct())
{
if (!equalDocumentTableDescribe(tableName))
{
_sqlAdaptor.recreateTable(tableName, OneCv77DocumentsColumns.Where(t => t.tableName.Equals(tableName)).ToList());
}
}
foreach (var tableName in OneCv77DocumentsHeaderColumns.Select(s => s.tableName).Distinct())
{
if (!equalDocumentHeaderDescribe(tableName))
{
_sqlAdaptor.recreateTable(tableName, OneCv77DocumentsHeaderColumns.Where(t => t.tableName.Equals(tableName)).ToList());
}
}
}
catch (Exception ex)
{
Logger.logger.Error(ex);
return(false);
}
return(true);
}
protected bool equalCatalogTableDescribe(string tableName)
{
foreach (var oneCcol in OneCv77CatalogColumns.Where(c => c.tableName.Equals(tableName)))
{
if (!SqlColumns.Any(c => c.tableName.Equals(tableName) && c.columnName.Equals(oneCcol.columnName)))
{
return(false);
}
}
return(true);
}
public override bool Sync()
{
try
{
DateTime dateFrom = DateTime.Now.AddDays(-Config.SyncDatabases.lastDays.Value);
IEnumerable <TableColumn> dataDocTableExist = null;
string tableNameData = string.Empty;
foreach (var tableName in OneCv77CatalogColumns.Select(s => s.tableName).Distinct())
{
_sqlAdaptor.recreateTable(tableName, OneCv77CatalogColumns.Where(w => w.tableName.Equals(tableName)).ToList());
int page = 0;
var tableColumns = _comClient1Cv77Adatpor.getCatalogTableColumns(tableName);
while (true)
{
DataTable dt = _comClient1Cv77Adatpor.getCatalogDataTable(tableName, tableColumns, page);
_sqlAdaptor.bulkInsertData(tableName, dt);
if (dt.Rows.Count == 0)
{
break;
}
page++;
}
_sqlAdaptor.dropTable(string.Format("{0}_ok", tableName));
_sqlAdaptor.renameTable(tableName, string.Format("{0}_ok", tableName));
}
foreach (var tableName in OneCv77DocumentsHeaderColumns.Select(s => s.tableName).Distinct())
{
DateTime date = dateFrom;
dataDocTableExist = OneCv77DocumentsColumns.Where(
s =>
comClient1Cv77Adatpor.cleanSuffix(s.tableName) ==
comClient1Cv77Adatpor.cleanSuffix(tableName));
if (dataDocTableExist.Count() > 0)
{
tableNameData = dataDocTableExist.First().tableName;
if (!_sqlAdaptor.deleteRefTable(tableName + "_ok", tableNameData + "_ok", dateFrom))
{
Logger.logger.Error(string.Format("Can't particular sync {0}", tableNameData));
tableNameData = string.Empty;
}
}
else
{
tableNameData = string.Empty;
}
if (_sqlAdaptor.deleteTable(tableName + "_ok", dateFrom))
{
while (true)
{
List <string> dataRows = _comClient1Cv77Adatpor.GetDocumentData(tableName, date);
if (dataRows.Count > 0)
{
_sqlAdaptor.bulkInsertData(tableName + "_ok",
_comClient1Cv77Adatpor.getDocumentDataHeader(tableName, dataRows));
if (dataDocTableExist.Count() > 0 && tableNameData != string.Empty)
{
var dataTable = _comClient1Cv77Adatpor.getDocumentDataTable(tableNameData, dataRows);
if (dataTable.Rows.Count > 0)
{
_sqlAdaptor.bulkInsertData(tableNameData + "_ok", dataTable);
}
}
}
if (date > DateTime.Now.AddDays(10))
{
break;
}
date = date.AddDays(1);
}
}
else
{
Logger.logger.Error(string.Format("Can't particular sync {0}", tableName));
}
}
}
catch (Exception ex)
{
Logger.logger.Error(ex);
return(false);
}
return(true);
}
public override bool Sync()
{
try
{
foreach (var tableName in OneCv77CatalogColumns.Select(s => s.tableName).Distinct())
{
_sqlAdaptor.recreateTable(tableName, SqlColumns.Where(w => w.tableName.Equals(tableName)).ToList());
int page = 0;
var tableColumns = _comClient1Cv77Adatpor.getCatalogTableColumns(tableName);
while (true)
{
DataTable dt = _comClient1Cv77Adatpor.getCatalogDataTable(tableName, tableColumns, page);
_sqlAdaptor.bulkInsertData(tableName, dt);
if (dt.Rows.Count == 0)
{
break;
}
page++;
}
_sqlAdaptor.dropTable(string.Format("{0}_ok", tableName));
_sqlAdaptor.renameTable(tableName, string.Format("{0}_ok", tableName));
}
string tableNameData = string.Empty;
foreach (var tableName in OneCv77DocumentsHeaderColumns.Select(s => s.tableName).Distinct())
{
_sqlAdaptor.recreateTable(tableName, SqlColumns.Where(w => w.tableName.Equals(tableName)).ToList());
DateTime date = new DateTime(2003, 01, 01);
IEnumerable <TableColumn> dataDocTableExist = OneCv77DocumentsColumns.Where(
s =>
comClient1Cv77Adatpor.cleanSuffix(s.tableName) ==
comClient1Cv77Adatpor.cleanSuffix(tableName));
if (dataDocTableExist.Count() > 0)
{
tableNameData = dataDocTableExist.First().tableName;
_sqlAdaptor.recreateTable(tableNameData, SqlColumns.Where(w => w.tableName.Equals(tableNameData)).ToList());
}
while (true)
{
List <string> dataRows = _comClient1Cv77Adatpor.GetDocumentData(tableName, date);
if (dataRows.Count > 0)
{
_sqlAdaptor.bulkInsertData(tableName, _comClient1Cv77Adatpor.getDocumentDataHeader(tableName, dataRows));
if (dataDocTableExist.Count() > 0)
{
var dataTable = _comClient1Cv77Adatpor.getDocumentDataTable(tableNameData, dataRows);
if (dataTable.Rows.Count > 0)
{
_sqlAdaptor.bulkInsertData(tableNameData, dataTable);
}
}
}
if (date > DateTime.Now)
{
break;
}
date = date.AddDays(1);
}
_sqlAdaptor.dropTable(string.Format("{0}_ok", tableName));
_sqlAdaptor.renameTable(tableName, string.Format("{0}_ok", tableName));
if (dataDocTableExist.Count() > 0)
{
_sqlAdaptor.dropTable(string.Format("{0}_ok", tableNameData));
_sqlAdaptor.renameTable(tableNameData, string.Format("{0}_ok", tableNameData));
}
}
}
catch (Exception ex)
{
Logger.logger.Error(ex);
return(false);
}
return(true);
}
