private void connectBtnClicked(object sender, EventArgs e)
{
if (_currentConnection == null)
{
return;
}
toolStripStatusLabel1.Text = string.Format("Connecting to {0}...", _currentConnection.Name);
statusStrip1.Refresh();
Cursor.Current = Cursors.WaitCursor;
try
{
tablesListBox.DataSource = null;
tablesListBox.DisplayMember = "Name";
sequencesComboBox.Items.Clear();
metadataReader = MetadataFactory.GetReader(_currentConnection.Type, _currentConnection.ConnectionString);
toolStripStatusLabel1.Text = "Retrieving owners...";
statusStrip1.Refresh();
PopulateOwners();
toolStripStatusLabel1.Text = string.Empty;
}
catch (Exception ex)
{
toolStripStatusLabel1.Text = ex.Message;
}
finally
{
Cursor.Current = Cursors.Default;
}
}
public void ShouldCreateTheAppropriateMetadataReader()
{
IMetadataReader metadataReader = MetadataFactory.GetReader(ServerType.Oracle, "conn");
Assert.That(metadataReader, Is.TypeOf(typeof (OracleMetadataReader)));
metadataReader = MetadataFactory.GetReader(ServerType.SqlServer, "conn");
Assert.That(metadataReader, Is.TypeOf(typeof (SqlServerMetadataReader)));
}
private void openMetadataToolStripMenuItem_Click(object sender, System.EventArgs e)
{
var cfg = Configuration.Project.Directories[Configuration.DirectoryCollection.DirectoryType.Metadata];
using (var ofd = new OpenFileDialog())
{
ofd.InitialDirectory = cfg.FullPath;
ofd.FileName = cfg.File;
ofd.Filter = "CSV|*.csv|Excel 97-2003|*.xls";
if (!string.IsNullOrEmpty(cfg.File))
{
ofd.FilterIndex = cfg.File.EndsWith("csv") ? 1 : 2;
}
if (ofd.ShowDialog() == DialogResult.OK)
{
var mr = MetadataFactory.GetReader(ofd.FileName);
var openMetadataDetailsForm = new MetadataOpen();
if (mr.SupportSheets)
{
openMetadataDetailsForm.MetadataReader = mr;
openMetadataDetailsForm.ShowDialog();
}
StartClick(null);
metadataTreeview.Nodes.Clear();
mr.ProgressStatusChanged += new ProgressStatusHandler(ProgressStatus);
Metadata = mr.Read();
mr.ProgressStatusChanged -= new ProgressStatusHandler(ProgressStatus);
metadataTreeview.Content = Metadata;
if (mr.SupportSheets && openMetadataDetailsForm.Track != "None")
{
var perspTrack = mr.Read(openMetadataDetailsForm.Track);
metadataTreeview.Selection = perspTrack;
}
cfg.FullFileName = ofd.FileName;
EndClick(null);
}
}
}
private void generateMapclass()
{
var Mapclasssettings = new Connection();
string mapTempPath = Path.GetTempPath();
if (mapTempPath.EndsWith(@"\") == false)
{
mapTempPath += @"\";
}
mapTempPath += @"Mapping\";
if (Directory.Exists(mapTempPath) == false)
{
Directory.CreateDirectory(mapTempPath);
}
Mapclasssettings.Domainfolderpath = mapTempPath;
Mapclasssettings.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"];
Mapclasssettings.EntityName = "Entity";
if ((RecoEngine_BI.Common.iDBType) == (int)Enums.DBType.Oracle)
{
Mapclasssettings.Type = ServerType.Oracle;
}
metadataReader = MetadataFactory.GetReader(Mapclasssettings.Type, Mapclasssettings.ConnectionString);
var owners = metadataReader.GetOwners();
IList <Table> tblList = metadataReader.GetTables("RECOUSR");
int tableindex = 0;
for (int i = 0; i < tblList.Count; i++)
{
if (tblList[i].Name == "OPPORTUNITY")
{
tableindex = i;
break;
}
}
Table table = tblList[tableindex];
table.PrimaryKey = metadataReader.DeterminePrimaryKeys(table);
metadataReader.GetTableDetails(table, "RECOUSR");
var applicationPreferences = GetApplicationPreferences(table, false, Mapclasssettings);
new ApplicationController(applicationPreferences, table).Generate();
}
private void connectBtnClicked(object sender, EventArgs e)
{
errorLabel.Text = string.Empty;
Cursor.Current = Cursors.WaitCursor;
try
{
tablesListBox.Items.Clear();
sequencesComboBox.Items.Clear();
metadataReader = MetadataFactory.GetReader((ServerType)serverTypeComboBox.SelectedItem,
connStrTextBox.Text);
PopulateOwners();
PopulateTablesAndSequences();
}
catch (Exception ex)
{
errorLabel.Text = ex.Message;
}
finally
{
Cursor.Current = Cursors.Default;
}
}
