void ViewRelationForm_OKButtonSelected(object sender, EventArgs e)
{
ViewRelation viewRelation = (ViewRelation)this.Tag;
viewRelation.MasterFieldDisplayName = ((CamlFieldRef)((ComboBoxItem)MasterFieldDisplayNameComboBox.SelectedItem).Tag).Name;
viewRelation.MasterFieldValueName = ((CamlFieldRef)((ComboBoxItem)MasterFieldValueNameComboBox.SelectedItem).Tag).Name;
viewRelation.DetailFieldName = ((CamlFieldRef)((ComboBoxItem)DetailFieldNameComboBox.SelectedItem).Tag).Name;
}
public static string GetCodeFkName(this ViewRelation relation)
{
var parentEntity = relation.ParentTable;
var childEntity = relation.ChildView;
var fkName = string.Format("FK_{0}_{1}_{2}", relation.PascalRoleName, childEntity.PascalName, parentEntity.PascalName);
return(fkName);
}
private void AddButton_Click(object sender, RoutedEventArgs e)
{
if (ViewComboBox.SelectedItem == null)
{
return;
}
TreeViewItem selectedTreeViewItem = null;
IQueryPanel masterQueryPanel = null;
Guid masterViewRelationID = Guid.Empty;
if (ViewRelationsTreeView.SelectedItem != null)
{
selectedTreeViewItem = (TreeViewItem)ViewRelationsTreeView.SelectedItem;
Guid detailQueryPanelID = ((ViewRelation)selectedTreeViewItem.Tag).DetailQueryPanelID;
masterViewRelationID = ((ViewRelation)selectedTreeViewItem.Tag).ID;
masterQueryPanel = ApplicationContext.Current.SPCamlStudio.QueriesPanel.GetQueryPanel(detailQueryPanelID);
//masterQueryPanel = (IQueryPanel)selectedTreeViewItem.Tag;
}
ComboBoxItem selectedComboBoxItem = (ComboBoxItem)ViewComboBox.SelectedItem;
IQueryPanel detailQueryPanel = (IQueryPanel)selectedComboBoxItem.Tag;
ViewRelation viewRelation = ViewRelation.NewViewRelation();
viewRelation.MasterViewRelationID = masterViewRelationID;
viewRelation.DetailQueryPanelID = detailQueryPanel.ID;
viewRelation.Name = detailQueryPanel.FileName;
viewRelation.DetailSiteUrl = detailQueryPanel.AttachedObject.GetWebUrl();
viewRelation.DetailListName = detailQueryPanel.AttachedObject.GetListName();
if (selectedComboBoxItem.Parent == null)
{
viewRelation.IsRoot = true;
}
TreeViewItem newTreeViewItem = new TreeViewItem()
{
Header = viewRelation.Name,
Tag = viewRelation
};
if (selectedTreeViewItem == null)
{
ViewRelationsTreeView.Items.Add(newTreeViewItem);
}
else
{
ViewRelationForm viewRelationForm = new ViewRelationForm();
viewRelationForm.Initialize(masterQueryPanel, detailQueryPanel);
viewRelationForm.Tag = viewRelation;
if (viewRelationForm.ShowDialog(this.ParentWindow, "View Relation") == true)
{
selectedTreeViewItem.Items.Add(newTreeViewItem);
}
}
}
private string GenerateGridsScript(ItemCollection items)
{
StringBuilder sb = new StringBuilder();
foreach (object t in items)
{
TreeViewItem treeviewItem = (TreeViewItem)t;
ViewRelation viewRelation = (ViewRelation)treeviewItem.Tag;
IQueryPanel queryPanel = ApplicationContext.Current.SPCamlStudio.QueriesPanel.GetQueryPanel(viewRelation.DetailQueryPanelID);
string appendix = viewRelation.ID.ToString().Replace('-', '_');
sb.AppendLine("var dataSourceBuilder" + appendix + " = new soby_CamlBuilder('" + viewRelation.DetailListName + "', '', 5, '" + viewRelation.DetailSiteUrl + "');");
sb.AppendLine("dataSourceBuilder" + appendix + ".Filters = new CamlFilters(false);");
sb.AppendLine("var spService" + appendix + " = new soby_SharePointService(dataSourceBuilder" + appendix + ");");
sb.AppendLine("var sobyGrid" + appendix + " = new soby_DataGrid('#soby_GridDiv" + appendix + "', '" + viewRelation.DetailListName + "', spService" + appendix + ", 'There is no record found.')");
List <CamlFieldRef> viewFields = queryPanel.GetViewFields();
foreach (CamlFieldRef viewField in viewFields)
{
sb.AppendLine("dataSourceBuilder" + appendix + ".AddViewField('" + viewField.Name + "', '" + viewField.Name + "', CamlFieldTypes.Text);");
sb.AppendLine("sobyGrid" + appendix + ".AddColumn('" + viewField.Name + "', '" + viewField.DisplayName + "');");
}
foreach (object z in treeviewItem.Items)
{
TreeViewItem treeviewItem1 = (TreeViewItem)z;
ViewRelation viewRelation1 = (ViewRelation)treeviewItem1.Tag;
if ((from h in viewFields
where h.Name == viewRelation1.MasterFieldValueName
select h).ToList().Count == 0)
{
sb.AppendLine("dataSourceBuilder" + appendix + ".AddViewField('" + viewRelation1.MasterFieldValueName + "', '" + viewRelation1.MasterFieldValueName + "', CamlFieldTypes.Text);");
}
}
if (string.IsNullOrEmpty(viewRelation.MasterFieldDisplayName) == false)
{
sb.AppendLine("sobyGrid" + viewRelation.MasterViewRelationID.ToString().Replace('-', '_') + ".AddDataRelation('" + viewRelation.MasterFieldDisplayName + "', '" + viewRelation.MasterFieldValueName + "', sobyGrid" + appendix + ".GridID, '" + viewRelation.DetailFieldName + "')");
}
else
{
sb.AppendLine("sobyGrid" + appendix + ".Initialize(true);");
}
sb.Append(GenerateGridsScript(treeviewItem.Items));
}
return(sb.ToString());
}
void GenerateSharePointCode()
{
XmlDocument xDoc = new XmlDocument();
XmlNode contentNode = null;
//var assembly = Assembly.Load("Sobiens.Connectors.UI");
//var resourceName = "Sobiens.Connectors.UI.Resources.SPOnlineWebpart.dwp";
string dwpPath = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location) + @"\Resources\SPOnlineWebpart.dwp";
//using (Stream stream = assembly.GetManifestResourceStream(resourceName))
//using (StreamReader reader = new StreamReader(stream))
//{
string xmlString = File.ReadAllText(dwpPath);
xDoc.LoadXml(xmlString);
foreach (XmlNode node in xDoc.ChildNodes[1].ChildNodes)
{
if (node.Name.Equals("Content", StringComparison.InvariantCultureIgnoreCase) == true)
{
contentNode = node;
break;
}
}
//}
StringBuilder sb = new StringBuilder();
foreach (object t in ViewRelationsTreeView.Items)
{
TreeViewItem treeviewItem = (TreeViewItem)t;
ViewRelation viewRelation = (ViewRelation)treeviewItem.Tag;
string appendix = viewRelation.ID.ToString().Replace('-', '_');
sb.AppendLine("<div id='soby_GridDiv" + appendix + "'></div>");
}
sb.AppendLine("<script src='https://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js'></script>");
sb.AppendLine("<script language='javascript' src='https://cdn.rawgit.com/serkantsamurkas/sobiens/master/soby.spservice.js'></script>");
sb.AppendLine("<script language='javascript' src='https://cdn.rawgit.com/serkantsamurkas/sobiens/master/soby.ui.components.js'></script>");
sb.AppendLine("<script language='javascript'>");
sb.Append(GenerateGridsScript(ViewRelationsTreeView.Items));
sb.AppendLine("</script>");
string path = GetTempPath();
contentNode.InnerText = sb.ToString();
xDoc.Save(path + "\\soby_test.dwp");
// File.WriteAllText(path + "\\soby_test.dwp", sb.ToString());
Process.Start("Explorer.exe", path);
}
public IActionResult Post([FromBody] ViewRelation relation)
{
Relation buffer = db.Relations.FirstOrDefault((Relation x) => x.UserName == User.Identity.Name && x.ProductId == relation.ProductId);
if (buffer != null)
{
string username = User.Identity.Name;
Relation product = db.Relations.FirstOrDefault(x => x.ProductId == relation.ProductId && x.UserName == username && x.Checked == true);
db.Relations.Remove(product);
db.SaveChanges();
return(Ok(relation));
}
Relation dbrelationmodel = new Relation()
{
ProductId = relation.ProductId, Checked = true, UserName = User.Identity.Name
};
db.Relations.Add(dbrelationmodel);
db.SaveChanges();
return(Ok(relation));
}
public override void Initialize()
{
m_RelationFields =
Execute(RelationFieldCommandText)
.Select(o => RelationField.CreateFrom(SqlHelper, o))
.ToDictionary(x => new RelationFieldKey(x.RelationName, x.FieldName));
m_RelationFieldByTypeObjectNameKey =
m_RelationFields
.Values
.ToDictionary(rf => rf.TypeObjectNameKey);
var relationFields = m_RelationFields.Values.ToLookup(x => x.RelationName);
m_Relations =
Execute(RelationCommandText)
.Select(o => Relation.CreateFrom(SqlHelper, o, relationFields))
.ToDictionary(x => x.RelationName);
m_ViewRelations =
Execute(ViewRelationCommandText)
.Select(o => ViewRelation.CreateFrom(SqlHelper, o))
.ToList();
m_Tables =
m_Relations.Values
.Where(x => x.MetadataRelationType == MetadataRelationType.Persistent)
.ToDictionary(x => x.RelationName);
m_Views =
m_Relations.Values
.Where(x => x.MetadataRelationType == MetadataRelationType.View)
.ToDictionary(x => x.RelationName);
m_ExternalTables =
m_Relations.Values
.Where(x => x.MetadataRelationType == MetadataRelationType.External)
.ToDictionary(x => x.RelationName);
m_GttTables =
m_Relations.Values
.Where(x => x.MetadataRelationType == MetadataRelationType.GlobalTemporaryPreserve || x.MetadataRelationType == MetadataRelationType.GlobalTemporaryDelete)
.ToDictionary(x => x.RelationName);
}
public override void Initialize()
{
m_RelationFields =
Execute(RelationFieldCommandText)
.Select(o => RelationField.CreateFrom(SqlHelper, o))
.ToDictionary(x => new RelationFieldKey(x.RelationName, x.FieldName));
m_RelationFieldByTypeObjectNameKey =
m_RelationFields
.Values
.ToDictionary(rf => rf.TypeObjectNameKey);
var relationFields = m_RelationFields.Values.ToLookup(x => x.RelationName);
m_Relations =
Execute(RelationCommandText)
.Select(o => Relation.CreateFrom(SqlHelper, o, relationFields))
.ToDictionary(x => x.RelationName);
m_ViewRelations =
Execute(ViewRelationCommandText)
.Select(o => ViewRelation.CreateFrom(SqlHelper, o))
.ToList();
m_Tables =
m_Relations.Values
.Where(x => x.MetadataRelationType == MetadataRelationType.PERSISTENT)
.ToDictionary(x => x.RelationName);
m_Views =
m_Relations.Values
.Where(x => x.MetadataRelationType == MetadataRelationType.VIEW)
.ToDictionary(x => x.RelationName);
m_ExternalTables =
m_Relations.Values
.Where(x => x.MetadataRelationType == MetadataRelationType.EXTERNAL)
.ToDictionary(x => x.RelationName);
m_GttTables =
m_Relations.Values
.Where(x => x.MetadataRelationType == MetadataRelationType.GLOBAL_TEMPORARY_PRESERVE || x.MetadataRelationType == MetadataRelationType.GLOBAL_TEMPORARY_DELETE)
.ToDictionary(x => x.RelationName);
}
public CompExtention.ComponentView GetView(string viewid)
{
DataTable dt = new DataTable();
Builder.Data.ComponentViewBuilder cv = new Builder.Data.ComponentViewBuilder(this.Connection);
dt = cv.GetView(viewid);
DataTable dtViewSchema = new DataTable();
dtViewSchema = cv.GetViewSchema(viewid);
List <ComponentView> views = new List <ComponentView>();
foreach (DataRow dr in dt.Rows)
{
ComponentView v = new ComponentView();
v.ID = dr[Builder.Schema.TalentozView.ViewID.Name] == null ? "" : dr[Builder.Schema.TalentozView.ViewID.Name].ToString();
v.Name = dr[Builder.Schema.TalentozView.Name.Name] == null ? "" : dr[Builder.Schema.TalentozView.Name.Name].ToString();
v.Category = dr[Builder.Schema.TalentozView.Catgory.Name] == null ? "" : dr[Builder.Schema.TalentozView.Catgory.Name].ToString();
v.CoreComponent = dr[Builder.Schema.TalentozView.CoreComponent.Name] == null ? "" : dr[Builder.Schema.TalentozView.CoreComponent.Name].ToString();
var dtVS = dtViewSchema.DefaultView.ToTable(true, "ViewID", Builder.Schema.TalentozViewSchema.ComponentID.Name,
Builder.Schema.TalentozViewSchema.ChildComponentID.Name);
foreach (DataRow drSch in dtVS.Rows)
{
ComponentRelation vc = new ComponentRelation();
vc.ViewID = viewid;
vc.ComponentID = drSch[Builder.Schema.TalentozViewSchema.ComponentID.Name] == null ? "" : drSch[Builder.Schema.TalentozViewSchema.ComponentID.Name].ToString();
vc.ChildComponentID = drSch[Builder.Schema.TalentozViewSchema.ChildComponentID.Name] == null ? "" : drSch[Builder.Schema.TalentozViewSchema.ChildComponentID.Name].ToString();
dtViewSchema.DefaultView.RowFilter =
Builder.Schema.TalentozViewSchema.ComponentID.Name + " = '" + vc.ComponentID + "' AND " +
Builder.Schema.TalentozViewSchema.ChildComponentID.Name + " = '" + vc.ChildComponentID + "'";
var dtvsre = dtViewSchema.DefaultView.ToTable(true);
dtViewSchema.DefaultView.RowFilter = "";
vc.Relationship = new List <ViewRelation>();
foreach (DataRow drRel in dtvsre.Rows)
{
var vr = new ViewRelation();
vr.ID = drRel[Builder.Schema.TalentozViewSchemaRelation.ViewSchemaRelation.Name] == null ? "" :
drRel[Builder.Schema.TalentozViewSchemaRelation.ViewSchemaRelation.Name].ToString();
vr.Left = drRel[Builder.Schema.TalentozViewSchemaRelation.Parent.Name] == null ? "" :
drRel[Builder.Schema.TalentozViewSchemaRelation.Parent.Name].ToString();
vr.LeftField = drRel[Builder.Schema.TalentozViewSchemaRelation.ParentField.Name] == null ? "" :
drRel[Builder.Schema.TalentozViewSchemaRelation.ParentField.Name].ToString();
vr.Right = drRel[Builder.Schema.TalentozViewSchemaRelation.Child.Name] == null ? "" :
drRel[Builder.Schema.TalentozViewSchemaRelation.Child.Name].ToString();
vr.LeftField = drRel[Builder.Schema.TalentozViewSchemaRelation.RelatedField.Name] == null ? "" :
drRel[Builder.Schema.TalentozViewSchemaRelation.RelatedField.Name].ToString();
vc.Relationship.Add(vr);
}
v.ComponentRelations.Add(vc);
}
return(v);
}
return(null);
}
public static string GetDatabaseFkName(this ViewRelation relation)
{
return(GetCodeFkName(relation));
}
