public void GetTableFromQuery_ShouldReturnSqlResult_WhenNotSelectStatement()
{
const string sql = @"
DECLARE @sql nvarchar(max) = 'some dynamic sql'
EXEC sp_executesql (@sql)
";
Assert.That(ImportFileHelper.GetTableNameFromSelectStatement(sql), Is.EqualTo("SQL RESULT"));
}
public void GetTableFromQuery_ShouldReturnTableName_WhenSelectStatement()
{
const string sql = @"
SELECT
id
,mytext
,foo
,bar
from [Database].[schema].[table] t
WHERE
id = 1;
";
Assert.That(ImportFileHelper.GetTableNameFromSelectStatement(sql), Is.EqualTo("[DATABASE].[SCHEMA].[TABLE]"));
}
private void BrowseFile_Click(object sender, EventArgs e)
{
// Displays an OpenFileDialog so the user can select the Stock Input File.
OpenFileDialog openFileDialog1 = new OpenFileDialog();
openFileDialog1.Filter = "Text Files|*.txt";
openFileDialog1.Title = "Select stock Input File";
this.GainLabel.Visible = false;
this.GainDetailText.Visible = false;
// Show the Dialog.
// If the user clicked OK in the dialog and
// a .TXT file was selected, open it.
if (openFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
System.IO.StreamReader sr = new
System.IO.StreamReader(openFileDialog1.FileName);
try
{
this.GainLabel.Visible = true;
if (sr.Peek() != -1)
{
string resultString = ImportFileHelper.ReadInputFile(sr);
if (resultString == string.Empty)
{
SetGainText("Input file doesnt have sufficient stock quotes", Color.Red, FontStyle.Bold);
}
else
{
SetGainText("Biggest Gain Trading Dates:", Color.White, FontStyle.Regular);
SetGainDetaiProperties(resultString);
}
}
else
{
SetGainText("Input file doesnt have stock price(s)", Color.Red, FontStyle.Bold);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
sr.Close();
}
}
}
public void ExecuteDataTableFromTextFile_ShouldImport_WhenCsv()
{
const string query = @"SELECT * FROM [Test#csv]";
var path = Path.Combine(TestContext.CurrentContext.WorkDirectory, "Data", "Test.csv");
var file = new FileInfo(path);
var expected = Common.CreateDataTable("Expected", new[] { 0, 2 });
Common.AddDataRow(expected, "Text one.", 42, 2.00d, 2.00m);
Common.AddDataRow(expected, "Text two.", 42, 3.00d, 3.00m);
Common.AddDataRow(expected, "Text three.", 43, 4.00d, 4.00m);
Common.AddDataRow(expected, "Text four.", 43, 5.00d, 5.00m);
var actual = ImportFileHelper.ExecuteDataTableFromTextFile(query, file, expected.PrimaryKey);
var diffs = DataTableHelper.CompareDataTables(expected, actual);
Assert.That(diffs, Is.Null);
}
private void ImportDataButton_Click(object sender, EventArgs e)
{
using (var dlg = new OpenFileDialog())
{
dlg.Multiselect = false;
dlg.Filter = "CSV files (.csv)|";
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
try
{
ImportFileHelper.Import(dlg.FileName);
}
finally
{
Cursor.Current = Cursors.Default;
RefreshData();
}
}
}
public ICommandResult ExecuteHendler(ImportFileCommand command)
{
if (command.IsValid)
{
var fileControllerReturn = new List <string>();
fileReadSales = new FileReadSalesBase(command.FileName, DateTime.Now);
if (fileReadSales.Invalid)
{
return(new CommandResult(false, fileReadSales.AddErrorFromNotifications()));
}
foreach (string line in command.FileReader)
{
ELineType lineType = ImportFileHelper.IdentifyLineType(line);
string errorReturn = string.Empty;
switch (lineType)
{
case ELineType.ClienteData:
Client cli = convertToClient.ExecuteConversion(line);
if (cli.Invalid)
{
errorReturn = cli.AddErrorFromNotifications();
}
fileReadSales.AddClient(cli);
break;
case ELineType.SalesData:
SalesData sale = convertToSalesdata.ExecuteConversion(line);
if (sale.Invalid)
{
errorReturn = sale.AddErrorFromNotifications();
}
fileReadSales.AddSales(sale);
break;
case ELineType.SalesmanData:
Salesman salesman = convertToSalesman.ExecuteConversion(line);
if (salesman.Invalid)
{
errorReturn = salesman.AddErrorFromNotifications();
}
fileReadSales.AddSalesman(salesman);
break;
}
fileControllerReturn.Add($"{line} => {errorReturn}");
}
var linesOutFile = fileReadSales.WriteFileLines();
_fileWriteServices.WriteFileFromLines(lines: linesOutFile, filePath: command.FilePath, fileName: command.FileName);
_fileWriteServices.WriteFileFromLines(lines: fileControllerReturn.ToArray(), filePath: command.FilePath, fileName: $"{command.FileName}.RET");
}
return(new CommandResult(true, "Dados importados com sucesso"));
}
