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); }