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 SessionObjects AddProfilePic(IConnectToDB _Connect, SessionObjects SO, FormCollection _formCollection)
{
try
{
if (_formCollection.Keys.Count > 1)
{
SecurityHelper securityHelper = new SecurityHelper();
IdentityHelper identityHelper = new IdentityHelper();
ER_DML er_dml = new ER_DML();
add addHelp = new add();
long? identitiesId = ER_Tools.ConvertToInt64(identityHelper.GetIdentityID(_Connect, _formCollection["identitiesUUID"].ToString()));
string fileName = _formCollection["fileName"].ToString();
string fileType = _formCollection["fileType"].ToString();
long? fileSize = ER_Tools.ConvertToInt64(_formCollection["fileSize"].ToString());
byte[] fileContent = Encoding.UTF8.GetBytes(_formCollection["profileImage"].ToString());
Guid? ProfilesUUID = ER_Tools.ConvertToGuid(_formCollection["profilesUUID"].ToString());
long? Profiles_ID = GetProfileId(_Connect, ProfilesUUID.ToString());
long? profileImagesId = 0;
var profileImagesDT = GetImageIdByProfile(_Connect, Profiles_ID);
DataColumnCollection _dccColumnID = profileImagesDT.Columns;
if (_dccColumnID.Contains("PROFILE_IMAGES_ID") && profileImagesDT.Rows.Count > 0)
{
Values.UpdateProfileImages ProfileImagesModel = null;
ProfileImagesModel = addHelp.UPDATE_ENTRY_Profile_Images(_Connect, new Values.UpdateProfileImages
{
I_PROFILE_IMAGES_ID = profileImagesDT.Rows[0].Field <long?>("PROFILE_IMAGES_ID"),
I_PROFILES_ID = Profiles_ID,
I_FILE_NAME = fileName,
I_FILE_SIZE = fileSize,
I_CONTENT_TYPE = fileType,
I_VALUE = fileContent
});
profileImagesId = ProfileImagesModel.O_PROFILE_IMAGES_ID;
//Enable Profile Image
er_dml.TOGGLE_OBJECT(_Connect, "PROFILE_IMAGES", profileImagesId, "Y");
}
else
{
//Values.AddProfilesSecPriv ProfilesSecPrivModel = null;
//ProfilesSecPrivModel = addHelp.ADD_ENTRY_Profiles_Sec_Priv(_Connect, new Values.AddProfilesSecPriv
//{
// I_OBJECT_TYPE = "Permission",
// I_PROFILES_ID = Profiles_ID,
// I_PRIVILEGES_ID = ER_Tools.ConvertToInt64(securityHelper.GetPrivID(_Connect, "CREATE OBJECT")),
// I_ENABLED = 'Y',
// I_IDENTITIES_ID = identitiesId
//});
Values.AddProfileImages ProfileImagesModel = null;
ProfileImagesModel = addHelp.ADD_ENTRY_Profile_Images(_Connect, new Values.AddProfileImages
{
I_IDENTITIES_ID = identitiesId,
I_PROFILES_UUID = ProfilesUUID,
I_ENABLED = 'Y',
I_FILE_NAME = fileName,
I_FILE_SIZE = fileSize,
I_CONTENT_TYPE = fileType,
I_VALUE = fileContent
});
}
//Set Profile Image
_session.SetString("ProfileImage", GetProfileImage(_Connect, identitiesId));
}
}
catch
{
}
return(SO);
}
