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