/// <summary>
/// For Unlinking all the variable links
/// </summary>
/// <param name="IdVariable"></param>
/// <returns></returns>
public void UnlinkVariables(HttpContext context)
{
Guid IdVariable = Guid.Parse(context.Request.Params["IdVariable"]);
Guid IdTaxonomyVariable = Guid.Parse(context.Request.Params["IdTaxonomyVariable"]);
VariableLink variableLink = new VariableLink(Global.Core.VariableLinks);
List <object[]> variableLinks = Global.Core.VariableLinks.GetValues(
new string[] { "Id" },
new string[] { "IdVariable", "IdTaxonomyVariable" },
new object[] { IdVariable, IdTaxonomyVariable });
if (variableLinks.Count > 0)
{
List <object[]> categoryLinks = Global.Core.CategoryLinks.ExecuteReader("SELECT IdVariable,IdCategory,IdTaxonomyCategory,IdTaxonomyVariable FROM [dbo].[CategoryLinks]" +
"WHERE IdVariable={0} AND IdTaxonomyVariable ={1}",
new object[] { IdVariable, IdTaxonomyVariable });
if (categoryLinks.Count > 0)
{
Global.Core.CategoryLinks.ExecuteQuery("DELETE FROM [CategoryLinks] WHERE IdVariable='" + IdVariable + "'" + "AND IdTaxonomyVariable ='" + IdTaxonomyVariable + "'");
}
Global.Core.VariableLinks.ExecuteQuery("DELETE FROM [VariableLinks] WHERE IdVariable='" + IdVariable + "'" + "AND IdTaxonomyVariable ='" + IdTaxonomyVariable + "'");
}
context.Response.Write("success");
}
public ConditionBase()
{
this.lhs = new VariableLink(new MyVariable(typeof(Nullable)));
this.comparison = COMPARE.equal;
this.rhs = new VariableLink(new MyVariable(typeof(Nullable)));
this.alias = string.Empty;
this.invert = false;
}
public MyForeach()
{
this.list = new VariableLink(new Block.MyVariable(typeof(Nullable))
{
List = true
});
this.objectAlias = new VariableLink(new Block.MyVariable(typeof(Nullable)));
this.iteratorAlias = new VariableLink(new Block.MyVariable(typeof(int)));
}
public static string Link(string IdTaxonomyCategory, string IdCategory, string IdVariable, string IdTaxonomyVariable)
{
VariableLink variableLink = new VariableLink(Global.Core.VariableLinks);
List <object[]> variableLinks = Global.Core.VariableLinks.GetValues(
new string[] { "Id" },
new string[] { "IdVariable", "IdTaxonomyVariable" },
new object[] { IdVariable, IdTaxonomyVariable });
variableLink.IdVariable = new Guid(IdVariable);
variableLink.IdTaxonomyVariable = new Guid(IdTaxonomyVariable);
variableLink.CreationDate = DateTime.Now;
if (variableLinks.Count() == 0)
{
variableLink.Insert();
}
CategoryLink categoryLink = new CategoryLink(Global.Core.CategoryLinks);
categoryLink.IdCategory = new Guid(IdCategory);
categoryLink.IdTaxonomyCategory = new Guid(IdTaxonomyCategory);
categoryLink.IdVariable = new Guid(IdVariable);
categoryLink.IdTaxonomyVariable = new Guid(IdTaxonomyVariable);
categoryLink.CreationDate = DateTime.Now;
List <object[]> categoryLinks = Global.Core.CategoryLinks.GetValues(
new string[] { "Id" },
new string[] {
"IdCategory",
"IdTaxonomyCategory",
"IdVariable",
"IdTaxonomyVariable"
},
new object[] {
IdCategory,
IdTaxonomyCategory,
IdVariable,
IdTaxonomyVariable
});
if (categoryLinks.Count() == 0)
{
categoryLink.Insert();
}
return("sucess");
}
/// <summary>
/// segregated only link funtionality of variables
/// </summary>
/// <param name="IdsStudyVariables">comma seperated values of variable ids to be un linked</param>
/// <param name="IdsTaxonomyVariables">comma seperated values of taxonomy variable ids to be un linked</param>
/// <returns></returns>
private static void LinkVariables(string[] ArrIdsStudyVariables, string[] ArrIdsTaxonomyVariables)
{
for (int i = 0; i < ArrIdsStudyVariables.Count(); i++)
{
List <object[]> variableLinks = Global.Core.VariableLinks.GetValues(new string[] { "Id" }, new string[] { "IdVariable", "IdTaxonomyVariable" }, new object[] { ArrIdsStudyVariables[i], ArrIdsTaxonomyVariables[0] });
if (variableLinks.Count() == 0)
{
VariableLink newVariableLink = new VariableLink(Global.Core.VariableLinks);
newVariableLink.IdVariable = new Guid(ArrIdsStudyVariables[i]);
newVariableLink.IdTaxonomyVariable = new Guid(ArrIdsTaxonomyVariables[0]);
newVariableLink.CreationDate = DateTime.Now;
newVariableLink.Insert();
}
}
}
/// <summary>
/// For Linking Multi and Numeric Variables
/// </summary>
/// <param name="context"></param>
public void LinkNumericOrMulti(HttpContext context)
{
Guid IdVariable = Guid.Parse(context.Request.Params["IdVariable"]);
Guid IdTaxonomyVariable = Guid.Parse(context.Request.Params["IdTaxonomyVariable"]);
VariableLink variableLink = new VariableLink(Global.Core.VariableLinks);
List <object[]> variableLinks = Global.Core.VariableLinks.GetValues(
new string[] { "Id" },
new string[] { "IdVariable", "IdTaxonomyVariable" },
new object[] { IdVariable, IdTaxonomyVariable });
variableLink.IdVariable = IdVariable;
variableLink.IdTaxonomyVariable = IdTaxonomyVariable;
variableLink.CreationDate = DateTime.Now;
if (variableLinks.Count() == 0)
{
variableLink.Insert();
}
context.Response.Write("success");
}
public MyAssign() : base()
{
this.variable = new VariableLink(new Block.MyVariable(typeof(Nullable)));
this.value = new VariableLink(new Block.MyVariable(typeof(Nullable)));
}
public MyValidation() : base()
{
this.myObject = new VariableLink(new MyVariable(typeof(string)));
this.validations = new ObservableCollection <MyIfError>();
}
/// <summary>
/// For Linking Variables and Categories
/// </summary>
/// <param name="context"></param>
public void Link(HttpContext context)
{
Guid IdTaxonomyCategory = Guid.Parse(context.Request.Params["IdTaxonomyCategory"]);
Guid IdCategory = Guid.Parse(context.Request.Params["IdCategory"]);
Guid IdVariable = Guid.Parse(context.Request.Params["IdVariable"]);
Guid IdTaxonomyVariable = Guid.Parse(context.Request.Params["IdTaxonomyVariable"]);
VariableLink variableLink = new VariableLink(Global.Core.VariableLinks);
List <object[]> variableLinks = Global.Core.VariableLinks.GetValues(
new string[] { "Id" },
new string[] { "IdVariable", "IdTaxonomyVariable" },
new object[] { IdVariable, IdTaxonomyVariable });
ArrayList categoriesLinkList = new ArrayList();
variableLink.IdVariable = IdVariable;
variableLink.IdTaxonomyVariable = IdTaxonomyVariable;
variableLink.CreationDate = DateTime.Now;
if (variableLinks.Count() == 0)
{
variableLink.Insert();
}
CategoryLink categoryLink = new CategoryLink(Global.Core.CategoryLinks);
categoryLink.IdVariable = IdVariable;
categoryLink.IdCategory = IdCategory;
categoryLink.IdTaxonomyCategory = IdTaxonomyCategory;
categoryLink.IdTaxonomyVariable = IdTaxonomyVariable;
categoryLink.CreationDate = DateTime.Now;
List <object[]> categoryLinks = Global.Core.CategoryLinks.GetValues(
new string[] { "Id" },
new string[] {
"IdCategory",
"IdTaxonomyCategory",
"IdVariable",
"IdTaxonomyVariable"
},
new object[] {
IdCategory,
IdTaxonomyCategory,
IdVariable,
IdTaxonomyVariable
});
if (categoryLinks.Count() == 0)
{
categoryLink.Insert();
}
foreach (var item in categoryLinks)
{
dynamic variable = new { IdVariable = IdVariable, IdCategory = IdCategory, IdTaxonomyCategory = IdTaxonomyCategory, IdTaxonomyVariable = IdTaxonomyVariable };
categoriesLinkList.Add(variable);
}
string jSon = new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(categoriesLinkList);
context.Response.Write(jSon);
//context.Response.Write("success");
}
public MyRegistry() : base()
{
this.action = ACTION.Insert;
this.variable = new VariableLink(new MyVariable(typeof(MyAsset)));
this.preventDelay = false;
}
public MyModification() : base()
{
this.myObject = new VariableLink(new MyVariable(typeof(string)));
this.assignments = new ObservableCollection <MyAssign>();
}
public VMvariableLink(VariableLink root) : base(root)
{
}
