/// <summary>
/// Cancel button closes this dialog
/// </summary>
/// <param name="sender">Object that fired the event</param>
/// <param name="e">.NET supplied event parameters</param>
private void btnCancel_Click(object sender, System.EventArgs e)
{
this.project = null;
this.MetaDataProvider = null;
this.SelectedTable = null;
this.Close();
}
/// <summary>
/// Returns the source data for this DDL
/// </summary>
/// <returns>Source Data</returns>
public DataTable GetSourceData()
{
if (string.IsNullOrEmpty(SourceTableName))
{
return(null);
}
DataTable dataTable = new DataTable();
View view = this.view;
Page page = ((RenderableField)this).Page;
Epi.Data.Services.IMetadataProvider metadata = view.GetMetadata();
string tableName = SourceTableName;
Project project = this.GetProject();
string filterExpression = string.Empty;
if (project.CollectedData.TableExists(tableName) == false)
{
string separator = " - ";
if (tableName.Contains(separator))
{
string[] view_page = tableName.Replace(separator, "^").Split('^');
string viewName = view_page[0].ToString();
string pageName = view_page[1].ToString();
View targetView = project.Metadata.GetViewByFullName(viewName);
if (targetView == null)
{
return(null);
}
DataTable targetPages = project.Metadata.GetPagesForView(targetView.Id);
DataView dataView = new DataView(targetPages);
filterExpression = string.Format("Name = '{0}'", pageName);
DataRow[] pageArray = targetPages.Select(filterExpression);
if (pageArray.Length > 0)
{
int pageId = (int)pageArray[0]["PageId"];
tableName = viewName + pageId;
}
}
}
if (this.GetProject().CollectedData.TableExists(tableName))
{
dataTable = GetProject().GetTableData(tableName);
}
return(dataTable);
}
/// <summary>
/// Dialog to select a tble
/// </summary>
/// <param name="frm">The main form</param>
public TableSelectionDialog(Epi.Windows.MakeView.Forms.MakeViewMainForm frm)
: base(frm)
{
// This call is required by the Windows Form Designer.
InitializeComponent();
if (frm.projectExplorer != null)
{
if (frm.projectExplorer.currentPage != null)
{
this.project = frm.projectExplorer.currentPage.view.Project;
this.MetaDataProvider = this.project.Metadata;
}
}
}
/// <summary>
/// Dialog to select a tble
/// </summary>
/// <param name="frm">The main form</param>
public TableSelectionDialog(Epi.Windows.MakeView.Forms.MakeViewMainForm frm)
: base(frm)
{
// This call is required by the Windows Form Designer.
InitializeComponent();
if (frm.projectExplorer != null)
{
if (frm.projectExplorer.currentPage != null)
{
this.project = frm.projectExplorer.currentPage.view.Project;
this.MetaDataProvider = this.project.Metadata;
}
}
}
private void Button3_Click(object sender, EventArgs e)
{
OpenFileDialog openFileDialog = new OpenFileDialog();
// openFileDialog.Filter = "Epi2000 and Epi7 Project Files (*.mdb;*.prj)|*.mdb;*.prj|Epi2000 Project files (*.mdb)|*.mdb |Epi7 Project Files (*.prj)|*.prj";
#if LINUX_BUILD
openFileDialog.Filter = "*.prj";
#else
openFileDialog.Filter = "Epi2000 and Epi7 Project Files (*.mdb;*.prj)|*.mdb;*.prj|Epi2000 Project files (*.mdb)|*.mdb|Epi7 Project Files (*.prj)|*.prj";
#endif
openFileDialog.FilterIndex = 1;
openFileDialog.Multiselect = false;
DialogResult res = openFileDialog.ShowDialog();
if (res == DialogResult.OK)
{
string filePath = openFileDialog.FileName.Trim();
System.Collections.Generic.List <string> TableList;
if (filePath.EndsWith(".prj"))
{
this.project = new Project(filePath);
this.MetaDataProvider = this.project.Metadata;
TableList = this.project.Metadata.GetDataTableList();
}
else
{
// to do
TableList = new System.Collections.Generic.List <string>();
TableList.Add("to do add datatables for non epi7 projects");
}
ListBox1.Items.Clear();
this.Text = "Selected Project: " + this.project.Name;
foreach (string t in TableList)
{
if (!string.IsNullOrEmpty(t))
{
ListBox1.Items.Add(t);
}
}
}
}
/// <summary>
/// Cancel button closes this dialog
/// </summary>
/// <param name="sender">Object that fired the event</param>
/// <param name="e">.NET supplied event parameters</param>
private void btnCancel_Click(object sender, System.EventArgs e)
{
this.project = null;
this.MetaDataProvider = null;
this.SelectedTable = null;
this.Close();
}
private void Button3_Click(object sender, EventArgs e)
{
OpenFileDialog openFileDialog = new OpenFileDialog();
// openFileDialog.Filter = "Epi2000 and Epi7 Project Files (*.mdb;*.prj)|*.mdb;*.prj|Epi2000 Project files (*.mdb)|*.mdb |Epi7 Project Files (*.prj)|*.prj";
#if LINUX_BUILD
openFileDialog.Filter = "*.prj";
#else
openFileDialog.Filter = "Epi2000 and Epi7 Project Files (*.mdb;*.prj)|*.mdb;*.prj|Epi2000 Project files (*.mdb)|*.mdb|Epi7 Project Files (*.prj)|*.prj";
#endif
openFileDialog.FilterIndex = 1;
openFileDialog.Multiselect = false;
DialogResult res = openFileDialog.ShowDialog();
if (res == DialogResult.OK)
{
string filePath = openFileDialog.FileName.Trim();
System.Collections.Generic.List<string> TableList;
if (filePath.EndsWith(".prj"))
{
this.project = new Project(filePath);
this.MetaDataProvider = this.project.Metadata;
TableList = this.project.Metadata.GetDataTableList();
}
else
{
// to do
TableList = new System.Collections.Generic.List<string>();
TableList.Add("to do add datatables for non epi7 projects");
}
ListBox1.Items.Clear();
this.Text = "Selected Project: " + this.project.Name;
foreach (string t in TableList)
{
if (!string.IsNullOrEmpty(t))
{
ListBox1.Items.Add(t);
}
}
}
}
