public bool AliasPluralValidate(LookupValue lookupValue, out string failReason)
{
failReason = "";
/*Don't check items that are not enabled*/
if (!lookupValue.Enabled)
{
return(true);
}
if (string.IsNullOrEmpty(lookupValue.AliasPlural))
{
failReason = "AliasPlural cannot be zero-length.";
return(false);
}
if (lookupValue.AliasPlural.IndexOf(" ") >= 0)
{
failReason = "AliasPlural cannot have spaces.";
return(false);
}
foreach (LookupValue sibling in lookupValue.Parent.LookupValues)
{
if (sibling != lookupValue && sibling.Enabled && ArchAngel.Providers.Database.Helper.Script.StringsAreEqual(sibling.AliasPlural, lookupValue.AliasPlural, false))
{
failReason = "Duplicate AliasPlural: " + lookupValue.AliasPlural;
return(false);
}
}
return(true);
}
public bool NameValidate(LookupValue lookupValue, out string failReason)
{
failReason = "";
/*Don't check items that are not enabled*/
if (!lookupValue.Enabled)
{
return true;
}
if (string.IsNullOrEmpty(lookupValue.Name))
{
failReason = "Name cannot be zero-length.";
return false;
}
if (lookupValue.Name.IndexOf(" ") >= 0)
{
failReason = "Name cannot have spaces.";
return false;
}
foreach (LookupValue sibling in lookupValue.Parent.LookupValues)
{
if (sibling != this && sibling.Enabled && ArchAngel.Providers.Database.Helper.Script.StringsAreEqual(sibling.Name, Name, false))
{
failReason = "Duplicate name: " + Name;
return false;
}
}
return true;
}
public virtual string AliasPluralDefault(LookupValue lookupValue)
{
return ArchAngel.Providers.Database.Helper.Script.GetPlural(lookupValue.Alias);
}
public bool AliasDisplayValidate(LookupValue lookupValue, out string failReason)
{
failReason = "";
return true;
}
private void btnFetchValuesFromOtherTable_Click(object sender, EventArgs e)
{
Cursor = Cursors.WaitCursor;
try
{
if (ddlLookupIdColumns.SelectedItem == null)
{
MessageBox.Show("Please select an ID column.", "Missing Data", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
Model.Column idColumn = (Model.Column)ddlLookupIdColumns.SelectedItem;
string sql = string.Format("SELECT DISTINCT [{0}]", idColumn.Name);
if (ddlLookupNameColumns.SelectedItem != null &&
ddlLookupNameColumns.SelectedItem is Model.Column)
{
sql += string.Format(", [{0}]", ((Model.Column)ddlLookupNameColumns.SelectedItem).Name);
}
Model.ScriptObject table = (Model.ScriptObject)ddlLookupTables.SelectedItem;
sql += string.Format(" FROM [{0}].[{1}] ORDER BY [{2}]", table.Schema, table.Name, idColumn.Name);
System.Data.DataTable results = null;
try
{
Providers.Database.Helper.Utility.ResetAllConnections();
results = table.Database.RunQuerySQL(sql);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
System.Data.DataRow[] rows = results.Select();
if (results.Rows.Count > 100)
{
if (MessageBox.Show(string.Format("{0} rows were returned. Are you sure you want to import this many?", results.Rows.Count), "Many Results", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
}
foreach (System.Data.DataRow row in rows)
{
string id = row[0].ToString();
string name = row.ItemArray.Length == 1 ? "" : row[1].ToString();
// Check if already exists
bool exists = false;
foreach (System.Windows.Forms.DataGridViewRow dataGridRow in dataGridViewX1.Rows)
{
if (dataGridRow.IsNewRow)
{
continue;
}
if (dataGridRow.Cells[(int)ColumnNames.Id].Value != null && Slyce.Common.Utility.StringsAreEqual(dataGridRow.Cells[(int)ColumnNames.Id].Value.ToString(), id, false))
{
if (!Slyce.Common.Utility.StringsAreEqual(dataGridRow.Cells[(int)ColumnNames.Name].Value.ToString(), name, false) &&
string.IsNullOrEmpty(dataGridRow.Cells[(int)ColumnNames.Name].Value.ToString()))
{
dataGridRow.Cells[(int)ColumnNames.Name].Value = name;
((LookupValue)dataGridRow.Tag).Name = name;
}
exists = true;
break;
}
}
if (exists)
{
continue;
}
LookupValue lookupValue = new LookupValue(name, false, Lookup);
lookupValue.Id = id;
lookupValue.Name = name;
Lookup.LookupValues.Add(lookupValue);
AddLookupValueToGrid(lookupValue);
}
HighlightDuplicates();
}
finally
{
Cursor = Cursors.Default;
}
}
private void AddLookupValueToGrid(LookupValue lookupValue)
{
int newIndex = dataGridViewX1.Rows.Add(new object[] { lookupValue.Enabled, lookupValue.Id.ToString(), lookupValue.Name, lookupValue.Alias, lookupValue.AliasPlural, lookupValue.Description });
dataGridViewX1.Rows[newIndex].Tag = lookupValue;
}
private void dataGridViewX1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
System.Windows.Forms.DataGridViewRow row = ((DevComponents.DotNetBar.Controls.DataGridViewX)sender).Rows[e.RowIndex];
if (row.IsNewRow)
{
return;
}
LookupValue lookupValue = (LookupValue)row.Tag;
if (row.Tag == null)
{
lookupValue = new LookupValue("", true, "", "", Lookup);
lookupValue.Enabled = true;
row.Cells[(int)ColumnNames.Enabled].Value = true;
Lookup.LookupValues.Add(lookupValue);
row.Tag = lookupValue;
}
else
{
lookupValue = (LookupValue)row.Tag;
}
// Has the Name field been edited?
if (row.Cells[e.ColumnIndex] == row.Cells[(int)ColumnNames.Name])
{
if (row.Cells[(int)ColumnNames.Name] == null || row.Cells[(int)ColumnNames.Name].Value == null)
{
lookupValue.Name = "";
}
else
{
lookupValue.Name = row.Cells[(int)ColumnNames.Name].Value.ToString();
}
if (string.IsNullOrEmpty(lookupValue.Alias))
{
lookupValue.Alias = lookupValue.AliasDefault(lookupValue);
row.Cells[(int)ColumnNames.Alias].Value = lookupValue.Alias;
}
if (string.IsNullOrEmpty(lookupValue.AliasPlural))
{
lookupValue.AliasPlural = lookupValue.AliasPluralDefault(lookupValue);
row.Cells[(int)ColumnNames.AliasPlural].Value = lookupValue.AliasPlural;
}
}
// Has the Alias field been edited?
if (row.Cells[e.ColumnIndex] == row.Cells[(int)ColumnNames.Alias])
{
lookupValue.Alias = row.Cells[(int)ColumnNames.Alias] == null ? "" : row.Cells[(int)ColumnNames.Alias].Value.ToString();
lookupValue.AliasPlural = lookupValue.AliasPluralDefault(lookupValue);
row.Cells[(int)ColumnNames.AliasPlural].Value = lookupValue.AliasPlural;
}
if (row.Cells[(int)ColumnNames.Enabled].Value == null)
{
row.Cells[(int)ColumnNames.Enabled].Value = false;
}
lookupValue.Alias = row.Cells[(int)ColumnNames.Alias].Value == null ? "" : row.Cells[(int)ColumnNames.Alias].Value.ToString();
lookupValue.AliasPlural = row.Cells[(int)ColumnNames.AliasPlural].Value == null ? "" : row.Cells[(int)ColumnNames.AliasPlural].Value.ToString();
lookupValue.Description = row.Cells[(int)ColumnNames.Description].Value == null ? "" : row.Cells[(int)ColumnNames.Description].Value == null ? "" : row.Cells[(int)ColumnNames.Description].Value.ToString();
lookupValue.Enabled = (bool)row.Cells[(int)ColumnNames.Enabled].Value;
lookupValue.Id = row.Cells[(int)ColumnNames.Id].Value == null ? "" : row.Cells[(int)ColumnNames.Id].Value.ToString();
lookupValue.Name = row.Cells[(int)ColumnNames.Name].Value == null ? "" : row.Cells[(int)ColumnNames.Name].Value.ToString();
HighlightDuplicates();
}
public virtual string AliasPluralDefault(LookupValue lookupValue)
{
return(ArchAngel.Providers.Database.Helper.Script.GetPlural(lookupValue.Alias));
}
public bool AliasDisplayValidate(LookupValue lookupValue, out string failReason)
{
failReason = "";
return(true);
}