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); } }