public DataTable getDataSource(int DataSourceID)
{
iQuery = new QueryBuilder(QueryType._Select).AddField("*", "s_DataSource")
.AddWhere(0, "s_DataSource", "DataSourceID", FieldType._Text, Operator._Equal, DataSourceID.ToString(), Condition._None);
dtResult = rd.ExecuteQuery(iQuery).GetResult;
return(dtResult);
}
public DataTable GetLookUpItems(int pClientID, int pLookUpID)
{
dtResult = new DataTable();
Query selectQ = new QueryBuilder(QueryType._Select).AddTable("vw_lookupitem").AddField("*", "vw_lookupitem").
AddWhere(0, "vw_lookupitem", "ClientID", FieldType._Number, Operator._Equal, pClientID.ToString(), Condition._And).
AddWhere(0, "vw_lookupitem", "LookUpID", FieldType._Number, Operator._Equal, pLookUpID.ToString());
dtResult = rd.ExecuteQuery(selectQ).GetResult;
return(dtResult);
}
public DataTable GetProcedure(int procedureID)
{
dtResult = new DataTable();
Query iQuery = new QueryBuilder(QueryType._Select)
.AddField("ProcedureID", "s_entity_procedure")
.AddField("Name", "s_entity_procedure")
.AddField("Steps", "s_entity_procedure")
.AddField("datasourcekey", "s_entity_procedure");
dtResult = rd.ExecuteQuery(iQuery).GetResult;
return(dtResult);
}
public DataTable GetJob(int JobID)
{
iQuery = new QueryBuilder(QueryType._Select)
.AddField("jobid", "s_entityjob", FieldType._Number, "")
.AddField("datasourcekey", "s_entityjob", FieldType._String, "")
.AddField("name", "s_entityjob", FieldType._String, "")
.AddField("description", "s_entityjob", FieldType._String, "")
.AddField("steps", "s_entityjob", FieldType._String, "")
.AddField("jobstartdate", "s_entityjob", FieldType._DateTime, "")
.AddField("jobtime", "s_entityjob", FieldType._DateTime, "")
.AddField("currentschedule", "s_entityjob", FieldType._DateTime, "")
.AddField("type", "s_entityjob", FieldType._Number, "")
.AddField("status", "s_entityjob", FieldType._Number, "");
dtResult = rd.ExecuteQuery(iQuery).GetResult;
return(dtResult);
}
public int Save(string Name, string inputParam, string outputParam, string steps)
{
int NextID = rd.getNextID("Function");
Query iQuery = new QueryBuilder(QueryType._Insert
).AddTable("s_entity_function")
.AddField("FunctionID", "s_entity_function", FieldType._Number, "", NextID.ToString())
.AddField("Name", "s_entity_function", FieldType._String, "", Name.ToString())
.AddField("Inputparam", "s_entity_function", FieldType._String, "", inputParam.ToString())
.AddField("Outputparam", "s_entity_function", FieldType._String, "", outputParam.ToString())
.AddField("Steps", "s_entity_function", FieldType._String, "", steps.ToString())
.AddField("LastUPD", "s_entity_function", FieldType._DateTime, "", DateTime.Now.ToString());
if (rd.ExecuteQuery(iQuery).Result)
{
return(NextID);
}
else
{
return(-1);
}
}
public int Save(string Name, int entityKey, TechSharpy.Entitifier.Core.ActionType type, TechSharpy.Entitifier.Core.EventType eventType, string steps)
{
int NextID = rd.getNextID("Trigger");
Query iQuery = new QueryBuilder(QueryType._Insert
).AddTable("s_entity_trigger")
.AddField("TriggerID", "s_entity_trigger", FieldType._Number, "", NextID.ToString())
.AddField("Name", "s_entity_trigger", FieldType._String, "", Name.ToString())
.AddField("entityKey", "s_entity_trigger", FieldType._String, "", entityKey.ToString())
.AddField("Actiontype", "s_entity_trigger", FieldType._String, "", type.ToString())
.AddField("eventType", "s_entity_trigger", FieldType._String, "", eventType.ToString())
.AddField("LastUPD", "s_entity_trigger", FieldType._DateTime, "", DateTime.Now.ToString());
if (rd.ExecuteQuery(iQuery).Result)
{
return(NextID);
}
else
{
return(-1);
}
}
public int Save(int formComponentID, string name, string code, string description, string category)
{
var nextid = rd.getNextID("form");
iQuery = new QueryBuilder(QueryType._Insert)
.AddField("FormID", "s_form", FieldType._Number, "", nextid.ToString())
.AddField("Name", "s_form", FieldType._String, "", name.ToString())
.AddField("code", "s_form", FieldType._String, "", code.ToString())
.AddField("Description", "s_form", FieldType._String, "", description.ToString())
.AddField("Category", "s_form", FieldType._String, "", category.ToString())
.AddField("FormComponentID", "s_form", FieldType._Number, "", formComponentID.ToString())
.AddField("LastUPD", "s_form", FieldType._DateTime, "", DateTime.Now.ToString());
if (rd.ExecuteQuery(iQuery).Result)
{
return(nextid);
}
else
{
return(-1);
}
}
public int Save(int formID, int elementtype, string title, string code, int mode, string elementattribute
, int componentid)
{
int nextid = rd.getNextID("formelement");
iQuery = new QueryBuilder(QueryType._Insert)
.AddField("elementid", "s_formelement", FieldType._Number, "", nextid.ToString())
.AddField("formID", "s_formelement", FieldType._Number, "", formID.ToString())
.AddField("elementtype", "s_formelement", FieldType._Number, "", elementtype.ToString())
.AddField("title", "s_formelement", FieldType._String, "", title.ToString())
.AddField("code", "s_formelement", FieldType._String, "", code.ToString())
.AddField("Mode", "s_formelement", FieldType._Number, "", mode.ToString())
.AddField("componentid", "s_formelement", FieldType._Number, "", componentid.ToString())
.AddField("elementattribute", "s_formelement", FieldType._Text, "", elementattribute)
.AddField("LastUPD", "s_form", FieldType._DateTime, "", DateTime.Now.ToString());
if (rd.ExecuteQuery(iQuery).Result)
{
return(nextid);
}
else
{
return(-1);
}
}
public int SaveAction(int pEntitykey, int pActionType, bool pIsInclude, string pActionName, string pActionSchema)
{
int NextID = rd.getNextID("Action");
Query iQuery = new QueryBuilder(QueryType._Insert
).AddTable("s_entity_action")
.AddField("ActionID", "s_entity_action", FieldType._Number, "", NextID.ToString())
.AddField("ActionName", "s_entity_action", FieldType._String, "", pActionName.ToString())
.AddField("ActionType", "s_entity_action", FieldType._String, "", pActionType.ToString())
.AddField("ActionSchema", "s_entity_action", FieldType._String, "", pActionSchema.ToString())
.AddField("entityKey", "s_entity_action", FieldType._String, "", pEntitykey.ToString())
.AddField("ActionDate", "s_entity_action", FieldType._String, "", DateTime.Now.ToString())
.AddField("IsInclude", "s_entity_action", FieldType._Question, "", pIsInclude.ToString())
.AddField("lastUPD", "s_entity_action", FieldType._Question, "", DateTime.Now.ToString());
if (rd.ExecuteQuery(iQuery).Result)
{
return(NextID);
}
else
{
return(-1);
}
}
public DataTable GetNodeByEntityKey(int entitykey, int modelID)
{
iQuery = new QueryBuilder(QueryType._Select)
.AddField("left", "s_EntityModelNode")
.AddField("right", "s_EntityModelNode")
.AddField("NodeID", "s_EntityModelNode")
.AddField("depth", "s_EntityModelNode")
.AddField("nodekey", "s_EntityModelNode")
.AddField("entitykey", "s_EntityModelNode")
.AddWhere(0, "s_EntityModelNode", "Entitykey", FieldType._Number, entitykey.ToString(), Condition._And)
.AddWhere(0, "s_EntityModelNode", "modelID", FieldType._Number, modelID.ToString());
return(rd.ExecuteQuery(iQuery).GetResult);
}
public DataTable GetEntityList(int ClientID)
{
dtResult = new DataTable();
//dtResult.Pivot("","");
Query selectQ = new QueryBuilder(QueryType._Select).AddTable("s_entity").AddField("*", "s_entity").
AddWhere(0, "s_entity", "ClientID", FieldType._Number, Operator._Equal, ClientID.ToString());
dtResult = rd.ExecuteQuery(selectQ).GetResult;
return(dtResult);
}
