public EvaluationResult <CustomerData> SQLServerDownload(ISQLServerContext context, string tableName)
{
var result = new EvaluationResult <CustomerData>();
try
{
int recCount = testCountSQL(context.ConnectionString);
result.Results = context.GetData(tableName);
result.Code = result.Results.Count > 0 ? 0 : 1;
result.Text = result.Results.Count > 0 ? "Successfully downloaded customer data" : "There was no customer data downloaded.";
}
catch (Exception ex)
{
result.Code = 2;
result.Text = $"Error loading data: {ex.Message}";
}
return(result);
}
public EvaluationResult <CustomerData> SQLServerUpload(ISQLServerContext context, string tableName)
{
var result = new EvaluationResult <CustomerData>();
try
{
var sample = sampleData.CustomerData();
context.CreateTable(tableName);
context.LoadData(sample, tableName);
int recCount = testCountSQL(context.ConnectionString);
result.Code = recCount == sample.Count ? 0 : 1;
result.Text = result.Code == 0 ? "Successfully uploaded customer data to SQL Server" : (recCount > -1 ? $"No errors were encountered during upload but the database record count is {recCount} and the sample record count is {sample.Count}" : "The upload did not return an error, but there was an error retrieving the SQL Server record count.");
}
catch (Exception ex)
{
result.Code = 2;
result.Text = $"Error loading customer data to SQL Server: {ex.Message}";
}
return(result);
}
