public IActionResult EntityManagerRelationSave(RelationModel model) { if (namespaceId == model.EntityId) { return(Json("You are unable to create a relation to the same entity")); } string sqlValidation = ""; var paramListValidation = new List <KeyValuePair <string, string> >() { new KeyValuePair <string, string>("entityid", namespaceId), new KeyValuePair <string, string>("parententityid", model.EntityId) }; if (model.AttributeId != "0" && model.AttributeId != "") { sqlValidation = "SELECT * FROM entitysettings.entityrelation WHERE entityid = @entityid and parententityid = @parententityid;"; } else { sqlValidation = "SELECT * FROM entitysettings.entityrelation WHERE entityid = @entityid and parententityid = @parententityid and localentityattributeid = @localentityattributeid;"; paramListValidation.Add(new KeyValuePair <string, string>("localentityattributeid", model.AttributeId)); } DataSet ds = DataServices.DataSetFromSQL(sqlValidation, paramListValidation); DataTable dtValidation = ds.Tables[0]; if (dtValidation.Rows.Count > 0) { return(Json("The relation that you are trying to create already exists for this entity")); } string sql = @"SELECT entitysettings.addrelationtoentity( @p_entityid, @p_entityname, @p_synapsenamespaceid, @p_synapsenamespacename, @p_parententityid, @p_parententityname, @p_parentsynapsenamespaceid, @p_parentsynapsenamespacename, @p_attributeid, @p_attributename, CAST(@p_ordinal_position AS integer), @p_entityversionid, @p_username, @p_localentityattributeid, @p_localentityattributename )"; DataTable dt = SynapseHelpers.GetEntityDSFromID(namespaceId); DataTable dtParent = SynapseHelpers.GetEntityDSFromID(model.EntityId); DataTable dtKey = SynapseHelpers.GetEntityKeyAttributeFromID(model.EntityId); string entityName = SynapseHelpers.GetEntityNameFromID(model.EntityId); string localAttributeName = string.Empty; string attributename = dtKey.Rows[0]["attributename"].ToString(); string nextOrdinalPosition = SynapseHelpers.GetNextOrdinalPositionFromID(namespaceId); if (model.AttributeId != "0" && !string.IsNullOrWhiteSpace(model.AttributeId)) { localAttributeName = SynapseHelpers.GetAttributeNameFromAttributeID(model.AttributeId); attributename += "_" + localAttributeName; } var paramList = new List <KeyValuePair <string, string> >() { new KeyValuePair <string, string>("p_entityid", namespaceId), new KeyValuePair <string, string>("p_entityname", SynapseHelpers.GetEntityNameFromID(namespaceId)), new KeyValuePair <string, string>("p_synapsenamespaceid", dt.Rows[0]["synapsenamespaceid"].ToString()), new KeyValuePair <string, string>("p_synapsenamespacename", dt.Rows[0]["synapsenamespacename"].ToString()), new KeyValuePair <string, string>("p_parententityid", model.EntityId), new KeyValuePair <string, string>("p_parententityname", entityName), new KeyValuePair <string, string>("p_parentsynapsenamespaceid", dtParent.Rows[0]["synapsenamespaceid"].ToString()), new KeyValuePair <string, string>("p_parentsynapsenamespacename", dtParent.Rows[0]["synapsenamespacename"].ToString()), new KeyValuePair <string, string>("p_attributeid", dtKey.Rows[0]["attributeid"].ToString()), new KeyValuePair <string, string>("p_attributename", attributename), new KeyValuePair <string, string>("p_ordinal_position", nextOrdinalPosition), new KeyValuePair <string, string>("p_entityversionid", SynapseHelpers.GetCurrentEntityVersionFromID(namespaceId)), new KeyValuePair <string, string>("p_username", HttpContext.Session.GetString(SynapseSession.FullName)), new KeyValuePair <string, string>("p_localentityattributeid", model.AttributeId), new KeyValuePair <string, string>("p_localentityattributename", localAttributeName) }; DataServices.ExcecuteNonQueryFromSQL(sql, paramList); return(Json(namespaceId)); }
private void CreateNewAttribute() { DataTable dtBVs = SynapseHelpers.GetEntityBaseviewsDT(this.hdnEntityID.Value); this.hdnDataType.Value = SynapseHelpers.GetDataTypeFromID(this.ddlDataType.SelectedValue); string sql = @"SELECT entitysettings.addattributetoentity( @p_entityid, @p_entityname, @p_synapsenamespaceid, @p_synapsenamespacename, @p_username, @p_attributename, @p_attributedescription, @p_datatype, @p_datatypeid, CAST(@p_ordinal_position AS integer), @p_attributedefault, @p_maximumlength, @p_commondisplayname, @p_isnullsetting, @p_entityversionid )"; DataTable dt = SynapseHelpers.GetEntityDSFromID(this.hdnEntityID.Value); string maxLength = ""; if (this.ddlDataType.SelectedItem.Text == "Short String") { maxLength = "255"; } if (this.ddlDataType.SelectedItem.Text == "Long String") { maxLength = "1000"; } var paramList = new List <KeyValuePair <string, string> >() { new KeyValuePair <string, string>("p_entityid", this.hdnEntityID.Value), new KeyValuePair <string, string>("p_entityname", SynapseHelpers.GetEntityNameFromID(this.hdnEntityID.Value)), new KeyValuePair <string, string>("p_synapsenamespaceid", dt.Rows[0]["synapsenamespaceid"].ToString()), new KeyValuePair <string, string>("p_synapsenamespacename", dt.Rows[0]["synapsenamespacename"].ToString()), new KeyValuePair <string, string>("p_username", this.hdnUserName.Value), new KeyValuePair <string, string>("p_attributename", this.txtAttributeName.Text), new KeyValuePair <string, string>("p_attributedescription", "Description"), new KeyValuePair <string, string>("p_datatype", this.hdnDataType.Value), new KeyValuePair <string, string>("p_datatypeid", this.ddlDataType.SelectedValue), new KeyValuePair <string, string>("p_ordinal_position", this.hdnNextOrdinalPosition.Value), new KeyValuePair <string, string>("p_attributedefault", ""), new KeyValuePair <string, string>("p_maximumlength", maxLength), new KeyValuePair <string, string>("p_commondisplayname", ""), new KeyValuePair <string, string>("p_isnullsetting", ""), new KeyValuePair <string, string>("p_entityversionid", SynapseHelpers.GetCurrentEntityVersionFromID(this.hdnEntityID.Value)) }; DataServices.ExcecuteNonQueryFromSQL(sql, paramList); ClearAttributesForm(); this.lblSuccess.Text = "Attribute created"; this.lblSuccess.Visible = true; this.hdnNextOrdinalPosition.Value = SynapseHelpers.GetNextOrdinalPositionFromID(this.hdnEntityID.Value); foreach (DataRow row in dtBVs.Rows) { string baseview_id = row["baseview_id"].ToString(); string sqlRecreate = "SELECT listsettings.recreatebaseview(@baseview_id);"; var paramListRecreate = new List <KeyValuePair <string, string> >() { new KeyValuePair <string, string>("baseview_id", baseview_id) }; try { DataServices.ExcecuteNonQueryFromSQL(sqlRecreate, paramListRecreate); } catch (Exception ex) { var a = ex.ToString(); } } BindEntityGrid(); }
public IActionResult EntityManagerAttributeSave(AttributeModel model) { DataTable dtBVs = SynapseHelpers.GetEntityBaseviewsDT(namespaceId); string dataType = SynapseHelpers.GetDataTypeFromID(model.DataTypeId); string dataTypeDisplay = SynapseHelpers.GetDataTypeDisplayFromID(model.DataTypeId); string nextOrdinalPosition = SynapseHelpers.GetNextOrdinalPositionFromID(namespaceId); string sql = @"SELECT entitysettings.addattributetoentity( @p_entityid, @p_entityname, @p_synapsenamespaceid, @p_synapsenamespacename, @p_username, @p_attributename, @p_attributedescription, @p_datatype, @p_datatypeid, CAST(@p_ordinal_position AS integer), @p_attributedefault, @p_maximumlength, @p_commondisplayname, @p_isnullsetting, @p_entityversionid )"; DataTable dt = SynapseHelpers.GetEntityDSFromID(namespaceId); string maxLength = ""; if (dataTypeDisplay == "Short String") { maxLength = "255"; } if (dataTypeDisplay == "Long String") { maxLength = "1000"; } var paramList = new List <KeyValuePair <string, string> >() { new KeyValuePair <string, string>("p_entityid", namespaceId), new KeyValuePair <string, string>("p_entityname", SynapseHelpers.GetEntityNameFromID(namespaceId)), new KeyValuePair <string, string>("p_synapsenamespaceid", dt.Rows[0]["synapsenamespaceid"].ToString()), new KeyValuePair <string, string>("p_synapsenamespacename", dt.Rows[0]["synapsenamespacename"].ToString()), new KeyValuePair <string, string>("p_username", HttpContext.Session.GetString(SynapseSession.FullName)), new KeyValuePair <string, string>("p_attributename", model.AttributeName), new KeyValuePair <string, string>("p_attributedescription", "Description"), new KeyValuePair <string, string>("p_datatype", dataType), new KeyValuePair <string, string>("p_datatypeid", model.DataTypeId), new KeyValuePair <string, string>("p_ordinal_position", nextOrdinalPosition), new KeyValuePair <string, string>("p_attributedefault", ""), new KeyValuePair <string, string>("p_maximumlength", maxLength), new KeyValuePair <string, string>("p_commondisplayname", ""), new KeyValuePair <string, string>("p_isnullsetting", ""), new KeyValuePair <string, string>("p_entityversionid", SynapseHelpers.GetCurrentEntityVersionFromID(namespaceId)) }; DataServices.ExcecuteNonQueryFromSQL(sql, paramList); foreach (DataRow row in dtBVs.Rows) { string baseview_id = row["baseview_id"].ToString(); string sqlRecreate = "SELECT listsettings.recreatebaseview(@baseview_id);"; var paramListRecreate = new List <KeyValuePair <string, string> >() { new KeyValuePair <string, string>("baseview_id", baseview_id) }; DataServices.ExcecuteNonQueryFromSQL(sqlRecreate, paramListRecreate); } return(Json(namespaceId)); }
private void CreateRelation() { string sql = @"SELECT entitysettings.addrelationtoentity( @p_entityid, @p_entityname, @p_synapsenamespaceid, @p_synapsenamespacename, @p_parententityid, @p_parententityname, @p_parentsynapsenamespaceid, @p_parentsynapsenamespacename, @p_attributeid, @p_attributename, CAST(@p_ordinal_position AS integer), @p_entityversionid, @p_username, @p_localentityattributeid, @p_localentityattributename )"; DataTable dt = SynapseHelpers.GetEntityDSFromID(this.hdnEntityID.Value); DataTable dtParent = SynapseHelpers.GetEntityDSFromID(this.ddlEntity.SelectedValue); DataTable dtKey = SynapseHelpers.GetEntityKeyAttributeFromID(this.ddlEntity.SelectedValue); string attributename = dtKey.Rows[0]["attributename"].ToString(); if (this.ddlLocalAttribute.SelectedIndex > 0) { attributename += "_" + this.ddlLocalAttribute.SelectedItem.Text; } var paramList = new List <KeyValuePair <string, string> >() { new KeyValuePair <string, string>("p_entityid", this.hdnEntityID.Value), new KeyValuePair <string, string>("p_entityname", SynapseHelpers.GetEntityNameFromID(this.hdnEntityID.Value)), new KeyValuePair <string, string>("p_synapsenamespaceid", dt.Rows[0]["synapsenamespaceid"].ToString()), new KeyValuePair <string, string>("p_synapsenamespacename", dt.Rows[0]["synapsenamespacename"].ToString()), new KeyValuePair <string, string>("p_parententityid", this.ddlEntity.SelectedValue), new KeyValuePair <string, string>("p_parententityname", this.ddlEntity.SelectedItem.Text), new KeyValuePair <string, string>("p_parentsynapsenamespaceid", dtParent.Rows[0]["synapsenamespaceid"].ToString()), new KeyValuePair <string, string>("p_parentsynapsenamespacename", dtParent.Rows[0]["synapsenamespacename"].ToString()), new KeyValuePair <string, string>("p_attributeid", dtKey.Rows[0]["attributeid"].ToString()), new KeyValuePair <string, string>("p_attributename", attributename), new KeyValuePair <string, string>("p_ordinal_position", this.hdnNextOrdinalPosition.Value), new KeyValuePair <string, string>("p_entityversionid", SynapseHelpers.GetCurrentEntityVersionFromID(this.hdnEntityID.Value)), new KeyValuePair <string, string>("p_username", this.hdnUserName.Value), new KeyValuePair <string, string>("p_localentityattributeid", this.ddlLocalAttribute.SelectedValue), new KeyValuePair <string, string>("p_localentityattributename", this.ddlLocalAttribute.SelectedItem.Text) }; DataServices.ExcecuteNonQueryFromSQL(sql, paramList); ClearAttributesForm(); this.hdnNextOrdinalPosition.Value = SynapseHelpers.GetNextOrdinalPositionFromID(this.hdnEntityID.Value); BindEntityGrid(); this.lblSuccess.Text = "Relation created"; this.lblSuccess.Visible = true; }