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