public void ResetPassword(IConnectToDB _Connect, string VerifyUUID, string password) { ER_Sec er_sec = new ER_Sec(); ER_DML er_dml = new ER_DML(); _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> verifyIdentityFilters = new List <DynamicModels.RootReportFilter>(); List <DynamicModels.RootReportFilter> idPasswordFilters = new List <DynamicModels.RootReportFilter>(); verifyIdentityFilters.Add(new DynamicModels.RootReportFilter { FilterName = "UUID_", DBType = SqlDbType.VarChar, ParamValue = VerifyUUID }); DataTable verifyIdentityTable = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__VERIFY_SEARCH", new DataTableDotNetModelMetaData { columns = "IDENTITIES_ID", length = -1, order = "1 asc", start = 0, verify = "T" }, verifyIdentityFilters); idPasswordFilters.Add(new DynamicModels.RootReportFilter { FilterName = "Identities_ID_", DBType = SqlDbType.BigInt, ParamValue = verifyIdentityTable.Rows[0].Field <long?>("IDENTITIES_ID") }); DataTable idPasswordTable = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__ID_PASSWORD_SEARCH", new DataTableDotNetModelMetaData { columns = "ID_PASSWORD_ID", length = -1, order = "1 asc", start = 0, verify = "T" }, idPasswordFilters); //Update Password string hash = ER_Sec.ComputeHash(password, "SHA512", null); er_dml.OBJECT_DML(_Connect, "Update", "ID_PASSWORD", "PASSWORD", idPasswordTable.Rows[0].Field <long?>("ID_PASSWORD_ID"), new Object_Value { _File = new File_Object { _FileBytes = er_sec.EncryptStringToBytes_Aes(hash, er_sec.GetCryptPairforID(_Connect, verifyIdentityTable.Rows[0].Field <long?>("IDENTITIES_ID"), new ER_CRYPT_PAIR())) } }); //disable verification VerificationHelper VH = new VerificationHelper(); VH.DisableVerificationsForID(_Connect, verifyIdentityTable.Rows[0].Field <long?>("IDENTITIES_ID"), "ResetPassword"); }
public List <ViewObjectPropFile> FindFiles(IConnectToDB _Connect, List <ViewObjectPropFile> Files, string _id, string type) { _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); if (type == "object_sets") { Filters.Add(new DynamicModels.RootReportFilter { FilterName = "OBJECT_SETS_UUID_", DBType = SqlDbType.BigInt, ParamValue = _id }); } else { Filters.Add(new DynamicModels.RootReportFilter { FilterName = "OBJ_PROP_SETS_UUID_", DBType = SqlDbType.BigInt, ParamValue = _id }); } DataTable TempDataTable = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__OBJ_PROP_SETS_Dat_File_SEARCH", new DataTableDotNetModelMetaData { length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); Files = PopulatePropertyFiles(Files, TempDataTable); return(Files); }
public DataTable FindbyGripId(IConnectToDB _Connect, string gripsid, string objectsetsid) { _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "GRIPS_ID_", DBType = SqlDbType.VarChar, SearchParamSize = -1, ParamValue = gripsid }); if (!string.IsNullOrWhiteSpace(objectsetsid) && objectsetsid != "0") { Filters.Add(new DynamicModels.RootReportFilter { FilterName = "OBJECT_SETS_ID_", DBType = SqlDbType.VarChar, SearchParamSize = -1, ParamValue = objectsetsid }); } DataTable TempDataTable = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__OBJ_PROP_SETS_SEARCH", new DataTableDotNetModelMetaData { length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); return(TempDataTable); }
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 string GetRichtextFromBytes(IConnectToDB _Connect, long?forms_id, long?object_prop_sets_id) { _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "OBJ_PROP_SETS_ID_", DBType = SqlDbType.BigInt, ParamValue = object_prop_sets_id }); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "FORMS_ID_", DBType = SqlDbType.BigInt, ParamValue = forms_id }); DataTable TempDataTable = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__FORMS_DAT_FILE_SEARCH", new DataTableDotNetModelMetaData { length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); char[] chars = new char[0]; if (TempDataTable.Rows.Count > 0) { IOHelper io = new IOHelper(); //labelstring= io.getStringFromBytes(TempDataTable.Rows[0]["FILE_DATA"].ToString()); byte[] bytes = (byte[])TempDataTable.Rows[0]["Value"]; chars = new char[bytes.Length / sizeof(char)]; System.Buffer.BlockCopy(bytes, 0, chars, 0, bytes.Length); } return(new string(chars)); }
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 <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 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 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 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 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 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 string DisableVerificationsForID(IConnectToDB _Connect, long?identities_id, string Validation_Type) { ER_DML er_dml = new ER_DML(); _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); try { Filters.Add(new DynamicModels.RootReportFilter { FilterName = "IDENTITIES_ID_", DBType = SqlDbType.BigInt, ParamValue = identities_id }); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "VALIDATION_TYPE_", DBType = SqlDbType.VarChar, SearchParamSize = -1, ParamValue = Validation_Type }); DataTable _ResultSet = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__VERIFY_SEARCH", new DataTableDotNetModelMetaData { length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); foreach (DataRow _Row in _ResultSet.Rows) { er_dml.TOGGLE_OBJECT(_Connect, "VERIFY", _Row.Field <long?>("VERIFY_ID"), "N"); } return("All Validations Disabled"); } catch { return("Error Disabling Verifications"); } }
public DataTable FindNotifications(IConnectToDB _Connect) { _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); DataTable TempDataTable = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW_ACTIVITY_NOTIFICATIONS_SEARCH", new DataTableDotNetModelMetaData { length = -1, order = "DT_CREATED desc", start = 0, verify = "T" }, Filters); return(TempDataTable); }
public DataTable FindAll(IConnectToDB _Connect, string NotificationTable) { _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); DataTable TempDataTable = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__" + NotificationTable + "_NTFY_SEARCH", new DataTableDotNetModelMetaData { length = 50, order = "DT_CREATED desc", start = 0, verify = "T" }, Filters); return(TempDataTable); }
public DataTable FindAll(IConnectToDB _Connect) { _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); DataTable TempDataTable = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__OBJECT_SETS_SEARCH", new DataTableDotNetModelMetaData { length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); return(TempDataTable); }
public bool RecoverUsername(IConnectToDB _Connect, string _emailaddress) { _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "EMAIL_", DBType = SqlDbType.VarChar, ParamSize = -1, ParamValue = _emailaddress }); DataTable Username = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__ID_PASSWORD_SEARCH", new DataTableDotNetModelMetaData { columns = "USER_NAME", length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); if (Username.Rows.Count > 0) { string Host = Current.Request.Scheme + "://" + Current.Request.Host.ToString().ToLower(); if (Current.Request.Host.Port != 80 && Current.Request.Host.Port != 443) { Host = Host + ":" + Current.Request.Host.Port; } string VerifyURL = Host + "/Login/"; string EmailBody = "This email was sent by an automated administrator. Please do not reply to this message." + "<br /><br />" + "Your Revamp username was requested at " + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + " via the forgot username link. Your username for your Revamp account is: <b>" + Username.Rows[0]["USER_NAME"] + "</b>" + "<br /><br />Please click <a href='" + VerifyURL + "'>here</a> to login" + "<br/><br/> If you did not request your username no further action is needed on your part." + "<br /><br /><br /><br />" + "Thanks for using Revamp!"; string tempemail = _emailaddress; IOHelper ioHelper = new IOHelper(); try { ioHelper.SendEmail(tempemail, "NO REPLY: Username for " + _Connect.SourceDBOwner.ToUpper() + " ACCOUNT", EmailBody); } catch { //Couldn't send email. } return(true); } else { return(false); } }
public string MarkVerificationsForID(IConnectToDB _Connect, long identities_id, string Validation_Type) { //ER_DML er_dml = new ER_DML(); _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); add addHelp = new add(); long?verifyId = null; List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); try { Filters.Add(new DynamicModels.RootReportFilter { FilterName = "IDENTITIES_ID_", DBType = SqlDbType.BigInt, ParamValue = identities_id }); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "VALIDATION_TYPE_", DBType = SqlDbType.VarChar, SearchParamSize = -1, ParamValue = Validation_Type }); DataTable _ResultSet = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__VERIFY_SEARCH", new DataTableDotNetModelMetaData { length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); foreach (DataRow _Row in _ResultSet.Rows) { Values.UpdateVerify VerifyModel = null; VerifyModel = addHelp.UPDATE_ENTRY_Verify(_Connect, new Values.UpdateVerify { I_VERIFY_ID = _Row.Field <long?>("VERIFY_ID"), I_UUID = _Row.Field <string>("UUID"), I_VERIFIED = "Y", I_VALIDATION_TYPE = _Row.Field <string>("VALIDATION_TYPE") }); verifyId = VerifyModel.O_VERIFY_ID; //er_dml.OBJECT_DML(_Connect, "Update", "VERIFY", "VERIFIED", _Row.Field<Int32>("VERIFY_ID"), new Object_Value { _String = "Y" }); } return("All Validations Disabled"); } catch { return("Error Disabling Verifications"); } }
public bool ValidVerification(IConnectToDB _Connect, string VerificationString, string validation_type) { _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "UUID_", DBType = SqlDbType.VarChar, SearchParamSize = -1, ParamValue = VerificationString }); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "VALIDATION_TYPE_", DBType = SqlDbType.VarChar, SearchParamSize = -1, ParamValue = validation_type }); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "ENABLED_", DBType = SqlDbType.VarChar, SearchParamSize = -1, ParamValue = "Y" }); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "WHERE", DBType = SqlDbType.VarChar, SearchParamSize = -1, ParamValue = "DT_CREATED > DATEADD(minute, -15, GETDATE())" }); DataTable DT = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__VERIFY_SEARCH", new DataTableDotNetModelMetaData { length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); string UUID = ""; try { foreach (DataRow DR in DT.Rows) { UUID = DR.Field <string>("UUID"); if (UUID == VerificationString) { return(true); } } } catch { return(false); } return(false); }
public DataTable GetImageIdByProfile(IConnectToDB _Connect, long?id) { _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "PROFILES_ID_", DBType = SqlDbType.BigInt, ParamValue = id }); DataTable TempDataTable = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__PROFILE_IMAGES_SEARCH", new DataTableDotNetModelMetaData { columns = "PROFILE_IMAGES_ID", length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); return(TempDataTable); }
public DataTable Find(IConnectToDB _Connect, string _id) { _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "GRIPS_ID_", DBType = SqlDbType.BigInt, ParamValue = _id }); DataTable TempDataTable = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__OBJ_PROP_OPT_SETS_SEARCH", new DataTableDotNetModelMetaData { length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); return(TempDataTable); }
public DataTable GetAllStageObjects(IConnectToDB _Connect, string Stage) { _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "GRIP_TYPE_", DBType = SqlDbType.VarChar, SearchParamSize = -1, ParamValue = Stage }); DataTable TempDataTable = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__OBJ_PROP_SETS_SEARCH", new DataTableDotNetModelMetaData { length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); return(TempDataTable); }
public DataTable FindbyColumnID(IConnectToDB _Connect, string _column, string _value) { _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); Filters.Add(new DynamicModels.RootReportFilter { FilterName = _column + "_", DBType = SqlDbType.VarChar, SearchParamSize = -1, ParamValue = _value }); DataTable TempDataTable = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__OBJ_PROP_OPT_SETS_SEARCH", new DataTableDotNetModelMetaData { length = -1, order = "OBJ_PROP_OPT_SETS_ID asc", start = 0, verify = "T" }, Filters); return(TempDataTable); }
public DataTable getUUIDByUsername(string Username, IConnectToDB _Connect) { _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "USER_NAME_", DBType = SqlDbType.VarChar, SearchParamSize = -1, ParamValue = Username }); DataTable TempDataTable = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW_VERIFY_IDENTITIES_SEARCH", new DataTableDotNetModelMetaData { length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); return(TempDataTable); }
public DataTable FindbyColumnIDs(IConnectToDB _Connect, string _column, List <string> _value) { _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); Filters.Add(new DynamicModels.RootReportFilter { FilterName = _column, ParamValue = String.Join(",", _value) }); DataTable TempDataTable = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__OBJECT_SETS_SEARCH", new DataTableDotNetModelMetaData { length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); return(TempDataTable); }
public DataRow GetUser(IConnectToDB _Connect, string EDIPI) { _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "EDIPI_", ParamValue = EDIPI }); DataTable edipidt = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__IDENTITIES_SEARCH", new DataTableDotNetModelMetaData { length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); DataRow _DR = edipidt.NewRow(); if (edipidt.Rows.Count == 1) { foreach (DataRow _DR1 in edipidt.Rows) { try { if (_DR1.Field <string>("EDIPI") == EDIPI) { _DR = _DR1; break; } } catch { //Do Nothing } } } return(_DR); }
public ObjectPropSetModels FindExtras(IConnectToDB _Connect, ObjectPropSetModels PropSet, Guid?_id) { _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "OBJ_PROP_SETS_UUID_", DBType = SqlDbType.UniqueIdentifier, ParamValue = _id }); DataTable TempDataTable = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__OBJ_PROP_SETS_DAT_FILE_SEARCH", new DataTableDotNetModelMetaData { length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); PropSet = PopulatePropertyFiles(PropSet, TempDataTable); ViewObjectPropSetFile OPS = new ViewObjectPropSetFile(); return(PropSet); }
public string GetUsernameByEmail(IConnectToDB _Connect, string email) { _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "EMAIL_", DBType = SqlDbType.VarChar, SearchParamSize = -1, ParamValue = email }); DataTable usernamedt = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_IDENTITIES_SEARCH", new DataTableDotNetModelMetaData { length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); if (usernamedt.Rows.Count == 1) { return(usernamedt.Rows[0]["User_Name"].ToString()); } return(""); }
public void UpdateProfileEmail(IConnectToDB _Connect, long?_Identities_ID, string email) { IdentityHelper identityHelper = new IdentityHelper(); if (!string.IsNullOrWhiteSpace(email) && _Identities_ID > 0) { _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "IDENTITIES_ID_", DBType = SqlDbType.BigInt, ParamValue = _Identities_ID }); DataTable TempDataTable = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__IDENTITIES_SEARCH", new DataTableDotNetModelMetaData { length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); DataColumnCollection _dccColumnID = TempDataTable.Columns; if (_dccColumnID.Contains("IDENTITIES_ID") && TempDataTable.Rows.Count > 0) { long?identitiesId = TempDataTable.Rows[0].Field <long?>("IDENTITIES_ID"); var objectType = TempDataTable.Rows[0].Field <string>("OBJECT_TYPE"); var userName = TempDataTable.Rows[0].Field <string>("USER_NAME"); var edipi = TempDataTable.Rows[0].Field <string>("EDIPI"); var active = TempDataTable.Rows[0].Field <string>("ACTIVE"); var verified = TempDataTable.Rows[0].Field <string>("VERIFIED"); //Update user string result = identityHelper.UpdateIdentity(_Connect, identitiesId, objectType, userName, edipi, email, active, verified); //SH.LogActivity(_Connect, "Deactivate Identity", "1000", "1000", "IDENTITIES", id.ToString(), SO.SessionIdentity.Identity.identities_id, "1004", "1005", Session["UserName"].ToString().ToUpper() + " deactivated user " + user_name, "1000", "1000", ""); } } }
public DataTable FindbyNameandStage(IConnectToDB _Connect, string propname, string stagetype, string stagename) { _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "PROPERTY_NAME_", ParamValue = propname }); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "STAGE_TYPE_", ParamValue = stagetype }); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "STAGE_NAME_", ParamValue = stagename }); DataTable TempDataTable = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__OBJ_PROP_SETS_SEARCH", new DataTableDotNetModelMetaData { length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); return(TempDataTable); }