public DetallePermisoUsr BuscarDetallePermisoPorId(int detallePermisoId)
{
const string sqlStatement = "SELECT DP.Id, DP.UsrId, DP.PermisoId, P.Descripcion, DP.Otorgado, DP.DVH " +
"FROM [dbo].[SEG_DetallePermisos] as DP " +
"JOIN [dbo].[SEG_Permisos] as P " +
"ON P.Id = DP.PermisoId " +
"WHERE DP.Id = @detallePermisoId; ";
var result = new DetallePermisoUsr();
var db = DatabaseFactory.CreateDatabase(ConnectionName);
using (var cmd = db.GetSqlStringCommand(sqlStatement))
{
db.AddInParameter(cmd, "@detallePermisoId", DbType.Int32, detallePermisoId);
using (var dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
result = MapearDetallePermisoUsr(dr); // Mapper
}
}
}
return(result);
}
private DetallePermisoUsr MapearDetallePermisoUsr(IDataReader dr)
{
var detallePermiso = new DetallePermisoUsr
{
Id = GetDataValue <int>(dr, "Id"),
UsrId = GetDataValue <int>(dr, "UsrId"),
PermisoId = GetDataValue <int>(dr, "PermisoId"),
Descripcion = GetDataValue <string>(dr, "Descripcion"),
Otorgado = GetDataValue <string>(dr, "Otorgado"),
DVH = GetDataValue <Int64>(dr, "DVH")
};
return(detallePermiso);
}
