private void loadFile()
{
string fileName = txtSRDPath.Text.Trim();
if (string.IsNullOrEmpty(fileName) || File.Exists(fileName) == false)
{
return;
}
var er = new ExcelReader();
var ds = er.GetDataSet(fileName);
if (ds == null)
{
txtSRDPath.SelectAll();
btnChooseSrd.Focus();
return;
}
var srd = Srd.Parse(ds);
bindingSource1.DataSource = srd;
propertiesBindingSource.DataSource = srd.Model.Properties;
//codeFilesBindingSource .List .RaiseListChangedEvents = true;
codeFilesBindingSource.DataSource = srd.CodeFiles;
MessageBox.Show("Load File Complete");
}
public static PropertiesColumns Create(DataTable dt)
{
PropertiesColumns pc = new PropertiesColumns();
int headerRow;
int headerColumn;
Srd.FindColumn(dt, "Property", out headerRow, out headerColumn);
pc.Row = headerRow;
pc.Property = headerColumn;
Srd.FindColumn(dt, "Display", out headerRow, out headerColumn);
pc.Display = headerColumn;
Srd.FindColumn(dt, "Helper Text", out headerRow, out headerColumn);
pc.HelperText = headerColumn;
Srd.FindColumn(dt, "UI Type", out headerRow, out headerColumn);
pc.UIType = headerColumn;
Srd.FindColumn(dt, "Required", out headerRow, out headerColumn);
pc.Required = headerColumn;
Srd.FindColumn(dt, "Default", out headerRow, out headerColumn);
pc.Default = headerColumn;
Srd.FindColumn(dt, "Rule", out headerRow, out headerColumn);
pc.Rule = headerColumn;
Srd.FindColumn(dt, "System Type", out headerRow, out headerColumn);
pc.SystemType = headerColumn;
Srd.FindColumn(dt, "Dependency", out headerRow, out headerColumn);
pc.Dependency = headerColumn;
Srd.FindColumn(dt, "DependencyLoading", out headerRow, out headerColumn);
pc.DependencyLoading = headerColumn;
Srd.FindColumn(dt, "Char Limit", out headerRow, out headerColumn);
pc.CharLimit = headerColumn;
Srd.FindColumn(dt, "CRUD Grid", out headerRow, out headerColumn);
pc.CRUDGrid = headerColumn;
Srd.FindColumn(dt, "BO-Access", out headerRow, out headerColumn);
pc.BOAccess = headerColumn;
Srd.FindColumn(dt, "API -Access", out headerRow, out headerColumn);
pc.APIAccess = headerColumn;
Srd.FindColumn(dt, "Service-Access", out headerRow, out headerColumn);
pc.ServiceAccess = headerColumn;
return(pc);
}
