///<summary>Uses lower sql permissions, making it safe to pass a query.</summary>
public static DataTable GetTableLow(string command)
{
if (RemotingClient.RemotingRole != RemotingRole.ClientWeb)
{
throw new ApplicationException("Meth.GetTableLow may only be used when RemotingRole is ClientWeb.");
}
DtoGetTableLow dto = new DtoGetTableLow();
dto.MethodName = "";
DtoObject dtoObj = new DtoObject(command, typeof(string));
dto.Params = new DtoObject[] { dtoObj };
dto.Credentials = new Credentials();
dto.Credentials.Username = Security.CurUser.UserName;
dto.Credentials.Password = Security.PasswordTyped; //.CurUser.Password;
DataTable retval = new DataTable();
try {
retval = RemotingClient.ProcessGetTableLow(dto);
}
catch (ODException ex) {
if (ex.ErrorCode == (int)ODException.ErrorCodes.CheckUserAndPasswordFailed)
{
CredentialsFailed(); //The application pauses here in the main thread to wait for user input.
retval = GetTableLow(command);
}
else
{
throw;
}
}
return(retval);
}
///<summary>Uses lower sql permissions, making it safe to pass a query.</summary>
public static DataTable GetTableLow(string command)
{
if (RemotingClient.RemotingRole != RemotingRole.ClientWeb)
{
throw new ApplicationException("Meth.GetTableLow may only be used when RemotingRole is ClientWeb.");
}
DtoGetTableLow dto = new DtoGetTableLow();
dto.MethodName = "";
DtoObject dtoObj = new DtoObject(command, typeof(string));
dto.Params = new DtoObject[] { dtoObj };
dto.Credentials = new Credentials();
dto.Credentials.Username = Security.CurUser.UserName;
dto.Credentials.Password = Security.PasswordTyped; //.CurUser.Password;
return(RemotingClient.ProcessGetTableLow(dto));
}
