/// <summary>
/// Execute
/// </summary>
/// <returns></returns>
protected override bool Execute()
{
DTO.CcnUsername = SamAccountName;
Account_ADO accountAdo = new Account_ADO();
Account_DTO_Read dtoRead = new Account_DTO_Read();
dtoRead.CcnUsername = SamAccountName;
var readUser = accountAdo.Read(Ado, dtoRead);
if (readUser.hasData)
{
DTO.PrvCode = accountAdo.ReadAccounts(readUser)[0].PrvCode;
int nUpdated = accountAdo.Update(Ado, DTO, SamAccountName);
if (nUpdated == 0)
{
Log.Instance.Debug("Failed to update Account");
Response.error = Label.Get("error.update");
return(false);
}
}
Response.data = JSONRPC.success;
return(true);
}
/// <summary>
/// Reads the account table based on an Account_DTO_Read parameter
/// </summary>
/// <param name="ado"></param>
/// <param name="account"></param>
/// <returns></returns>
internal ADO_readerOutput Read(ADO ado, Account_DTO_Read account)
{
List <ADO_inputParams> paramList = new List <ADO_inputParams>();
if (!string.IsNullOrEmpty(account.CcnUsername))
{
paramList.Add(new ADO_inputParams()
{
name = "@CcnUsername", value = account.CcnUsername
});
}
if (!string.IsNullOrEmpty(account.PrvCode))
{
paramList.Add(new ADO_inputParams()
{
name = "@PrvCode", value = account.PrvCode
});
}
ADO_readerOutput output = ado.ExecuteReaderProcedure("Security_Account_Read", paramList);
return(output);
}
/// <summary>
/// Checks if the user is registered on the system
/// </summary>
/// <param name="ado"></param>
/// <param name="ccnUsername"></param>
/// <returns></returns>
internal bool IsRegistered(ADO ado, string ccnUsername)
{
Account_ADO accountAdo = new Account_ADO();
Account_DTO_Read dto = new Account_DTO_Read();
dto.CcnUsername = ccnUsername;
ADO_readerOutput output = accountAdo.Read(ado, dto);
return(output.hasData);
}
internal bool IsModerator(ADO ado, string ccnUsername)
{
Account_ADO accountAdo = new Account_ADO();
Account_DTO_Read dto = new Account_DTO_Read();
dto.CcnUsername = ccnUsername;
ADO_readerOutput output = accountAdo.Read(ado, dto);
if (!output.hasData)
{
return(false);
}
else
{
dynamic account = output.data.First();
return(account.PrvCode.Equals(Resources.Constants.C_SECURITY_PRIVILEGE_MODERATOR));
}
}
/// <summary>
/// Reads the account table based on an Account_DTO_Read parameter
/// </summary>
/// <param name="ado"></param>
/// <param name="account"></param>
/// <returns></returns>
internal ADO_readerOutput Read(ADO ado, Account_DTO_Read account, bool adOnly = false, string ccnEmail = null)
{
List <ADO_inputParams> paramList = new List <ADO_inputParams>();
if (!string.IsNullOrEmpty(account.CcnUsername))
{
paramList.Add(new ADO_inputParams()
{
name = "@CcnUsername", value = account.CcnUsername
});
}
if (!string.IsNullOrEmpty(account.PrvCode))
{
paramList.Add(new ADO_inputParams()
{
name = "@PrvCode", value = account.PrvCode
});
}
if (adOnly)
{
paramList.Add(new ADO_inputParams()
{
name = "@AdFlag", value = true
});
}
if (ccnEmail != null)
{
paramList.Add(new ADO_inputParams()
{
name = "@CcnEmail", value = ccnEmail
});
}
ADO_readerOutput output = ado.ExecuteReaderProcedure("Security_Account_Read", paramList);
return(output);
}
