public static int InsertCaptureEventForTextConversion(AdvancedRecomendation captureEvent, ReplacementEvent replacementEvent)
{
int returnCode = -1;
int RecommendationId = InsertRecommendationForTextConversion(captureEvent);
int CapturePointId = Rec_CapturePoints_TextConv.InsertCapturePointsForTextConversion(RecommendationId, captureEvent.CaptureEventCapturePointsList);
replacementEvent.capturePointId = RecommendationId;
Advanced_Replacements_TextConv.InsertNewReplacementForTextConversion(replacementEvent);
return returnCode;
}
public static void SaveCaptureEventByIdForTextConversion(int captureEventId, AdvancedRecomendation captureEvent, ReplacementEvent replacementEvent)
{
SqlCeTransaction transaction;
SqlCeConnection conn = BackEndUtils.GetSqlConnection();
try {
conn.Open();
transaction = conn.BeginTransaction();
try {
UpdateRecommendationByIdForTextConversion(captureEventId, captureEvent, conn, transaction);
Rec_CapturePoints_TextConv.DeletAllRespectiveCapturePointsForTextConversion(captureEventId, conn, transaction);
Rec_CapturePoints_TextConv.InsertCapturePointsAsTransactionForTextConversion(captureEventId, captureEvent.CaptureEventCapturePointsList, conn, transaction);
replacementEvent.capturePointId = captureEventId;
Advanced_Replacements_TextConv.SaveReplacementEventForTextConversion(replacementEvent, conn, transaction);
transaction.Commit();
} catch (Exception ex) {
CommonUtils.LogError(ex.Message, ex);
transaction.Rollback();
}
} finally {
conn.Close();
}
}
private static void UpdateRecommendationById(int captureEventId, AdvancedRecomendation advancedRecomendation, SqlCeConnection conn, SqlCeTransaction transaction)
{
int value = 0;
SqlCeCommand command = new SqlCeCommand(Advanced_Recommendations_SQL.commandUpdateRecommendationById, conn);
command.Transaction = transaction;
command.Parameters.Add("@name", advancedRecomendation.CaptureEventName);
command.Parameters.Add("@description", advancedRecomendation.CaptureEventDescription);
command.Parameters.Add("@event_text", advancedRecomendation.CaptureEventEventText);
command.Parameters.Add("@id", captureEventId);
command.Parameters.Add("@categoryId", advancedRecomendation.captureEventCategory);
command.Parameters.Add("@usageCount", advancedRecomendation.captureEventUsageCount);
command.Parameters.Add("@userId", FrontendUtils.LoggedInUserId);
value = Convert.ToInt32(command.ExecuteNonQuery());
}
private static AdvancedRecomendation GetAdvancedRecommendationItem(DataRow advancedRecRow, DataTable capturePointsTable, SqlCeConnection conn)
{
List<CustomTreeNode> customCapturePointList = BackEndUtils.GetCustomCapturePointListFromTable(capturePointsTable);
AdvancedRecomendation capture = new AdvancedRecomendation(Convert.ToInt32(advancedRecRow["id"]), advancedRecRow["name"].ToString(), advancedRecRow["description"].ToString(), advancedRecRow["event_text"].ToString(), Convert.ToInt32(advancedRecRow["categoryId"]), Convert.ToInt32(advancedRecRow["usageCount"]), customCapturePointList, FrontendUtils.LoggedInUserId);
capture.Replacement = Advanced_Replacements.GetReplacementEventByCaptureEventId(capture.CaptureEventId, conn);
return capture;
}
public static int InsertCaptureEvent(AdvancedRecomendation advancedRecomendation)
{
int returnCode = -1;
int RecommendationId = InsertRecommendation(advancedRecomendation);
int CapturePointId = Rec_CapturePoints.InsertCapturePoints(RecommendationId, advancedRecomendation.CaptureEventCapturePointsList);
return returnCode;
}
private void ParseUsingAdvancedList(AdvancedRecomendation captureEvent, XDocument xdoc)
{
var test21 = from c1 in xdoc.Descendants(captureEvent.CaptureEventCapturePointsList[0].Text)
where AllAttributesAvailable(c1, captureEvent.CaptureEventCapturePointsList[0].customizedAttributeCollection)
select new {
elements = c1.DescendantNodesAndSelf()
};
List<bool> foundlist = new List<bool>();
for (int i = 0; i < test21.Count(); i++) {
bool found = true;
XNode node = test21.ElementAt(i).elements.ElementAt(0);
XmlReader Xreader = node.CreateReader();
Xreader.Read();
while (Xreader.Read() && found) {
if (Xreader.NodeType == XmlNodeType.Element) {
for (int listLength = 1; found && listLength < captureEvent.CaptureEventCapturePointsList.Count; listLength++) {//Xreader.Name;
if (!captureEvent.CaptureEventCapturePointsList[listLength].nodeVisited && string.Equals(captureEvent.CaptureEventCapturePointsList[listLength].Text, Xreader.Name)) {
captureEvent.CaptureEventCapturePointsList[listLength].nodeVisited = true;
#region Loop Thru attributes
for (int attrCoun = 0; found && attrCoun < captureEvent.CaptureEventCapturePointsList[listLength].customizedAttributeCollection.Count; attrCoun++) {
CustomizedAttribute customizedAttribute = captureEvent.CaptureEventCapturePointsList[listLength].customizedAttributeCollection[attrCoun];
string attributeValueFromXml = Xreader.GetAttribute(customizedAttribute.attrName);
if (string.IsNullOrEmpty(attributeValueFromXml) && !string.IsNullOrEmpty(customizedAttribute.attrName)) {
found = false;
} else if (!string.Equals(attributeValueFromXml, customizedAttribute.attrValue) && !string.IsNullOrEmpty(customizedAttribute.attrName)) {
found = false;
}
}
listLength = captureEvent.CaptureEventCapturePointsList.Count;
#endregion
}
}
}
}
foundlist.Add(found);
}
//txtFoundEvents.Text = string.Empty;
//for (int k = 0; k < foundlist.Count; k++) {
// if (foundlist[k]) {
// XNode node = test21.ElementAt(k).elements.ElementAt(0);
// txtFoundEvents.Text = txtFoundEvents.Text + (string.IsNullOrEmpty(txtFoundEvents.Text) ? "" : "\r\n") + FrontendUtils.FormatXml(node.ToString());
// }
//}
}
private void lbAdvancedCE_SelectedIndexChanged_1(object sender, EventArgs e)
{
try {
captureNodesSelectedNames = new List<string>();
AdvancedRecomendation captureEvent = new AdvancedRecomendation();
captureEvent = lbAdvancedCE.SelectedItem as AdvancedRecomendation;
if (captureEvent != null) {
btnAddCaptureEvent.Enabled = false;
btnSaveCaptureEvent.Enabled = true;
txtAOEventIn.ReadOnly = true;
tvOutput.Nodes.Clear();
dgvAttributes.Rows.Clear();
AdvancedRecomendation workingEvent = new AdvancedRecomendation(captureEvent.CaptureEventId,
captureEvent.CaptureEventName,
captureEvent.CaptureEventDescription,
captureEvent.CaptureEventEventText,
captureEvent.captureEventCategory,
captureEvent.captureEventUsageCount,
captureEvent.CaptureEventCapturePointsList,
captureEvent.captureEventuserId);
CurrentlySelectedCaptureEvent = workingEvent;
for (int i = 0; i < captureEvent.CaptureEventCapturePointsList.Count; i++) {
captureEvent.CaptureEventCapturePointsList[i].nodeVisited = false;
}
cboCaptureType.SelectedValue = captureEvent.captureEventCategory;
txtAOName.Text = workingEvent.CaptureEventName;
txtAODescription.Text = workingEvent.CaptureEventDescription;
txtAOEventIn.Text = workingEvent.CaptureEventEventText;
InterpretCaptureEvent(workingEvent);
RecurResetTag(tvOutput.Nodes);
if (captureEvent.captureEventCategory == (int)AdvancedRecomendationCategory.Verbal) {
// setup validation and ui for verbal recommendations
ConfigureToValidateXml = false;
} else {
ConfigureToValidateXml = true;
}
}
} catch (Exception ex) {
CommonUtils.ShowError(ex.Message, ex);
}
}
private CustomTreeNode GetRespectiveCapturePoint(CustomTreeNode customTreeNode, AdvancedRecomendation captureEvent, XmlNode xNode, int index, int level, int parentIndex, int parentLevel)
{
for (int i = 1; i < captureEvent.CaptureEventCapturePointsList.Count; i++) {
if (captureEvent.CaptureEventCapturePointsList[i].nodeIndex == index &&
captureEvent.CaptureEventCapturePointsList[i].nodeLevel == level &&
captureEvent.CaptureEventCapturePointsList[i].parentIndex == parentIndex &&
captureEvent.CaptureEventCapturePointsList[i].parentLevel == parentLevel) {
if (string.Equals(captureEvent.CaptureEventCapturePointsList[i].Text, xNode.Name)) {
if ((captureNodesSelectedNames.Count < captureEvent.CaptureEventCapturePointsList.Count - 1) || (!captureNodesSelectedNames.Contains(xNode.Name))) {
customTreeNode.customizedAttributeCollection = captureEvent.CaptureEventCapturePointsList[i].customizedAttributeCollection;
customTreeNode.isNodeUsed = captureEvent.CaptureEventCapturePointsList[i].isNodeUsed;
if ((level == 2) && (!string.Equals(captureNodesSelectedNames[captureNodesSelectedNames.Count - 1], xNode.Name))) {
captureNodesSelectedNames.Add(xNode.Name);
} else if (level < 2) {
captureNodesSelectedNames.Add(xNode.Name);
}
}
}
}
}
return customTreeNode;
}
private void ParseTargetedFile(AdvancedRecomendation captureEvent, string readText, ComplexCaptureMatchObject complexCaptureMatchObject, string fileName)
{
captureEvent = GetCapturePointListType(captureEvent);
XDocument xdoc = XDocument.Parse(readText);
List<string> foundEvents = new List<string>();
if (captureEvent.capturePointListType == CapturePointListType.SimpleList) {
List<XNode> foundNodes = ParseUsingSimpleList(captureEvent, xdoc, foundEvents);
totalFoundNodes = totalFoundNodes + foundNodes.Count;
if (foundNodes.Count > 0) {
FileAndNumberOfMatches fileAndNumberOfMatches = new FileAndNumberOfMatches();
fileAndNumberOfMatches.fileName = fileName;
fileAndNumberOfMatches.matchedNodes = foundNodes;
complexCaptureMatchObject.fileNamesHit.Add(fileAndNumberOfMatches);
}
} else {
List<XNode> foundNodes = ParseUsingAdvancedList(captureEvent, xdoc);
totalFoundNodes = totalFoundNodes + foundNodes.Count;
if (foundNodes.Count > 0) {
FileAndNumberOfMatches fileAndNumberOfMatches = new FileAndNumberOfMatches();
fileAndNumberOfMatches.fileName = fileName;
fileAndNumberOfMatches.matchedNodes = foundNodes;
complexCaptureMatchObject.fileNamesHit.Add(fileAndNumberOfMatches);
}
}
}
private void lvAdvancedRules_ItemSelectionChanged(object sender, ListViewItemSelectionChangedEventArgs e)
{
try {
//tag contains rec id
if ((sender as ListView).SelectedItems.Count != 0) {
//currentlySelectedEvent = BackEndUtils.SelectAdvancedRecById((sender as ListView).SelectedItems[0].Tag);
currentlySelectedEvent = currentlyLoadedEvents[Convert.ToInt32((sender as ListView).SelectedItems[0].Tag)];
SetupUiFromCapturePoint(currentlySelectedEvent);
}
} catch (Exception ex) {
CommonUtils.ShowError(ex.Message, ex);
}
}
private void LoadAvailableAdvancedRecommendations()
{
lvAdvancedRules.Clear();
DataSet dataSet = Advanced_Recommendation_Categories.GetAllAdvancedRecCategoriesAsDataset();
foreach (DataRow dataRow in dataSet.Tables[0].Rows) {
lvAdvancedRules.Groups.Add(dataRow["id"].ToString(), dataRow["enumerationName"].ToString());
}
AllCategories = dataSet;
DataSet newDataSet = Advanced_Recommendations.GetAllAdvancedRecsAsDataSet();
currentlyLoadedEvents = new Dictionary<int, AdvancedRecomendation>();
foreach (DataRow dataRow in newDataSet.Tables[0].Rows) {
System.Windows.Forms.ListViewItem item = lvAdvancedRules.Items.Add(dataRow["id"].ToString(), dataRow["name"].ToString(), 0);
item.Group = lvAdvancedRules.Groups[dataRow["categoryId"].ToString()];
item.Tag = dataRow["id"].ToString();//tag holding the id of the rec
item.ImageIndex = 1;
AdvancedRecomendation capture = new AdvancedRecomendation();
capture.CaptureEventId = Convert.ToInt32(item.Tag);
capture.CaptureEventName = dataRow["name"].ToString();
capture.CaptureEventDescription = dataRow["description"].ToString();
capture.captureEventUsageCount = Convert.ToInt32(dataRow["usageCount"]);
currentlyLoadedEvents.Add(Convert.ToInt32(item.Tag), capture);
}
AllAdvancedRecs = newDataSet;
CAPTURE_TOTAL_USAGE_COUNT = Advanced_Recommendations.GetTotalAdvanceRecUsageCount();
}
private void btnResetForm_Click(object sender, EventArgs e)
{
try {
btnStart.Enabled = true;
currentlySelectedEvent = new AdvancedRecomendation();
currentlyUsedCaptures = new List<AdvancedRecomendation>();
backGroundWorkerObject = new BackGroundWorkerObject();
totalFoundNodes = 0;
lblFoundNodesCound.Text = 0 + "";
dgvSearchResult.Rows.Clear();
dgvSearchResult.Visible = false;
btnProceedToReplacement.Visible = false;
btnResetForm.Visible = false;
pbPercentComplete.Visible = true;
pbPercentComplete.Value = 0;
LoadAvailableAdvancedRecommendations();
pcProgress.Visible = false;
pcProgress.Clear();
pcProgress.Rotate = false;
DataSet AllCategories = new DataSet();
DataSet AllAdvancedRecs = new DataSet();
lvAdvancedRules.Focus();
txtRuleDescription.ResetText();
txtRuleName.ResetText();
srcPopularityAdded.m_hoverStar = 0;
srcPopularityAdded.m_selectedStar = 0;
srcPopularityAdded.Invalidate();
} catch (Exception ex) {
CommonUtils.ShowError(ex.Message, ex);
}
}
private void SetupUiFromCapturePoint(AdvancedRecomendation capture)
{
txtRuleName.Text = capture.CaptureEventName;
txtRuleDescription.Text = capture.CaptureEventDescription;
SetPopularity(capture);
}
private void SetPopularity(AdvancedRecomendation capture)
{
srcPopularityAdded.m_hoverStar = 0;
srcPopularityAdded.m_selectedStar = 0;
srcPopularityAdded.Invalidate();
double usagePercent = ((double)capture.captureEventUsageCount / CAPTURE_TOTAL_USAGE_COUNT) * 20;
srcPopularityAdded.m_hoverStar = (int)usagePercent;
srcPopularityAdded.m_selectedStar = (int)usagePercent;
srcPopularityAdded.m_hovering = true;
srcPopularityAdded.Invalidate();
}
private void SelectAllAvailableAdvancedRules()
{
//0 => green
//1 => red
foreach (System.Windows.Forms.ListViewItem item in lvAdvancedRules.Items) {
item.ImageIndex = 0;
//currentlySelectedEvent = BackEndUtils.SelectAdvancedRecById(item.Tag);
currentlySelectedEvent = currentlyLoadedEvents[Convert.ToInt32(item.Tag)];
currentlyUsedCaptures = AddCapturePointToList(currentlyUsedCaptures, currentlySelectedEvent);
}
}
private void FillReplacementsListBox(AdvancedRecomendation selectedAdvancedRec)
{
int savedIndex = 0;
if (lbAvailableReplacements.SelectedIndex !=null) {
savedIndex = lbAvailableReplacements.SelectedIndex;
}
lbAvailableReplacements.Items.Clear();
List<ReplacementEvent> availableReplacements = Advanced_Replacements.GetAvailableReplacementsByCaptureId(selectedAdvancedRec.CaptureEventId, BackEndUtils.GetSqlConnection());
for (int i = 0; i < availableReplacements.Count; i++) {
lbAvailableReplacements.Items.Add(availableReplacements[i]);
}
lbAvailableReplacements.SelectedIndex = savedIndex;
}
private AdvancedRecomendation GetCapturePointListType(AdvancedRecomendation captureEvent)
{
List<CustomTreeNode> list = captureEvent.CaptureEventCapturePointsList;
captureEvent.capturePointListType = CapturePointListType.SimpleList;
for (int listCount = 1; listCount < list.Count; listCount++) {
if (list[listCount - 1].nodeLevel > list[listCount].nodeLevel) {
captureEvent.capturePointListType = CapturePointListType.ListWithMutlipleDesc;
return captureEvent;
}
}
return captureEvent;
}
private List<AdvancedRecomendation> AddCapturePointToList(List<AdvancedRecomendation> currentlyUsedCaptures, AdvancedRecomendation currentlySelectedEvent)
{
bool found = false;
if (currentlyUsedCaptures.Count == 0) {
currentlyUsedCaptures.Add(currentlySelectedEvent);
} else {
for (int i = 0; i < currentlyUsedCaptures.Count && !found; i++) {
if (currentlyUsedCaptures[i].CaptureEventId == currentlySelectedEvent.CaptureEventId) {
found = true;
}
if (!found && i == currentlyUsedCaptures.Count - 1) {
currentlyUsedCaptures.Add(currentlySelectedEvent);
}
}
}
return currentlyUsedCaptures;
}
private void InterpretCaptureEvent(AdvancedRecomendation captureEvent)
{
ParseEventFromDatabase(captureEvent);
CustomTreeNode[] customArray = new CustomTreeNode[captureEvent.CaptureEventCapturePointsList.Count];
captureEvent.CaptureEventCapturePointsList.CopyTo(customArray);
RestoreSelectedCapturePoints(customArray, tvOutput.Nodes);
}
private void showDetailsFormToolStripMenuItem_Click(object sender, EventArgs e)
{
try {
AdvancedRecomendation obj = new AdvancedRecomendation();
ShowSearchDetailsForm form = new ShowSearchDetailsForm(obj);
form.MdiParent = this;
form.Show();
} catch (Exception ex) {
FrontendUtils.ShowError(ex.Message, ex);
}
}
private void ParseEventFromDatabase(AdvancedRecomendation captureEvent)
{
xmlDocument = XDocument.Parse(captureEvent.CaptureEventEventText);
populateTreeviewSingleEventFromDatabase(xmlDocument.ToString(), captureEvent);
//IEnumerable<XElement> childred =
// object patterns = xmlDocument.XPathEvaluate(@"MXClientScript\Events");
IEnumerable<XElement> children = xmlDocument.Elements();
}
private string ParseTargetedFile(AdvancedRecomendation captureEvent, string readText)
{
captureEvent = GetCapturePointListType(captureEvent);
XDocument xdoc = XDocument.Parse(readText);
List<string> foundEvents = new List<string>();
List<XNode> foundNodes = new List<XNode>();
if (captureEvent.capturePointListType == CapturePointListType.SimpleList) {
foundNodes = ParseUsingSimpleList(captureEvent, xdoc, foundEvents);
if (foundNodes.Count > 0) {
FileAndNumberOfMatches fileAndNumberOfMatches = new FileAndNumberOfMatches();
fileAndNumberOfMatches.matchedNodes = foundNodes;
}
} else {
foundNodes = ParseUsingAdvancedList(captureEvent, xdoc);
if (foundNodes.Count > 0) {
FileAndNumberOfMatches fileAndNumberOfMatches = new FileAndNumberOfMatches();
fileAndNumberOfMatches.matchedNodes = foundNodes;
}
}
ReplaceFoundNodes(captureEvent.Replacement, foundNodes);
return xdoc.ToString();
}
private void ParseUsingSimpleList(AdvancedRecomendation captureEvent, XDocument xdoc, List<string> foundEvents)
{
switch (captureEvent.CaptureEventCapturePointsList.Count) {
case 1:
var q1 = from c1 in xdoc.Descendants(captureEvent.CaptureEventCapturePointsList[0].Text)
where AllAttributesAvailable(c1, captureEvent.CaptureEventCapturePointsList[0].customizedAttributeCollection)
select new {
elements = c1.DescendantNodesAndSelf()
};
for (int i = 0; i < q1.Count(); i++) {
foundEvents.Add(q1.ElementAt(i).elements.ElementAt(0).ToString());
}
break;
case 2:
var q2 = from c1 in xdoc.Descendants(captureEvent.CaptureEventCapturePointsList[0].Text)
where AllAttributesAvailable(c1, captureEvent.CaptureEventCapturePointsList[0].customizedAttributeCollection)
from c2 in c1.Elements(captureEvent.CaptureEventCapturePointsList[1].Text)
where AllAttributesAvailable(c2, captureEvent.CaptureEventCapturePointsList[1].customizedAttributeCollection)
select new {
elements = c1.DescendantNodesAndSelf()
};
for (int i = 0; i < q2.Count(); i++) {
foundEvents.Add(q2.ElementAt(i).elements.ElementAt(0).ToString());
}
break;
case 3:
var q3 = from c1 in xdoc.Descendants(captureEvent.CaptureEventCapturePointsList[0].Text)
where AllAttributesAvailable(c1, captureEvent.CaptureEventCapturePointsList[0].customizedAttributeCollection)
from c2 in c1.Elements(captureEvent.CaptureEventCapturePointsList[1].Text)
where AllAttributesAvailable(c2, captureEvent.CaptureEventCapturePointsList[1].customizedAttributeCollection)
from c3 in c2.Elements(captureEvent.CaptureEventCapturePointsList[2].Text)
where AllAttributesAvailable(c3, captureEvent.CaptureEventCapturePointsList[2].customizedAttributeCollection)
select new {
elements = c1.DescendantNodesAndSelf()
};
for (int i = 0; i < q3.Count(); i++) {
foundEvents.Add(q3.ElementAt(i).elements.ElementAt(0).ToString());
}
break;
case 4:
var q4 = from c1 in xdoc.Descendants(captureEvent.CaptureEventCapturePointsList[0].Text)
where AllAttributesAvailable(c1, captureEvent.CaptureEventCapturePointsList[0].customizedAttributeCollection)
from c2 in c1.Elements(captureEvent.CaptureEventCapturePointsList[1].Text)
where AllAttributesAvailable(c2, captureEvent.CaptureEventCapturePointsList[1].customizedAttributeCollection)
from c3 in c2.Elements(captureEvent.CaptureEventCapturePointsList[2].Text)
where AllAttributesAvailable(c3, captureEvent.CaptureEventCapturePointsList[2].customizedAttributeCollection)
from c4 in c3.Elements(captureEvent.CaptureEventCapturePointsList[3].Text)
where AllAttributesAvailable(c4, captureEvent.CaptureEventCapturePointsList[3].customizedAttributeCollection)
select new {
elements = c1.DescendantNodesAndSelf()
};
for (int i = 0; i < q4.Count(); i++) {
foundEvents.Add(q4.ElementAt(i).elements.ElementAt(0).ToString());
}
break;
}
}
private void populateTreeviewSingleEventFromDatabase(string document, AdvancedRecomendation captureEvent)
{
try {
//Just a good practice -- change the cursor to a
//wait cursor while the nodes populate
XmlDocument xDoc = new XmlDocument();
xDoc.LoadXml(document);
this.Cursor = Cursors.WaitCursor;
//First, we'll load the Xml document
//Now, clear out the treeview,
//and add the first (root) node
tvOutput.Nodes.Clear();//captureEvent.CaptureEventCapturePointsList[i]
CustomTreeNode customRootNode = new CustomTreeNode(xDoc.DocumentElement.Name, xDoc.DocumentElement.Attributes);
customRootNode.isNodeUsed = true;
customRootNode.customizedAttributeCollection = captureEvent.CaptureEventCapturePointsList[0].customizedAttributeCollection;
tvOutput.Nodes.Add(customRootNode);
TreeNode tNode = new TreeNode();
tNode = (TreeNode)tvOutput.Nodes[0];
//We make a call to addTreeNode,
//where we'll add all of our nodes
addTreeNodeForSingleEventFromDatabase(xDoc.DocumentElement, tNode, captureEvent, 1, 0, 0, 0);
//Expand the treeview to show all nodes
tvOutput.ExpandAll();
} catch (XmlException xExc)
//Exception is thrown is there is an error in the Xml
{
CommonUtils.ShowError(xExc.Message, xExc);
} catch (Exception ex) { //General exception
CommonUtils.ShowError(ex.Message, ex);
} finally {
this.Cursor = Cursors.Default; //Change the cursor back
}
}
public static void SaveAdvancedRecomendationById(int captureEventId, AdvancedRecomendation advancedRecomendation)
{
SqlCeTransaction transaction;
SqlCeConnection conn = BackEndUtils.GetSqlConnection();
try {
conn.Open();
transaction = conn.BeginTransaction();
try {
UpdateRecommendationById(captureEventId, advancedRecomendation, conn, transaction);
Rec_CapturePoints.DeletAllRespectiveCapturePoints(captureEventId, conn, transaction);
Rec_CapturePoints.InsertCapturePointsAsTransaction(captureEventId, advancedRecomendation.CaptureEventCapturePointsList, conn, transaction);
transaction.Commit();
} catch (Exception ex) {
FrontendUtils.LogError(ex.Message, ex);
transaction.Rollback();
}
} finally {
conn.Close();
}
}
private void addTreeNodeForSingleEventFromDatabase(XmlNode xmlNode, TreeNode treeNode, AdvancedRecomendation captureEvent, int level, int index, int parentLevel, int parentIndex)
{
int newParentLevel = 0;
XmlNode xNode;
TreeNode tNode;
XmlNodeList xNodeList;
if (xmlNode.HasChildNodes) { //The current node has children
xNodeList = xmlNode.ChildNodes;
for (int x = 0, j = 0; x <= xNodeList.Count - 1; x++, j++)
//Loop through the child nodes
{
xNode = xmlNode.ChildNodes[x];
if (xNode.NodeType != XmlNodeType.Text) {
CustomTreeNode customTreeNode = new CustomTreeNode(xNode.Name, xNode.Attributes);
int currentIndex = j;
customTreeNode = GetRespectiveCapturePoint(customTreeNode, captureEvent, xNode, currentIndex, level, parentIndex, parentLevel);
treeNode.Nodes.Add(customTreeNode);
//nodeIncludedText
tNode = treeNode.Nodes[j];
newParentLevel = level;
int newParentIndex = currentIndex;
if (xNode.HasChildNodes) {
//addTreeNodeForSingleEventFromDatabase(xNode, tNode, captureEvent, level + 1, 0, newParentIndex, newParentLevel);
int indextElementTypeOnly = 0;
for (int i = 0; i < xNode.ChildNodes.Count; i++) {
XmlNode childNode = xNode.ChildNodes[i];
if (childNode.NodeType != XmlNodeType.Text) {
customTreeNode = new CustomTreeNode(childNode.Name, childNode.Attributes);
currentIndex = i;
customTreeNode = GetRespectiveCapturePoint(customTreeNode, captureEvent, childNode, indextElementTypeOnly, level + 1, j, level);
tNode.Nodes.Add(customTreeNode);
indextElementTypeOnly++;
}
}
}
} else {
j = x - 1;
}
}
} else { //No children, so add the outer xml (trimming off whitespace)
// treeNode.Text = xmlNode.Name;
// treeNode.Text = xmlNode.Attributes["name"].Value;
treeNode.Text = xmlNode.Attributes["name"] == null ? xmlNode.Name : xmlNode.Attributes["name"].Value;
}
}
private static int InsertRecommendation(AdvancedRecomendation advancedRecomendation)
{
SqlCeConnection conn = BackEndUtils.GetSqlConnection();
int value = 0;
try {
conn.Open();
SqlCeCommand command = new SqlCeCommand(Advanced_Recommendations_SQL.commandInsertRecommendation, conn);
command.Parameters.Add("@name", advancedRecomendation.CaptureEventName);
command.Parameters.Add("@description", advancedRecomendation.CaptureEventDescription);
command.Parameters.Add("@eventText", advancedRecomendation.CaptureEventEventText);
// @categoryId, @usageCount
command.Parameters.Add("@categoryId", advancedRecomendation.captureEventCategory);
command.Parameters.Add("@usageCount", advancedRecomendation.captureEventUsageCount);
command.Parameters.Add("@userId", FrontendUtils.LoggedInUserId);
value = Convert.ToInt32(command.ExecuteNonQuery());
SqlCeCommand commandMaxId = new SqlCeCommand(Advanced_Recommendations_SQL.commandMaxRecommendationId, conn);
value = Convert.ToInt32(commandMaxId.ExecuteScalar());
}catch (Exception ex){
FrontendUtils.LogError(ex.Message,ex);
}
finally {
conn.Close();
}
return value;
}
private void btnAddCaptureEvent_Click(object sender, EventArgs e)
{
try {
if (eventParsed) {
tvOutput.Select();
string ruleName = txtAOName.Text;
string ruleDescription = txtAODescription.Text;
string ruleEventIn = txtAOEventIn.Text;
if (IsValidToAddRule(ruleName, ruleDescription, ruleEventIn)) {
Recur(tvOutput.Nodes);
SaveUpdatedAttributes();
AdvancedRecomendation captureEvent = new AdvancedRecomendation(ruleName, ruleDescription, ruleEventIn, captureEventNodes);
captureEvent.captureEventCategory = Convert.ToInt32(cboCaptureType.SelectedValue);
captureEvent.captureEventUsageCount = 0;
Advanced_Recommendations.InsertCaptureEvent(captureEvent);
CommonUtils.ShowInformation("Capture event inserted successfully!",false);
}
}
LoadAvailableARtoList();
SetAllCombos();
BindCombos();
lbAdvancedCE.Select();
} catch (Exception ex) {
CommonUtils.ShowError(ex.Message, ex);
}
}
public ShowSearchDetailsForm(AdvancedRecomendation passedCaptureEvent)
{
InitializeComponent();
captureEvent = passedCaptureEvent;
}
private void btnSaveCaptureEvent_Click(object sender, EventArgs e)
{
try {
tvOutput.Select();
Recur(tvOutput.Nodes);
SaveUpdatedAttributes();
AdvancedRecomendation captureEvent = new AdvancedRecomendation(txtAOName.Text, txtAODescription.Text, txtAOEventIn.Text, captureEventNodes);
captureEvent.captureEventCategory = Convert.ToInt32(cboCaptureType.SelectedValue);
captureEvent.captureEventUsageCount = CurrentlySelectedCaptureEvent.captureEventUsageCount;
Advanced_Recommendations.SaveAdvancedRecomendationById(CurrentlySelectedCaptureEvent.CaptureEventId, captureEvent);
LoadAvailableARtoList();
SetAllCombos();
BindCombos();
ResetForm();
CommonUtils.ShowInformation("Recommendation ["+captureEvent.CaptureEventName+"] saved.",false);
} catch (Exception ex) {
CommonUtils.ShowError(ex.Message, ex);
}
}