/// <summary>
/// Save file csv
/// </summary>
/// <returns></returns>
internal bool SaveCsv()
{
try
{
using (ReadFile read = new ReadFile())
{
using (StreamWriter outputFile = new StreamWriter(this.FileCsv))
{
outputFile.WriteLine(string.Join(",", this.Header));
foreach (Infors inf in read.Series(this.FileB3))
{
System.Windows.Forms.Application.DoEvents();
if (!this.CheckCodneg(inf.Codneg))
{
continue;
}
List <string> data = this.GetLine(inf);
outputFile.WriteLine(string.Join(",", data));
}
}
// return true if file exists
return(System.IO.File.Exists(this.FileCsv));
}
}
catch (Exception ex)
{
throw;
}
}
/// <summary>
/// Save data into sql
/// </summary>
/// <returns></returns>
internal bool SaveSql()
{
try
{
using (ReadFile read = new ReadFile())
{
using (Connection connection = new Connection(this.ConnectionString))
{
List <string> tables = new List <string>();
if (this.IsTableSeparated == false)
{
ScriptDb.CreateTable(this.Table, this.DropTable, connection);
}
string sql = ScriptDb.Sql(this.Table, this.DropTable);
foreach (Infors inf in read.Series(this.FileB3))
{
System.Windows.Forms.Application.DoEvents();
if (!this.CheckCodneg(inf.Codneg))
{
continue;
}
if (this.IsTableSeparated == true)
{
sql = ScriptDb.Sql(inf.Codneg, this.DropTable);
if (this.DropTable && tables.Contains(inf.Codneg) == false)
{
ScriptDb.CreateTable(inf.Codneg, this.DropTable, connection);
tables.Add(inf.Codneg);
}
}
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("@Codneg", inf.Codneg);
cmd.Parameters.AddWithValue("@Data", inf.Data);
cmd.Parameters.AddWithValue("@Abertura", inf.Abertura);
cmd.Parameters.AddWithValue("@Maxima", inf.Maxima);
cmd.Parameters.AddWithValue("@Minima", inf.Minima);
cmd.Parameters.AddWithValue("@Fechamento", inf.Fechamento);
cmd.Parameters.AddWithValue("@Empresa", inf.Empresa);
connection.Query(cmd);
}
}
}
}
return(true);
}
catch (Exception ex)
{
throw;
}
return(false);
}
/// <summary>
/// Save csv's separated
/// </summary>
/// <returns></returns>
internal bool SaveCsvSepareted()
{
try
{
using (ReadFile read = new ReadFile())
{
string folder = System.IO.Path.Combine(this.FileCsv, "CSVb3_" + DateTime.Now.ToString("HHmmss"));
if (System.IO.Directory.Exists(folder) == false)
{
System.IO.Directory.CreateDirectory(folder);
}
List <string> exists = new List <string>();
foreach (Infors inf in read.Series(this.FileB3))
{
System.Windows.Forms.Application.DoEvents();
if (!this.CheckCodneg(inf.Codneg))
{
continue;
}
string file = System.IO.Path.Combine(folder, inf.Codneg + ".csv");
using (StreamWriter outputFile = new StreamWriter(file, true))
{
if (exists.Contains(inf.Codneg) == false)
{
outputFile.WriteLine(string.Join(",", this.Header));
exists.Add(inf.Codneg);
}
List <string> data = this.GetLine(inf);
outputFile.WriteLine(string.Join(",", data));
}
}
// return true if file exists
return(System.IO.Directory.Exists(folder));
}
}
catch (Exception ex)
{
throw;
}
}