public static Day getRow(LocalDate lDate) throws SQLException {
		
		log.entry("getRow (DayManager)");
		
		String sql = "SELECT * FROM Day WHERE id_day = ?";
		ResultSet rs = null;
		Date theDate = DateManager.localDateToSqlDate(lDate);
		
		try (
				PreparedStatement stmt = conn.prepareStatement(sql);
				){
			stmt.setDate(1, theDate);
			rs = stmt.executeQuery();
			
			
			if (rs.next()) {
				
				Day bean = new Day();
				if (DateManager.isWeekDay(theDate)) {
					
					Serializer serializer = new Persister(Day.getXmlFormat());
//					File source = new File("./data/maxes.xml");
					
					Day preBean = new Day();
					try {
						bean = serializer.read(preBean, Day.getXmlFile());
					} catch (Exception e) {
						bean = preBean;
					}
				}

				bean.setDate(rs.getDate("id_day"));
				bean.setAvailableScreenCups(rs.getLong("avail_screen"));
				bean.setAvailableScreenNaps(rs.getLong("avail_screen_naps"));
				bean.setAvailablePad(rs.getLong("avail_pad"));
				bean.setAvailableHotstamp(rs.getLong("avail_hotstamp"));
				bean.setAvailableDigitalFlats(rs.getLong("avail_digital"));
				bean.setAvailableOffsetCups(rs.getLong("avail_offset_cups"));
				bean.setAvailableOffsetNaps(rs.getLong("avail_offset_naps"));
				bean.setRemainScreenCups(rs.getLong("remain_screen"));
				bean.setRemainScreenNaps(rs.getLong("remain_screen_naps"));
				bean.setRemainPad(rs.getLong("remain_pad"));
				bean.setRemainHotstamp(rs.getLong("remain_hotstamp"));
				bean.setRemainDigitalCups(rs.getLong("remain_digital_cups"));
				bean.setRemainDigitalFlats(rs.getLong("remain_digital"));
				bean.setRemainOffsetCups(rs.getLong("remain_offset_cups"));
				bean.setRemainOffsetNaps(rs.getLong("remain_offset_naps"));
				bean.setDayCompleted(rs.getTimestamp("day_completed"));
				bean.setAvailableOutsourced(rs.getLong("avail_outsourced"));
				bean.setRemainOutsourced(rs.getLong("remain_outsourced"));
				return bean;
			} else {
				return log.exit(null);
			}
			
		} catch (SQLException e) {
			 log.error(e);
			 return log.exit(null);
		} finally {
			if (rs != null) {
				rs.close();
			}
		}
	}