public int Save(string Datasourcekey, string name, string description, string steps,
DateTime jobstartDate, DateTime jobTime, JobType type, DateTime currentSchedule, Status status)
{
int inext = rd.getNextID("Job");
iQuery = new QueryBuilder(QueryType._Insert)
.AddField("jobid", "s_entityjob", FieldType._Number, "", inext.ToString())
.AddField("datasourcekey", "s_entityjob", FieldType._String, "", Datasourcekey.ToString())
.AddField("name", "s_entityjob", FieldType._String, "", name.ToString())
.AddField("description", "s_entityjob", FieldType._String, "", description.ToString())
.AddField("steps", "s_entityjob", FieldType._String, "", steps.ToString())
.AddField("jobstartdate", "s_entityjob", FieldType._DateTime, "", jobstartDate.ToString())
.AddField("jobtime", "s_entityjob", FieldType._DateTime, "", jobTime.ToString())
.AddField("currentschedule", "s_entityjob", FieldType._DateTime, "", currentSchedule.ToString())
.AddField("type", "s_entityjob", FieldType._Number, "", type.ToString())
.AddField("status", "s_entityjob", FieldType._Number, "", status.ToString());
if (rd.ExecuteQuery(iQuery).Result)
{
return(inext);
}
else
{
return(-1);
}
}
public int Save(int pClientID, string pName, bool pIsCore, bool haveChild, TechSharpy.Entitifier.Core.LookUpType lookupType)
{
int NextID = rd.getNextID("LookUp");
Query iQuery = new QueryBuilder(QueryType._Insert
).AddTable("s_entitylookup")
.AddField("LookUpID", "s_entitylookup", FieldType._Number, "", NextID.ToString())
.AddField("LookUpName", "s_entitylookup", FieldType._String, "", pName.ToString())
.AddField("IsCore", "s_entitylookup", FieldType._Question, "", pIsCore.ToString())
.AddField("HaveChild", "s_entitylookup", FieldType._Question, "", haveChild.ToString())
.AddField("ClientID", "s_entitylookup", FieldType._Number, "", pClientID.ToString())
.AddField("LookUpType", "s_entitylookup", FieldType._Number, "", ((int)lookupType).ToString())
.AddField("LastUPD", "s_entitylookup", FieldType._DateTime, "", DateTime.Now.ToString());
if (rd.ExecuteQuery(iQuery).Result)
{
return(NextID);
}
else
{
return(-1);
}
}
public int Save(string ModelName, string Sourcekey)
{
try
{
int NextID = rd.getNextID("EntityModel");
iQuery = new QueryBuilder(QueryType._Insert)
.AddField("ModelID", "s_EntityModel", FieldType._Number, "", NextID.ToString())
.AddField("ModelName", "s_EntityModel", FieldType._String, "", ModelName)
// .AddField("Sourcekey", "s_EntityModel", FieldType._String, "", Sourcekey)
.AddField("LastUPD", "s_EntityModel", FieldType._DateTime, "", DateTime.Now.ToString());
if (rd.ExecuteQuery(iQuery).Result)
{
return(NextID);
}
else
{
return(-1);
}
}
catch (Exception ex) {
throw ex;
}
}
public int Save(int pClientID, string pTableName, string Name, string pDescription, string keys, TechSharpy.Entitifier.Core.EntityType pType)
{
int NextID = rd.getNextID("Entity");
Query iQuery = new QueryBuilder(QueryType._Insert
).AddTable("s_entity")
.AddField("EntityID", "s_entity", FieldType._Number, "", NextID.ToString())
.AddField("Name", "s_entity", FieldType._String, "", Name.ToString())
.AddField("Keys", "s_entity", FieldType._String, "", keys.ToString())
.AddField("TableName", "s_entity", FieldType._String, "", pTableName.ToString())
.AddField("Description", "s_entity", FieldType._String, "", pDescription.ToString())
.AddField("Type", "s_entity", FieldType._Number, "", Convert.ToInt32(pType).ToString())
.AddField("ClientID", "s_entity", FieldType._Number, "", pClientID.ToString())
.AddField("LastUPD", "s_entity", FieldType._DateTime, "", DateTime.Now.ToString());
if ((rd.ExecuteQuery(iQuery).Result))
{
return(NextID);
}
else
{
return(-1);
}
}
public int Save(string sourceKey, string name)
{
int nextid = rd.getNextID("DataSource");
iQuery = new QueryBuilder(QueryType._Insert)
.AddField("DataSourceID", "s_DataSource", FieldType._Number, "", nextid.ToString())
.AddField("sourceKey", "s_DataSource", FieldType._String, "", sourceKey)
.AddField("name", "s_DataSource", FieldType._String, "", name)
.AddField("LastUPD", "s_DataSource", FieldType._DateTime, "", DateTime.Now.ToString());
if (rd.ExecuteQuery(iQuery).Result)
{
return(nextid);
}
else
{
return(-1);
}
}
public int Save(string Name, string steps, string datasourcekey)
{
int NextID = rd.getNextID("procedure");
Query iQuery = new QueryBuilder(QueryType._Insert
).AddTable("s_entity_procedure")
.AddField("ProcedureID", "s_entity_procedure", FieldType._Number, "", NextID.ToString())
.AddField("Name", "s_entity_procedure", FieldType._String, "", Name.ToString())
.AddField("datasourcekey", "s_entity_procedure", FieldType._String, "", datasourcekey.ToString())
.AddField("Steps", "s_entity_procedure", FieldType._String, "", steps.ToString())
.AddField("LastUPD", "s_entity_procedure", FieldType._DateTime, "", DateTime.Now.ToString());
if (rd.ExecuteQuery(iQuery).Result)
{
return(NextID);
}
else
{
return(-1);
}
}
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 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 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);
}
}
