public PersonForm(PersonRowData person)
{
InitializeComponent();
this.person = person;
Text = person.Person.FullName + " - " + person.Person.UIId();
personInfo.EditValue = person.Person.ToFullString();
personInfo.SuperTip = Utilities.CreateSuperTip(body: person.Person.ToFullString());
infoSource.Caption += person.Person.Source;
infoStripeId.Caption += person.StripeId;
infoYKID.Caption += person.Person.YKID;
infoYKID.SuperTip = Utilities.CreateSuperTip("Row ID", person.Person.Id.ToString());
foreach (DataTable table in person.DataSet.Tables)
{
var grid = new GridControl()
{
Dock = DockStyle.Fill,
DataSource = table,
};
tabs.TabPages.Add(new XtraTabPage {
Text = table.TableName,
Controls = { grid }
});
var view = new GridView();
grid.MainView = view;
CustomizeDetailView(table, view);
}
}
public int MergePerson(DbTransaction transaction, PersonRowData oldPerson, Person newPerson)
{
return
transaction.ExecuteNonQuery(
tables.Join(";\n\n\n", t => t.UpdateSql)
+ ";\n\n\nUPDATE Data.MasterDirectory SET StripeId = @oldStripeId WHERE Id = @newId AND StripeId IS NULL"
+ ";\n\n\nDELETE FROM Data.MasterDirectory WHERE Id = @oldId", new { oldId = oldPerson.Person.Id, newId = newPerson.Id, oldStripeId = oldPerson.StripeId });
}
public int MergePerson(DbTransaction transaction, PersonRowData oldPerson, Person newPerson)
{
return
(transaction.ExecuteNonQuery(
tables.Join(";\n\n\n", t => t.UpdateSql)
+ ";\n\n\nUPDATE Data.MasterDirectory SET StripeId = @oldStripeId WHERE Id = @newId AND StripeId IS NULL"
+ ";\n\n\nDELETE FROM Data.MasterDirectory WHERE Id = @oldId", new { oldId = oldPerson.Person.Id, newId = newPerson.Id, oldStripeId = oldPerson.StripeId }));
}
public PersonForm(PersonRowData person)
{
InitializeComponent();
this.person = person;
Text = person.Person.FullName + " - " + person.Person.Id;
personInfo.EditValue = person.Person.ToFullString();
personInfo.SuperTip = Utilities.CreateSuperTip(body: person.Person.ToFullString());
infoSource.Caption += person.Person.Source;
infoStripeId.Caption += person.StripeId;
infoYKID.Caption += person.Person.YKID;
foreach (DataTable table in person.DataSet.Tables) {
var grid = new GridControl() {
Dock = DockStyle.Fill,
DataSource = table,
};
tabs.TabPages.Add(new XtraTabPage {
Text = table.TableName,
Controls = { grid }
});
var view = new GridView();
grid.MainView = view;
view.PopulateColumns();
view.OptionsBehavior.Editable = false;
foreach (GridColumn column in view.Columns) {
if (hiddenFields.Contains(column.FieldName)
|| column.FieldName == pluralizer.Singularize(Path.GetExtension(table.TableName).TrimStart('.')) + "Id")
column.Visible = false;
}
view.BestFitColumns();
}
}
public MergeForm(IEnumerable <PersonRowData> sources, string caption)
{
InitializeComponent();
gridSource = new GridList(sources);
target = gridSource.Sources.Last();
label.Text = caption;
Text = $"Merge {gridSource.Sources.Count} people";
gridControl1.DataSource = gridSource;
// Remove grid columns from detail views or other non-data properties
foreach (var gridColumn in gridView.Columns.ToList())
{
if (gridColumn.FieldName == nameof(Extensions.UIId) ||
gridColumn.FieldName == Person.IdColumn.Name ||
Person.Schema.Columns[gridColumn.FieldName]?.ReadOnly != false)
{
gridView.Columns.Remove(gridColumn);
}
}
gridView.BestFitColumns();
}