internal bool LoadExclusionData()
{
string fileName = Application.ExecutablePath.ToUpper().Replace("DBS2QVLS.EXE", "Exclusions.xml");
ExclusionData.Clear();
ExclusionList.Clear();
ExclusionData.TableName = "ExclusionData";
if (File.Exists(fileName))
{
ExclusionData.ReadXml(fileName);
}
else
{
return(false);
}
foreach (DataRow row in ExclusionData.Rows)
{
ExclusionItem ei = new ExclusionItem();
ei.Row = (int)row["Row"];
ei.SourceTableName = Convert.IsDBNull(row["SourceTableName"]) ? "" : (string)row["SourceTableName"];
ei.SourceColumnName = Convert.IsDBNull(row["SourceColumnName"]) ? "" : (string)row["SourceColumnName"];
// ei.DestinationTableName = Convert.IsDBNull(row["DestinationTableName"]) ? "" : (string) row["DestinationTableName"];
// ei.DestinationColumnName = Convert.IsDBNull(row["DestinationColumnName"]) ? "" : (string) row["DestinationColumnName"];
ExclusionList.Add(ei);
}
return(true);
}
internal void SaveExclusionData(DataGridViewRow[] gridRows, string fileName)
{
ExclusionData.Clear();
ExclusionList.Clear();
foreach (DataGridViewRow row in gridRows)
{
if (row.IsNewRow)
{
continue;
}
DataRow dataRow = ExclusionData.NewRow();
ExclusionItem ei = new ExclusionItem();
dataRow["Row"] = (int)row.Cells[0].Value;
dataRow["SourceTableName"] = (string)row.Cells[1].Value;
dataRow["SourceColumnName"] = (string)row.Cells[2].Value;
// dataRow["DestinationTableName"] = (string) row.Cells[3].Value;
// dataRow["DestinationColumnName"] = (string) row.Cells[4].Value;
ExclusionData.Rows.Add(dataRow);
ei.Row = (int)row.Cells[0].Value;
ei.SourceTableName = (string)row.Cells[1].Value;
ei.SourceColumnName = (string)row.Cells[2].Value;
// ei.DestinationTableName = (string) row.Cells[3].Value;
// ei.DestinationColumnName = (string) row.Cells[4].Value;
ExclusionList.Add(ei);
}
DataView view = new DataView(ExclusionData);
view.Sort = "SourceTableName ASC, SourceColumnName ASC";
DataTable dt = view.ToTable();
dt.TableName = "ExclusionData";
dt.WriteXml(fileName, XmlWriteMode.WriteSchema);
dt.Dispose();
view.Dispose();
}