protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string id = "";
try
{
id = Request.QueryString["id"].ToString();
}
catch
{
Response.Redirect("Error.aspx");
}
if (String.IsNullOrEmpty(id))
{
Response.Redirect("Error.aspx");
}
this.hdnAttributeID.Value = id;
this.hdnEntityID.Value = SynapseHelpers.GetEntityIDFromAttributeID(id);
this.lblHeading.Text = SynapseHelpers.GetAttributeNameFromAttributeID(id);
this.lblAttributeName.Text = SynapseHelpers.GetAttributeNameFromAttributeID(id);
try
{
}
catch { }
try
{
this.hdnUserName.Value = Session["userFullName"].ToString();
}
catch { }
this.lblSummaryType.Text = SynapseHelpers.GetEntityNameAndNamespaceFromID(id);
this.hdnNextOrdinalPosition.Value = SynapseHelpers.GetNextOrdinalPositionFromID(id);
BindGrid();
this.btnDropAttribute.Attributes.Add("onclick", "if(confirm('Are you sure that you want to delete this relation? This cannot be undone!!')){return true;} else {return false;};");
}
}
public IActionResult RelationView(string id)
{
ViewBag.Id = namespaceId;
ViewBag.RelationId = id;
ViewBag.Summary = SynapseHelpers.GetAttributeNameFromAttributeID(id);
string sql = "SELECT * FROM entitysettings.v_attributedetailsummary WHERE attributeid = @attributeid ORDER BY orderby";
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("attributeid", id)
};
DataSet dsEntityDetail = DataServices.DataSetFromSQL(sql, paramList);
List <DetailDto> detailDto = dsEntityDetail.Tables[0].ToList <DetailDto>();
return(View(detailDto));
}
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));
}
public IActionResult EntityManagerAttributeView(string id)
{
namespaceId = SynapseHelpers.GetEntityIDFromAttributeID(id);
ViewBag.Id = namespaceId;
ViewBag.AttributeId = id;
ViewBag.Heading = SynapseHelpers.GetAttributeNameFromAttributeID(id);
ViewBag.AttributeName = SynapseHelpers.GetAttributeNameFromAttributeID(id);
ViewBag.Summary = SynapseHelpers.GetEntityNameAndNamespaceFromID(namespaceId);
string sql = "SELECT * FROM entitysettings.v_attributedetailsummary WHERE attributeid = @attributeid ORDER BY orderby";
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("attributeid", id)
};
DataSet ds = DataServices.DataSetFromSQL(sql, paramList);
DataTable dt = ds.Tables[0];
ViewBag.Error = "";
foreach (DataRow drow in dt.Rows)
{
string colName = drow["entitydetail"].ToString();
string colVal = drow["entitydescription"].ToString();
if (colName == "Is Key Attribute")
{
if (colVal == "1")
{
ViewBag.Error = "Drop Attribute button not available as it is not possible to delete a key attribute";
}
}
if (colName == "Is System Attribute")
{
if (colVal == "1")
{
ViewBag.Error = "Drop Attribute button not available as it is not possible to delete a system attribute";
}
}
if (colName == "Is Relation Attribute")
{
if (colVal == "1")
{
ViewBag.Error = "Drop Attribute button not available as it is not possible to delete a relation attribute from this screen";
}
}
}
DataTable dtBVs = SynapseHelpers.GetEntityBaseviewsDT(namespaceId);
Int16 bvCount = System.Convert.ToInt16(dtBVs.Rows.Count);
DetailModel detailModel = new DetailModel();
List <DetailDto> detailDto = dt.ToList <DetailDto>();
List <BaseViewDto> baseViewDto = dtBVs.ToList <BaseViewDto>();
detailModel.DetailDto = detailDto;
detailModel.BaseViewDto = baseViewDto;
return(View(detailModel));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string id = "";
try
{
id = Request.QueryString["id"].ToString();
}
catch
{
Response.Redirect("Error.aspx");
}
if (String.IsNullOrEmpty(id))
{
Response.Redirect("Error.aspx");
}
this.hdnAttributeID.Value = id;
this.hdnEntityID.Value = SynapseHelpers.GetEntityIDFromAttributeID(id);
this.lblHeading.Text = SynapseHelpers.GetAttributeNameFromAttributeID(id);
this.lblAttributeName.Text = SynapseHelpers.GetAttributeNameFromAttributeID(id);
try
{
}
catch { }
try
{
this.hdnUserName.Value = Session["userFullName"].ToString();
}
catch { }
this.lblSummaryType.Text = SynapseHelpers.GetEntityNameAndNamespaceFromID(id);
this.hdnNextOrdinalPosition.Value = SynapseHelpers.GetNextOrdinalPositionFromID(id);
BindGrid();
this.btnDropAttribute.Attributes.Add("onclick", "if(confirm('Are you sure that you want to delete this attribute? This cannot be undone!!')){return true;} else {return false;};");
DataTable dtBVs = SynapseHelpers.GetEntityBaseviewsDT(this.hdnEntityID.Value);
Int16 bvCount = System.Convert.ToInt16(dtBVs.Rows.Count);
this.lblDependentBaseviewCount.Text = bvCount.ToString();
this.lblHasDepencies.Text = bvCount.ToString();
if (bvCount > 0)
{
this.pnlHasDepencies.Visible = true;
}
else
{
this.pnlHasDepencies.Visible = false;
}
this.dgBaseViewDependancies.DataSource = dtBVs;
this.dgBaseViewDependancies.DataBind();
}
}