public virtual EstadoNumEntity GetEstadosNumFromReader(IDataReader reader)
{
EstadoNumEntity entity = null;
try
{
entity = new EstadoNumEntity();
entity.Numero = reader["numero"] == System.DBNull.Value ? 0 : (int)reader["numero"];
DateTime InParse = reader["fecha"] == System.DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(reader["fecha"]);
entity.Fecha = Convert.ToDateTime(InParse.Year + "/" + InParse.Month + "/" + InParse.Day + " " + InParse.Hour + ":" + InParse.Minute);
entity.FechaParseo = InParse.Year + "/" + InParse.Month + "/" + InParse.Day + " " + InParse.Hour + ":" + InParse.Minute;
entity.Prec = reader["prec"] == System.DBNull.Value ? 0 : (decimal)reader["prec"];
entity.Temt = reader["temt"] == System.DBNull.Value ? 0 : (decimal)reader["temt"];
entity.Dirv = reader["dirv"] == System.DBNull.Value ? 0 : (decimal)reader["dirv"];
entity.Velv = reader["velv"] == System.DBNull.Value ? 0 : (decimal)reader["velv"];
entity.Radg = reader["radg"] == System.DBNull.Value ? 0 : (decimal)reader["radg"];
entity.Humr = reader["humr"] == System.DBNull.Value ? 0 : (decimal)reader["humr"];
entity.Humh = reader["humh"] == System.DBNull.Value ? 0 : (decimal)reader["humh"];
entity.Eto = reader["eto"] == System.DBNull.Value ? 0 : (decimal)reader["eto"];
}
catch (Exception ex) {
throw new Exception("Error converting data of EstadoNum...", ex);
}
return(entity);
}
public override List <EstadoNumEntity> GetEstadosNumUltimateDate(int Idedo, int IdEstacion)
{
EstadoNumEntity entityNumEstado = null;
List <EstadoNumEntity> List = new List <EstadoNumEntity>();
string query = @"select numero,fecha, prec, temt, dirv, velv,radg,humr,humh,eto
from estado" + Idedo + " where numero=" + IdEstacion + " and fecha=(select max(fecha) from estado" + Idedo + " 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())
{
entityNumEstado = new EstadoNumEntity();
entityNumEstado = GetEstadosNumFromReader(reader);
List.Add(entityNumEstado);
}
}
catch (Exception ex)
{
throw new Exception("Error al consultar EstadosNum..." + ex.Message, ex);
}
finally
{
connection.Close();
reader.Close();
connection.Dispose();
}
return(List);
}
