//C:\Users\Eminent\Documents\Projects\perception\CMS\CMS\CMS\Files\_originals\Koala.jpg //string strPath = HttpContext.Current.Server.MapPath("/Files/_originals/Koala.jpg"); public Values.AddFile SaveFile(IConnectToDB _Connect, IFormFile File) { add addHelp = new add(); string ContentType = File.ContentType; long? ContentSize = File.Length; string FileName = File.FileName; byte[] longRaw = new byte[File.Length]; //TODO: Review .Net Core Port if (File.Length > 0) { using (var ms = new MemoryStream()) { File.CopyTo(ms); longRaw = ms.ToArray(); //string s = Convert.ToBase64String(fileBytes); // act on the Base64 data } } Values.AddFile thisFile = addHelp.ADD_ENTRY_FILE(_Connect, new Values.AddFile { I_FILE_NAME = FileName, I_CONTENT_TYPE = ContentType, I_FILE_SIZE = ContentSize, I_FILE_DATA = longRaw }); return(thisFile); }
public List <CommandResult> EXTEND_SCAFFOLD(IConnectToDB _Connect, string Name) { List <CommandResult> HoldResult = new List <CommandResult>(); ER_Generate gen = new ER_Generate(); HoldResult.Add(new CommandResult { _Successful = true, _Response = "---Start Scaffold " + Name + "", _EndTime = DateTime.Now }); List <string> ColumnsList2 = new List <string>(); ColumnsList2.Add(Name + "_ID"); //Add(ADD_TABLE(Name)); //HoldResult.AddRange(ADD_COLUMNS(_Connect, Name, ColumnsList)); //HoldResult.Add(ADD_KEY_UNIQUE(_Connect, Name, ColumnsList2)); //HoldResult.Add(er_ddl.ADD_ORACLE_SEQUENCE(_Connect, Name)); //HoldResult.Add(er_ddl.ADD_SEQUENCE_TRIGGER(_Connect, Name, "Before", "INSERT", (Name + "_SQ"), (Name + "_ID"))); HoldResult.AddRange(gen.ADD_PROCEDURE_INSERT(_Connect, Name, "")); HoldResult.AddRange(gen.ADD_PROCEDURE_UPDATE(_Connect, Name, "")); HoldResult.AddRange(gen.ADD_PROCEDURE_DELETE(_Connect, Name, "")); HoldResult.Add(new CommandResult { _Successful = true, _Response = "---End Scaffold " + Name + "", _EndTime = DateTime.Now }); return(HoldResult); }
public ViewObjectPropFile GetFileByID(IConnectToDB _Connect, Guid?FileID) { byte[] bytes = new byte[0]; ViewObjectPropFile _File = new ViewObjectPropFile(); _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "OBJ_PROP_SETS_DAT_FILE_ID_", DBType = SqlDbType.UniqueIdentifier, ParamValue = FileID }); DataTable _DT = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__OBJ_PROP_SETS_DAT_FILE_SEARCH", new DataTableDotNetModelMetaData { columns = "DT_CREATED, CONTENT_TYPE, FILE_NAME", length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); DataColumnCollection DCC = _DT.Columns; if (DCC.Contains("FILE_NAME") && _DT.Rows.Count > 0) { string thisFileRow = new JObject(_DT.Columns.Cast <DataColumn>() .Select(c => new JProperty(c.ColumnName, JToken.FromObject(_DT.Rows[0][c]))) ).ToString(Formatting.None); _File = Newtonsoft.Json.JsonConvert.DeserializeObject <ViewObjectPropFile>(thisFileRow); } return(_File); }
public long?GetProfileRendition(IConnectToDB _Connect, long?identity_id) { long?value = 0; ER_DML er_dml = new ER_DML(); _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "IDENTITIES_ID_", DBType = SqlDbType.BigInt, ParamValue = identity_id }); DataTable TempDataTable = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW_PROFILES_DAT_CHAR_RENDITION_SEARCH", new DataTableDotNetModelMetaData { length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); foreach (DataRow row in TempDataTable.Rows) { if (row["rendition"].ToString() != "") { value = ER_Tools.ConvertToInt64(row["rendition"].ToString()); } } return(value); }
public static string GetSymbolbyID(IConnectToDB _Connect, string SymbolName) { string sqlstatement = "Select * from CSA.SYMBOLS where LOWER(SYMBOL_NAME) = @SYMBOL_NAME"; ER_Query.Parameter_Run SQlin = new ER_Query.Parameter_Run { sqlIn = sqlstatement, _dbParameters = new List <DBParameters> { new DBParameters { ParamName = "SYMBOL_NAME", MSSqlParamDataType = SqlDbType.BigInt, ParamValue = SymbolName.ToLower() } } }; DataTable _DT = ER_Query._RUN_PARAMETER_QUERY(_Connect, SQlin); DataColumnCollection DCC = _DT.Columns; if (_DT.Rows.Count > 0 && DCC.Contains("SYMBOLS_ID")) { return(_DT.Rows[0]["SYMBOLS_ID"].ToString()); } else { return("1000"); } }
public long?AddProfileEntry(IConnectToDB _Connect, long?identitiesId) { SecurityHelper securityHelper = new SecurityHelper(); add addHelp = new add(); long? profilesId = null; long? privilegesId = ER_Tools.ConvertToInt64(securityHelper.GetPrivID(_Connect, "ADD PROFILE")); //Enter profile information Values.AddProfiles ProfilesModel = null; ProfilesModel = addHelp.ADD_ENTRY_Profiles(_Connect, new Values.AddProfiles { I_IDENTITIES_ID = identitiesId, I_ENABLED = 'Y', }); profilesId = ProfilesModel.O_PROFILES_ID; //Enter profile security information //Values.AddProfilesSecPriv ProfilesSecPrivModel = null; //ProfilesSecPrivModel = addHelp.ADD_ENTRY_Profiles_Sec_Priv(_Connect, new Values.AddProfilesSecPriv //{ // I_OBJECT_TYPE = "Permission", // I_PROFILES_ID = profilesId, // I_PRIVILEGES_ID = privilegesId, // I_ENABLED = 'Y', // I_IDENTITIES_ID = identitiesId //}); //profilesSecPrivId = ProfilesSecPrivModel.O_PROFILES_SEC_PRIV_ID; return(profilesId); }
public string GetProfileData(IConnectToDB _Connect, long?identity_id, string property) { string value = "", rendition = ""; rendition = GetProfileRendition(_Connect, identity_id).ToString(); _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "IDENTITIES_ID_", DBType = SqlDbType.BigInt, ParamValue = identity_id }); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "RENDITION_", DBType = SqlDbType.VarChar, ParamSize = -1, ParamValue = rendition }); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "PROPERTY_VALUE_", DBType = SqlDbType.VarChar, ParamSize = -1, ParamValue = property }); DataTable TempDataTable = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__PROFILES_DAT_CHAR_SEARCH", new DataTableDotNetModelMetaData { columns = "VALUE", length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); if (TempDataTable.Rows.Count > 0) { value = TempDataTable.Rows[0][0].ToString(); } return(value); }
public Dictionary.DropView DROP_Dictionary_View(IConnectToDB _Connect, string ViewName) { List <DBParameters> EntryProcedureParameters = new List <DBParameters>(); ER_Query.Parameter_Run SQlin = new ER_Query.Parameter_Run { sqlIn = "Select * from CSA.ER_VIEWS where UPPER(VIEW_NAME) = @VIEW_NAME", _dbParameters = new List <DBParameters> { new DBParameters { ParamName = "VIEW_NAME", MSSqlParamDataType = SqlDbType.VarChar, ParamValue = ViewName.ToUpper() } } }; DataTable _DT = ER_Query._RUN_PARAMETER_QUERY(_Connect, SQlin); DataColumnCollection DCC = _DT.Columns; Dictionary.DropView thisModel = new Dictionary.DropView(); if (_DT.Rows.Count > 0 && DCC.Contains("ER_VIEWS_ID")) { thisModel = new Dictionary.DropView { I_ER_VIEWS_ID = _DT.Rows[0].Field <long?>("ER_VIEWS_ID") }; Universal_Call <Dictionary.DropView> dv = new Universal_Call <Dictionary.DropView>(); thisModel = dv.GenericInputProcedure(_Connect, thisModel); } return(thisModel); }
public string GetNotificationSettingValue(IConnectToDB _Connect, long?identity, string type) { ER_Query er_query = new ER_Query(); ER_Query.Parameter_Run SQlin = new ER_Query.Parameter_Run(); string settingValue = ""; SQlin.sqlIn = "Select property_type from CSA.IDENTITY_PROPERTIES a where a.DT_CREATED >= (select max(ip.DT_CREATED) FROM CSA.IDENTITY_PROPERTIES ip where ip.IDENTITIES_ID = @IDENTITIES_ID and ip.PROPERTY_NAME = @PROPERTY_NAME) and a.PROPERTY_NAME = @PROPERTY_NAME"; SQlin._dbParameters = new List <DBParameters> { new DBParameters { ParamName = "IDENTITIES_ID", MSSqlParamDataType = SqlDbType.BigInt, ParamValue = identity }, new DBParameters { ParamName = "PROPERTY_NAME", MSSqlParamDataType = SqlDbType.VarChar, ParamValue = type } }; DataTable TempDataTable = er_query.RUN_PARAMETER_QUERY(_Connect, SQlin); if (TempDataTable.Rows.Count > 0) { settingValue = TempDataTable.Rows[0][0].ToString(); } return(settingValue); }
public DataTable FindNotifications(IConnectToDB _Connect, string start) { ER_Query er_query = new ER_Query(); ER_Query.Parameter_Run SQlin = new ER_Query.Parameter_Run(); SQlin._dbParameters = new List <DBParameters> { new DBParameters { ParamName = "ACTIVITY_ID", MSSqlParamDataType = SqlDbType.BigInt, ParamValue = start } }; SQlin.sqlIn = " Select * " + " from (Select ROW_NUMBER() OVER(ORDER BY ACTIVITY_ID ) AS rownumb, * from CSA.VW__ACTIVITY where Lower(object_type) in ('add object','delete object') and " + "Lower(table_source) in ('identities', 'applications')) ok " + " where rownumb between CONVERT(int, (select rownumb1 from (Select ROW_NUMBER() OVER(ORDER BY ACTIVITY_ID ) AS rownumb1, * from CSA.VW__ACTIVITY where Lower(object_type) in ('add object','delete object') and " + " Lower(table_source) in ('identities', 'applications')) ok1 where activity_id = @ACTIVITY_ID)) + 1 and CONVERT(int, (select rownumb1 from (Select ROW_NUMBER() OVER(ORDER BY ACTIVITY_ID ) AS rownumb1, * from CSA.VW__ACTIVITY where Lower(object_type) in ('add object','delete object') and " + " Lower(table_source) in ('identities', 'applications')) ok1 where activity_id = @ACTIVITY_ID)) + 10 and Lower(object_type) in ('add object','delete object') and " + " Lower(table_source) in ('identities', 'applications') Order by DT_CREATED desc"; DataTable TempDataTable = er_query.RUN_PARAMETER_QUERY(_Connect, SQlin); return(TempDataTable); }
public static flowObject GetWorkflowIfExists(IConnectToDB _Connect, Guid?applications_uuid, string Column) { flowObject theWorkflow = null; List <DynamicModels.RootReportFilter> thisTempFilters = new List <DynamicModels.RootReportFilter>(); thisTempFilters.Add(new DynamicModels.RootReportFilter { FilterName = "GET_LATEST", ParamValue = "T" }); thisTempFilters.Add(new DynamicModels.RootReportFilter { FilterName = Column + "_", ParamValue = applications_uuid }); DataTable AppWorkflow = _DynamicOutputProcedures._DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__WORKFLOWS_SEARCH", new DataTableDotNetModelMetaData { length = -1, order = "1 desc", start = 0, verify = "T" }, thisTempFilters); if (AppWorkflow.Rows.Count > 0) { byte[] thisWorkflowBytes = AppWorkflow.Rows[0].Field <Byte[]>("WORKFLOW"); theWorkflow = Revamp.IO.Tools.Box.FromByteArray <flowObject>(thisWorkflowBytes); theWorkflow.workflows_uuid = AppWorkflow.Rows[0].Field <Guid?>("workflows_uuid"); theWorkflow.base_workflows_uuid = AppWorkflow.Rows[0].Field <Guid?>("base_workflows_uuid"); } return(theWorkflow); }
public List <ObjectPropSetModels> GetPropSetsbySetNID(IConnectToDB _Connect, List <ObjectPropSetModels> PropSets, ObjectSetModels ObjSet, int identity_id) { ObjectPropSetsHelper PropSetHelper = new ObjectPropSetsHelper(); DataTable PropSetDT = PropSetHelper.FindbyColumnID(_Connect, "Object_Sets_ID", ObjSet.SetView.object_sets_id.ToString()); foreach (DataRow PropRows in PropSetDT.Rows) { ObjectPropSetModels PropSet = new ObjectPropSetModels(); PropSet.PropSetView = new PropSetView(); PropSet.PropSetView.obj_prop_sets_id = PropRows.Field <long?>("obj_prop_sets_id"); PropSet.PropSetView.object_prop_type = PropRows.Field <string>("object_prop_type"); PropSet.PropSetView.property_name = PropRows.Field <string>("property_name"); PropSet.PropSetView.property_value = PropRows.Field <string>("property_value"); PropSet.PropSetView.value_datatype = PropRows.Field <string>("value_datatype"); PropSet.PropSetView.has_parent = PropRows.Field <string>("has_parent"); PropSet.PropSetView.has_child = PropRows.Field <string>("has_child"); PropSet.PropSetView.parent_obj_prop_sets_id = PropRows.Field <long?>("parent_obj_prop_sets_id"); PropSet.ObjectPropOptSets = GetPropOptSetsbyPropSetNID(_Connect, new List <ObjectPropOptSetModels>(), PropSet, identity_id); PropSets.Add(PropSet); } return(PropSets); }
public DataTable Find(IConnectToDB _Connect, string _id, string type) { _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); switch (type.ToLower()) { case "cores": case "core": Filters.Add(new DynamicModels.RootReportFilter { FilterName = "CORES_ID_", DBType = SqlDbType.BigInt, ParamValue = _id }); break; case "coreactivity": Filters.Add(new DynamicModels.RootReportFilter { FilterName = "OBJECT_TYPE_", DBType = SqlDbType.VarChar, ParamSize = -1, ParamValue = "add object" }); //Filters.Add(new DynamicModels.RootReportFilter { FilterName = "OBJECT_TYPE_", DBType = SqlDbType.VarChar, ParamSize = -1, ParamValue = type }); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "TABLE_SOURCE_", DBType = SqlDbType.VarChar, ParamSize = -1, ParamValue = "applications" }); break; } DataTable TempDataTable = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__ACTIVITY_SEARCH", new DataTableDotNetModelMetaData { length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); return(TempDataTable); }
public List <GripModels> GetgripsforStage(IConnectToDB _Connect, List <GripModels> Grips, StageModels Stage, int identity_id) { GripsHelper griphelper = new GripsHelper(); DataTable StageGrips = griphelper.FindbyColumnID(_Connect, "Stages_ID", Stage.Stage.stages_id.ToString()); foreach (DataRow GripRows in StageGrips.Rows) { GripModels grip = new GripModels(); grip.gripinfo = new GripModel(); grip.gripinfo.grips_id = GripRows.Field <long?>("grips_id"); grip.gripinfo.grip_name = GripRows.Field <string>("grip_name"); grip.gripinfo.grip_type = GripRows.Field <string>("grip_type"); grip.gripinfo.stages_id = GripRows.Field <long?>("stages_id"); grip.gripinfo.stage_name = GripRows.Field <string>("stage_name"); grip.gripinfo.stage_type = GripRows.Field <string>("stage_type"); grip.gripinfo.identities_id = GripRows.Field <long?>("identities_id"); grip.gripinfo.enabled = GripRows.Field <string>("enabled"); grip.gripinfo.dt_created = GripRows.Field <DateTime>("dt_created"); grip.gripinfo.dt_available = GripRows.Field <DateTime?>("dt_available"); grip.ObjectSets = GetSetsbyGripNID(_Connect, new List <ObjectSetModels>(), grip, identity_id); Grips.Add(grip); } return(Grips); }
public List <StageModels> GetStagesForAppandUserID(IConnectToDB _Connect, List <StageModels> Stages, ApplicationModels application, int identity_id) { StagesHelper stageshelper = new StagesHelper(); DataTable ApplicationStages = stageshelper.FindbyColumnID(_Connect, "Applications_ID", application.AppView.applications_id.ToString()); foreach (DataRow StageRows in ApplicationStages.Rows) { StageModels tempStageModel = new StageModels(); tempStageModel.Stage = new StageModel(); tempStageModel.Grips = new List <GripModels>(); tempStageModel.Stage.stages_id = StageRows.Field <long?>("stages_id"); tempStageModel.Stage.stage_name = StageRows.Field <string>("stage_name"); tempStageModel.Stage.stage_type = StageRows.Field <string>("stage_type"); tempStageModel.Stage.dt_created = StageRows.Field <DateTime>("dt_created"); tempStageModel.Stage.dt_available = StageRows.Field <DateTime?>("dt_available"); tempStageModel.Stage.dt_end = StageRows.Field <DateTime?>("dt_end"); tempStageModel.Stage.enabled = StageRows.Field <string>("enabled"); tempStageModel.Grips = GetgripsforStage(_Connect, new List <GripModels>(), tempStageModel, identity_id); Stages.Add(tempStageModel); } return(Stages); }
public List <CoreModels> GetsCoreForUserID(IConnectToDB _Connect, List <CoreModels> Cores, int identity_id) { //Get Cores for user. CoreHelper CoreHelper = new CoreHelper(); DataTable CoreTable = CoreHelper.FindAll(_Connect); foreach (DataRow CoreRow in CoreTable.Rows) { //Instantiate New Models CoreModels CoreModel = new CoreModels(); CoreModel.Core = new CoreStruct(); CoreModel.Core.Core = new CoreTableModel(); CoreModel.Core.Core.core_name = CoreRow.Field <string>("core_name"); CoreModel.Core.Core.dt_created = CoreRow.Field <DateTime>("dt_created"); CoreModel.Core.Core.cores_id = CoreRow.Field <long?>("cores_id"); CoreModel.Core.Core.object_type = CoreRow.Field <string>("object_type"); CoreModel.Core.Core.dt_available = CoreRow.Field <DateTime?>("dt_available"); CoreModel.Core.Core.dt_end = CoreRow.Field <DateTime?>("dt_end"); CoreModel.Core.Core.enabled = CoreRow.Field <string>("enabled"); //Get Applications belonging to Each Core. CoreModel.applications = GetApplicationsForUserID(_Connect, CoreModel, new List <ApplicationModels>(), identity_id); Cores.Add(CoreModel); } return(Cores); }
public List <ViewObjectPropSetsModel> GetObjectPropSetsViaObjectSet(IConnectToDB _Connect, string object_sets_id) { //ObjectSets objectsets = new ObjectSets(); ObjectPropSetsHelper objectpropsets = new ObjectPropSetsHelper(); DataTable objectpropsetsdt; if (object_sets_id.ToLower() == "all") { objectpropsetsdt = objectpropsets.FindAll(_Connect); } else { objectpropsetsdt = objectpropsets.FindbyColumnID(_Connect, "object_sets_id", object_sets_id); } List <ViewObjectPropSetsModel> ObjectPropSetsList = new List <ViewObjectPropSetsModel>(); ViewObjectPropSetsModel[] ObjectPropSets = new ViewObjectPropSetsModel[objectpropsetsdt.Rows.Count]; for (int i = 0; i < objectpropsetsdt.Rows.Count; i++) { string thisPropSet = new JObject(objectpropsetsdt.Columns.Cast <DataColumn>() .Select(c => new JProperty(c.ColumnName, JToken.FromObject(objectpropsetsdt.Rows[i][c]))) ).ToString(Formatting.None); ObjectPropSets[i] = JsonConvert.DeserializeObject <ViewObjectPropSetsModel>(thisPropSet); ObjectPropSets[i].ObjectPropOptSets = objectpropsets.GetPropOptSetsViaPropSets(_Connect, ObjectPropSets[i].obj_prop_sets_id.ToString()); ObjectPropSetsList.Add(ObjectPropSets[i]); } return(ObjectPropSetsList); }
//Returns the count of the new notifications public string NewNotificationCount(IConnectToDB _Connect, string _identity) { ER_Query er_query = new ER_Query(); ER_Query.Parameter_Run SQlin = new ER_Query.Parameter_Run(); string count = ""; SQlin._dbParameters = new List <DBParameters> { new DBParameters { ParamName = "IDENTITIES_ID", MSSqlParamDataType = SqlDbType.BigInt, ParamValue = _identity }, }; SQlin.sqlIn = " Select COUNT(*) total from CSA.VW__ACTIVITY a where a.APPLICATION_NAME != 'Core Settings' and a.DT_CREATED >= (select max(ip.DT_CREATED) FROM CSA.IDENTITY_PROPERTIES ip where ip.IDENTITIES_ID = @IDENTITIES_ID) and a.OBJECT_TYPE not in ('Login','Access Log')"; DataTable TempDataTable = er_query.RUN_PARAMETER_QUERY(_Connect, SQlin); if (TempDataTable.Rows.Count > 0) { count = TempDataTable.Rows[0][0].ToString(); } return(count); }
public string GetSessionAndRequest(IConnectToDB _Connect, long?_identities_id, string uname) { SessionRequest SR = new SessionRequest(); SR.identities_id = _identities_id > 0 ? _identities_id : 0; SR.username = uname; //TODO: Refactor for .Net Core /* SR.anonymousid = System.Web.HttpContext.Current.Request.AnonymousID != null ? System.Web.HttpContext.Current.Request.AnonymousID : "0"; * SR.sessionid = !Current.Session.Keys.Contains("SessionID") ? "" : Current.Session.GetString("SessionID"); * SR.timeout = !Current.Session.Keys.Contains("Timeout") ? "" : Current.Session.GetString("Timeout"); * SR.useragent = !Current.Request.Headers.Keys.Contains("User-Agent") ? "" : Current.Request.Headers["User-Agent"].ToString(); * SR.userhostaddress = !Current.Request.Headers.Keys.Contains("UserHostAddress") ? "" : Current.Request.Headers["UserAgent"].ToString(); * SR.userhostaddress = System.Web.HttpContext.Current.Request.UserHostAddress == null ? "" : System.Web.HttpContext.Current.Request.UserHostAddress; * SR.userhostname = System.Web.HttpContext.Current.Request.UserHostName == null ? "" : System.Web.HttpContext.Current.Request.UserHostName; * SR.isauthenticated = System.Web.HttpContext.Current.Request.IsAuthenticated.ToString() == null ? "" : System.Web.HttpContext.Current.Request.IsAuthenticated.ToString(); * SR.logonuseridentity = System.Web.HttpContext.Current.Request.LogonUserIdentity.Name.ToString() == null ? "" : System.Web.HttpContext.Current.Request.LogonUserIdentity.Name.ToString(); * SR.browser = System.Web.HttpContext.Current.Request.Browser.Browser.ToString() == null ? "" : System.Web.HttpContext.Current.Request.Browser.Browser.ToString(); * SR.majorversion = System.Web.HttpContext.Current.Request.Browser.MajorVersion.ToString() == null ? "" : System.Web.HttpContext.Current.Request.Browser.MajorVersion.ToString(); * SR.version = System.Web.HttpContext.Current.Request.Browser.Version.ToString() == null ? "" : System.Web.HttpContext.Current.Request.Browser.Version.ToString(); * SR.crawler = System.Web.HttpContext.Current.Request.Browser.Crawler.ToString() == null ? "" : System.Web.HttpContext.Current.Request.Browser.Crawler.ToString(); * SR.clrversion = System.Web.HttpContext.Current.Request.Browser.ClrVersion.ToString() == null ? "" : System.Web.HttpContext.Current.Request.Browser.ClrVersion.ToString(); * SR.cookies = ""; * SR.ismobiledevice = System.Web.HttpContext.Current.Request.Browser.IsMobileDevice.ToString() == null ? "" : System.Web.HttpContext.Current.Request.Browser.IsMobileDevice.ToString(); * SR.platform = System.Web.HttpContext.Current.Request.Browser.Platform == null ? "" : System.Web.HttpContext.Current.Request.Browser.Platform; * SR.url = System.Web.HttpContext.Current.Request.Url.ToString() == null ? "" : System.Web.HttpContext.Current.Request.Url.ToString(); * SR.urlreferrer = (System.Web.HttpContext.Current.Request.UrlReferrer == null) ? "" : System.Web.HttpContext.Current.Request.UrlReferrer.ToString();*/ return(LogRequest(_Connect, SR)); }
public DataTable FindAll(IConnectToDB _Connect, string _typeofActivity) { _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); switch (_typeofActivity.ToLower()) { case "all": break; default: Filters.Add(new DynamicModels.RootReportFilter { FilterName = "OBJECT_TYPE_", DBType = SqlDbType.VarChar, ParamSize = -1, ParamValue = _typeofActivity }); break; } DataTable TempDataTable = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__ACTIVITY_SEARCH", new DataTableDotNetModelMetaData { length = -1, order = "DT_CREATED desc", start = 0, verify = "T" }, Filters); return(TempDataTable); }
public string PROCEDURE_ACTION(IConnectToDB _Connect, string ProcedureName, List <DBParameters> EntryProcedureParameters, string _ReturnParameter) { List <DBParameters> ParamListDynamic = new List <DBParameters>(); switch (_Connect.Platform.ToLower()) { case "microsoft": Paramatizer(EntryProcedureParameters, ParamListDynamic); BIG_CALL RUN = new BIG_CALL(); RUN.COMMANDS = new List <SQL_PROCEDURE_CALL>(); RUN.COMMANDS.Add(new SQL_PROCEDURE_CALL { ProcedureType = "value", ProcedureName = ProcedureName, _dbParameters = ParamListDynamic }); DataTable _result = ER_Procedure.SQL_PROCEDURE_PARAMS(_Connect, RUN).COMMANDS[0].result._DataTable; return(ER_Procedure.SQL_PROCEDURE_GET_VALUE("@" + _ReturnParameter, _result)); default: return("Invalid DB Platform"); } }
// START DB SQL Executes, USER for DDL, and DML //Only for None Query SQL statements. public bool CanIdentityConnect(IConnectToDB _Connect) { switch (_Connect.Platform) { case "Microsoft": case "MICROSOFT": using (SqlConnection connection = new SqlConnection(_Connect.DBConnString)) { try { connection.Open(); return(true); } catch (SqlException ex) { string err = ex.ToString(); return(false); } finally { connection.Close(); connection.Dispose(); } } default: return(false); } }
public DataTable GET_COLUMNS_VIA_TABLENAME(IConnectToDB _Connect, string TableName) { StringBuilder SQLin = new StringBuilder(); SQLin.Append("Select COLUMN_NAME, DATA_TYPE, "); switch (_Connect.Platform) { case "Microsoft": case "MICROSOFT": SQLin.Append("CHARACTER_OCTET_LENGTH DATA_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE "); SQLin.Append("from INFORMATION_SCHEMA.COLUMNS "); SQLin.Append("where upper(TABLE_NAME) = upper(@TABLE_NAME) "); SQLin.Append("order by ORDINAL_POSITION ASC "); ER_Query.Parameter_Run SQlin = new ER_Query.Parameter_Run { sqlIn = SQLin.ToString(), _dbParameters = new List <DBParameters> { new DBParameters { ParamName = "TABLE_NAME", MSSqlParamDataType = SqlDbType.VarChar, ParamValue = TableName } } }; return(ER_Query._RUN_PARAMETER_QUERY(_Connect, SQlin)); default: return(new DataTable()); } }
public List <string> GetAllStagesforApp(IConnectToDB _Connect, string applications_id) { _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "APPLICATIONS_ID_", DBType = SqlDbType.BigInt, ParamValue = applications_id }); DataTable TempDataTable = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__STAGES_SEARCH", new DataTableDotNetModelMetaData { columns = "stages_id", length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); List <string> stagesList = new List <string>(); foreach (DataRow datarowdc in TempDataTable.Rows) { stagesList.Add(datarowdc["stages_id"].ToString()); } return(stagesList); }
public void ChangePassword(IConnectToDB _Connect, Guid?uuid, string password) { _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); ER_Sec er_sec = new ER_Sec(); add addHelp = new add(); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "IDENTITIES_UUID_", DBType = SqlDbType.UniqueIdentifier, ParamValue = uuid }); DataTable TempDataTable = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__ID_PASSWORD_SEARCH", new DataTableDotNetModelMetaData { columns = "ID_PASSWORD_ID,RENDITION,IDENTITIES_ID", length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); DataColumnCollection _dccColumnID = TempDataTable.Columns; if (_dccColumnID.Contains("ID_PASSWORD_ID") && TempDataTable.Rows.Count > 0) { //Update Password Values.UpdateIDPassword IDPasswordModel = null; string hash = ER_Sec.ComputeHash(password, "SHA512", null); IDPasswordModel = addHelp.UPDATE_ENTRY_Identities_Password(_Connect, new Values.UpdateIDPassword { I_ID_PASSWORD_ID = TempDataTable.Rows[0].Field <long?>("ID_PASSWORD_ID"), I_OBJECT_TYPE = "Password", I_RENDITION = TempDataTable.Rows[0].Field <long?>("RENDITION"), I_PASSWORD = er_sec.EncryptStringToBytes_Aes(hash, er_sec.GetCryptPairforID(_Connect, TempDataTable.Rows[0].Field <long?>("IDENTITIES_ID"), new ER_CRYPT_PAIR())) }); } }
public List <CommandResult> ADD_SCAFFOLD_FLOW(IConnectToDB _Connect, string Name, string ScaffoldType, List <ColumnStructure> ColumnsList) { Tools.Box er_tools = new Tools.Box(); List <CommandResult> HoldResult = new List <CommandResult>(); ER_Generate gen = new ER_Generate(); string newTableName = er_tools.MaxNameLength(Name, (128 - 16)); string Actions_Table = newTableName + "_Flo_Acts"; string Identities_Table = newTableName + "_Flo_Iden"; string Conditions_Table = newTableName + "_Flo_Cond"; string if_table = newTableName + "_Flo_If"; string then_table = newTableName + "_Flo_Then"; HoldResult.Add(new CommandResult { _Response = "--Start FLOW Scaffold " + Name + "", _Successful = true }); List <string> ColumnsList2 = new List <string>(); ColumnsList2.Add(Name + "_ID"); HoldResult.AddRange(ER_DDL._ADD_TABLE(_Connect, Name, ScaffoldType)); HoldResult.AddRange(ER_DDL._ADD_COLUMNS(_Connect, Name, ColumnsList)); HoldResult.AddRange(ER_DDL._ADD_KEY_UNIQUE(_Connect, Name + "_ID", Name, ColumnsList2)); HoldResult.AddRange(gen.ADD_PROCEDURE_INSERT(_Connect, Name, "")); HoldResult.AddRange(gen.ADD_PROCEDURE_UPDATE(_Connect, Name, "")); HoldResult.AddRange(gen.ADD_PROCEDURE_DELETE(_Connect, Name, "")); HoldResult.Add(new CommandResult { _Response = "--EndScaffold " + Name + "", _Successful = true }); return(HoldResult); }
//TOLEARN: This is important and has to be refactored for new system. public DataTable FindIDStatuses(IConnectToDB _Connect, long?identities_id) { ER_Query er_query = new ER_Query(); ER_Query.Parameter_Run SQlin = new ER_Query.Parameter_Run(); SQlin._dbParameters = new List <DBParameters> { new DBParameters { ParamName = "IDENTITIES_ID", MSSqlParamDataType = SqlDbType.BigInt, ParamValue = identities_id } }; SQlin.sqlIn = "Select distinct e.FORMS_ID, a.DT_CREATED 'Date_Submitted', a.DT_CREATED 'Date_Updated', a.IDENTITIES_ID, a.FORMS_DAT_OPT_ID, a.applications_id, d.application_name, a.PROPERTY_VALUE, a.VALUE from " + _Connect.Schema + ".FORMS_DAT_OPT a " + "inner join CSA.Object_Sets b ON " + "(a.OBJECT_SETS_ID = b.OBJECT_SETS_ID and a.Identities_id = @IDENTITIES_ID) " + "inner join CSA.[OBJ_PROP_SETS] c on (b.OBJECT_SETS_ID = c.OBJECT_SETS_ID) " + "inner join CSA.[APPLICATIONS] d on (d.APPLICATIONS_ID = a.APPLICATIONS_ID) " + "inner join CSA.FORMS e on (e.FORMS_ID = a.FORMS_ID) " + "where c.PROPERTY_NAME in ('Status Check', 'Status Type', 'Status Message') " + "and a.RENDITION in (Select MAX(RENDITION) from CSA.VW__forms_dat_opt fdo2 where fdo2.FORMS_ID = a.FORMS_ID) " + "ORDER BY a.FORMS_DAT_OPT_ID desc "; DataTable Result_DT = er_query.RUN_PARAMETER_QUERY(_Connect, SQlin); return(Result_DT); }
public string EP_SAVE_FILE(IConnectToDB _Connect, string serverpath) { //C:\Users\Eminent\Documents\Projects\perception\CMS\CMS\CMS\Files\_originals\Koala.jpg //string strPath = HttpContext.Current.Server.MapPath("/Files/_originals/Koala.jpg"); string strPath = serverpath; string ContentType = new FileInfo(strPath).Extension; string ContentSize = new FileInfo(strPath).Length.ToString(); string FileName = new FileInfo(strPath).Name; FileStream fs = new FileStream(strPath, FileMode.Open, FileAccess.Read); byte[] longRaw = new byte[fs.Length]; fs.Read(longRaw, 0, longRaw.Length); fs.Close(); add addHelp = new add(); //OracleBinary OraclebinaryFile = new OracleBinary(longRaw); return("File Added" + addHelp.ADD_ENTRY_FILE(_Connect, new Values.AddFile { I_FILE_NAME = FileName, I_CONTENT_TYPE = ContentType, I_FILE_SIZE = longRaw.Length, I_FILE_DATA = longRaw })); }
public long?GetProfileId(IConnectToDB _Connect, string uuid) { _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); long?value = 0; Filters.Add(new DynamicModels.RootReportFilter { FilterName = "PROFILES_UUID_", DBType = SqlDbType.VarChar, ParamSize = -1, ParamValue = uuid }); DataTable TempDataTable = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__PROFILES_SEARCH", new DataTableDotNetModelMetaData { columns = "PROFILES_ID", length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); DataColumnCollection _dccColumnID = TempDataTable.Columns; if (_dccColumnID.Contains("PROFILES_ID") && TempDataTable.Rows.Count > 0) { value = TempDataTable.Rows[0].Field <long?>("PROFILES_ID"); } return(value); }
public List <CommandResult> REMOVE_SCAFFOLD(IConnectToDB _Connect, string Name, bool PreserveTable, bool PreserveProcedures) { List <CommandResult> results = new List <CommandResult>(); CommandResult _result = new CommandResult(); ER_DDL ddl = new ER_DDL(); results.Add(new CommandResult { _Response = "--Start Remove Scaffold " + Name + "", _Successful = true }); if (!PreserveProcedures) { results.AddRange(ddl.DROP_PROCEDURE(_Connect, "SP_I_" + Name + "")); results.AddRange(ddl.DROP_PROCEDURE(_Connect, "SP_U_" + Name)); results.AddRange(ddl.DROP_PROCEDURE(_Connect, "SP_D_" + Name)); results.AddRange(ddl.DROP_PROCEDURE(_Connect, Name + "O_")); results.AddRange(ddl.DROP_PROCEDURE(_Connect, "SP_S_" + Name + "_SEARCH")); //results.AddRange(DROP_PROCEDURE(_Connect, Name + "_SEARCH_COUNT")); } if (!PreserveTable) { results.AddRange(ddl.DROP_TABLE(_Connect, Name)); } results.Add(new CommandResult { _Response = "--End Remove Scaffold " + Name + "", _Successful = true }); return(results); }
internal RiskActions(IConnectToDB connection) { this.connection = connection; }
internal UserActions(IConnectToDB connection) { this.connection = connection; }