/// <summary>
/// Returns the template table for imports node as a varbinary(max) in Sql Server
/// </summary>
/// <returns>Template table for saving node as a varbinary(max)</returns>
private DataTable GetTableGeo()
{
ConstructDataTable constructDataTable = new ConstructDataTable(_importConfigurator.DataBaseConfig.TableNameGeo);
constructDataTable.AddColumn("idGeo", TypeDataTable.Int64);
constructDataTable.AddColumn("bin", TypeDataTable.ByteArray);
constructDataTable.AddColumn("typeGeo", TypeDataTable.Int16);
return(constructDataTable.GetDataTable());
}
/// <summary>
/// Returns the template table for imports ways in Sql Server
/// </summary>
/// <returns>Template table for saving way</returns>
private DataTable GetTableWays()
{
ConstructDataTable ways = new ConstructDataTable("dbo.Ways");
ways.AddColumn("id", TypeDataTable.Int64);
ways.AddColumn("orders", TypeDataTable.Int16);
ways.AddColumn("idNode", TypeDataTable.Int64);
ways.AddColumn("times", TypeDataTable.DateTime);
return(ways.GetDataTable());
}
/// <summary>
/// Returns the template table for imports nodes in Sql Server
/// </summary>
/// <returns>Template table for saving node</returns>
private DataTable GetTableNodes()
{
ConstructDataTable nodes = new ConstructDataTable("dbo.Nodes");
nodes.AddColumn("id", TypeDataTable.Int64);
nodes.AddColumn("lat", TypeDataTable.Double);
nodes.AddColumn("lon", TypeDataTable.Double);
nodes.AddColumn("times", TypeDataTable.DateTime);
return(nodes.GetDataTable());
}
/// <summary>
/// Creates a table for storing tags and their values
/// </summary>
/// <returns>Table for storing tags and their values</returns>
private DataTable GetTableTagsValue()
{
ConstructDataTable constructDataTable = new ConstructDataTable(_importConfigurator.DataBaseConfig.TableNameValues);
constructDataTable.AddColumn("idGeo", TypeDataTable.Int64);
constructDataTable.AddColumn("tag", TypeDataTable.Int32);
constructDataTable.AddColumn("vType", TypeDataTable.Int16);
constructDataTable.AddColumn("vHash", TypeDataTable.Int32);
constructDataTable.AddColumn("vString", TypeDataTable.String);
constructDataTable.AddColumn("vInt", TypeDataTable.Int32);
return(constructDataTable.GetDataTable());
}
private DataTable GetTableTagsValuesTrans()
{
ConstructDataTable constructDataTable = new ConstructDataTable("dbo.TagsValuesTrans");
constructDataTable.AddColumn("tagHash", TypeDataTable.Int32);
constructDataTable.AddColumn("valueHash", TypeDataTable.Int32);
constructDataTable.AddColumn("tagTrans", TypeDataTable.String);
constructDataTable.AddColumn("valTrans", TypeDataTable.String);
constructDataTable.AddColumn("LCID", TypeDataTable.Int16);
constructDataTable.AddColumn("typeTrans", TypeDataTable.Byte);
return(constructDataTable.GetDataTable());
}