public virtual EstadoNumDiarioEntity GetEstadosNumDiarioFromReader(IDataReader reader) { EstadoNumDiarioEntity entity = null; try { entity = new EstadoNumDiarioEntity(); entity.Numero = reader["numero"] == System.DBNull.Value ? 0 : (int)reader["numero"]; entity.Fecha = reader["fecha"] == System.DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(reader["fecha"]); DateTime InParse = reader["fecha"] == System.DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(reader["fecha"]); entity.FechaParseo = InParse.Day + "/" + InParse.Month + "/" + InParse.Year; entity.Prec = reader["prec"] == System.DBNull.Value ? 0 : (decimal)reader["prec"]; entity.Tmax = reader["tmax"] == System.DBNull.Value ? 0 : (decimal)reader["tmax"]; entity.Tmin = reader["tmin"] == System.DBNull.Value ? 0 : (decimal)reader["tmin"]; entity.Tmed = reader["tmed"] == System.DBNull.Value ? 0 : (decimal)reader["tmed"]; entity.VelvMax = reader["velvmax"] == System.DBNull.Value ? 0 : (decimal)reader["velvmax"]; entity.Velv = reader["velv"] == System.DBNull.Value ? 0 : (decimal)reader["velv"]; entity.DirvVMax = reader["dirvvmax"] == System.DBNull.Value ? 0 : (decimal)reader["dirvvmax"]; entity.Dirv = reader["dirv"] == System.DBNull.Value ? 0 : (decimal)reader["dirv"]; entity.Radg = reader["radg"] == System.DBNull.Value ? 0 : (decimal)reader["radg"]; entity.Humr = reader["humr"] == System.DBNull.Value ? 0 : (decimal)reader["humr"]; entity.Et = reader["et"] == System.DBNull.Value ? 0 : (decimal)reader["et"]; entity.Ep = reader["ep"] == System.DBNull.Value ? 0 : (decimal)reader["ep"]; entity.Porc = reader["porc"] == System.DBNull.Value ? "0" : Convert.ToString(reader["porc"]); } catch (Exception ex) { throw new Exception("Error converting data of EstadoNumDiario...", ex); } return(entity); }
public override List <EstadoNumDiarioEntity> GetEstadoNumDiarioUltimateDate(int Idedo, int IdEstacion) { EstadoNumDiarioEntity entityNumEstadoDiario = null; List <EstadoNumDiarioEntity> List = new List <EstadoNumDiarioEntity>(); string query = @"select numero,fecha,prec,tmax,tmin,tmed,velvmax,velv,dirvvmax,dirv,radg,humr,et,ep,porc from estado" + Idedo + "diarios " + @"where numero=" + IdEstacion + " and fecha = (select max(fecha) from estado" + Idedo + "diarios where numero=" + IdEstacion + ")"; SqlConnection connection = new SqlConnection(DataAccess.SqlGlobalConectionString); SqlCommand command = new SqlCommand(query, connection); command.CommandType = System.Data.CommandType.Text; SqlDataReader reader = null; try { if (connection.State == ConnectionState.Closed) { connection.Open(); } reader = command.ExecuteReader(); while (reader.Read()) { entityNumEstadoDiario = new EstadoNumDiarioEntity(); entityNumEstadoDiario = GetEstadosNumDiarioFromReader(reader); List.Add(entityNumEstadoDiario); } } catch (Exception ex) { throw new Exception("Error al consultar EstadosNumDiario..." + ex.Message, ex); } finally { connection.Close(); reader.Close(); connection.Dispose(); } return(List); }