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