Repository navigation
Expand file tree
/
Copy pathHelpers.cs
More file actions
133 lines (131 loc) · 5.86 KB
/
Copy pathHelpers.cs
File metadata and controls
133 lines (131 loc) · 5.86 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
using Dapper;
using Microsoft.Data.SqlClient;
using Microsoft.Data.Sqlite;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Drawing.Imaging;
namespace ImagesInDB {
public static class ImageHelper {
public static ImageFormat GetImageFormat(Image img) {
return $"{img.RawFormat}" switch {
"Jpeg" => ImageFormat.Jpeg,
"Png" => ImageFormat.Png,
"Gif" => ImageFormat.Gif,
"Bmp" => ImageFormat.Bmp,
"Emf" => ImageFormat.Emf,
"Wmf" => ImageFormat.Wmf,
"Tiff" => ImageFormat.Tiff,
"Exif" => ImageFormat.Exif,
"Icon" => ImageFormat.Icon,
_ => ImageFormat.Bmp
};
}
public static string GetImageExtension(Image img) {
return $"{img.RawFormat}" switch {
"Jpeg" => "jpg",
_ => $"{img.RawFormat}".ToLower()
};
}
}
public static class IOHelper {
public static void CheckDir(string dir) {
if(!Directory.Exists(dir))
Directory.CreateDirectory(dir);
}
}
public static class DBHelper {
public static DataSet GetMDBDataSet(string path) {
DataSet dataSet = new();
string connectionString = $"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={path};";
using(OleDbConnection connection = new(connectionString)) {
try {
connection.Open();
DataTable schemaTable = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
foreach(DataRow row in schemaTable.Rows) {
string tableName = row["TABLE_NAME"].ToString();
if(!tableName.StartsWith("MSys")) {
OleDbDataAdapter dataAdapter = new($"SELECT * FROM [{tableName}]", connection);
DataTable dataTable = new(tableName);
dataAdapter.Fill(dataTable);
dataSet.Tables.Add(dataTable);
}
}
} catch(Exception ex) {
Console.WriteLine($"MDB Error: {ex.Message}");
} finally {
if(connection.State == ConnectionState.Open) {
connection.Close();
}
}
}
return dataSet;
}
public static DataSet GetMDFDataSet(string path) {
DataSet dataSet = new();
string connectionString = $@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename={path};Integrated Security=True;";
using(SqlConnection connection = new(connectionString)) {
try {
connection.Open();
DataTable tablesSchema = connection.GetSchema("Tables");
foreach(DataRow row in tablesSchema.Rows) {
string tableName = row["TABLE_NAME"].ToString();
SqlDataAdapter dataAdapter = new($"SELECT * FROM {tableName}", connection);
try { //error handling for tables that can't be read
DataTable dataTable = new(tableName);
dataAdapter.Fill(dataTable);
dataSet.Tables.Add(dataTable);
} catch { }
}
} catch(Exception ex) {
Console.WriteLine($"MDF Error: {ex.Message}");
} finally {
if(connection.State == ConnectionState.Open) {
connection.Close();
}
}
return dataSet;
}
}
public static DataSet GetXMLDataSet(string path) {
DataSet dataSet = new();
try {
dataSet.ReadXml(path);
} catch(Exception ex) {
Console.WriteLine($"XML Error: {ex.Message}");
}
return dataSet;
}
public static DataSet GetDBFDataSet(string path) {
DataSet dataSet = new();
string connectionString = $@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={path};Extended Properties=dBASE IV;";
using(OleDbConnection connection = new(connectionString)) {
try {
connection.Open();
foreach(string file in Directory.GetFiles(path, "*.dbf")) {
string tableName = Path.GetFileNameWithoutExtension(file);
string query = $"SELECT * FROM [{tableName}]";
OleDbDataAdapter adapter = new(query, connection);
adapter.Fill(dataSet, tableName);
}
} catch(Exception ex) {
Console.WriteLine($"DBF Error: {ex.Message}");
}
}
return dataSet;
}
public static void GetSQLTables(FileInfo fi, string prefix, Action<string, string, string, List<object>> saveImages) {
string connectionString = $"Data Source={fi.FullName};";
using(SqliteConnection connection = new(connectionString)) {
try {
connection.Open();
var tables = connection.Query<string>("SELECT name FROM sqlite_master WHERE type = 'table';");
foreach(var table in tables)
saveImages(prefix, fi.Name, $"{table}", connection.Query($"SELECT * FROM {table}").ToList());
} catch(Exception ex) {
Console.WriteLine($"SQL Error: {ex.Message}");
}
}
}
}
}