/// <summary> /// Lee la tabla base y retorna entidad con Id coincidente o null. /// </summary> /// <param name="Id">Entero que especifica la clave principal PK de la entidad.</param> /// <returns>Objeto del tipo Entidad definido en clase derivada.</returns> public T ReadEntityById(int Id) { T ent = default(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(); ent = mapper.MapEntity(reader); return(ent); } catch { throw; } finally { reader.Close(); } } } catch { throw; } finally { connection.Close(); } } }
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(); } } }
public override ClaveMes ReadEntityBy2Params(int mes, int anno) { 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 Mes y Anno IDataParameter param1 = command.CreateParameter(); param1.ParameterName = Constants.FilterOneParam; param1.DbType = DbType.Int32; param1.Value = mes; command.Parameters.Add(param1); param1 = command.CreateParameter(); param1.ParameterName = Constants.FilterTwoParam; param1.DbType = DbType.Int32; param1.Value = anno; command.Parameters.Add(param1); ClaveMes ent = null; try { connection.Open(); using (IDataReader reader = command.ExecuteReader()) { try { MapperBase <ClaveMes> mapper = GetMapper(); ent = mapper.MapEntity(reader); return(ent); } catch { throw; } finally { reader.Close(); } } } catch { throw; } finally { connection.Close(); } } }