private void LoadAllToolStripMenuItemClick(object sender, EventArgs e)
{
var collectionParameters = new CollectionParameters(entityAttributes, entityRelationships,
filterQuery, lookupMaping, mapper, mapping);
LoadAllFiles(NotificationService, tbSchemaPath, tbExportConfig, tbImportConfig, workingstate, collectionParameters);
}
private void ButtonSchemaFolderPathClick(object sender, EventArgs e)
{
using (var fileDialog = new SaveFileDialog
{
Filter = "XML Files|*.xml",
OverwritePrompt = false
})
{
var dialogResult = fileDialog.ShowDialog();
var controller = new SchemaController();
var collectionParameters = new CollectionParameters(entityAttributes, entityRelationships, null, null, null, null);
controller.SchemaFolderPathAction(NotificationService, tbSchemaPath, workingstate, collectionParameters /*entityAttributes, entityRelationships*/, dialogResult, fileDialog, LoadSchemaFile);
}
}
public void SchemaFolderPathActionWithDialogResultCancel()
{
using (var fileDialog = new System.Windows.Forms.SaveFileDialog())
{
using (var schemaPathTextBox = new System.Windows.Forms.TextBox())
{
var dialogResult = System.Windows.Forms.DialogResult.Cancel;
var collectionParameters = new CollectionParameters(inputEntityAttributes, inputEntityRelationships, null, null, null, null);
FluentActions.Invoking(() => systemUnderTest.SchemaFolderPathAction(NotificationServiceMock.Object, schemaPathTextBox, inputWorkingstate, collectionParameters, dialogResult, fileDialog, (x1, x2, x3, x4, x5) => { }))
.Should()
.NotThrow();
schemaPathTextBox.Text.Should().BeEmpty();
}
}
}
public void CanInstantiate()
{
Dictionary <string, HashSet <string> > inputEntityAttributes = null;
Dictionary <string, HashSet <string> > inputEntityRelationships = null;
Dictionary <string, string> inputFilterQuery = null;
Dictionary <string, Dictionary <string, List <string> > > inputLookupMaping = null;
Dictionary <string, Dictionary <Guid, Guid> > inputMapper = null;
Dictionary <string, List <Item <EntityReference, EntityReference> > > inputMapping = null;
var systemUndertest = new CollectionParameters(inputEntityAttributes, inputEntityRelationships, inputFilterQuery, inputLookupMaping, inputMapper, inputMapping);
systemUndertest.EntityAttributes.Should().BeNull();
systemUndertest.EntityRelationships.Should().BeNull();
systemUndertest.FilterQuery.Should().BeNull();
systemUndertest.LookupMaping.Should().BeNull();
systemUndertest.Mapper.Should().BeNull();
systemUndertest.Mapping.Should().BeNull();
}
public void SchemaFolderPathActionWithDialogResultOkAndNonExistingFile()
{
var filename = "TestData\\nonexistingfile.xml";
using (var fileDialog = new System.Windows.Forms.SaveFileDialog())
{
fileDialog.FileName = filename;
using (var schemaPathTextBox = new System.Windows.Forms.TextBox())
{
var dialogResult = System.Windows.Forms.DialogResult.OK;
var collectionParameters = new CollectionParameters(inputEntityAttributes, inputEntityRelationships, null, null, null, null);
FluentActions.Invoking(() => systemUnderTest.SchemaFolderPathAction(NotificationServiceMock.Object, schemaPathTextBox, inputWorkingstate, collectionParameters, dialogResult, fileDialog, (x1, x2, x3, x4, x5) => { }))
.Should()
.NotThrow();
schemaPathTextBox.Text.Should().Be(filename);
}
}
}
public void LoadAllFiles(INotificationService feedbackManager, TextBox schemaPath, TextBox exportConfig, TextBox importConfig, bool inputWorkingstate, CollectionParameters collectionParameters)
{
LoadSchemaFile(schemaPath.Text, inputWorkingstate, feedbackManager, collectionParameters.EntityAttributes, collectionParameters.EntityRelationships);
var controller = new ConfigurationController();
controller.LoadExportConfigFile(feedbackManager, exportConfig, collectionParameters.FilterQuery, collectionParameters.LookupMaping);
controller.LoadImportConfigFile(feedbackManager, importConfig, collectionParameters.Mapper, collectionParameters.Mapping);
}
/// <summary>
/// Method to find a list of employees using a search option and pagination parameters.
/// </summary>
/// <param name="search">text to compare against lastname and phone number</param>
/// <param name="parameters">pagination and sorting parameters</param>
/// <returns></returns>
public override async Task <IEnumerable <Employee> > FindAsync(string search, CollectionParameters parameters)
{
string orderby = string.Empty;
string top = string.Empty;
string offset = string.Empty;
string where = string.Empty;
if (parameters.OrderBy != null && parameters.OrderBy.Length > 0 && typeof(Employee).GetProperties().Count(f => f.Name.Equals(parameters.OrderBy)) == 1)
{
orderby = "ORDER BY " + parameters.OrderBy + ((parameters.Ordering == AscDec.Asc) ? " ASC" : " DESC");
}
if (parameters.Limit != null && parameters.Limit > 0)
{
top = $"TOP({parameters.Limit})";
}
if (parameters.Offset != null && parameters.Offset > 0)
{
offset = $"OFFSET {parameters.Offset} ROWS";
}
if (search != null && search.Length > 0)
{
offset = $"WHERE LastName LIKE '%{search}%' OR Phone LIKE '%{search}%' ";
}
string sql = $"SELECT {top} * FROM {_tableName} {where} {orderby} {offset} ";
return(await _connection.QueryAsync <Employee>(sql, transaction : _transaction));
}
public void SchemaFolderPathAction(INotificationService notificationService, TextBox schemaPathTextBox, bool inputWorkingstate, CollectionParameters collectionParameters, DialogResult dialogResult, SaveFileDialog fileDialog,
Action <string, bool, INotificationService, Dictionary <string, HashSet <string> >, Dictionary <string, HashSet <string> > > loadSchemaFile
)
{
if (dialogResult == DialogResult.OK)
{
schemaPathTextBox.Text = fileDialog.FileName.ToString(CultureInfo.InvariantCulture);
if (File.Exists(schemaPathTextBox.Text))
{
loadSchemaFile(schemaPathTextBox.Text, inputWorkingstate, notificationService, collectionParameters.EntityAttributes, collectionParameters.EntityRelationships);
}
}
else if (dialogResult == DialogResult.Cancel)
{
schemaPathTextBox.Text = null;
}
}
