private void CRMForm_Load(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);
dataContext = new CRMOntologyContext(connectionString);
client = BrightstarService.GetClient(connectionString);
//getPredicates
XDocument xDoc = dataContext.ExecuteQuery("SELECT DISTINCT ?predicate WHERE { ?x ?predicate ?y.}");
foreach (var sparqlResultRow in xDoc.SparqlResultRows())
{
string result = sparqlResultRow.GetColumnValue("predicate").ToString();
//beautify
if (result.IndexOf(URI) >= 0)
{
treeViewOntology.Nodes[0].Nodes[0].Nodes.Add(result, result.Replace(URI + "/", "").Replace("#", ""));
treeViewOntology.Nodes[0].Nodes[1].Nodes.Add(result, result.Replace(URI + "/", "").Replace("#", ""));
}
}
}
public static object GetCustomerSegment(int ObjectTypeCode, Guid ObjectId, CRMOntologyContext DataContext)
{
//sales modules needs to apply to calculate segmentation
//rules are;
//each sales order has 2 coin and each invoice has 4 coins and each quote has 1 coin
//FullfillLevel.high = 100 coin or FullfillLevel.low = 20 coin or FullfillLevel.medium = 50 coin
//if total number between 501 - 1001, segment will be GOLD
//if total number above 1001, segment will be PREMIUM
//if total number between 1 - 500, segment will be SILVER
Random random = new Random();
switch (random.Next(1, 3))
{
case 1:
return(DataContext.Golds.Create());;
case 2:
return(DataContext.Silvers.Create());
case 3:
return(DataContext.Premiums.Create());
default: return(null);
}
}
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();
}