public void SetSimpleLogging()
{
using (ShapefileEntities db = new ShapefileEntities())
{
db.Database.Initialize(true);
}
using (SqlConnection conn = new SqlConnection(DataHelper.DefaultConnectionString))
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandTimeout = DataHelper.DefaultTimeoutSeconds;
cmd.CommandType = CommandType.Text;
cmd.CommandText = $"ALTER DATABASE {conn.Database} SET RECOVERY SIMPLE";
try
{
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception e)
{
Console.WriteLine($"\r\n{e.Message}\r\n{e}");
throw;
}
finally
{
conn.Close();
}
}
}
}
public void ImportFromFile(FileInfo file)
{
try
{
using (BinaryReader br = new BinaryReader(file.OpenRead()))
{
long streamLength = br.BaseStream.Length;
FileCode = NumericsHelper.ReverseInt(br.ReadInt32());
for (int i = 0; i < 5; i++)
{
br.ReadInt32(); // Skip 5 empty Integer (4-byte) slots
}
ContentLength = NumericsHelper.ReverseInt(br.ReadInt32()); // Big Endian, Reverse for actual value
FileVersion = br.ReadInt32();
ShapeType = (ShapeType)br.ReadInt32();
XMin = br.ReadDouble();
YMin = br.ReadDouble();
XMax = br.ReadDouble();
YMax = br.ReadDouble();
ZMin = br.ReadDouble();
ZMax = br.ReadDouble();
MMin = br.ReadDouble();
MMax = br.ReadDouble();
int rowsAffected;
using (ShapefileEntities db = new ShapefileEntities())
{
db.Entry(this).State = EntityState.Added;
rowsAffected = db.SaveChanges();
}
if (!(rowsAffected > 0) ||
!(Id > 0))
{
throw new Exception(
"The index file was not added to the database properly. No ID is present to assign to the child index records. Unable to proceed!");
}
List <ShapeIndex> shapeIndices = new List <ShapeIndex>();
int counter = 0;
while (br.PeekChar() > -1)
{
LH.Write(StringHelper.GetProgressString(br.BaseStream.Position, streamLength, file.Name));
shapeIndices.Add(new ShapeIndex
{
IndexFileId = Id,
RecordNumber = ++counter,
Offset = NumericsHelper.ReverseInt(br.ReadInt32()),
ContentLength = NumericsHelper.ReverseInt(br.ReadInt32())
});
}
LH.Write(StringHelper.GetProgressString(br.BaseStream.Position, streamLength, file.Name));
using (SqlBulkCopy sbc = new SqlBulkCopy(DataHelper.DefaultConnectionString))
{
sbc.BatchSize = DataHelper.DefaultBatchSize;
sbc.BulkCopyTimeout = DataHelper.DefaultTimeoutSeconds;
sbc.DestinationTableName = "ShapeIndex";
sbc.EnableStreaming = true;
sbc.SqlRowsCopied += DataHelper.SqlBulkCopy_SqlRowsCopied;
sbc.NotifyAfter = DataHelper.DefaultBatchSize;
sbc.ColumnMappings.Add("Id", "Id");
sbc.ColumnMappings.Add("IndexFileId", "IndexFileId");
sbc.ColumnMappings.Add("RecordNumber", "RecordNumber");
sbc.ColumnMappings.Add("Offset", "Offset");
sbc.ColumnMappings.Add("ContentLength", "ContentLength");
try
{
DataTable shapeIndicesData = DataHelper.CreateDataTable(shapeIndices);
sbc.WriteToServerAsync(shapeIndicesData);
}
catch (Exception e)
{
LH.Error($"\r\n{e.Message}\r\n{e}");
throw;
}
finally
{
sbc.Close();
}
}
}
}
catch (Exception e)
{
LH.Error($"\r\n{e.Message}\r\n{e}");
throw;
}
}
public void ImportFromFile(FileInfo file)
{
try
{
// TODO: Delete all records that pertain to this file
using (BinaryReader br = new BinaryReader(file.OpenRead()))
{
long streamLength = br.BaseStream.Length;
LH.Write(StringHelper.GetProgressString(br.BaseStream.Position, streamLength, file.Name));
FileCode = NumericsHelper.ReverseInt(br.ReadInt32());
for (int i = 0; i < 5; i++)
{
br.ReadInt32(); // Skip 5 empty Integer (4-byte) slots
}
ContentLength = NumericsHelper.ReverseInt(br.ReadInt32()); // Big Endian, Reverse for actual value
FileVersion = br.ReadInt32();
ShapeType = (ShapeType)br.ReadInt32();
XMin = br.ReadDouble();
YMin = br.ReadDouble();
XMax = br.ReadDouble();
YMax = br.ReadDouble();
ZMin = br.ReadDouble();
ZMax = br.ReadDouble();
MMin = br.ReadDouble();
MMax = br.ReadDouble();
int rowsAffected;
using (ShapefileEntities db = new ShapefileEntities())
{
db.Entry(this).State = EntityState.Added;
rowsAffected = db.SaveChanges();
}
if (rowsAffected > 0 &&
Id > 0)
{
List <Shape> shapes = new List <Shape>();
while (br.PeekChar() > -1)
{
LH.Write(StringHelper.GetProgressString(br.BaseStream.Position, streamLength, file.Name));
shapes.Add(new Shape(Id, ShapeType, br));
}
LH.Write(StringHelper.GetProgressString(br.BaseStream.Position, streamLength, file.Name));
using (SqlBulkCopy sbc = new SqlBulkCopy(DataHelper.DefaultConnectionString))
{
sbc.BatchSize = DataHelper.DefaultBatchSize;
sbc.BulkCopyTimeout = DataHelper.DefaultTimeoutSeconds;
sbc.DestinationTableName = "Shape";
sbc.EnableStreaming = true;
sbc.SqlRowsCopied += DataHelper.SqlBulkCopy_SqlRowsCopied;
sbc.NotifyAfter = 250;
sbc.ColumnMappings.Add("ShapeFileId", "ShapeFileId");
sbc.ColumnMappings.Add("ShapeType", "ShapeType");
sbc.ColumnMappings.Add("RecordNumber", "RecordNumber");
sbc.ColumnMappings.Add("ContentLength", "ContentLength");
sbc.ColumnMappings.Add("XMin", "XMin");
sbc.ColumnMappings.Add("YMin", "YMin");
sbc.ColumnMappings.Add("XMax", "XMax");
sbc.ColumnMappings.Add("YMax", "YMax");
sbc.ColumnMappings.Add("ZMin", "ZMin");
sbc.ColumnMappings.Add("ZMax", "ZMax");
sbc.ColumnMappings.Add("MMin", "MMin");
sbc.ColumnMappings.Add("MMax", "MMax");
sbc.ColumnMappings.Add("NumberOfParts", "NumberOfParts");
sbc.ColumnMappings.Add("NumberOfPoints", "NumberOfPoints");
sbc.ColumnMappings.Add("DTGeometry", "Geometry");
try
{
DataTable shapesData = DataHelper.CreateDataTable(shapes);
sbc.WriteToServerAsync(shapesData);
}
catch (Exception e)
{
LH.Error($"\r\n{e.Message}\r\n{e}");
throw;
}
finally
{
sbc.Close();
}
}
}
else
{
throw new FileLoadException("The ShapeFile record failed to save properly or doesn't have a valid ID");
}
}
}
catch (Exception e)
{
LH.Error($"\r\n{e.Message}\r\n{e}");
throw;
}
}
