/// <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; } }