private void backup_zapisanie(Controler.Controler controler)
{
List <string> lines = new List <string>();
string[] param;
param = controler.parametre_tabulka().Split(',');
sql_cmd.CommandText = $"Select * From {controler.ToString()}";
using (DbDataReader dataReader = sql_cmd.ExecuteReader())
{
while (dataReader.Read())
{
string line = " ";
for (int i = 0; i < param.Length; i++)
{
line += dataReader[param[i]].ToString();
if (i + 1 != param.Length)
{
line += ";";
}
}
lines.Add(line);
}
using (System.IO.StreamWriter file = new System.IO.StreamWriter($"../../Backup/Backup_{controler.ToString()}.csv"))
{
foreach (string line in lines)
{
file.WriteLine(line);
}
}
lines.Clear();
}
}
private void backup_citanie(Controler.Controler controler)
{
List <string> riadky = File.ReadAllLines($"../../Backup/Backup_{controler.ToString()}.csv").ToList();
int index = 1;
string text = "";
foreach (var line in riadky)
{
string[] riadok = line.Split(';');
text = $"INSERT INTO {controler.ToString()} VALUES ( "; //'{index}',
for (int i = 0; i < riadok.Length; i++)
{
text += $"'{riadok[i]}'";
if (i + 1 != riadok.Length)
{
text += ",";
}
else
{
text += ")";
}
}
sql_cmd.CommandText = text;
sql_cmd.ExecuteNonQuery();
index++;
}
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
string provider = ConfigurationManager.AppSettings["provider"];
string connectionString = ConfigurationManager.AppSettings["connectionString"];
DbProviderFactory factory = DbProviderFactories.GetFactory(provider);
Controler.Controler controler = new Controler.Controler();
using (DbConnection connection = factory.CreateConnection())
{
if (connection == null)
{
Console.WriteLine("Connection Error");
Console.ReadLine();
return;
}
connection.ConnectionString = connectionString;
connection.Open();
DbCommand command = factory.CreateCommand();
if (command == null)
{
Console.WriteLine("Command Error");
Console.ReadLine();
return;
}
command.Connection = connection;
Application.Run(new Prihlasenie(command));
}
}
