public Collection <T> ReadCollection(int id)
{
Collection <T> collection = new Collection <T>();
using (IDbConnection connection = GetConnection())
{
IDbCommand command = connection.CreateCommand();
command.Connection = connection;
command.CommandText = this.CommandText;
command.CommandType = this.CommandType;
foreach (IDataParameter param in this.GetParameters(command, id))
{
command.Parameters.Add(param);
}
try
{
connection.Open();
using (IDataReader reader = command.ExecuteReader())
{
try
{
MapperBase <T> mapper = GetMapper();
collection = mapper.MapAll(reader);
return(collection);
}
catch
{
throw;
}
finally
{
reader.Close();
}
}
}
catch
{
throw;
}
finally
{
connection.Close();
}
}
}
public override Collection <Checkinout> ReadCollectionBy2Params(string userId, string fecha)
{
Collection <Checkinout> collection = new Collection <Checkinout>();
using (IDbConnection connection = GetConnection())
{
IDbCommand command = connection.CreateCommand();
command.Connection = connection;
command.CommandText = this.CommandText;
command.CommandType = this.CommandType;
foreach (IDataParameter param in this.GetParameters(command))
{
command.Parameters.Add(param);
}
// Creando Parametro para filtrar por userId y fecha
IDataParameter param1 = command.CreateParameter();
param1.ParameterName = Constants.FilterOneParam;
param1.DbType = DbType.String;
param1.Value = userId;
command.Parameters.Add(param1);
param1 = command.CreateParameter();
param1.ParameterName = Constants.FilterTwoParam;
param1.DbType = DbType.String;
param1.Value = fecha;
//Console.WriteLine("Fecha: " + fecha.ToString("yyyyMMdd"));
command.Parameters.Add(param1);
try
{
connection.Open();
using (IDataReader reader = command.ExecuteReader())
{
try
{
MapperBase <Checkinout> mapper = GetMapper();
collection = mapper.MapAll(reader);
return(collection);
}
catch
{
throw;
}
finally
{
reader.Close();
}
}
}
catch
{
throw;
}
finally
{
connection.Close();
}
}
}