private static Driver_Transaction_History ReaderDataHistory(MySqlDataReader reader)
{
Driver_Transaction_History objHist = new Driver_Transaction_History();
objHist.DRIVERID = Converter.IsValidInt(reader["DRIVERID"]);
objHist.TRANSACTIONTYPE = Converter.IsValidString(reader["TRANSACTIONTYPE"]);
objHist.AMOUNT = Converter.IsValidString(reader["AMOUNT"]);
objHist.DATE = Converter.IsValidString(reader["DATE"]);
return(objHist);
}
public static List <Driver_Transaction_History> GetHistory(string whereclause, MySqlConnection conn = null)
{
Driver_Transaction_History objHist = null;
List <Driver_Transaction_History> lstHist = new List <Driver_Transaction_History>();
try
{
bool isConnArgNull = (conn != null) ? false : true;
MySqlConnection connection = (conn != null) ? conn : PrimaryConnection();
tryOpenConnection(connection);
string sql = "select * from Driver_transaction_history";
if (!string.IsNullOrEmpty(whereclause))
{
sql += " where " + whereclause;
}
using (MySqlCommand command = new MySqlCommand())
{
command.Connection = connection;
command.CommandText = sql;
using (MySqlDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
objHist = ReaderDataHistory(reader);
lstHist.Add(objHist);
}
}
else
{
}
}
if (isConnArgNull == true)
{
connection.Dispose();
}
}
}
//endtry
catch (Exception ex)
{
}
return(lstHist);
}
