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