public MySqlDataReader List(BankDepositStatus DepositStatus, string SortField, SortOption SortOrder)
{
try
{
string SQL = SQLSelect() + "WHERE a.DepositStatus = @DepositStatus ORDER BY " + SortField;
if (SortOrder == SortOption.Ascending)
{
SQL += " ASC";
}
else
{
SQL += " DESC";
}
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@DepositStatus", DepositStatus.ToString("d"));
MySqlDataReader myReader = (MySqlDataReader)cmd.ExecuteReader();
return(myReader);
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
public MySqlDataReader List(BankDepositStatus DepositStatus, string SortField, SortOption SortOrder)
{
try
{
string SQL = SQLSelect() + "WHERE a.DepositStatus = @DepositStatus ORDER BY " + SortField;
if (SortOrder == SortOption.Ascending)
SQL += " ASC";
else
SQL += " DESC";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@DepositStatus", DepositStatus.ToString("d"));
MySqlDataReader myReader = (MySqlDataReader)cmd.ExecuteReader();
return myReader;
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
