private void btnStartTransfer_Click(object sender, EventArgs e)
{
// Initialise license and stores directory location
Configuration.Register();
//create a unique store name
var storeName = "CRM_Ontology";
//connection string to the BrightstarDB service
string connectionString =
string.Format(@"Type=embedded;storesDirectory={0};StoreName={1};", Configuration.StoresDirectory,
storeName);
OWLTransfer transfer = new OWLTransfer();
transfer.StartTransfer(connectionString);
}
private void listViewResult_SelectedIndexChanged(object sender, EventArgs e)
{
////set loading animated gif to richtext field
//LoadingDataForm dataForm = new LoadingDataForm();
//dataForm.Location = new Point(Convert.ToInt32(richTextBox1.Location.X * 1.25),Convert.ToInt32(richTextBox1.Location.Y * 1.25));
//dataForm.Show(this);
richTextBoxObject.Text = "";
richTextBoxSubject.Text = "";
CRMOntology.DataAccessLayer.CRMOntology_StagingEntities SQLServerContext = new DataAccessLayer.CRMOntology_StagingEntities();
// Initialise license and stores directory location
Configuration.Register();
//create a unique store name
var storeName = "CRM_Ontology";
//connection string to the BrightstarDB service
string connectionString =
string.Format(@"Type=embedded;storesDirectory={0};StoreName={1};", Configuration.StoresDirectory,
storeName);
OWLTransfer transfer = new OWLTransfer();
CRMOntologyContext OntologyContext = new CRMOntologyContext(connectionString);
for (int i = 0; i < listViewResult.SelectedItems.Count; i++)
{
string strObject = listViewResult.SelectedItems[i].Text;
string strSubject = listViewResult.SelectedItems[i].SubItems.Count == 3 ? listViewResult.SelectedItems[i].SubItems[2].Text : "";
string[] strSplit = strObject.Split('#');
if (strSplit != null && strSplit.Length == 2)
{
//Object
richTextBoxObject.AppendText(string.Format("Object {0} - {1}", strSplit[0], Environment.NewLine));
DataSet ds = transfer.RetrieveRecordFromMapOWL(SQLServerContext, OntologyContext, Guid.Parse(strSplit[1]), strSplit[0]);
if (ds != null)
{
foreach (DataTable dt in ds.Tables)
{
foreach (DataRow drow in dt.Rows)
{
foreach (DataColumn dc in dt.Columns)
{
richTextBoxObject.AppendText(string.Format("{0} = {1}{2}", dc.ColumnName, drow[dc].ToString(), Environment.NewLine));
}
}
}
}
else
{
richTextBoxObject.AppendText(string.Format("No Record found... {0}", Environment.NewLine));
}
}
else
{
richTextBoxSubject.AppendText(string.Format("Subject {0}{1}", strObject, Environment.NewLine));
}
strSplit = strSubject.Split('#');
if (strSplit != null && strSplit.Length == 2)
{
//Subject
richTextBoxSubject.AppendText(string.Format("Subject {0}{1}", strSplit[0], Environment.NewLine));
DataSet ds = transfer.RetrieveRecordFromMapOWL(SQLServerContext, OntologyContext, Guid.Parse(strSplit[1]), strSplit[0]);
if (ds != null)
{
foreach (DataTable dt in ds.Tables)
{
foreach (DataRow drow in dt.Rows)
{
foreach (DataColumn dc in dt.Columns)
{
richTextBoxSubject.AppendText(string.Format("{0} = {1}{2}", dc.ColumnName, drow[dc].ToString(), Environment.NewLine));
}
}
}
}
else
{
richTextBoxSubject.AppendText(string.Format("No Record found... {0}", Environment.NewLine));
}
}
else
{
richTextBoxSubject.AppendText(string.Format("Subject {0}{1}", strSubject, Environment.NewLine));
}
}
// Shutdown Brightstar processing threads.
BrightstarDB.Client.BrightstarService.Shutdown();
//dataForm.Close();
//dataForm.Dispose();
}
